Freeradius 2.1.0.
I have a NAS which sends a NAS-Port-Id attribute in the range
2147483648..2164260863. PostgreSQL doesn't like the query Freeradius
performs. It's choking when trying to insert for instance
'2163214239::integer' into the radacct table.
$ select 2163214239::integer;
ERROR: integer out of range
Example:
INSERT INTO radacct (AcctSessionId, AcctUniqueId, UserName, Realm,
NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime,
AcctSessionTime, AcctAuthentic, ConnectInfo_stop, AcctInputOctets,
AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause,
ServiceType, FramedProtocol, FramedIPAddress, AcctStopDelay)
values('80f0079f', '5c9f0b7076dcc9c0', 'username', NULLIF('', ''),
'1.2.3.4', 2163214239::integer, 'Wireless-802.11', ('2008-09-26
09:52:52'::timestamp - '1'::interval - '3382'::interval), ('2008-09-26
09:52:52'::timestamp - '1'::interval), NULLIF('3382', '')::bigint, '', '',
(('0'::bigint << 32) + '57743'::bigint), (('0'::bigint << 32) +
'294709'::bigint), 'hotspot', 'XX:XX:XX:XX:XX:XX', 'Lost-Service', '',
'', NULLIF('192.168.12.94', '')::inet, 0)
rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
rlm_sql_postgresql: Error integer out of range
rlm_sql_postgresql: Postgresql Fatal Error: [22003: NUMERIC VALUE OUT OF RANGE]
Occurred!!
[sql] Couldn't insert SQL accounting STOP record - ERROR: integer out of range
rlm_sql (sql): Released sql socket id: 3
++[sql] returns fail
Quick fixes...?
--
Vegard Svanberg <[EMAIL PROTECTED]> [EMAIL PROTECTED] (EFnet)]
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
