<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Ivan,<br>
<br>
<a class="moz-txt-link-abbreviated" href="mailto:tnt@kalik.net">tnt@kalik.net</a> wrote:
<blockquote id="mid_wBsjRgLU_1234972774_9905450_tnt_kalik_net"
cite="mid:wBsjRgLU.1234972774.9905450.tnt@kalik.net" type="cite">
<blockquote id="StationeryCiteGenerated_1" type="cite">
<pre wrap="">Many thanks for your suggestion. However, (using 2.1.3) my
sqlippool.conf file is now:
sqlippool {
#########################################
## SQL instance to use (from sql.conf) ##
#########################################
sql-instance-name = "sql"
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
<blockquote id="StationeryCiteGenerated_2" type="cite">
<pre wrap=""> Pool-Name = %{control:Huntgroup-Name}
</pre>
</blockquote>
<pre wrap=""><!---->
Where did that come from? That should be in the users entry (radcheck or
radgroupcheck).
</pre>
</blockquote>
I've tried adding to the radcheck table ( INSERT into `radcheck` SET
`id` = 0, `username` = '447XXXXXXXX', `op` = ':=', `value` =
'%{control:Huntgroup-Name}`; )<br>
and then I get<br>
...<br>
Wed Feb 18 16:14:34 2009 : Info: [sqlippool] expand: SELECT
framedipaddress FROM radippool WHERE pool_name =
'%{control:Pool-Name}' AND callingstationid = '%{Calling-Station-Id}'
LIMIT 1 FOR UPDATE -> SELECT framedipaddress FROM radippool
WHERE pool_name = '=25=7Bcontrol:Huntgroup-Name=7D' AND
callingstationid = '447775777672' LIMIT 1 FOR UPDATE<br>
Wed Feb 18 16:14:34 2009 : Debug: rlm_sql_mysql: query: SELECT
framedipaddress FROM radippool WHERE pool_name =
'=25=7Bcontrol:Huntgroup-Name=7D' AND callingstationid = '447XXXXXXX'
LIMIT 1 FOR UPDATE<br>
Wed Feb 18 16:14:34 2009 : Info: [sqlippool] SQL query did not return
any results<br>
....<br>
<br>
The same result was obtained when radgroupcheck is used<br>
<br>
<blockquote id="mid_wBsjRgLU_1234972774_9905450_tnt_kalik_net"
cite="mid:wBsjRgLU.1234972774.9905450.tnt@kalik.net" type="cite">
<pre wrap="">Wed Feb 18 14:21:17 2009 : Info: +- entering group post-auth {...}
Wed Feb 18 14:21:17 2009 : *Info: [sqlippool] No Pool-Name defined.*
</pre>
</blockquote>
<blockquote id="mid_wBsjRgLU_1234972774_9905450_tnt_kalik_net"
cite="mid:wBsjRgLU.1234972774.9905450.tnt@kalik.net" type="cite">
<pre wrap=""><!---->
You haven't entered that Pool-Name (name of your huntgroup) in the
radippool table.
Ivan Kalik
Kalik Informatika ISP
</pre>
</blockquote>
</body>
</html>