-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Greetings. I am seeing a problem with a new freeradius 0.8.1 install using postgresql as the backend. Authentication works fine. Accounting Start records work fine. Accounting stop records dont. Here is the radiusd -x -x -x output: Nothing to do. Sleeping until we see a request. rad_recv: Accounting-Request packet from host 127.0.0.1:32824, id=88, length=38 User-Name = "root" Acct-Status-Type = Stop Acct-Session-Id = "1808" modcall: entering group preacct modcall[preacct]: module "preprocess" returns noop rlm_realm: No '@' in User-Name = "root", looking up realm NULL rlm_realm: No such realm NULL modcall[preacct]: module "suffix" returns noop modcall[preacct]: module "files" returns noop modcall: group preacct returns noop modcall: entering group accounting rlm_acct_unique: WARNING: Attribute 87 was not found in request, unique ID MAY be inconsistent rlm_acct_unique: Hashing ',Client-IP-Address = 127.0.0.1,NAS-IP-Address = 127.0.0.1,Acct-Session-Id = "1808",User-Name = "root"' rlm_acct_unique: Acct-Unique-Session-ID = "c73b34e5c9f495dc". modcall[accounting]: module "acct_unique" returns ok radius_xlat: '/var/log/radius/radacct/127.0.0.1/detail-20030702' rlm_detail: /var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /var/log/radius/radacct/127.0.0.1/detail-20030702 modcall[accounting]: module "detail" returns ok modcall[accounting]: module "unix" returns noop radius_xlat: 'root' rlm_sql (sql): sql_set_user escaped user --> 'root' radius_xlat: 'UPDATE radacct SET AcctStopTime = '2003-07-02 15:33:30', AcctSessionTime = '', AcctInputOctets = CASE WHEN '' = '' THEN 0 E LSE '' END, AcctOutputOctets = CASE WHEN '' = '' THEN 0 ELSE '' END, AcctTerminateCause = '', AcctStopDelay = '0', FramedIPAddress = '', ConnectInfo_stop = '' WHERE AcctSessionId = '1808' AND UserName = 'root' AND NASIPAddress = '127.0.0.1' AND AcctStopTime IS NULL' rlm_sql (sql): Reserving sql socket id: 1 rlm_sql_postgresql: query: UPDATE radacct SET AcctStopTime = '2003-07-02 15:33:30', AcctSessionTime = '', AcctInputOctets = CASE WHEN '' = '' THEN 0 ELSE '' END, AcctOutputOctets = CASE WHEN '' = '' THEN 0 ELSE '' END, AcctTerminateCause = '', AcctStopDelay = '0', FramedIPAd dress = '', ConnectInfo_stop = '' WHERE AcctSessionId = '1808' AND UserName = 'root' AND NASIPAddress = '127.0.0.1' AND AcctStopTime IS NU LL rlm_sql_postgresql: Status: PGRES_FATAL_ERROR rlm_sql_postgresql: affected rows = rlm_sql_postgresql: Postgresql check_error: s, returning SQL_DOWN rlm_sql (sql): Attempting to connect rlm_sql_postgresql #1 rlm_sql (sql): Connected new DB handle, #1 rlm_sql_postgresql: query: UPDATE radacct SET AcctStopTime = '2003-07-02 15:33:30', AcctSessionTime = '', AcctInputOctets = CASE WHEN '' = '' THEN 0 ELSE '' END, AcctOutputOctets = CASE WHEN '' = '' THEN 0 ELSE '' END, AcctTerminateCause = '', AcctStopDelay = '0', FramedIPAd dress = '', ConnectInfo_stop = '' WHERE AcctSessionId = '1808' AND UserName = 'root' AND NASIPAddress = '127.0.0.1' AND AcctStopTime IS NU LL rlm_sql_postgresql: Status: PGRES_FATAL_ERROR rlm_sql_postgresql: affected rows = rlm_sql_postgresql: Postgresql check_error: s, returning SQL_DOWN rlm_sql (sql): failed after re-connect rlm_sql (sql): Couldn't update SQL accounting STOP record - ERROR: Bad numeric input format '' rlm_sql (sql): Released sql socket id: 1 modcall[accounting]: module "sql" returns fail modcall: group accounting returns fail Finished request 3 Going to the next request This seems like something wrong in the postgresql.conf accounting stop sql, but I'm not sure what. Any ideas? I am happy to provide any additional debugging. kevin -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Processed by Mailcrypt 3.5.8 <http://mailcrypt.sourceforge.net/> iD8DBQE/BHDm3imCezTjY0ERAivgAJ0b3qlfLc1ksczY35fD1je4czQDSgCghVGU XbIQXJg1dc4JIo4jzmV20Q4= =C3ZA -----END PGP SIGNATURE----- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html