<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6001.18148" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I need some help trying to configure sqlippool.
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I've followed the instruction from <A
href="http://wiki.freeradius.org/Rlm_sqlippool">http://wiki.freeradius.org/Rlm_sqlippool</A> and few
other places.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>
<DIV><FONT face=Arial size=2>I did compile FR from source with the following
configuration options:</FONT></DIV></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Options 1:</FONT></DIV>
<DIV><FONT face=Arial size=2>./configure
--prefix=/usr/local/freeradius-server-2.1.1 --with-openssl --with-threads
--with-vmps --with-modules=rlm_sqlippool</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Options 2:</FONT></DIV>
<DIV><FONT face=Arial size=2>./configure
--prefix=/usr/local/freeradius-server-2.1.1 --with-openssl --with-threads
--with-vmps --with-rlm_sqlippool</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Options 3:</FONT></DIV>
<DIV><FONT face=Arial size=2>./configure
--prefix=/usr/local/freeradius-server-2.1.1 --with-openssl --with-threads
--with-vmps --enable-rlm_sqlippool</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Each time my start access point running hostapd, FR
crashes with the following message.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#ff0000 size=2>Sun Oct 26 22:10:49 2008 : Info:
++[sradutmp] returns ok</FONT></DIV>
<DIV><FONT face=Arial color=#ff0000 size=2>Sun Oct 26 22:10:49 2008 : Debug:
rlm_sql (sql): Reserving sql socket id: 1</FONT></DIV>
<DIV><FONT face=Arial color=#ff0000 size=2>Sun Oct 26 22:10:49 2008 : Info:
[sqlippool] expand: %{User-Name} -> </FONT></DIV>
<DIV><FONT face=Arial color=#ff0000 size=2>Sun Oct 26 22:10:49 2008 : Info:
[sqlippool] sql_set_user escaped user --> ''</FONT></DIV>
<DIV><FONT face=Arial color=#ff0000 size=2>Sun Oct 26 22:10:49 2008 : Info:
[sqlippool] expand: START TRANSACTION -> START TRANSACTION</FONT></DIV>
<DIV><FONT face=Arial color=#ff0000><STRONG>radiusd: symbol lookup error:
/usr/local/freeradius-server-2.1.1/lib/rlm_sqlippool-2.1.1.so: undefined symbol:
rlm_sql_query</STRONG></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Below are my configuration</FONT></DIV>
<DIV><FONT face=Arial size=2>OS: Ubuntu (Kernel 2.6.24-21)</FONT></DIV>
<DIV><FONT face=Arial size=2>FR: 2.1.1</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>radiusd.conf</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial color=#800000 size=1><EM>exec_prefix =
${prefix}</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>sysconfdir =
${prefix}/etc</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>localstatedir =
${prefix}/var</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>sbindir =
${exec_prefix}/sbin</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>logdir =
${localstatedir}/log/radius</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>raddbdir =
${sysconfdir}/raddb</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>radacctdir =
${logdir}/radacct</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>name =
radiusd</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>confdir =
${raddbdir}</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>run_dir =
${localstatedir}/run/radiusd</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>db_dir =
${raddbdir}</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>libdir =
${exec_prefix}/lib</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>pidfile =
${run_dir}/${name}.pid</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>max_request_time =
30</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>cleanup_delay =
5</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>max_requests =
1024</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>listen {</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> type =
auth</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> ipaddr =
*</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> port =
0</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>}</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>listen {</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> ipaddr =
*</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> port =
0</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> type =
acct</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>}</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>hostname_lookups =
no</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>allow_core_dumps =
no</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>regular_expressions = yes</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>extended_expressions = yes</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>log {</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> destination =
files</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> file =
${logdir}/radius.log</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> syslog_facility =
daemon</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> stripped_names =
no</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> auth =
no</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> auth_badpass =
no</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> auth_goodpass =
no</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>}</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>checkrad =
${sbindir}/checkrad</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>security {</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> max_attributes =
200</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> reject_delay =
1</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> status_server =
yes</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>}</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>proxy_requests =
yes</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>$INCLUDE
proxy.conf</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>$INCLUDE
clients.conf</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM></EM></FONT> </DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>thread pool {</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> start_servers =
5</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> max_servers =
32</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> min_spare_servers =
3</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> max_spare_servers =
10</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> max_requests_per_server
= 0</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>}</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>modules {</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> $INCLUDE
${confdir}/modules/</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> $INCLUDE
eap.conf</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> $INCLUDE
sql.conf</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> $INCLUDE
sql/mysql/counter.conf</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> $INCLUDE
sqlippool.conf</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>}</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>instantiate {</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> exec</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> expr</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> daily</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>
expiration</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>
logintime</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>}</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>$INCLUDE
policy.conf</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>$INCLUDE
sites-enabled/</EM></FONT></DIV></BLOCKQUOTE>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>sites-enabled/default</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial color=#800000 size=1><EM>authorize {</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>
preprocess</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> chap</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> mschap</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> suffix</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> eap {</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>
ok = return</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> }</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> unix</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> #files</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> sql</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> daily</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>
expiration</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>
logintime</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> pap</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>}</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>authenticate
{</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> Auth-Type PAP
{</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>
pap</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> }</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> Auth-Type CHAP
{</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>
chap</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> }</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> Auth-Type MS-CHAP
{</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>
mschap</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> }</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> unix</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> eap</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>}</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>preacct {</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>
preprocess</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>
acct_unique</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> suffix</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> #files</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>}</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>accounting {</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> detail</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> daily</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> unix</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>
radutmp</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>
sradutmp</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>
sqlippool</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> sql</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>
sql_log</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>
attr_filter.accounting_response</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>}</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>session {</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>
radutmp</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>}</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>post-auth {</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>
sqlippool</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>
reply_log</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> sql</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>
sql_log</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> exec</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> Post-Auth-Type REJECT
{</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>
attr_filter.access_reject</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> }</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>}</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>pre-proxy {</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>}</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>post-proxy {</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM> eap</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>}</EM></FONT></DIV></BLOCKQUOTE>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>ippool.conf</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial color=#800000 size=1><EM> allocate-clear = "UPDATE
${ippool_table} \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> SET nasipaddress = '',
pool_key = 0, \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> callingstationid = '',
username = '', \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> expiry_time IS NULL
\</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> WHERE expiry_time <=
NOW() - INTERVAL 1 SECOND</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> AND nasipaddress =
'%{Nas-IP-Address}'"</EM></FONT></DIV>
<DIV><FONT color=#800000 size=1><EM></EM></FONT> </DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>allocate-find = "SELECT
framedipaddress FROM ${ippool_table} \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> WHERE pool_name =
'%{control:Pool-Name}' AND expiry_time < NOW() \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> ORDER BY (username
<> '%{User-Name}'), \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> (callingstationid
<> '%{Calling-Station-Id}'), \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> expiry_time
\</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> LIMIT 1
\</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> FOR
UPDATE"</EM></FONT></DIV>
<DIV><FONT color=#800000 size=1><EM></EM></FONT> </DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>pool-check = "SELECT id FROM
${ippool_table} \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> WHERE
pool_name='%{control:Pool-Name}' LIMIT 1"</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>allocate-update = "UPDATE
${ippool_table} \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> SET nasipaddress =
'%{NAS-IP-Address}', pool_key = '${pool-key}', \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> callingstationid =
'%{Calling-Station-Id}', username = '%{User-Name}', \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> expiry_time = NOW() +
INTERVAL ${lease-duration} SECOND \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> WHERE framedipaddress =
'%I'"</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>start-update = "UPDATE
${ippool_table} \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> SET expiry_time = NOW() +
INTERVAL ${lease-duration} SECOND \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> WHERE nasipaddress =
'%{NAS-IP-Address}' AND pool_key = '${pool-key}'"</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM></EM></FONT> </DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>stop-clear = "UPDATE
${ippool_table} \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> SET nasipaddress = '',
pool_key = 0, callingstationid = '', username = '', \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> expiry_time IS NULL
\</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> WHERE nasipaddress =
'%{Nas-IP-Address}' AND pool_key = '${pool-key}' \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> AND username =
'%{User-Name}' \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> AND callingstationid =
'%{Calling-Station-Id}' \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> AND framedipaddress =
'%{Framed-IP-Address}'"</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM></EM></FONT> </DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>alive-update = "UPDATE
${ippool_table} \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> SET expiry_time = NOW() +
INTERVAL ${lease-duration} SECOND \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> WHERE nasipaddress =
'%{Nas-IP-Address}' AND pool_key = '${pool-key}' \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> AND username =
'%{User-Name}' \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> AND callingstationid =
'%{Calling-Station-Id}' \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> AND framedipaddress =
'%{Framed-IP-Address}'"</EM></FONT></DIV>
<DIV><FONT color=#800000 size=1><EM></EM></FONT> </DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>on-clear = "UPDATE
${ippool_table} \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> SET nasipaddress = '',
pool_key = 0, callingstationid = '', username = '', \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> expiry_time IS NULL
\</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> WHERE nasipaddress =
'%{Nas-IP-Address}'"</EM></FONT></DIV>
<DIV><FONT color=#800000 size=1><EM></EM></FONT> </DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>off-clear = "UPDATE
${ippool_table} \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> SET nasipaddress = '',
pool_key = 0, callingstationid = '', username = '', \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> expiry_time IS NULL
\</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> WHERE nasipaddress =
'%{Nas-IP-Address}'"</EM></FONT></DIV></BLOCKQUOTE>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>sqlippool.conf</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial color=#800000 size=1><EM>sqlippool {</EM></FONT></DIV>
<DIV><EM><FONT color=#800000 size=1></FONT></EM> </DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> sql-instance-name =
"sql"</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> ippool_table =
"radippool"</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> lease-duration =
3600</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> pool-key =
"%{NAS-Port}"</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> #pool-key =
"%{Calling-Station-Id}"</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> $INCLUDE
sql/mysql/ippool.conf</EM></FONT></DIV>
<DIV><EM><FONT color=#800000 size=1></FONT></EM> </DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> sqlippool_log_exists =
"Existing IP: %{reply:Framed-IP-Address} \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> (did
%{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user
%{User-Name})"</EM></FONT></DIV>
<DIV><EM><FONT color=#800000 size=1></FONT></EM> </DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> sqlippool_log_success =
"Allocated IP: %{reply:Framed-IP-Address} from %{control:Pool-Name}
\</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> (did
%{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user
%{User-Name})"</EM></FONT></DIV>
<DIV><EM><FONT color=#800000 size=1></FONT></EM> </DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> sqlippool_log_clear =
"Released IP %{Framed-IP-Address}\</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> (did %{Called-Station-Id}
cli %{Calling-Station-Id} user %{User-Name})"</EM></FONT></DIV>
<DIV><EM><FONT color=#800000 size=1></FONT></EM> </DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> sqlippool_log_failed =
"IP Allocation FAILED from %{control:Pool-Name} \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> (did
%{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user
%{User-Name})"</EM></FONT></DIV>
<DIV><EM><FONT color=#800000 size=1></FONT></EM> </DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> sqlippool_log_nopool =
"No Pool-Name defined \</EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM> (did
%{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user
%{User-Name})"</EM></FONT></DIV>
<DIV><EM><FONT color=#800000 size=1></FONT></EM> </DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>}</EM></FONT></DIV></BLOCKQUOTE>
<DIV><FONT face=Arial size=2>radippool table</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>mysql> select * from
radippool;</EM></FONT></DIV>
<DIV><EM><FONT color=#800000 size=1></FONT></EM> </DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>+----+-----------+-----------------+--------------+---------------------------+------------------+-------------+----------+----------+-----------------+-------------+----------+----------+</EM></FONT></DIV>
<DIV><EM><FONT color=#800000 size=1></FONT></EM> </DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>| id | pool_name |
framedipaddress | nasipaddress |
calledstationid |
callingstationid | expiry_time | username | pool_key |</EM></FONT></DIV>
<DIV><EM><FONT color=#800000 size=1></FONT></EM> </DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>+----+-----------+-----------------+--------------+---------------------------+------------------+-------------+----------+----------+-----------------+-------------+----------+----------+</EM></FONT></DIV>
<DIV><EM><FONT color=#800000 size=1></FONT></EM> </DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>| 2 | main_pool |
10.5.5.29 | 192.168.2.31 |
06-07-6F-4A-C1-60:Tlink-g
|
| NULL
| testuser
|
| </EM></FONT></DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM></EM></FONT> </DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>| 3 | main_pool |
10.5.5.30 | 192.168.2.31 |
06-07-6F-4A-C1-60:Tlink-g
| |
NULL
| testuser2
|
| </EM></FONT></DIV>
<DIV><EM><FONT color=#800000 size=1> </FONT></EM></DIV>
<DIV><FONT face=Arial color=#800000
size=1><EM>+----+-----------+-----------------+--------------+---------------------------+------------------+-------------+----------+----------+-----------------+-------------+----------+----------+</EM></FONT></DIV>
<DIV><EM><FONT color=#800000 size=1></FONT></EM> </DIV>
<DIV><FONT face=Arial color=#800000 size=1><EM>2 rows in set (0.00
sec)</EM></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>