Hi After upgrading to FreeRadius 2.1.1 I get the following error after running the service for a while. I suspect it being a result of a malfunction during accounting data exchange.
/usr/local/sbin/radiusd: symbol lookup error: /usr/local/lib/rlm_sqlippool-2.1.1.so: undefined symbol: rlm_sql_query The below is the debug print up until the error. Anyone knowing what the problem might be? Maybe just point me into the right direction? Thanks in advance. ./rasmus rad_recv: Accounting-Request packet from host 192.168.7.9 port 1223, id=222, length=212 NAS-IP-Address = 192.168.7.9 NAS-Identifier = "xxx" Called-Station-Id = "xxxt" Framed-Protocol = GPRS-PDP-Context Service-Type = Framed-User NAS-Port-Type = Virtual Acct-Status-Type = Start Framed-IP-Address = 192.168.0.4 Acct-Session-Id = "3E87A45A1B7DE62F" User-Name = "xxx" 3GPP-IMSI = "xxx" Calling-Station-Id = "xxx" 3GPP-PDP-Type = 0 3GPP-GPRS-Negotiated-QoS-profile = "99-13921f739697b074821040" 3GPP-SGSN-Address = xxx 3GPP-Selection-Mode = "0" Acct-Authentic = RADIUS Acct-Delay-Time = 0 +- entering group preacct {...} ++[preprocess] returns ok [acct_unique] WARNING: Attribute NAS-Port was not found in request, unique ID MAY be inconsistent [acct_unique] Hashing ',Client-IP-Address = 192.168.7.9,NAS-IP-Address = 192.168.7.9,Acct-Session-Id = "3E87A45A1B7DE62F",User-Name = "xxx"' [acct_unique] Acct-Unique-Session-ID = "6156897ce44b112f". ++[acct_unique] returns ok [suffix] No '@' in User-Name = "xxx", looking up realm NULL [suffix] No such realm "NULL" ++[suffix] returns noop ++[files] returns noop +- entering group accounting {...} [detail] expand: /usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d -> /usr/local/var/log/radius/radacct/192.168.7.9/detail-20081111 [detail] /usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /usr/local/var/log/radius/radacct/192.168.7.9/detail-20081111 [detail] expand: %t -> Tue Nov 11 14:41:29 2008 ++[detail] returns ok ++[unix] returns noop [radutmp] expand: /usr/local/var/log/radius/radutmp -> /usr/local/var/log/radius/radutmp [radutmp] expand: %{User-Name} -> xxx rlm_radutmp: No NAS-Port seen. Cannot do anything. rlm_radumtp: WARNING: checkrad will probably not work! ++[radutmp] returns noop [main_pool] This is not an Accounting-Stop. Return NOOP. ++[main_pool] returns noop [sql] expand: %{User-Name} -> xxx [sql] sql_set_user escaped user --> 'xxx' [sql] expand: %{Acct-Delay-Time} -> 0 [sql] expand: INSERT INTO radacct (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, xascendsessionsvrkey) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', [sql] expand: /usr/local/var/log/radius/sqltrace.sql -> /usr/local/var/log/radius/sqltrace.sql rlm_sql (sql): Reserving sql socket id: 4 rlm_sql_mysql: query: INSERT INTO radacct (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, xascendsessionsvrkey) VALUES ('3E87A45A1B7DE62F', '6156897ce44b112f', 'xxx', '', '192.168.7.9', '', 'Virtual', '2008-11-11 14:41:29', NULL, '0', 'RADIUS', '', '', '0', '0', 'xxx', 'xxx', '', 'Framed-User', 'GPRS-PDP-Context', '192.168.0.4', '0', '0', '') rlm_sql (sql): Released sql socket id: 4 ++[sql] returns ok rlm_sql (sql): Reserving sql socket id: 3 [sqlippool] expand: %{User-Name} -> xxx [sqlippool] sql_set_user escaped user --> 'xxx' [sqlippool] expand: START TRANSACTION -> START TRANSACTION /usr/local/sbin/radiusd: symbol lookup error: /usr/local/lib/rlm_sqlippool-2.1.1.so: undefined symbol: rlm_sql_query
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html