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@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@g-rock.net]
>>>> Sent: Tuesday, 7 October 2008 10:57 PM
>>>> To: Craig Guy
>>>> Cc: users@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@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-tp19723468p19973522.html
>>> Sent from the OpenSER Users Mailing List mailing list archive at
>>> Nabble.com.
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users@lists.kamailio.org
>>> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>>>
>>
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users@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-tp19723468p19974473.html
> Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.
>
>
> _______________________________________________
> Users mailing list
> Users@lists.kamailio.org
> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>




_______________________________________________
Users mailing list
Users@lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

---

_______________________________________________
Users mailing list
Users@lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users