Ok I installed version 0.8.1, but I still see the >
open("/usr/local/lib/libradius-0.7.so", O_RDONLY) = 3
line. This would indicate-as you said that the linker is not working
correctly? Or looking in the wrong place?
Here is the output from radiusd -X (running version 0.8.1):
[MOCKINGBIRD.ROOT][/home/jefft/freeradius-0.8.1]# radiusd -X
Starting - reading configuration files ...
reread_config: reading radiusd.conf
Config: including file: /etc/raddb/proxy.conf
Config: including file: /etc/raddb/clients.conf
Config: including file: /etc/raddb/snmp.conf
Config: including file: /etc/raddb/sql.conf
main: prefix = "/usr/local/"
main: localstatedir = "/var"
main: logdir = "/var/log/radius"
main: libdir = "/usr/local//lib:/usr/local/lib"
main: radacctdir = "/var/log/radius/radacct"
main: hostname_lookups = no
main: max_request_time = 30
main: cleanup_delay = 5
main: max_requests = 1024
main: delete_blocked_requests = 0
main: port = 1645
main: allow_core_dumps = no
main: log_stripped_names = yes
main: log_file = "/var/log/radius/radius.log"
main: log_auth = yes
main: log_auth_badpass = yes
main: log_auth_goodpass = no
main: pidfile = "/var/run/radiusd/radiusd.pid"
main: user = "radius"
main: group = "radius"
main: usercollide = no
main: lower_user = "after"
main: lower_pass = "no"
main: nospace_user = "before"
main: nospace_pass = "before"
main: checkrad = "/usr/local//sbin/checkrad"
main: proxy_requests = no
proxy: retry_delay = 5
proxy: retry_count = 3
proxy: synchronous = no
proxy: default_fallback = yes
proxy: dead_time = 120
proxy: servers_per_realm = 15
security: max_attributes = 200
security: reject_delay = 1
security: status_server = no
main: debug_level = 0
read_config_files: reading dictionary
read_config_files: reading naslist
read_config_files: reading clients
read_config_files: reading realms
radiusd: entering modules setup
Module: Library search path is /usr/local/lib:/usr/local/lib
Module: Loaded expr
Module: Instantiated expr (expr)
Module: Loaded MS-CHAP
mschap: ignore_password = no
mschap: use_mppe = yes
mschap: require_encryption = no
mschap: require_strong = no
mschap: passwd = "(null)"
mschap: authtype = "MS-CHAP"
Module: Instantiated mschap (mschap)
Module: Loaded preprocess
preprocess: huntgroups = "/etc/raddb/huntgroups"
preprocess: hints = "/etc/raddb/hints"
preprocess: with_ascend_hack = no
preprocess: ascend_channels_per_line = 23
preprocess: with_ntdomain_hack = no
preprocess: with_specialix_jetstream_hack = no
preprocess: with_cisco_vsa_hack = no
Module: Instantiated preprocess (preprocess)
Module: Loaded CHAP
Module: Instantiated chap (chap)
Module: Loaded SQL
sql: driver = "rlm_sql_mysql"
sql: server = "localhost"
sql: port = ""
sql: login = "root"
sql: password = "password"
sql: radius_db = "radius"
sql: acct_table = "radacct"
sql: acct_table2 = "radacct"
sql: authcheck_table = "radcheck"
sql: authreply_table = "radreply"
sql: groupcheck_table = "radgroupcheck"
sql: groupreply_table = "radgroupreply"
sql: usergroup_table = "usergroup"
sql: nas_table = "nas"
sql: dict_table = "dictionary"
sql: sqltrace = yes
sql: sqltracefile = "/var/log/radius/sqltrace.sql"
sql: deletestalesessions = yes
sql: num_sql_socks = 5
sql: sql_user_name = "%{User-Name}"
sql: default_user_profile = ""
sql: query_on_not_found = no
sql: authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM
radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY id"
sql: authorize_reply_query = "SELECT id,UserName,Attribute,Value,op FROM
radreply WHERE Username = '%{SQL-User-Name}' ORDER BY id"
sql: authorize_group_check_query = "SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche
ck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE
usergroup.Username = '%{SQL-User-Name}' AND usergroup.GroupName =
radgroupcheck.GroupName ORDER BY radgroupcheck.id"
sql: authorize_group_reply_query = "SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep
ly.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE
usergroup.Username = '%{SQL-User-Name}' AND usergroup.GroupName =
radgroupreply.GroupName ORDER BY radgroupreply.id"
sql: accounting_onoff_query = "UPDATE radacct SET AcctStopTime='%S',
AcctSessionTime=unix_timestamp('%S') - unix_timestamp(AcctStartTime),
AcctTerminateCause='%{Acct-Terminate-Cause}', AcctStopDelay =
%{Acct-Delay-Time} WHERE AcctSessionTime=0 AND AcctStopTime=0 AND
NASIPAddress= '%{NAS-IP-Address}' AND AcctStartTime <= '%S'"
sql: accounting_update_query = "UPDATE radacct SET FramedIPAddress =
'%{Framed-IP-Address}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND
UserName = '%{SQL-User-Name}' AND NASIPAddress= '%{NAS-IP-Address}' AND
AcctStopTime = 0"
sql: accounting_start_query = "INSERT into radacct (RadAcctId,
AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId,
NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic,
ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets,
CalledStationId, CallingStationId, AcctTerminateCause, ServiceType,
FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('',
'%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}',
'%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S',
'0', '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0',
'%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}',
'%{Framed-Protocol}', '%{Framed-IP-Address}', '%{Acct-Delay-Time}', '0')"
sql: accounting_start_query_alt = "UPDATE radacct SET AcctStartTime = '%S',
AcctStartDelay = '%{Acct-Delay-Time}', ConnectInfo_start = '%{Connect-Info}'
WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}'
AND NASIPAddress = '%{NAS-IP-Address}' AND AcctStopTime = 0"
sql: accounting_stop_query = "UPDATE radacct SET AcctStopTime = '%S',
AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets =
'%{Acct-Input-Octets}', AcctOutputOctets = '%{Acct-Output-Octets}',
AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay =
'%{Acct-Delay-Time}', ConnectInfo_stop = '%{Connect-Info}' WHERE
AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND
NASIPAddress = '%{NAS-IP-Address}' AND AcctStopTime = 0"
sql: accounting_stop_query_alt = "INSERT into radacct (RadAcctId,
AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId,
NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic,
ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets,
CalledStationId, CallingStationId, AcctTerminateCause, ServiceType,
FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('',
'%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}',
'%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '0',
'%S', '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Connect-Info}',
'%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}',
'%{Calling-Station-Id}', '%{Acct-Terminate-Cause}', '%{Service-Type}',
'%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{Acct-Delay-Time}')"
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"
rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found
rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the
search path of your system's ld.
radiusd.conf[14]: sql: Module instantiation failed.
And strace -e open radiusd:
[MOCKINGBIRD.ROOT][/home/jefft/freeradius-0.8.1]# strace -e open radiusd
open("/var/run/ld-elf.so.hints", O_RDONLY) = 3
open("/usr/lib/libcrypt.so.2", O_RDONLY) = 3
open("/usr/lib/libcipher.so.2", O_RDONLY) = 3
open("/usr/local/lib/libradius-0.7.so", O_RDONLY) = 3
open("/usr/local/lib/libltdl.so.4", O_RDONLY) = 3
open("/usr/lib/libc_r.so.4", O_RDONLY) = 3
open("/usr/lib/libc.so.4", O_RDONLY) = 3
open("/etc/localtime", O_RDONLY) = 5
Wed Jun 18 07:14:03 2003 : Info: Starting - reading configuration files ...
open("/etc/raddb/radiusd.conf", O_RDONLY) = 5
open("/etc/raddb/proxy.conf", O_RDONLY) = 6
open("/etc/raddb/clients.conf", O_RDONLY) = 6
open("/etc/raddb/snmp.conf", O_RDONLY) = 6
open("/etc/raddb/sql.conf", O_RDONLY) = 6
open("/etc/raddb/dictionary", O_RDONLY) = 5
open("/etc/raddb/dictionary.compat", O_RDONLY) = 6
open("/etc/raddb/dictionary.acc", O_RDONLY) = 6
open("/etc/raddb/dictionary.ascend", O_RDONLY) = 6
open("/etc/raddb/dictionary.bay", O_RDONLY) = 6
open("/etc/raddb/dictionary.cisco", O_RDONLY) = 6
open("/etc/raddb/dictionary.cisco.vpn3000", O_RDONLY) = 6
open("/etc/raddb/dictionary.cisco.vpn5000", O_RDONLY) = 6
open("/etc/raddb/dictionary.cisco.bbsm", O_RDONLY) = 6
open("/etc/raddb/dictionary.colubris", O_RDONLY) = 6
open("/etc/raddb/dictionary.livingston", O_RDONLY) = 6
open("/etc/raddb/dictionary.microsoft", O_RDONLY) = 6
open("/etc/raddb/dictionary.nomadix", O_RDONLY) = 6
open("/etc/raddb/dictionary.quintum", O_RDONLY) = 6
open("/etc/raddb/dictionary.redback", O_RDONLY) = 6
open("/etc/raddb/dictionary.shasta", O_RDONLY) = 6
open("/etc/raddb/dictionary.shiva", O_RDONLY) = 6
open("/etc/raddb/dictionary.tunnel", O_RDONLY) = 6
open("/etc/raddb/dictionary.usr", O_RDONLY) = 6
open("/etc/raddb/dictionary.versanet", O_RDONLY) = 6
open("/etc/raddb/dictionary.erx", O_RDONLY) = 6
open("/etc/raddb/dictionary.freeradius", O_RDONLY) = 6
open("/etc/raddb/dictionary.alcatel", O_RDONLY) = 6
open("/etc/raddb/dictionary.juniper", O_RDONLY) = 6
open("/etc/raddb/dictionary.alteon", O_RDONLY) = 6
open("/etc/raddb/naslist", O_RDONLY) = 5
open("/etc/resolv.conf", O_RDONLY) = 6
open("/etc/host.conf", O_RDONLY) = 6
open("/etc/hosts", O_RDONLY) = 6
open("/etc/raddb/clients", O_RDONLY) = 5
open("/etc/raddb/realms", O_RDONLY) = 5
open("/etc/spwd.db", O_RDONLY) = 5
open("/etc/group", O_RDONLY) = 5
----- Original Message -----
From: "Frank Cusack" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 17, 2003 11:58 PM
Subject: Re: MySQL database error
> On Tue, Jun 17, 2003 at 10:40:57PM -0500, Jeff wrote:
> > [MOCKINGBIRD.ROOT][/home/jefft]# strace -e open radiusd
>
> really should have done radiusd -X, but still the info here is good:
>
> > open("/usr/local/lib/libradius-0.7.so", O_RDONLY) = 3
>
> first of all, this is freeradius 0.7, not 0.8.1 or CVS (CVS will say
> 0.8.1 as well)
>
> ...
>
> > open("/usr/local/lib/rlm_sql.la", O_RDONLY) = 5
> > open("/usr/local/lib/rlm_sql.a", O_RDONLY) = 5
> > open("/usr/local/lib/rlm_sql-0.7.so", O_RDONLY) = 5
> > open("/usr/local/lib/rlm_sql_mysql.la", O_RDONLY) = 5
> > open("/usr/local/lib/libz.la", O_RDONLY) = -1 ENOENT (No such file or
> > directory)
>
> Can you show me the contents of /usr/local/lib/rlm_sql_mysql.la ?
> (It's a text file)
>
> > open("/usr/local/lib/libz.la", O_RDONLY) = -1 ENOENT (No such file or
> > directory)
> > open("/usr/local/lib/libz.la", O_RDONLY) = -1 ENOENT (No such file or
> > directory)
> > open("/lib/libz.la", O_RDONLY) = -1 ENOENT (No such file or
> > directory)
> > open("/usr/lib/libz.la", O_RDONLY) = -1 ENOENT (No such file or
> > directory)
> > open("libz.la", O_RDONLY) = -1 ENOENT (No such file or
> > directory)
> > open("/usr/local/lib/libmysqlclient.la", O_RDONLY) = -1 ENOENT (No such
file
> > or directory)
> > open("/usr/local/lib/libmysqlclient.la", O_RDONLY) = -1 ENOENT (No such
file
> > or directory)
> > open("/usr/local/lib/libmysqlclient.la", O_RDONLY) = -1 ENOENT (No such
file
> > or directory)
> > open("/lib/libmysqlclient.la", O_RDONLY) = -1 ENOENT (No such file or
> > directory)
> > open("/usr/lib/libmysqlclient.la", O_RDONLY) = -1 ENOENT (No such file
or
> > directory)
> > open("libmysqlclient.la", O_RDONLY) = -1 ENOENT (No such file or
> > directory)
>
> So the problem should be clear ... the mysql lib either cannot be
> found, or the runtime linker is not configured properly, or the library
> path is not encoded into the rlm_sql_mysql library properly.
>
> > open("/usr/local/lib/rlm_sql_mysql.a", O_RDONLY) = 5
> > open("/usr/local/lib/rlm_sql_mysql.so.0", O_RDONLY) = 5
>
> This is not a versioned library; an indicator that this is not the CVS
> freeradiusd. (But we already knew that.)
>
> > open("/usr/lib/libmysqlclient.so.10", O_RDONLY) = 5
> > open("/usr/lib/libz.so.2", O_RDONLY) = 5
>
> So here, you can see libz was found. It's hard to tell exactly from
> this trace, but it's likely that this one is found because the system
> libmysqlclient is correct while the freeradius module is incorrect
> (regarding the library path).
>
> You'll need to post 0.8.1 results (or preferrably CVS) for me to go
> further. I'm not interested in looking at 0.7 issues.
>
> /fc
>
> -
> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
