Re: MySQL database error
On Wed, Jun 18, 2003 at 12:14:12AM -0500, Jeff wrote: Ok I installed version 0.8.1, but I still see the open(/usr/local/lib/libradius-0.7.so, O_RDONLY) = 3 line. This would indicate-as you said that the linker is not working correctly? Or looking in the wrong place? No, if you see that it means you are NOT running 0.8.1. ie, not a linker problem, it's user error. :-) Here is the output from radiusd -X (running version 0.8.1): oh sorry, you did put in the strace, I didn't read that far. And strace -e open radiusd: [MOCKINGBIRD.ROOT][/home/jefft/freeradius-0.8.1]# strace -e open radiusd ... This needs to be radiusd -X. From what you've shown I can't verify what version this is and what it's doing. Also, you are probably not running what you think you are. I certainly hope '.' is not your $PATH. /fc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL database error
On Wed, Jun 18, 2003 at 12:14:12AM -0500, Jeff wrote: Ok I installed version 0.8.1, but I still see the open(/usr/local/lib/libradius-0.7.so, O_RDONLY) = 3 line. This would indicate-as you said that the linker is not working correctly? Or looking in the wrong place? Here is the output from radiusd -X (running version 0.8.1): [MOCKINGBIRD.ROOT][/home/jefft/freeradius-0.8.1]# radiusd -X You are not showing strace. /fc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: MySQL database error
Ok I got freeradius-0.8.1 installed! It was indeed a malfunctioning linker, so I backed up all of my configs and reinstalled FreeBSD. I compiled mysql4 and freeradius8 without any problems, but now mysql is not authenticating users... I get the following error from radiusd -X: rad_recv: Access-Request packet from host 204.57.72.47:1026, id=33, length=57 User-Name = jefft User-Password = jefft1 NAS-IP-Address = 204.57.72.47 NAS-Port = 99 rad_rmspace_pair: User-Name now 'jefft' rad_rmspace_pair: User-Password now 'jefft1' modcall: entering group authorize modcall[authorize]: module preprocess returns ok rlm_chap: Could not find proper Chap-Password attribute in request modcall[authorize]: module chap returns noop modcall[authorize]: module mschap returns notfound radius_xlat: 'jefft' rlm_sql (sql): sql_set_user escaped user -- 'jefft' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'jefft' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 4 rlm_sql_mysql: query: SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'jefft' ORDER BY id radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'jefft' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' rlm_sql_mysql: query: SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'jefft' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'jefft' ORDER BY id' rlm_sql_mysql: query: SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'jefft' ORDER BY id radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'jefft' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql_mysql: query: SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'jefft' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id rlm_sql (sql): Released sql socket id: 4 modcall[authorize]: module sql returns ok users: Matched DEFAULT at 150 modcall[authorize]: module files returns ok modcall: group authorize returns ok rad_check_password: Found Auth-Type System auth: type System auth: Failed to validate the user. Login incorrect: [jefft/jefft1] (from client NAS port 99) rad_lowerpair: User-Name now 'jefft' modcall: entering group authorize modcall[authorize]: module preprocess returns ok rlm_chap: Could not find proper Chap-Password attribute in request modcall[authorize]: module chap returns noop modcall[authorize]: module mschap returns notfound radius_xlat: 'jefft' rlm_sql (sql): sql_set_user escaped user -- 'jefft' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'jefft' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 3 rlm_sql_mysql: query: SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'jefft' ORDER BY id radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'jefft' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' rlm_sql_mysql: query: SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'jefft' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'jefft' ORDER BY id' rlm_sql_mysql: query: SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'jefft' ORDER BY id radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'jefft' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql_mysql: query: SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'jefft' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id rlm_sql (sql): Released sql socket id: 3 modcall[authorize]: module sql returns ok users: Matched DEFAULT at 150 modcall[authorize]: module files returns ok modcall: group authorize returns ok rad_check_password: Found Auth-Type System auth: type System auth: Failed to
Re: MySQL database error
On Wednesday 18 June 2003 4:18 pm, Jeff Thompson - World Net Technical Support wrote: Ok I got freeradius-0.8.1 installed! ... but now mysql is not authenticating users... I get the following error from radiusd -X: rad_recv: Access-Request packet from host 204.57.72.47:1026, id=33, length=57 User-Name = jefft User-Password = jefft1 NAS-IP-Address = 204.57.72.47 NAS-Port = 99 [...] rlm_sql_mysql: query: SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'jefft' ORDER BY id [...] modcall[authorize]: module sql returns ok users: Matched DEFAULT at 150 modcall[authorize]: module files returns ok modcall: group authorize returns ok rad_check_password: Found Auth-Type System auth: type System As I understand it, auth type system means use the unix passwd/shadow file. You need to set auth-type := local at some point [either in the defualt entry in the users file, or as one of the radcheck entries for username=jefft in the database] -- Yet another Blog: http://osnut.homelinux.net pgp0.pgp Description: signature
Re: MySQL database error
That was indeed it! It was set to system, changing it to Local worked! I'm finally done, and many many thanks to this list! On Wednesday 18 June 2003 4:18 pm, Jeff Thompson - World Net Technical Support wrote: Ok I got freeradius-0.8.1 installed! ... but now mysql is not authenticating users... I get the following error from radiusd -X: rad_recv: Access-Request packet from host 204.57.72.47:1026, id=33, length=57 User-Name = jefft User-Password = jefft1 NAS-IP-Address = 204.57.72.47 NAS-Port = 99 [...] rlm_sql_mysql: query: SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'jefft' ORDER BY id [...] modcall[authorize]: module sql returns ok users: Matched DEFAULT at 150 modcall[authorize]: module files returns ok modcall: group authorize returns ok rad_check_password: Found Auth-Type System auth: type System As I understand it, auth type system means use the unix passwd/shadow file. You need to set auth-type := local at some point [either in the defualt entry in the users file, or as one of the radcheck entries for username=jefft in the database] -- Yet another Blog: http://osnut.homelinux.net - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL database error
On Tue, Jun 17, 2003 at 07:30:57PM -0500, Jeff Thompson - World Net Technical Support wrote: Can someone give me some ideas here? 0.7 is the only version I can get to work on FreeBSD, but would like to use .8.1 if it would load the mysql modules. Anyone? It'd be good if you could post the radiusd -X intermingled with strace output. (Whatever the strace equiv is on FreeBSD.) /fc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL database error
This was covered all yesterday, but here is the output of radiusd -x when compiled using the source tarball from freeradius.org using ./configure --with-raddbdir=/etc/raddb --with-logdir=/var/log/radius: [MOCKINGBIRD.ROOT][/home/jefft/freeradius-0.8.1]# radiusd -x Starting - reading configuration files ... Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded preprocess Module: Instantiated preprocess (preprocess) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded SQL 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. radiusd.conf[14]: sql: Module instantiation failed. I go to the ports collection provided with FreeBSD (/usr/ports/net/freeradius/work/freeradius-0.7) and run the SAME configure line: ./configure --with-raddbdir=/etc/raddb --with-logdir=/var/log/radius It builds, installs and loads the sql module with no problem: [MOCKINGBIRD.ROOT][/usr/ports/net/freeradius/work/freeradius-0.7]# radiusd -x Starting - reading configuration files ... Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded preprocess Module: Instantiated preprocess (preprocess) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded SQL rlm_sql: Driver rlm_sql_mysql loaded and linked rlm_sql: Attempting to connect to [EMAIL PROTECTED]:/radius rlm_sql: starting 0 rlm_sql: Attempting to connect #0 rlm_sql: Starting connect to MySQL server for #0 rlm_sql: Connected new DB handle, #0 rlm_sql: starting 1 rlm_sql: Attempting to connect #1 rlm_sql: Starting connect to MySQL server for #1 rlm_sql: Connected new DB handle, #1 rlm_sql: starting 2 rlm_sql: Attempting to connect #2 rlm_sql: Starting connect to MySQL server for #2 rlm_sql: Connected new DB handle, #2 rlm_sql: starting 3 rlm_sql: Attempting to connect #3 rlm_sql: Starting connect to MySQL server for #3 rlm_sql: Connected new DB handle, #3 rlm_sql: starting 4 rlm_sql: Attempting to connect #4 rlm_sql: Starting connect to MySQL server for #4 rlm_sql: Connected new DB handle, #4 Module: Instantiated sql (sql) Module: Loaded files [/etc/raddb/users]:80 Cistron compatibility checks for entry steve ... [/etc/raddb/users]:150 Cistron compatibility checks for entry DEFAULT ... [/etc/raddb/users]:169 Cistron compatibility checks for entry DEFAULT ... [/etc/raddb/users]:181 Cistron compatibility checks for entry DEFAULT ... [/etc/raddb/users]:188 Cistron compatibility checks for entry DEFAULT ... [/etc/raddb/users]:195 Cistron compatibility checks for entry DEFAULT ... Module: Instantiated files (files) Module: Loaded realm Module: Instantiated realm (suffix) Module: Loaded radutmp Module: Instantiated radutmp (radutmp) Initializing the thread pool... Listening on IP address *, ports 1645/udp and 1646/udp. Ready to process requests. I have tried all of the ./configure switches to try and get .8 or .8.1 to load the rlm_sql_mysql module-but it will not. I KNOW this module is installing, but when radiusd goes to start it crashes. I REALLY need to get this working with mysql, but cannot make heads or tails of the problems I am having... On Tue, Jun 17, 2003 at 07:30:57PM -0500, Jeff Thompson - World Net Technical Support wrote: Can someone give me some ideas here? 0.7 is the only version I can get to work on FreeBSD, but would like to use .8.1 if it would load the mysql modules. Anyone? It'd be good if you could post the radiusd -X intermingled with strace output. (Whatever the strace equiv is on FreeBSD.) /fc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL database error
On Tue, Jun 17, 2003 at 10:16:55PM -0500, Jeff Thompson - World Net Technical Support wrote: This was covered all yesterday, but here is the output of radiusd -x when See below On Tue, Jun 17, 2003 at 07:30:57PM -0500, Jeff Thompson - World Net Technical Support wrote: Can someone give me some ideas here? 0.7 is the only version I can get to work on FreeBSD, but would like to use .8.1 if it would load the mysql modules. Anyone? It'd be good if you could post the radiusd -X intermingled with strace output. (Whatever the strace equiv is on FreeBSD.) You missed that last part. Actually, just the 'strace -e open' equivalent. Just plain strace would be too noisy. /fc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL database error
/rlm_realm.la, O_RDONLY) = 10 open(/usr/local/lib/rlm_realm.a, O_RDONLY) = 10 open(/usr/local/lib/rlm_realm-0.7.so, O_RDONLY) = 10 open(/usr/local/lib/rlm_radutmp.la, O_RDONLY) = 10 open(/usr/local/lib/rlm_radutmp.a, O_RDONLY) = 10 open(/usr/local/lib/rlm_radutmp-0.7.so, O_RDONLY) = 10 open(/etc/spwd.db, O_RDONLY) = 10 open(/etc/group, O_RDONLY)= 10 - Original Message - From: Frank Cusack [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:35 PM Subject: Re: MySQL database error On Tue, Jun 17, 2003 at 10:16:55PM -0500, Jeff Thompson - World Net Technical Support wrote: This was covered all yesterday, but here is the output of radiusd -x when See below On Tue, Jun 17, 2003 at 07:30:57PM -0500, Jeff Thompson - World Net Technical Support wrote: Can someone give me some ideas here? 0.7 is the only version I can get to work on FreeBSD, but would like to use .8.1 if it would load the mysql modules. Anyone? It'd be good if you could post the radiusd -X intermingled with strace output. (Whatever the strace equiv is on FreeBSD.) You missed that last part. Actually, just the 'strace -e open' equivalent. Just plain strace would be too noisy. /fc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL database error
And here's some more output, this is my buffer after trying to login to my NAS using the 'jefft' account I created in mysql database 'radius' rad_recv: Access-Request packet from host 204.57.72.47:1026, id=19, length=57 User-Name = jefft User-Password = \207C\017J\366\353\253\221\231Z8\370)M\377\336 NAS-IP-Address = 204.57.72.47 NAS-Port = 99 rlm_chap: Could not find proper Chap-Password attribute in request rlm_sql: Reserving sql socket id: 2 query: SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'jefft' ORDER BY id query: SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche ck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'jefft' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id query: SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'jefft' ORDER BY id query: SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep ly.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'jefft' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id query: MYSQL check_error: 1065 received rlm_sql_authorize: database query error rlm_sql: Released sql socket id: 2 rad_recv: Access-Request packet from host 204.57.72.47:1026, id=19, length=57 Sending Access-Reject of id 19 to 204.57.72.47:1026 rad_recv: Access-Request packet from host 204.57.72.47:1026, id=20, length=57 User-Name = jefft User-Password = \345\253q\320\006\243\271\222)\314\246\326x\250\357\242 NAS-IP-Address = 204.57.72.47 NAS-Port = 99 rlm_chap: Could not find proper Chap-Password attribute in request rlm_sql: Reserving sql socket id: 1 query: SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'jefft' ORDER BY id query: SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche ck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'jefft' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id query: SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'jefft' ORDER BY id query: SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep ly.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'jefft' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id query: MYSQL check_error: 1065 received rlm_sql_authorize: database query error rlm_sql: Released sql socket id: 1 rad_recv: Access-Request packet from host 204.57.72.47:1026, id=20, length=57 Sending Access-Reject of id 20 to 204.57.72.47:1026 - Original Message - From: Frank Cusack [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:35 PM Subject: Re: MySQL database error On Tue, Jun 17, 2003 at 10:16:55PM -0500, Jeff Thompson - World Net Technical Support wrote: This was covered all yesterday, but here is the output of radiusd -x when See below On Tue, Jun 17, 2003 at 07:30:57PM -0500, Jeff Thompson - World Net Technical Support wrote: Can someone give me some ideas here? 0.7 is the only version I can get to work on FreeBSD, but would like to use .8.1 if it would load the mysql modules. Anyone? It'd be good if you could post the radiusd -X intermingled with strace output. (Whatever the strace equiv is on FreeBSD.) You missed that last part. Actually, just the 'strace -e open' equivalent. Just plain strace would be too noisy. /fc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL database error
On Tue, Jun 17, 2003 at 10:40:57PM -0500, Jeff wrote: [MOCKINGBIRD.ROOT][/home/jefft]# strace -e open radiusd really should have done radiusd -X, but still the info here is good: open(/usr/local/lib/libradius-0.7.so, O_RDONLY) = 3 first of all, this is freeradius 0.7, not 0.8.1 or CVS (CVS will say 0.8.1 as well) ... open(/usr/local/lib/rlm_sql.la, O_RDONLY) = 5 open(/usr/local/lib/rlm_sql.a, O_RDONLY) = 5 open(/usr/local/lib/rlm_sql-0.7.so, O_RDONLY) = 5 open(/usr/local/lib/rlm_sql_mysql.la, O_RDONLY) = 5 open(/usr/local/lib/libz.la, O_RDONLY) = -1 ENOENT (No such file or directory) Can you show me the contents of /usr/local/lib/rlm_sql_mysql.la ? (It's a text file) open(/usr/local/lib/libz.la, O_RDONLY) = -1 ENOENT (No such file or directory) open(/usr/local/lib/libz.la, O_RDONLY) = -1 ENOENT (No such file or directory) open(/lib/libz.la, O_RDONLY) = -1 ENOENT (No such file or directory) open(/usr/lib/libz.la, O_RDONLY) = -1 ENOENT (No such file or directory) open(libz.la, O_RDONLY) = -1 ENOENT (No such file or directory) open(/usr/local/lib/libmysqlclient.la, O_RDONLY) = -1 ENOENT (No such file or directory) open(/usr/local/lib/libmysqlclient.la, O_RDONLY) = -1 ENOENT (No such file or directory) open(/usr/local/lib/libmysqlclient.la, O_RDONLY) = -1 ENOENT (No such file or directory) open(/lib/libmysqlclient.la, O_RDONLY) = -1 ENOENT (No such file or directory) open(/usr/lib/libmysqlclient.la, O_RDONLY) = -1 ENOENT (No such file or directory) open(libmysqlclient.la, O_RDONLY) = -1 ENOENT (No such file or directory) So the problem should be clear ... the mysql lib either cannot be found, or the runtime linker is not configured properly, or the library path is not encoded into the rlm_sql_mysql library properly. open(/usr/local/lib/rlm_sql_mysql.a, O_RDONLY) = 5 open(/usr/local/lib/rlm_sql_mysql.so.0, O_RDONLY) = 5 This is not a versioned library; an indicator that this is not the CVS freeradiusd. (But we already knew that.) open(/usr/lib/libmysqlclient.so.10, O_RDONLY) = 5 open(/usr/lib/libz.so.2, O_RDONLY)= 5 So here, you can see libz was found. It's hard to tell exactly from this trace, but it's likely that this one is found because the system libmysqlclient is correct while the freeradius module is incorrect (regarding the library path). You'll need to post 0.8.1 results (or preferrably CVS) for me to go further. I'm not interested in looking at 0.7 issues. /fc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL database error
/group, O_RDONLY)= 5 - Original Message - From: Frank Cusack [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 11:58 PM Subject: Re: MySQL database error On Tue, Jun 17, 2003 at 10:40:57PM -0500, Jeff wrote: [MOCKINGBIRD.ROOT][/home/jefft]# strace -e open radiusd really should have done radiusd -X, but still the info here is good: open(/usr/local/lib/libradius-0.7.so, O_RDONLY) = 3 first of all, this is freeradius 0.7, not 0.8.1 or CVS (CVS will say 0.8.1 as well) ... open(/usr/local/lib/rlm_sql.la, O_RDONLY) = 5 open(/usr/local/lib/rlm_sql.a, O_RDONLY) = 5 open(/usr/local/lib/rlm_sql-0.7.so, O_RDONLY) = 5 open(/usr/local/lib/rlm_sql_mysql.la, O_RDONLY) = 5 open(/usr/local/lib/libz.la, O_RDONLY) = -1 ENOENT (No such file or directory) Can you show me the contents of /usr/local/lib/rlm_sql_mysql.la ? (It's a text file) open(/usr/local/lib/libz.la, O_RDONLY) = -1 ENOENT (No such file or directory) open(/usr/local/lib/libz.la, O_RDONLY) = -1 ENOENT (No such file or directory) open(/lib/libz.la, O_RDONLY) = -1 ENOENT (No such file or directory) open(/usr/lib/libz.la, O_RDONLY) = -1 ENOENT (No such file or directory) open(libz.la, O_RDONLY) = -1 ENOENT (No such file or directory) open(/usr/local/lib/libmysqlclient.la, O_RDONLY) = -1 ENOENT (No such file or directory) open(/usr/local/lib/libmysqlclient.la, O_RDONLY) = -1 ENOENT (No such file or directory) open(/usr/local/lib/libmysqlclient.la, O_RDONLY) = -1 ENOENT (No such file or directory) open(/lib/libmysqlclient.la, O_RDONLY) = -1 ENOENT (No such file or directory) open(/usr/lib/libmysqlclient.la, O_RDONLY) = -1 ENOENT (No such file or directory) open(libmysqlclient.la, O_RDONLY) = -1 ENOENT (No such file or directory) So the problem should be clear ... the mysql lib either cannot be found, or the runtime linker is not configured properly, or the library path is not encoded into the rlm_sql_mysql library properly. open(/usr/local/lib/rlm_sql_mysql.a, O_RDONLY) = 5 open(/usr/local/lib/rlm_sql_mysql.so.0, O_RDONLY) = 5 This is not a versioned library; an indicator that this is not the CVS freeradiusd. (But we already knew that.) open(/usr/lib/libmysqlclient.so.10, O_RDONLY) = 5 open(/usr/lib/libz.so.2, O_RDONLY)= 5 So here, you can see libz was found. It's hard to tell exactly from this trace, but it's likely that this one is found because the system libmysqlclient is correct while the freeradius module is incorrect (regarding the library path). You'll need to post 0.8.1 results (or preferrably CVS) for me to go further. I'm not interested in looking at 0.7 issues. /fc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html