6 Oct
2008
6 Oct
'08
11:40 a.m.
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@g-rock.net]
Sent: Wednesday, 1 October 2008 9:30 PM
To: Craig Guy
Cc: users(a)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.
were
> 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@g-rock.net]
Sent: Wednesday, 1 October 2008 8:42 AM
To: Craig Guy; users(a)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(a)gmail.com> wrote:
DB
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@g-rock.net]
> Sent: Tuesday, 30 September 2008 7:53 AM
> To: Craig Guy
> Cc: users(a)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 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(a)gmail.com> wrote:
The
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. > 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(a)lists.kamailio.org
> [mailto:users-bounces@lists.kamailio.org] On Behalf Of Graham Wooden
> Sent: Monday, 29 September 2008 9:46 PM
> To: users(a)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(a)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(a)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
in
>>> earlier versions.
>>>
>>>
>>>
>>> Thanks.
>>> Diego.
>>>
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users(a)lists.kamailio.org
>>> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>>>
>>
>
>
>
>
> _______________________________________________
> Users mailing list
> Users(a)lists.kamailio.org
> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>
_______________________________________________
Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users