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}'"