1.1.7 sqlippool %{SQL-User-Name}

[Hugh Messenger]

Peter Nixon [mailto:listuser at peternixon.net] said:
> I have applied Alan's patch to the 1.1.x branch. Can you test and see
> if %{SQL-User-Name} works in rlm_sqlippool for MySQL now?

Doesn't seem to.  I updated cvs:

-rw-r--r--  1 root root 25278 Jul 17 10:30 rlm_sqlippool.c

... and did the usual make, make install and server restart, but I still see
this:

sqlippool_expand: 'UPDATE radippool   SET NASIPAddress =
'%{NAS-IP-Address}', pool_key = '%{Calling-Station-Id}',   CallingStationId
= '%{Calling-Station-Id}', UserName = '%{SQL-User-Name}',   expiry_time =
NOW() + INTERVAL 3600 SECOND   WHERE FramedIPAddress = '172.168.34.205''
radius_xlat:  'UPDATE radippool   SET NASIPAddress = 'x.x.x.x', pool_key =
'00:1A:70:57:91:C1',   CallingStationId = '00:1A:70:57:91:C1', UserName =
'',   expiry_time = NOW() + INTERVAL 3600 SECOND   WHERE FramedIPAddress =
'172.168.34.205''

I don't know if it makes any difference, but whereas I see this whenever
rlm_sql does something:

rlm_sql (sql): sql_set_user escaped user --> '3notchmuseum'

... I don't see anything to that effect when rlm_sqlippool does its stuff.

> Peter Nixon
> http://peternixon.net/

   -- hugh