Hi All,
I am trying to configure accounting on my MySQL server and everything
seems to be working fine... except for the fact that there are two
"INSERT" queries executed for every user logging in. Excerpt from the
"radiusd -x" command is below:
------------------CUT---------------------
rad_recv: Accounting-Request packet from host 202.183.67.218:34980,
id=109, length=149
Service-Type = Framed-User
Framed-Protocol = PPP
NAS-Identifier = "MikroTik"
NAS-Port = 19071
NAS-Port-Type = Ethernet
User-Name = "aakashshah"
Calling-Station-Id = "00:80:AD:83:B3:41"
Called-Station-Id = "Blaze-World.net"
NAS-Port-Id = "PPPoe"
Acct-Session-Id = "81903a63"
Framed-IP-Address = 203.115.66.241
Acct-Authentic = RADIUS
Acct-Status-Type = Start
NAS-IP-Address = 202.183.67.218
Acct-Delay-Time = 0
modcall: entering group preacct
modcall[preacct]: module "preprocess" returns noop
rlm_realm: No '@' in User-Name = "aakashshah", 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: Hashing 'NAS-Port-Id = "PPPoe",Client-IP-Address =
202.183.67.218,NAS-IP-Address = 202.183.67.218,Acct-Sessio
n-Id = "81903a63",User-Name = "aakashshah"'
rlm_acct_unique: Acct-Unique-Session-ID = "1d2f299d28c64497".
modcall[accounting]: module "acct_unique" returns ok
radius_xlat:
'/usr/local/var/log/radius/radacct/202.183.67.218/detail-20031009'
rlm_detail:
/usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d
expands to /usr/local/var/log/radius/radacct/
202.183.67.218/detail-20031009
modcall[accounting]: module "detail" returns ok
modcall[accounting]: module "unix" returns ok
radius_xlat: 'aakashshah'
rlm_sql (sql): sql_set_user escaped user --> 'aakashshah'
radius_xlat: 'INSERT into radacct (RadAcctId, AcctSessionId,
AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType,
AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic,
ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets,
CalledStationId, CallingStationId, AcctTerminateCause, ServiceType,
FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay)
values('', '81903a63', '1d2f299d28c64497', 'aakashshah', '',
'202.183.67.218', '19071', 'Ethernet', '2003-10-09 23:46:21', '0', '0',
'RADIUS', '', '', '0', '0', 'Blaze-World.net', '00:80:AD:83:B3:41', '',
'Framed-User', 'PPP', '203.115.66.241', '0', '0')'
radius_xlat: '/usr/local/var/log/radius/sqltrace.sql'
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql_mysql: query: INSERT into radacct (RadAcctId, AcctSessionId,
AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId,NASPortType,
AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic,
ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets,
CalledStationId, CallingStationId, AcctTerminateCause, ServiceType,
FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay)
values('', '81903a63', '1d2f299d28c64497', 'aakashshah', '',
'202.183.67.218', '19071', 'Ethernet','2003-10-09 23:46:21', '0', '0',
'RADIUS', '', '', '0', '0', 'Blaze-World.net', '00:80:AD:83:B3:41', '',
'Framed-User', 'PPP', '203.115.66.241', '0', '0')
rlm_sql (sql): Released sql socket id: 4
modcall[accounting]: module "sql" returns ok
------------------CUT---------------------
Is there anything that I am missing something that I need to check??
Thanks for your time..
Best regards,
Anindya
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.522 / Virus Database: 320 - Release Date: 29/09/2003
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
