[Kamailio-Users] CDRTool 6.6.4 with freeradius-cdrtool

[Graham Wooden]

Sure thing Tiago ­ I have got quite a few responses from folks so I will
post a link to the software by end of the weekend.
I am going to be away until then, but that will give me enough time to make
it available.

Thanks for the interest ...

-graham

On 10/14/08 10:44 AM, "Tiago Rés" <tiagores at gmail.com> wrote:

> Hi Graham, 
> 
> I am also interested because I'm also having troubles setting up CDRTools. It
> gives error "error instantiating db class" when I login, and it doesn't show
> me the CDRs.
> 
> Thanks,
> Tiago
> 
> 2008/10/14 Graham Wooden <graham at g-rock.net>
>> Hi,
>> 
>> I will make it available - it just Apache/MySQL/PHP kind of app.
>> Give me a week or so to tailor it up a bit. It will still be rough
>> however, but functional as described. Site authentication goes against
>> the username/password in openser.subscribers.
>> 
>> Anyone else that is interested let me know ...
>> 
>> -graham
>> 
>> 
>>> >
>>> > HI graham
>>> >
>>> > Thank you for the answer
>>> > i`m interesting in your GUI.
>>> > Could you forward me a copy of your GUI.
>>> > Thanks
>>> >
>>> > Mahdi
>>> >
>>> >
>>> >
>>> > Graham Wooden wrote:
>>>> >>
>>>> >> Hi Mahdi,
>>>> >>
>>>> >> I have given up on trying to find a fix; I have started to write my
>>>> >> own GUI - mainly because then I can tailor it easier. I already have
>>>> >> it where the CDRs are listed out for each subscriber (call direction,
>>>> >> minutes used) along with other openser stuff like what subscribers are
>>>> >> online, etc.
>>>> >>
>>>> >> Craig was a big help, but I am not sure why his worked and ours doesn't.
>>>> >> I couldn't figure out why it kept wanting to call
>>>> >> cdrtool.radacctNNNNNN , opposed to looking at radius.radacctNNNNNN .
>>>> >>
>>>> >> Well, Good luck!
>>>> >>
>>>> >> -graham
>>>> >>
>>>> >>
>>>>> >>>
>>>>> >>> hi
>>>>> >>>
>>>>> >>> I also  have the same error
>>>>> >>> Database error: Invalid SQL: select count(*) as records from radacct
>>>>> >>> where
>>>>> >>> (AcctStartTime >= '2008-10-14 14:05' and AcctStartTime < '2008-10-14
>>>>> >>> 23:55')
>>>>> >>> MySQL error: 1146 (Table 'cdrtool.radacct' doesn't exist) 58Session
>>>>> >>> halted.
>>>>> >>> Please i need your help
>>>>> >>>
>>>>> >>> Mahdi
>>>>> >>>
>>>>> >>>
>>>>> >>> Craig Guy wrote:
>>>>>> >>>>
>>>>>> >>>> Hi Graham,
>>>>>> >>>>
>>>>>> >>>> Had a look - I can't see either why it is generating an error
>>>>>> regarding
>>>>>> >>>> cdrtool.radacct200809.  The only thing I see different from my own
is
>>>>>> >>>> that
>>>>>> >>>> for DB_siptrace I use opensips DB rather than cdrtool.
>>>>>> >>>>
>>>>>> >>>> The datasource for radacct is DB_radius which you have defined as
the
>>>>>> >>>> radius
>>>>>> >>>> DB.
>>>>>> >>>>
>>>>>> >>>> I have included a copy of my own global.inc so you can compare.
>>>>>> >>>>
>>>>>> >>>> Craig
>>>>>> >>>>
>>>>>> >>>> -----Original Message-----
>>>>>> >>>> From: Graham Wooden [mailto:graham at g-rock.net]
>>>>>> >>>> Sent: Tuesday, 7 October 2008 10:57 PM
>>>>>> >>>> To: Craig Guy
>>>>>> >>>> Cc: users at lists.kamailio.org
>>>>>> >>>> Subject: RE: [Kamailio-Users] CDRTool 6.6.4 with freeradius-cdrtool
>>>>>> >>>>
>>>>>> >>>> Hi Craig, it's attached.
>>>>>> >>>> Thanks,
>>>>>> >>>>
>>>>>> >>>> -graham
>>>>>> >>>>
>>>>>> >>>>
>>>>>> >>>>
>>>>>> >>>> _______________________________________________
>>>>>> >>>> Users mailing list
>>>>>> >>>> Users at lists.kamailio.org
>>>>>> >>>> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>>>>>> >>>>
>>>>>> >>>>
>>>>> >>>
>>>>> >>> --
>>>>> >>> View this message in context:
>>>>> >>> 
>>>>> http://www.nabble.com/CDRTool-6.6.4-with-freeradius-cdrtool-tp19723468p199
>>>>> 73522.html
>>>>> >>> Sent from the OpenSER Users Mailing List mailing list archive at
>>>>> >>> Nabble.com.
>>>>> >>>
>>>>> >>>
>>>>> >>> _______________________________________________
>>>>> >>> 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
>>>> >>
>>>> >>
>>> >
>>> > --
>>> > View this message in context:
>>> > 
>>> http://www.nabble.com/CDRTool-6.6.4-with-freeradius-cdrtool-tp19723468p19974
>>> 473.html
>>> > Sent from the OpenSER Users Mailing List mailing list archive at
>>> Nabble.com.
>>> >
>>> >
>>> > _______________________________________________
>>> > 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20081014/aa5a880a/attachment.htm>