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}'.
-Chris
--
\\\|||/// \ Chris Parker - Manager, Development Engineering
\ ~ ~ / \ WX *is* Wireless! \ [EMAIL PROTECTED]
| @ @ | \ http://www.starnetwx.net \ (847) 963-0116
oOo---(_)---oOo--\------------------------------------------------------
\ Without C we would have 'obol', 'basi', and 'pasal'
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
