On Fri, 11 Jul 2003 03:50 am, Salvin Kumar wrote: > When I am trying to start the radius server and do accounting ith postgres > I get some errors when the values are being inserted:
> ERROR: "Bad numeric input format '' > LOG: connection received: host=localhost.is.com.fj[127.0.0.1] port=1121 > LOG: connection authorized: user=postgres database=radius > ERROR: "Bad numeric input format '' Please enable sql debugging and post the line that is failing insert.. > and this is how my radacct table looks: > > 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 timestamptz, > AcctStopTime timestamptz, ??? did you copy and paste this or did you type it in? timestamptz is not a valid Postgres field type afaik. -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
