Hi Ivan, tnt@kalik.net wrote:
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"
Pool-Name = %{control:Huntgroup-Name}
Where did that come from? That should be in the users entry (radcheck or radgroupcheck).
I've tried adding to the radcheck table ( INSERT into `radcheck` SET `id` = 0, `username` = '447XXXXXXXX', `op` = ':=', `value` = '%{control:Huntgroup-Name}`; ) and then I get ... 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 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 Wed Feb 18 16:14:34 2009 : Info: [sqlippool] SQL query did not return any results .... The same result was obtained when radgroupcheck is used
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.*
You haven't entered that Pool-Name (name of your huntgroup) in the radippool table.
Ivan Kalik Kalik Informatika ISP