Configure probably isn't finding the mysql libraries and/or header files and isn't compiling the rlm_sql module properly. I'm not sure why this is happening if everything is identical like you say, but its my bet. Look in your freeradius-1.1.1/lib/ directory for the rlm_sql module files. If they are not there, that is definitely your problem. Watch the configure closely. Try to point it where the mysql stuff is. Good luck. Chris Carver Shawn Hamman wrote:

Ok, I am going insane.

This is the story:

I have two IDENTICAL servers, HP DL320, Intel P4

I have Fedora Core 5 installed on both with IDENTICAL packages.

I downloaded, extracted the freeradius-1.1.1.tar.gz and proceeded to configure with the exact same configure statement.

I installed IDENTICAL perl modules on both servers.

I use IDENTICAL radius.conf, sql.conf etc. configuration files.

Server 1 works fine. No problems what so ever.

Server 2 throws a seg fault when loading the rlm_sql module.

I have: - enabled and disabled shared modules and packages - make clean, make distclean, manually remove every freeradius file - re-loaded the server from scratch - changed the processor from a P4 to a XEON to a P4

FreeRadius works just fine, right up until I load the rlm_sql module.

Setup:

Linux rad2. .net 2.6.15-1.2054_FC5smp #1 SMP Tue Mar 14 16:05:46 EST 2006 i686 i686 i386 GNU/Linux mysql-5.0.18-2.1

./configure --with-logdir=/var/log --with-radacctdir=/var/log --with-raddbdir=/etc/raddb --enable-developer

Debug: ... ... Module: Loaded eap eap: default_eap_type = "md5" eap: timer_expire = 60 eap: ignore_unknown_eap_types = no eap: cisco_accounting_username_bug = no rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap gtc: challenge = "Password: " gtc: auth_type = "PAP" rlm_eap: Loaded and initialized type gtc mschapv2: with_ntdomain_hack = no rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Module: Loaded SQL sql: driver = "rlm_sql_mysql" sql: server = "192.168.0.8" sql: port = "" sql: login = "root" sql: password = "mysql" sql: radius_db = "radius" sql: acct_table = "radacct" sql: acct_table2 = "radacct" ... ... ... sql: group_membership_query = "SELECT GroupName FROM usergroup WHERE UserName='%{SQL-User-Name}'" sql: connect_failure_retry_delay = 60 sql: simul_count_query = "" sql: simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName, NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, FramedProtocol FROM radacct WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0" sql: postauth_table = "radpostauth" sql: postauth_query = "INSERT into radpostauth (id, user, pass, reply, date) values ('', '%{User-Name}', '%{User-Password:-Chap-Password}', '%{reply:Packet-Type}', NOW())" sql: safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" Segmentation fault (core dumped)

Core dump:

Reading symbols from /usr/local/lib/rlm_eap_mschapv2-1.1.1.so...done. Loaded symbols for /usr/local/lib/rlm_eap_mschapv2-1.1.1.so Reading symbols from /usr/local/lib/rlm_sql-1.1.1.so...done. Loaded symbols for /usr/local/lib/rlm_sql-1.1.1.so #0 0x00d789c9 in lt_dlsym (handle=0x88de758, symbol=0x88dd158 "rlm_sql_mysql") at ltdl.c:3330 3330 lensym = LT_STRLEN (symbol) + LT_STRLEN (handle->loader->sym_prefix) (gdb) bt #0 0x00d789c9 in lt_dlsym (handle=0x88de758, symbol=0x88dd158 "rlm_sql_mysql") at ltdl.c:3330 #1 0x00fb65fa in rlm_sql_instantiate (conf=0x88307e0, instance=0x88dcb40) at rlm_sql.c:696 #2 0x0805303b in find_module_instance (instname=0x88339c8 "sql") at modules.c:358 #3 0x08053e1a in do_compile_modsingle (component=0, ci=0x88339a8, filename=0x805e931 "radiusd.conf", grouptype=0, modname=0xbf835314) at modcall.c:1005 #4 0x080536f3 in setup_modules () at modules.c:570 #5 0x080566db in main (argc=2, argv=0xbf8365a4) at radiusd.c:960

Does anybody out there have any ideas?

Shawn

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

Shawn Hamman wrote:

(gdb) bt #0 0x00d789c9 in lt_dlsym (handle=0x88de758, symbol=0x88dd158 "rlm_sql_mysql") at ltdl.c:3330 #1 0x00fb65fa in rlm_sql_instantiate (conf=0x88307e0, instance=0x88dcb40) at rlm_sql.c:696 #2 0x0805303b in find_module_instance (instname=0x88339c8 "sql") at modules.c:358 #3 0x08053e1a in do_compile_modsingle (component=0, ci=0x88339a8, filename=0x805e931 "radiusd.conf", grouptype=0, modname=0xbf835314) at modcall.c:1005 #4 0x080536f3 in setup_modules () at modules.c:570 #5 0x080566db in main (argc=2, argv=0xbf8365a4) at radiusd.c:960

Does anybody out there have any ideas?

It looks like bug #98. http://bugs.freeradius.org/show_bug.cgi?id=98 -- Nicolas Baradakis