and the file /usr/local/lib/rlm_sql_mysql.la:
# rlm_sql_mysql.la - a libtool library file
# Generated by ltmain.sh - GNU libtool 1.4.2 (1.922.2.54 2001/09/11
03:33:37)
#
# Please DO NOT delete this file!
# It is necessary for linking the library.
# The name that we can dlopen(3).
dlname='rlm_sql_mysql.so.0'
# Names of this library.
library_names='rlm_sql_mysql.so.0 rlm_sql_mysql.so rlm_sql_mysql.so'
# The name of the static archive.
old_library='rlm_sql_mysql.a'
# Libraries that this one depends upon.
dependency_libs=' -L/usr/local/lib/mysql -lmysqlclient -lz'
# Version information for rlm_sql_mysql.
current=0
age=0
revision=0
# Is this an already installed library?
installed=yes
# Files to dlopen/dlpreopen
dlopen=''
dlpreopen=''
# Directory that this library needs to be installed in:
libdir='/usr/local/lib'
----- Original Message -----
From: "Jeff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 18, 2003 12:14 AM
Subject: Re: MySQL database error
> 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
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
