1.1.7 sqlippool %{SQL-User-Name}

Peter Nixon listuser at peternixon.net
Tue Jul 17 22:59:52 CEST 2007


On Tue 17 Jul 2007, Hugh Messenger wrote:
> I said:
> > Peter Nixon said:
> > > Good eyes. Hopefully it should work now.
> >
> > Erm ... nope ...
>
> Ignore me.  It works:
>
> radius_xlat:  'BEGIN'
> radius_xlat:  'radiustest'
> rlm_sql (sql): sql_set_user escaped user --> 'radiustest'
> radius_xlat:  'UPDATE radippool   SET NASIPAddress = '', pool_key = 0,
> CallingStationId = '',   expiry_time = NOW() - INTERVAL 1 SECOND   WHERE
> NASIPAddress = 'x.x.x.x'   AND pool_key = '00:60:B3:45:6A:98'   AND
> UserName = 'radiustest'   AND CallingStationId = '00:60:B3:45:6A:98'   AND
> FramedIPAddress = '172.168.124.52''

Heh. Good. Because I was getting confused too ;-)

> Can we add sqlippool to the ./modules/stable list?

It is in the stable list for 2.0 but its up to Alan whether we put it in for 
1.1.7

> (embarrassed <cough>)

*grin*

-- 

Peter Nixon
http://peternixon.net/



More information about the Freeradius-Users mailing list