I have some problem like this. Mediaproxy starts correctly but I coudnt find mediaproxy databases.
-Thanks Darshak -----Original Message----- From: users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] On Behalf Of osiris123d Sent: Wednesday, December 23, 2009 1:55 AM To: users@lists.opensips.org Subject: Re: [OpenSIPS-Users] CDRtool freeradius mysql error 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', -> 'a...@umts.ro', 'a...@umts.ro', '83.149.75.105', '5060', '2006-12-10 12:09:19', -> '0', '0', '0', '0', 'sip:3...@umts.ro=3buser=3dphone', -> 'sip:a...@umts.ro', '200', 'Sip-Session', '', '', '0', '0', '200', 'Invite', -> 'sip:3...@vm01.dns-hosting.info', 'as5664a60b', '27qems1o2j', -> '31208005169', '81.23.228.147', '5060', -> 'sip:3...@vm01.dns-hosting.info', '', '', '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', -> 'a...@umts.ro', 'a...@umts.ro', '83.149.75.105', '5060', '2009-12-14 12:09:19', -> '0', '0', '0', '0', 'sip:3...@umts.ro', -> 'sip:a...@umts.ro', '200', 'Sip-Session', '', '', '0', '0', '200', 'Invite', -> 'sip:t...@umts.ro', 'a60bsss', 'qe222ms1o2j', -> '208005169', '81.23.228.147', '5060', -> 'sip:t...@umts.ro', '', '', 'chat' -> ); ERROR 1318 (42000): Incorrect number of arguments for PROCEDURE radius.insert_radacct_record; expected 34, got 32 Adrian Georgescu wrote: > > Looking at your configuration you are not using the latest > configuration files or you did not read the changelog that comes with > each update to keep your previously installed versions up to date. > > For example the sql.conf you have does not match the ones form our > latest packages, if you look at CDRTool latest sample configuration > for Freaaradius the number of fields differ from yours. I am not able > to tell what other things you did not update properly. > > Regarding the table auto-creation, the radcctYYYYMM table is created > by the stored procedure that you are calling in sql.conf: > > accounting_start_query = "\ > CALL insert_radacct_record( \ > 'radius', \ > > The latest stored procedure is found in CDRTool setup directory you > must update that as well. > > -- > Adrian > > > > > > > _______________________________________________ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > -- View this message in context: http://n2.nabble.com/CDRtool-freeradius-mysql-error-tp4200490p4205553.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users