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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
