MySQL Replication Error: Duplicate Entry

Filed Under (Misc.) by Kirby Witmer on 08-07-2008

Tagged Under : , ,

I just realized today that my MySQL slave box was like way out of sync. Yikes. The error message was ‘Duplicate Entry’. Which is like weird, because this is simply a replicated slave box, why would there be a duplicate entry anyway? After much searching I discovered this fix that worked like a charm. Just add the following line to the [mysqld] section of the slave’s my.cnf file.

slave-skip-errors = 1062

It worked, BUT is this a good idea? anyone have a betterĀ idea?

Could not link driver rlm_sql_mysql

Filed Under (Misc.) by Kirby Witmer on 29-02-2008

Tagged Under : , ,

I was trying to setup a radius server using mysql authentication and I was plumb stuck on this error message.

Could not link driver rlm_sql_mysql:

Very simple fix as it turns out. You just need to install the mysql enabled version of freeradius. For example in Debian linux, simply type:

apt-get install freeradius-mysql