Re: Freeradius and MySQL -- missing libraries?

On Fri, Apr 01, 2005 at 12:42:18PM -0800, Rick Kunkel wrote:
> Hello all,
> 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?

Yes.

> 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?

That's right. You'll find you've got a mySQL 4.1 server, and
libmysqlclient.so.10 (from mySQL 3.x) installed. They won't work
together out of the box. You can tell the mySQL server to use the old
style of password authentication, as a workaround, I believe.

--
Paul "TBBle" Hampson, on an alternate email client.

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