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