[Kamailio-Users] CDRTool 6.6.4 with freeradius-cdrtool

Graham Wooden graham at g-rock.net
Mon Oct 6 13:32:03 CEST 2008


No worries Craig; I will forward you a copy tonight.

But, to restate the issue ... My radacct tables are in my radius DB, which I
believe are correct, however CDRTool is looking for them in the cdrtool db.
I have reviewed the global.inc to the best of my knowledge - maybe a second
pair of eyes can locate the problem.

Thanks again,

-graham


On 10/6/08 3:40 AM, "Craig Guy" <craig.a.guy at gmail.com> wrote:

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






More information about the Users mailing list