<HTML>
<HEAD>
<TITLE>Re: [Kamailio-Users] CDRTool 6.6.4 with freeradius-cdrtool</TITLE>
</HEAD>
<BODY>
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>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.<BR>
I am going to be away until then, but that will give me enough time to make it available.<BR>
<BR>
Thanks for the interest ...<BR>
<BR>
-graham<BR>
<BR>
On 10/14/08 10:44 AM, "Tiago Rés" <<a href="tiagores@gmail.com">tiagores@gmail.com</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>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>
2008/10/14 Graham Wooden <<a href="graham@g-rock.net">graham@g-rock.net</a>><BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>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 [<a href="mailto:graham@g-rock.net">mailto:graham@g-rock.net</a>]<BR>
>>>> Sent: Tuesday, 7 October 2008 10:57 PM<BR>
>>>> To: Craig Guy<BR>
>>>> Cc: <a href="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="Users@lists.kamailio.org">Users@lists.kamailio.org</a><BR>
>>>> <a href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users">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">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="Users@lists.kamailio.org">Users@lists.kamailio.org</a><BR>
>>> <a href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a><BR>
>>><BR>
>><BR>
>><BR>
>><BR>
>><BR>
>> _______________________________________________<BR>
>> Users mailing list<BR>
>> <a href="Users@lists.kamailio.org">Users@lists.kamailio.org</a><BR>
>> <a href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users">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">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="Users@lists.kamailio.org">Users@lists.kamailio.org</a><BR>
> <a href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a><BR>
><BR>
<BR>
<BR>
<BR>
<BR>
_______________________________________________<BR>
Users mailing list<BR>
<a href="Users@lists.kamailio.org">Users@lists.kamailio.org</a><BR>
<a href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a><BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
<BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"></SPAN></FONT><FONT SIZE="2"><FONT FACE="Consolas, Courier New, Courier"><SPAN STYLE='font-size:10pt'>_______________________________________________<BR>
Users mailing list<BR>
<a href="Users@lists.kamailio.org">Users@lists.kamailio.org</a><BR>
<a href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a><BR>
</SPAN></FONT></FONT></BLOCKQUOTE>
</BODY>
</HTML>