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" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> >> 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:[EMAIL PROTECTED] >>>>>> >>>> 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-tp19723468p199 >>>>> 73522.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-tp19723468p19974 >>> 473.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
_______________________________________________ Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
