sqlippool : undefined symbol: rlm_sql_query

[Sebastian Krieger]

Hi,

I want to get freeradius running with the sqlippool module and mysql 
backend on Ubuntu 8.04 LTS Server.
Everything works so far, but it seems still impossible to enable the 
sqlippool on Debian based systems.

At first I tried the freeradius 1.1.7-1build4 packages supplied by the 
distribution, but then I always received the following error:

freeradius: symbol lookup error: /usr/lib/freeradius/rlm_sqlippool.so: 
undefined symbol: sql_get_socket

After that I gave the backport packages of version 2.1.0 a try, because 
I have read somewhere that this error should be solved since version 
2.0.4. But unfortunately I had the same result with it.

freeradius_2.1.0+dfsg-0ubuntu2~hardy1_i386.deb
freeradius-common_2.1.0+dfsg-0ubuntu2~hardy1_all.deb
freeradius-mysql_2.1.0+dfsg-0ubuntu2~hardy1_i386.deb
freeradius-utils_2.1.0+dfsg-0ubuntu2~hardy1_i386.deb
libfreeradius2_2.1.0+dfsg-0ubuntu2~hardy1_i386.deb

Now I tried to compile freeradius version 2.1.3 on this server and to 
build a fresh deb package with success, but using sqlippool now results 
into a slightly different error message.

freeradius: symbol lookup error: 
/usr/lib/freeradius/rlm_sqlippool-2.1.3.so: undefined symbol: rlm_sql_query

In this message a patch to this problem is mentioned.
http://lists.cistron.nl/pipermail/freeradius-devel/2009-January/012736.html

And here someone relinked rlmsqlippool to rlm_sql to get rid of this issue.
http://www.nabble.com/sqlippool-symbol-error-td20331823.html

What should I do to get sqlippool working? I don't know how to relink 
the it.

Thanks a lot.
Sebastian

---

There seems to be a syntax error at line 24 in 
/usr/local/etc/raddb/sql/mysql/ippool.conf. At the end of the line "\" 
is missing.

including configuration file /usr/local/etc/raddb/sql/mysql/ippool.conf
/usr/local/etc/raddb/sql/mysql/ippool.conf[24]: Expecting section start 
brace '{' after "AND nasipaddress"
Errors reading /usr/local/etc/raddb/radiusd.conf

  WHERE expiry_time <= NOW() - INTERVAL 1 SECOND \
  AND nasipaddress = '%{Nas-IP-Address}'"