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
