When I first used radacct on 2.16.1 things seemed to work great.
Then I imported a whole bunch of call data to the MySQL database. The
database is about 1.4Gig in size now.
When I run radacct.cgi I watch the raw Radiator logs and see that it is
getting a SQL Timeout. If I watch top -d I see that mysql is churning away
burning up the CPU.
So it appears that for some reason SQL authentications are getting held off
and are actually timing out while the radacct.cgi query is running.
Actually, I authenticate from the shadow password file, the AuthSQL is
basically only used for accounting purposes.
Any ideas on what the issue could be?
Thanks,
Chris
Wed Aug 30 10:12:57 2000: DEBUG: Handling with Radius::AuthSQL
Wed Aug 30 10:12:57 2000: DEBUG: Handling accounting with Radius::AuthSQL
Wed Aug 30 10:12:57 2000: DEBUG: do query is: insert into ACCOUNTING
(USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME,
ACCTINPUTOCTETS, ACCTOUTPUTOCTETS, ACCTSESSIONID, ACCTSESSIONTIME,
ACCTTERMINATECAUSE, PORTTYPE, NASPORT, NASIP, FRAMEDIPADDRESS,
CALLINGSTATION,
CALLEDSTATION, LIVINGSTON)
values
('username', 967651977, 'Stop', 0, 213, 34, '4600B3E0',
120, 'User-Request', 'ISDN',
24, '207.174.103.7', '204.144.244.81', '', '', 'User Request -
PPP Term Req')
Wed Aug 30 10:13:57 2000: ERR: do failed for 'insert into ACCOUNTING
(USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME,
ACCTINPUTOCTETS, ACCTOUTPUTOCTETS, ACCTSESSIONID, ACCTSESSIONTIME,
ACCTTERMINATECAUSE, PORTTYPE, NASPORT, NASIP, FRAMEDIPADDRESS,
CALLINGSTATION,
CALLEDSTATION, LIVINGSTON)
values
('username', 967651977, 'Stop', 0, 213, 34, '4600B3E0',
120, 'User-Request', 'ISDN',
24, '207.174.103.7', '204.144.244.81', '', '', 'User Request -
PPP Term Req')': SQL Timeout
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
