It still isn't working. The radacctYYYYMM table is never created in the radius database. I have logging turned on in MySQL and I never see the radius user execute the INSERT command to create the database. Can you explain to me when exactly does the radacctYYYYMM database get created? That way I could pinput what is going on and why it's not working.
Saul Ibarra Corretge wrote: > > Hi, > > On 22/12/09 9:24 PM, osiris123d wrote: >> >> Also in the /var/www/CDRTool/setup/radius/radius_accounting.proc file at >> the >> very end you have some testing statements >> >> when I get into mysql and copy and paste one I get an error >> >> mysql -u root -pPASSWORD -h localhost radius >> Welcome to the MySQL monitor. Commands end with ; or \g. >> Your MySQL connection id is 150 >> Server version: 5.0.51a-24+lenny2-log (Debian) >> >> Type 'help;' or '\h' for help. Type '\c' to clear the buffer. >> >> mysql> CALL insert_radacct_record ( >> -> 'radius','3c3b5ff12bf2-m5udeydrj...@snom320-000413241247', >> '5af53194787eccf1', >> -> '[email protected]', '[email protected]', '83.149.75.105', '5060', >> '2006-12-10 >> 12:09:19', >> -> '0', '0', '0', '0', 'sip:[email protected]=3buser=3dphone', >> -> 'sip:[email protected]', '200', 'Sip-Session', '', '', '0', '0', >> '200', >> 'Invite', >> -> 'sip:[email protected]', 'as5664a60b', '27qems1o2j', >> -> '31208005169', '81.23.228.147', '5060', >> -> 'sip:[email protected]', '', '', 'audio' >> -> ); >> ERROR 1318 (42000): Incorrect number of arguments for PROCEDURE >> radius.insert_radacct_record; expected 34, got 32 >> mysql> CALL insert_radacct_record ( >> -> 'radius','46477473...@blink-41247', '5af53194787eccf1', >> -> '[email protected]', '[email protected]', '83.149.75.105', '5060', >> '2009-12-14 >> 12:09:19', >> -> '0', '0', '0', '0', 'sip:[email protected]', >> -> 'sip:[email protected]', '200', 'Sip-Session', '', '', '0', '0', >> '200', >> 'Invite', >> -> 'sip:[email protected]', 'a60bsss', 'qe222ms1o2j', >> -> '208005169', '81.23.228.147', '5060', >> -> 'sip:[email protected]', '', '', 'chat' >> -> ); >> ERROR 1318 (42000): Incorrect number of arguments for PROCEDURE >> radius.insert_radacct_record; expected 34, got 32 >> > > You were right, there was an error in the testing statements, it's > already fixed in darcs. > > The error was only in the testing statements, so the system should be > working fine for you regardless of that. According to your previous > email, your installation is right, so did you have any problem with it > after you reinstalled it? > > > > Regards, > > > -- > Saúl Ibarra Corretgé > AG Projects > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > -- View this message in context: http://n2.nabble.com/CDRtool-freeradius-mysql-error-tp4200490p4209195.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
