Thai DANG wrote: > I've got installation troubles with postgresql. I saw that it is a > recurrent questions in the mailing but I did not find a valable answer. > This is the trace when I launch radiusd -X > > I have included /usr/local/lib in my LD_LIBRARY_PATH > I ve got a linux mandrake 8.2 > gcc 2.96 > > any idea ?? > > cheers > > > > > > ----------------------------------------- > > Module: Loaded SQL > sql: driver = "rlm_sql_postgresql" > sql: server = "localhost" > sql: port = "" > sql: login = "postgres" > sql: password = "postgres" > sql: radius_db = "mydatabase" > 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 = "/usr/local/var/log/radius/sqltrace.sql" > sql: deletestalesessions = yes > sql: num_sql_socks = 5 > sql: sql_user_name = "%{User-Name}" > sql: authorize_check_query = "SELECT id,UserName,Attribute,Value FROM > radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY id" > sql: authorize_reply_query = "SELECT id,UserName,Attribute,Value FROM > radreply WHERE Username = '%{SQL-User-Name}' ORDER BY id" > sql: authorize_group_check_query = "SELECT > radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value > 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,radgroupreply.Value > FROM radgroupreply,usergroup WHERE usergroup.Username = > '%{SQL-User-Name}' AND usergroup.GroupName = radgroupreply.GroupName > ORDER BY radgroupreply.id" > sql: authenticate_query = "SELECT Value,Attribute FROM radcheck WHERE > UserName = '%{User-Name}' AND ( Attribute = 'User-Password' OR > Attribute = 'Crypt-Password' ) ORDER BY Attribute DESC" > sql: accounting_onoff_query = "UPDATE radacct SET AcctStopTime='%S', > AcctSessionTime=extract(epoch from (timestamp('%S') - > 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 (AcctSessionId, > AcctUniqueId, UserName, Realm, NASIPAddress, NASPort, NASPortType, > AcctStartTime, 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', '%{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}', FramedIPAddress = '%{Framed-IP-Address}', > 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 ( > AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPort, > 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: connect_failure_retry_delay = 60 > sql: simul_count_query = "" > sql: simul_verify_query = "" > sql: simul_zap_query = "" > rlm_sql: Could not link driver rlm_sql_postgresql: file not found > rlm_sql: Make sure it (and all its dependent libraries!) are in the > search path of your system's ld. > radiusd.conf[8]: sql: Module instantiation failed. > > > - List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html
It seems to me that you didn't compile the module for postgresql. Maybe the configure didn't find the postgresql headers. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html