[Kamailio-Users] CDRTool 6.6.4 with freeradius-cdrtool

[Craig Guy]

Check your radius database - seems like the radacct200809 table hasn't been
created.  If you issue 'show tables' in mysql you should see both a radacct
table and radacct200809.  The radacct table should be empty.  If not then
you may not be using the correct sql.conf / installed the procedures to
mysql.

Craig

-----Original Message-----
From: Graham Wooden [mailto:graham at g-rock.net] 
Sent: Wednesday, 1 October 2008 8:42 AM
To: Craig Guy; users at lists.kamailio.org
Subject: Re: [Kamailio-Users] CDRTool 6.6.4 with freeradius-cdrtool

Hi Craig,
Yup, that is the file that I used to based my /etc/cdtool/global.inc off of.
DB_radius is pointing to my radius DB, but the CDRTool GUI is pointing to my
the CDRTool DB for the cdrs:

Database error: Invalid SQL: select count(*) as records from radacct200809
where (AcctStartTime >= '2008-09-30 18:26' and AcctStartTime < '2008-09-30
23:55') MySQL error: 1146 (Table 'cdrtool.radacct200809' doesn't exist)
64Session halted.

Where do I tell CDRTool to use radius.radacctYYYYMM?
I only have the cdrtool DB listed for DB_CDRTool and DB_Locker, which is
correct.  Maybe another setting I am overlooking?

Thanks,


On 9/30/08 3:17 AM, "Craig Guy" <craig.a.guy at gmail.com> wrote:

> Hi Graham,
> 
> That is correct - CDRTool looks in the radacct table of the radius
database
> for the cdrs as defined in the ser_radius datasource in global.inc - the
> table definition is:
> 
> "table" => "radacct".date("Ym"),
> 
> Have a close look at CDRTool/setup/global.inc.simple.sample to see how it
> goes together (db_class DB_radius)
> 
> Craig
> 
> -----Original Message-----
> From: Graham Wooden [mailto:graham at g-rock.net]
> Sent: Tuesday, 30 September 2008 7:53 AM
> To: Craig Guy
> Cc: users at lists.kamailio.org
> Subject: Re: [Kamailio-Users] CDRTool 6.6.4 with freeradius-cdrtool
> 
> That did it! Now a new problem - the tables being created in the radius DB
> opposed to the openser DB where CDRTool wants to look.
> The stored procedures are within the radius DB, is that right? so
how/where
> do I tell CDRTool to look in that DB for the new table or do I need to
move
> the stored procedures somewhere else?
> 
> Thanks again Craig for any guidance ...
> 
> -graham
> 
> 
> On 9/29/08 11:37 AM, "Craig Guy" <craig.a.guy at gmail.com> wrote:
> 
>> Hi Graham,
>> 
>> I'm currently working on implementing CDRTool 6.6.5.  There are two
> versions
>> of sql.conf - one calling the stored procedures and one that doesn't.
The
>> called procedures sql.conf is sourced from
>> CDRTool/setup/radius/OpenSIPs/radius_accounting.conf rather than
>> CDRTool/setup/radius/OpenSIPs/sql.conf
>> 
>> Craig
>> 
>> -----Original Message-----
>> From: users-bounces at lists.kamailio.org
>> [mailto:users-bounces at lists.kamailio.org] On Behalf Of Graham Wooden
>> Sent: Monday, 29 September 2008 9:46 PM
>> To: users at lists.kamailio.org
>> Subject: Re: [Kamailio-Users] CDRTool 6.6.4 with freeradius-cdrtool
>> 
>> Your're right Dan; we're not. After reading your reply below, it's
>> relating to something completely different.  I am just grasping at
>> straws as I spent the whole weekend trying to get CDRTool fully working.
>> 
>> I would agree that it's CDRTool (6.6.3) and MySQL (5.0.45); I don't
>> see how these stored proceedures work (how they get called).
>> 
>> I do appreciate the reply Dan. Thanks,
>> 
>> -graham
>> 
>> 
>>> Graham,
>>> 
>>> not sure whether we are speaking about same thing.
>>> 
>>> What Diego is after is a module of freeradius which makes it taking to
>>> cdrtool through the telnet interface (
>>> http://sourceforge.net/projects/frad-cdrtool).
>>> 
>>> The work I do there is public under GPL so no need of special channels
to
>>> get it.
>>> 
>>> Your problem looks more related to CDRTool and MySQL so I would imagine
>>> someone else should come up with solutions in this case.
>>> 
>>> Sorry about not being able to help you more.
>>> 
>>> Cheers,
>>> DanB
>>> 
>>> On Mon, Sep 29, 2008 at 3:21 PM, Graham Wooden <graham at g-rock.net>
wrote:
>>> 
>>>> Can I get a copy of that as well?
>>>> 
>>>> I am running the latest freeradius and CDRTool - having radius.radacct
>>>> populate just fine, but can't seem to get the stored procedures to
>>>> work (Yes, I have patched freeradius to have the stored procedures),
>>>> so CDRTool it can pull from openser.radacct.YYYMM.
>>>> 
>>>> While I am not sure if this below will fix it, but I had to overcome
>>>> several quarks to get everything to click, so far ....
>>>> 
>>>> Thanks,
>>>> 
>>>> -graham
>>>> 
>>>>> Hey Diego,
>>>>> 
>>>>> I am working on something right now. You should have it later
>> afternoon.
>>>>> 
>>>>> Cheers,
>>>>> DanB
>>>>> 
>>>>> On Mon, Sep 29, 2008 at 3:02 PM, Diego Zuaneti Arruda <
>>>>> diego at fasternet.com.br> wrote:
>>>>> 
>>>>>>  Hi all,
>>>>>> 
>>>>>>   Someone has a patch for use freeradius-cdrtool with the latest
>> version
>>>> of
>>>>>> cdrtool ?
>>>>>>   The stable versions of cdrtool not have multiple commands that were
>> in
>>>>>> earlier versions.
>>>>>> 
>>>>>> 
>>>>>> 
>>>>>> Thanks.
>>>>>> Diego.
>>>>>> 
>>>>>> 
>>>>>> 
>>>>>> _______________________________________________
>>>>>> Users mailing list
>>>>>> Users at lists.kamailio.org
>>>>>> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>>>>>> 
>>>>> 
>>>> 
>>>> 
>>>> 
>>>> 
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at lists.kamailio.org
>>>> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>>>> 
>>> 
>> 
>> 
>> 
>> 
>> _______________________________________________
>> Users mailing list
>> Users at lists.kamailio.org
>> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>> 
> 
>