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