[OpenSIPS-Users] CDRtool freeradius mysql error

Darshak Modi darshak.modi at elitecore.com
Wed Dec 23 06:11:36 CET 2009


I have some problem like this. Mediaproxy starts correctly but I coudnt find
mediaproxy databases.


-Thanks
Darshak

-----Original Message-----
From: users-bounces at lists.opensips.org
[mailto:users-bounces at lists.opensips.org] On Behalf Of osiris123d
Sent: Wednesday, December 23, 2009 1:55 AM
To: users at 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-m5udeydrjsuw at snom320-000413241247',
'5af53194787eccf1',
    -> 'adi at umts.ro', 'adi at umts.ro', '83.149.75.105', '5060', '2006-12-10
12:09:19', 
    -> '0', '0', '0', '0', 'sip:3333 at umts.ro=3Buser=3Dphone',
    -> 'sip:adi at umts.ro', '200', 'Sip-Session', '', '', '0', '0', '200',
'Invite',
    -> 'sip:3333 at vm01.dns-hosting.info', 'as5664a60b', '27qems1o2j',
    -> '31208005169', '81.23.228.147', '5060',
    -> 'sip:3333 at 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','46477473374 at blink-41247', '5af53194787eccf1',
    -> 'adi at umts.ro', 'adi at umts.ro', '83.149.75.105', '5060', '2009-12-14
12:09:19', 
    -> '0', '0', '0', '0', 'sip:3333 at umts.ro',
    -> 'sip:adi at umts.ro', '200', 'Sip-Session', '', '', '0', '0', '200',
'Invite',
    -> 'sip:test at umts.ro', 'a60bsss', 'qe222ms1o2j',
    -> '208005169', '81.23.228.147', '5060',
    -> 'sip:test at 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 at 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 at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users




More information about the Users mailing list