undefined symbol: rlm_sql_query

11 Nov 2008

      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

undefined symbol: rlm_sql_query

Rasmus Paarlberg