rlm_sql Segmentation Fault

[Shawn Hamman]

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