Freeradius and MySQL -- missing libraries?

Hello all,

This may very well be more of a MySQL question, but since it's directly
involved with me integrating it into FreeRADIUS, I'm hoping someone can
give me a pointer...

First off, I've already got two RADIUS servers that authenticate using a
replicated flat text users file. i want to move to SQL.

On one machine, when I try and implement SQL, I get this in debugging
mode:

rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found
rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the
search path of your system's ld.

I DO have the file /usr/local/lib/rlm_sql_mysql.so, and /usr/local/lib is
in /etc/ld.so.conf.

When I run an ldd though, I see this:
# ldd rlm_sql_mysql.so
libmysqlclient.so.12 => not found
libz.so.1 => /usr/lib/libz.so.1 (0x4000b000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x40019000)
libnsl.so.1 => /lib/libnsl.so.1 (0x40046000)
libm.so.6 => /lib/libm.so.6 (0x4005a000)
libc.so.6 => /lib/libc.so.6 (0x4007b000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)

Am I getting that error in debugging more since libmysqlclient.so.12 is
missing, which causes rlm_sql_mysql.so to fail as well?

OK..on the OTHER RADIUS machine, when attempting to implement SQL, I get:

rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and
linked
rlm_sql (sql): Attempting to connect to radius@saruman.w-link.net:/radius
rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql_mysql: Couldn't connect socket to MySQL server
radius@saruman.w-link.net:radius
rlm_sql_mysql: Mysql error 'Client does not support authentication
protocol requested by server; consider upgrading MySQL client'

This machine DOES have the libmysqlclient libraries, but maybe they're too
old?

In both cases, it looks like I need to upgrade these, but I can't seem to
find anyplace to get them. I don't want the whole blasted mySQL
server...just whatever it takes to get those libraries in place properly.
Has anyone run into this before?

Thanks much,

Rick Kunkel


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html