[Kamailio-Users] CDRTool 6.6.4 with freeradius-cdrtool

Mon Oct 6 10:40:49 CEST 2008

Hi Graham,

Sorry for the delay - I've been setting up my own copy of CDRTool with all
the fruit.  I am not getting that error and neither do I have a radacct
table in the cdrtool db.  I suspect your data sources in global.inc are
probably incorrect.  Could you forward me a copy of your global.inc?

Craig

-----Original Message-----
From: Graham Wooden [mailto:graham at g-rock.net] 
Sent: Wednesday, 1 October 2008 9:30 PM
To: Craig Guy
Cc: users at lists.kamailio.org
Subject: RE: [Kamailio-Users] CDRTool 6.6.4 with freeradius-cdrtool

Hi Craig,

The table is indeed there, and it's being populated. I saw it when I  
got the correct sql.conf moved over to my freeradius directory.  The  
problem (that I see it) is that the CDRTool GUI is looking in the  
'cdrtool' DB for that table.

>> MySQL error: 1146 (Table 'cdrtool.radacct200809' doesn't exist)

Thoughts?
Thanks for the continued guidance,

-graham

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