On Mon, 7 Jan 2002, Chris Parker wrote:
> At 11:51 AM 1/5/2002 +0200, Igor Chen wrote:
> >Seems that radius can't reach sql-user-name when updating session with
> >Alive record...
> >---
> >rlm_sql: Reserving sql socket id: 4
> >query: UPDATE radacct SET FramedIPAddress = '217.12.196.221' WHERE
> >AcctSessionId = '00000003' AND UserName = '' AND NASIPAddress=
> >'217.12.196.130'
> >rlm_postgresql Status: PGRES_COMMAND_OK
> >sql_postgresql: affected rows = 0
> >--
> >Why UserName = '' ? :-\ strange, because first query INSERT get's username
> >:-\
>
> What do you have set in 'sql.conf' for 'sql_user_name'?
>
> Also, check the 'sql.conf' to be sure that it specifies '%{SQL-User-Name}'.
>
The first thing that i did was that changing %{SQL-User-Name} to
%{User-Name} in sql.conf... But it is definitly bug... I have standart
sql.conf and i changed it only in authorization section (for postgres)
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html