rlm_sql Segmentation Fault

[Christopher Carver]

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