Hello
We run Freeradius 1.1.7 against a postgresql-database, and for some
auth-sessions Cisco NAS Port does not get stored in the database. I have
checked the freeradius detail-logs to see that the server really has
these values, so I'm a bit stumped as to why this happens. The
SQL-queries have been slightly modified to fit our use, so I'm including
the relevant ones here from postgresql.conf.
accounting_update_query = "UPDATE ${acct_table1} \
SET FramedIPAddress = NULLIF('%{Framed-IP-Address}',
'')::inet, \
AcctSessionTime = (EXTRACT(EPOCH FROM(now()::timestamp
with time zone - AcctStartTime::timestamp with time zone -
'%{Acct-Delay-Time:-0}'::interval)))::BIGINT, \
AcctInputOctets = (('%{Acct-Input-Gigawords:-0}'::bigint
<< 32) + '%{Acct-Input-Octets:-0}'::bigint), \
AcctOutputOctets =
(('%{Acct-Output-Gigawords:-0}'::bigint << 32) +
'%{Acct-Output-Octets:-0}'::bigint) \
WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}' AND
UserName = '%{SQL-User-Name}' \
AND NASIPAddress= '%{NAS-IP-Address}' AND AcctStopTime
IS NULL"
accounting_update_query_alt = "INSERT into ${acct_table1} \
(AcctSessionId, AcctUniqueId, UserName, Realm,
NASIPAddress, NASPortType, CiscoNASPort, AcctStartTime, \
AcctSessionTime, AcctInputOctets, AcctOutputOctets,
CalledStationId, CallingStationId, \
FramedProtocol, FramedIPAddress) \
values('%{Acct-Session-Id}',
'%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}',
'%{NAS-IP-Address}', \
'%{NAS-Port-Type}', NULLIF('%{Cisco-NAS-Port}', ''),
(now() - '%{Acct-Delay-Time:-0}'::interval -
'%{Acct-Session-Time:-0}'::interval), \
NULLIF('%{Acct-Session-Time}','')::bigint, \
(('%{Acct-Input-Gigawords:-0}'::bigint << 32) +
'%{Acct-Input-Octets:-0}'::bigint), \
(('%{Acct-Output-Gigawords:-0}'::bigint << 32) +
'%{Acct-Output-Octets:-0}'::bigint), '%{Called-Station-Id}', \
'%{Calling-Station-Id}', '%{Framed-Protocol}', \
NULLIF('%{Framed-IP-Address}', '')::inet)"
accounting_start_query = "INSERT into ${acct_table1} \
(AcctSessionId, AcctUniqueId, UserName, Realm,
NASIPAddress, NASPortType, CiscoNASPort, AcctStartTime, \
CalledStationId, CallingStationId, FramedProtocol,
FramedIPAddress, AcctStartDelay) \
values('%{Acct-Session-Id}',
'%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}',
'%{NAS-IP-Address}', \
'%{NAS-Port-Type}', NULLIF('%{Cisco-NAS-Port}', ''),
(now() - '%{Acct-Delay-Time:-0}'::interval), \
'%{Called-Station-Id}', '%{Calling-Station-Id}',
'%{Framed-Protocol}', \
NULLIF('%{Framed-IP-Address}', '')::inet,
'%{Acct-Delay-Time:-0}') "
accounting_start_query_alt = "UPDATE ${acct_table1} \
SET AcctStartTime = (now() -
'%{Acct-Delay-Time:-0}'::interval), \
WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}' AND
UserName = '%{SQL-User-Name}' \
AND NASIPAddress = '%{NAS-IP-Address}' AND AcctStopTime
IS NULL"
If I could get any pointers as to what could be wrong or ways to debug
this I would be very grateful.
Regards
Kai Bjørnenak
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
