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 [EMAIL PROTECTED]:/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 [EMAIL PROTECTED]: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