I have freeradius-0.4 with postgresql 7.1.2 I've seen it insert an accouting_stop record into the database if it cannot match the session id with a prexsisting start record. Usually this happens when an exsisting dialup user is connected and you restart the radiusd process
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jorge Manuel Finochietto Sent: Tuesday, January 08, 2002 12:21 PM To: [EMAIL PROTECTED] Subject: Problems with the PostgreSQL Accounting I am working with Frreradius 0.4 on a linux server (Suse 7,2) and I have also installed a PostgreSQL and OpenLDAP there. I am usin LDAP for atuhtetication and PostgreSQL for accounting. I am trying to test the Frreradius on a huge environment with multiple NAS and services, so I think this would help to test its performance. Although the Account Start packet makes the correct query to the PostgreSQL server, when I am sending an Account Stop packet (in order to stop the accounting record) the query that the radiusd sends is exactly the same as the accounting_query_start and it should be the accounting_query_stop. Can anyone help me?? I have tried to solve the problem but I can īt get it work coorectly. Thanks in advance, Jorge Finochietto TechTel rad_recv: Accounting-Request packet from host 10.160.4.11:3310, id=254, length=119 User-Name = "Admin" Acct-Status-Type = Stop Acct-Input-Octets = 10 Acct-Output-Octets = 10 Acct-Session-Time = 10 Called-Station-Id = "40004000" Calling-Station-Id = "40003000" Acct-Delay-Time = 10 NAS-IP-Address = 111.111.111.111 Framed-IP-Address = 222.222.222.222 NAS-Port-Type = ISDN Framed-Protocol = SLIP Connect-Info = "2" Service-Type = 0 Acct-Authentic = None Acct-Session-Id = "5" modcall: entering group preacct modcall[preacct]: module "suffix" returns ok modcall[preacct]: module "files" returns noop modcall[preacct]: module "preprocess" returns noop modcall: group preacct returns ok modcall: entering group accounting radius_xlat: '/usr/local/radius/var/log/radius/radacct/10.160.4.11/detail' rlm_detail: /usr/local/radius/var/log/radius/radacct/%{Client-IP-Address}/detail e xpands to /usr/local/radius/var/log/radius/radacct/10.160.4.11/detail modcall[accounting]: module "detail" returns ok rlm_sql: Reserving sql socket id: 9 radius_xlat: 'Admin' sql_escape in: 'Admin' sql_escape out: 'Admin' sql_set_user: escaped user --> 'Admin' radius_xlat: 'INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime , AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputO ctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedP rotocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('5', '', 'Admin', '', '111.111.111.111', '', 'ISDN', '2002-01-08 17:27:36', 'now', '10', 'None', '2' , '', '0', '0', '40004000', '40003000', '', '0', 'SLIP', '222.222.222.222', '10', '0')' query: INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAdd ress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAu thentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, C alledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('5', '', 'Admin', '', '111 .111.111.111', '', 'ISDN', '2002-01-08 17:27:36', 'now', '10', 'None', '2', '', '0 ', '0', '40004000', '40003000', '', '0', 'SLIP', '222.222.222.222', '10', '0') rlm_postgresql Status: PGRES_COMMAND_OK sql_postgresql: affected rows = 1 rlm_sql: Released sql socket id: 9 modcall[accounting]: module "sql" returns ok modcall[accounting]: module "unix" returns noop radius_xlat: 'Admin' modcall[accounting]: module "radutmp" returns noop modcall: group accounting returns ok Sending Accounting-Response of id 254 to 10.160.4.11:3310 Finished request 2 Going to the next request --- Walking the entire request list --- Cleaning up request 2 ID 254 with timestamp 3c3b5638 Nothing to do. Sleeping until we see a request. _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
