<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7653.38">
<TITLE>undefined symbol: rlm_sql_query</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Courier New">Hi</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">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.</FONT></P>
<P><B><FONT SIZE=2 FACE="Courier New">/usr/local/sbin/radiusd: symbol lookup error: /usr/local/lib/rlm_sqlippool-2.1.1.so: undefined symbol: rlm_sql_query</FONT></B>
</P>
<P><FONT SIZE=2 FACE="Courier New">The below is the debug print up until the error.</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">Anyone knowing what the problem might be? Maybe just point me into the right direction?</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">Thanks in advance.</FONT>
<BR><FONT SIZE=2 FACE="Courier New">./rasmus</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">rad_recv: Accounting-Request packet from host 192.168.7.9 port 1223, id=222, length=212</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New"> NAS-IP-Address = 192.168.7.9</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New"> NAS-Identifier = "xxx"</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New"> Called-Station-Id = "xxxt"</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New"> Framed-Protocol = GPRS-PDP-Context</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New"> Service-Type = Framed-User</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New"> NAS-Port-Type = Virtual</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New"> Acct-Status-Type = Start</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New"> Framed-IP-Address = 192.168.0.4</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New"> Acct-Session-Id = "3E87A45A1B7DE62F"</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New"> User-Name = "xxx"</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New"> 3GPP-IMSI = "xxx"</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New"> Calling-Station-Id = "xxx"</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New"> 3GPP-PDP-Type = 0</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New"> 3GPP-GPRS-Negotiated-QoS-profile = "99-13921f739697b074821040"</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New"> 3GPP-SGSN-Address = xxx</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New"> 3GPP-Selection-Mode = "0"</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New"> Acct-Authentic = RADIUS</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New"> Acct-Delay-Time = 0</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">+- entering group preacct {...}</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">++[preprocess] returns ok</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">[acct_unique] WARNING: Attribute NAS-Port was not found in request, unique ID MAY be inconsistent</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">[acct_unique] Hashing ',Client-IP-Address = 192.168.7.9,NAS-IP-Address = 192.168.7.9,Acct-Session-Id = "3E87A45A1B7DE62F",User-Name = "xxx"'</FONT></P>
<P><FONT COLOR="#000080" SIZE=2 FACE="Courier New">[acct_unique] Acct-Unique-Session-ID = "6156897ce44b112f".</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">++[acct_unique] returns ok</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">[suffix] No '@' in User-Name = "xxx", looking up realm NULL</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">[suffix] No such realm "NULL"</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">++[suffix] returns noop</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">++[files] returns noop</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">+- entering group accounting {...}</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">[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</FONT></P>
<P><FONT COLOR="#000080" SIZE=2 FACE="Courier New">[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</FONT></P>
<P><FONT COLOR="#000080" SIZE=2 FACE="Courier New">[detail] expand: %t -> Tue Nov 11 14:41:29 2008</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">++[detail] returns ok</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">++[unix] returns noop</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">[radutmp] expand: /usr/local/var/log/radius/radutmp -> /usr/local/var/log/radius/radutmp</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">[radutmp] expand: %{User-Name} -> xxx</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New"> rlm_radutmp: No NAS-Port seen. Cannot do anything.</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New"> rlm_radumtp: WARNING: checkrad will probably not work!</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">++[radutmp] returns noop</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">[main_pool] This is not an Accounting-Stop. Return NOOP.</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">++[main_pool] returns noop</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">[sql] expand: %{User-Name} -> xxx</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">[sql] sql_set_user escaped user --> 'xxx'</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">[sql] expand: %{Acct-Delay-Time} -> 0</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">[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}', </FONT></P>
<P><FONT COLOR="#000080" SIZE=2 FACE="Courier New">[sql] expand: /usr/local/var/log/radius/sqltrace.sql -> /usr/local/var/log/radius/sqltrace.sql</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">rlm_sql (sql): Reserving sql socket id: 4</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">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', '')</FONT></P>
<P><FONT COLOR="#000080" SIZE=2 FACE="Courier New">rlm_sql (sql): Released sql socket id: 4</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">++[sql] returns ok</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">rlm_sql (sql): Reserving sql socket id: 3</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">[sqlippool] expand: %{User-Name} -> xxx</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">[sqlippool] sql_set_user escaped user --> 'xxx'</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">[sqlippool] expand: START TRANSACTION -> START TRANSACTION</FONT>
<BR><FONT COLOR="#000080" SIZE=2 FACE="Courier New">/usr/local/sbin/radiusd: symbol lookup error: /usr/local/lib/rlm_sqlippool-2.1.1.so: undefined symbol: rlm_sql_query</FONT>
</P>
</BODY>
</HTML>