1 Oct
2008
1 Oct
'08
4:30 p.m.
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@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:
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 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(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 were
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