PostgreSql Radacct Problems

Sun, 20 Jul 2003 21:26:40 -0700

Please exuse my last post I accidentily sent it off before I was done
 
 
 
I am running redhat 9.0 with postgresql 7.3 and freeradius-0.8.1.
I use it for authentication for our fiber connections.  Everything was
working well untill lately.  I have noticed that I get an error like the
following in my radius.log and after that it looses the connection with
postgresql server and I have to restart the freeradius process.

Fri Jul  4 06:03:09 2003 : Error: rlm_sql (sql): Couldn't update SQL
accounting STOP record - ERROR:  pg_atoi: error reading "2618979488":
Numerical result out of range
 
I suspect that it is trying to write the acctoutputoctets for a session into the radacct table but I am not positive.  My postgresql radacct table was created with the following script
 
 
CREATE TABLE radacct (
  RadAcctId SERIAL,
  AcctSessionId VARCHAR(32) DEFAULT '' NOT NULL,
  AcctUniqueId VARCHAR(32) DEFAULT '' NOT NULL,
  UserName VARCHAR(32) DEFAULT '' NOT NULL,
  Realm VARCHAR(30) DEFAULT '',
  NASIPAddress VARCHAR(15) DEFAULT '' NOT NULL,
  NASPortId NUMERIC(12),
  NASPortType VARCHAR(32),
  AcctStartTime timestamp,
  AcctStopTime timestamp,
  AcctSessionTime NUMERIC(12),
  AcctAuthentic VARCHAR(32),
  ConnectInfo_start VARCHAR(32),
  ConnectInfo_stop VARCHAR(32),
  AcctInputOctets NUMERIC(12),
  AcctOutputOctets NUMERIC(12),
  CalledStationId VARCHAR(10) DEFAULT '' NOT NULL,
  CallingStationId VARCHAR(10) DEFAULT '' NOT NULL,
  AcctTerminateCause VARCHAR(32) DEFAULT '' NOT NULL,
  ServiceType VARCHAR(32),
  FramedProtocol VARCHAR(32),
  FramedIPAddress VARCHAR(15) DEFAULT '' NOT NULL,
  AcctStartDelay NUMERIC(12),
  AcctStopDelay NUMERIC(12),
  PRIMARY KEY (RadAcctId)
);
create index radacct_UserName on radacct (UserName);
create index radacct_AcctSessionId on radacct (AcctSessionId);
create index radacct_AcctUniqueId on radacct (AcctUniqueId);
create index radacct_FramedIPAddress on radacct (FramedIPAddress);
create index radacct_NASIPAddress on radacct (NASIPAddress);
create index radacct_AcctStartTime on radacct (AcctStartTime);
create index radacct_AcctStopTime on radacct (AcctStopTime);
 
Any help would be greatly appreciated.
 
Sincerely,
CW

Reply via email to