Greetings all,
I'm attempting to get a working and happy install of FreeRADIUS
authenticating off a MySQL database.
FreeRADIUS works without complaint on flatfiles, but with the sql module
in, it balks.
I'm using FreeRADIUS 0.8, with MySQL 3.23.49 which I compiled myself and
installed (which includes all of the libs and headers) on a Linux 2.4.17
box.
I'm aware of the need for FreeRADIUS to need to find the MySQL headers and
libraries. However the usual libraries are in the usual places
(/usr/local/mysql/lib/mysql/ and /usr/local/mysql/include/mysql/).
I'm assuming I haven't got something in the right place...
Any help would be greatly appreciated, I've included a little info below
in the hopes of tracking this down.
My 'ldconfig -p | grep mysql':
libmysqlclient.so.10 (libc6) => /usr/local/mysql/lib/mysql/libmysqlclient.so.10
libmysqlclient.so.6 (libc6) => /usr/lib/libmysqlclient.so.6
libmysqlclient.so (libc6) => /usr/local/mysql/lib/mysql/libmysqlclient.so
The trailing end of the 'radiusd -X':
rad_recv: Access-Request packet from host 127.0.0.1:60367, id=95, length=60
User-Name = "testuser"
User-Password = "testpass"
NAS-IP-Address = 255.255.255.255
NAS-Port = 1
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
rlm_realm: No '@' in User-Name = "testuser", looking up realm NULL
rlm_realm: No such realm NULL
modcall[authorize]: module "suffix" returns noop
radius_xlat: 'testuser'
rlm_sql (sql): sql_set_user escaped user --> 'testuser'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username =
'testuser' 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 = 'testuser' ORDER BY id
./radiusd: error in loading shared libraries:
/usr/local/radiusd/lib/rlm_sql_mysql.so.0: undefined symbol: mysql_errno
Many thanks for your time folks,
JP Hindin
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
