Seems that radius can't reach sql-user-name when updating session with
Alive record...
---
query: INSERT into radacct (AcctSessionId, AcctUniqueId, UserName,
Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime,
AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop,
AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId,
AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress,
AcctStartDelay, AcctStopDelay) values('00000003', '', 'lintec', '',
'217.12.196.130', '2', 'Async', '2002-01-05 11:48:28', '0', 'RADIUS', '',
'', '0', '0', '134000', '', '', 'Framed-User', 'PPP', '', '0', '0')
rlm_postgresql Status: PGRES_COMMAND_OK
sql_postgresql: affected rows = 1
rlm_sql: Released sql socket id: 4
Sending Accounting-Response of id 6 to 217.12.196.130:1646
rad_recv: Accounting-Request packet from host 217.12.196.130:1646, id=7,
length=100
NAS-IP-Address = 217.12.196.130
NAS-Port = 2
NAS-Port-Type = Async
User-Name = "lintec"
Called-Station-Id = "134000"
Acct-Status-Type = Alive
Acct-Authentic = RADIUS
Service-Type = Framed-User
Acct-Session-Id = "00000003"
Framed-Protocol = PPP
Framed-IP-Address = 217.12.196.221
Acct-Delay-Time = 0
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
:-\
--
cron-ripe
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
