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-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