[OpenSIPS-Users] CDRtool freeradius mysql error

[osiris123d]

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-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
> 
> _______________________________________________
> 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-tp4200490p4209195.html
Sent from the OpenSIPS - Users mailing list archive at Nabble.com.