-----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
