[OpenSIPS-Users] CDRtool freeradius mysql error

[Saúl Ibarra Corretgé]

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-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
>

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