Can I get a copy of that as well? I am running the latest freeradius and CDRTool - having radius.radacct populate just fine, but can't seem to get the stored procedures to work (Yes, I have patched freeradius to have the stored procedures), so CDRTool it can pull from openser.radacct.YYYMM. While I am not sure if this below will fix it, but I had to overcome several quarks to get everything to click, so far .... Thanks, -graham of _______________________________________________ Users mailing list Users(a)lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

Graham, not sure whether we are speaking about same thing. What Diego is after is a module of freeradius which makes it taking to cdrtool through the telnet interface ( http://sourceforge.net/projects/frad-cdrtool). The work I do there is public under GPL so no need of special channels to get it. Your problem looks more related to CDRTool and MySQL so I would imagine someone else should come up with solutions in this case. Sorry about not being able to help you more. Cheers, DanB On Mon, Sep 29, 2008 at 3:21 PM, Graham Wooden <graham(a)g-rock.net> wrote: > Can I get a copy of that as well? > > I am running the latest freeradius and CDRTool - having radius.radacct > populate just fine, but can't seem to get the stored procedures to > work (Yes, I have patched freeradius to have the stored procedures), > so CDRTool it can pull from openser.radacct.YYYMM. > > While I am not sure if this below will fix it, but I had to overcome > several quarks to get everything to click, so far .... > > Thanks, > > -graham > > > Hey Diego, > > > > I am working on something right now. You should have it later

> > > > Cheers, > > DanB > > > > On Mon, Sep 29, 2008 at 3:02 PM, Diego Zuaneti Arruda < > > diego(a)fasternet.com.br&gt; wrote: > > > >> Hi all, > >> > >> Someone has a patch for use freeradius-cdrtool with the latest

> of > >> cdrtool ? > >> The stable versions of cdrtool not have multiple commands that were

Hi Graham, I'm currently working on implementing CDRTool 6.6.5. There are two versions of sql.conf - one calling the stored procedures and one that doesn't. The called procedures sql.conf is sourced from CDRTool/setup/radius/OpenSIPs/radius_accounting.conf rather than CDRTool/setup/radius/OpenSIPs/sql.conf Craig -----Original Message----- From: users-bounces(a)lists.kamailio.org [mailto:users-bounces@lists.kamailio.org] On Behalf Of Graham Wooden Sent: Monday, 29 September 2008 9:46 PM To: users(a)lists.kamailio.org Subject: Re: [Kamailio-Users] CDRTool 6.6.4 with freeradius-cdrtool Your're right Dan; we're not. After reading your reply below, it's relating to something completely different. I am just grasping at straws as I spent the whole weekend trying to get CDRTool fully working. I would agree that it's CDRTool (6.6.3) and MySQL (5.0.45); I don't see how these stored proceedures work (how they get called). I do appreciate the reply Dan. Thanks, -graham afternoon. version in _______________________________________________ Users mailing list Users(a)lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

Hi Graham, That is correct - CDRTool looks in the radacct table of the radius database for the cdrs as defined in the ser_radius datasource in global.inc - the table definition is: "table" => "radacct".date("Ym"), Have a close look at CDRTool/setup/global.inc.simple.sample to see how it goes together (db_class DB_radius) Craig -----Original Message----- From: Graham Wooden [mailto:graham@g-rock.net] Sent: Tuesday, 30 September 2008 7:53 AM To: Craig Guy Cc: users(a)lists.kamailio.org Subject: Re: [Kamailio-Users] CDRTool 6.6.4 with freeradius-cdrtool That did it! Now a new problem - the tables being created in the radius DB opposed to the openser DB where CDRTool wants to look. The stored procedures are within the radius DB, is that right? so how/where do I tell CDRTool to look in that DB for the new table or do I need to move the stored procedures somewhere else? Thanks again Craig for any guidance ... -graham On 9/29/08 11:37 AM, "Craig Guy" &lt;craig.a.guy(a)gmail.com&gt; wrote: versions

> MySQL error: 1146 (Table 'cdrtool.radacct200809' doesn't exist)

Check your radius database - seems like the radacct200809 table hasn't been created. If you issue 'show tables' in mysql you should see both a radacct table and radacct200809. The radacct table should be empty. If not then you may not be using the correct sql.conf / installed the procedures to mysql. Craig -----Original Message----- From: Graham Wooden [mailto:graham@g-rock.net] Sent: Wednesday, 1 October 2008 8:42 AM To: Craig Guy; users(a)lists.kamailio.org Subject: Re: [Kamailio-Users] CDRTool 6.6.4 with freeradius-cdrtool Hi Craig, Yup, that is the file that I used to based my /etc/cdtool/global.inc off of. DB_radius is pointing to my radius DB, but the CDRTool GUI is pointing to my the CDRTool DB for the cdrs: Database error: Invalid SQL: select count(*) as records from radacct200809 where (AcctStartTime >= '2008-09-30 18:26' and AcctStartTime < '2008-09-30 23:55') MySQL error: 1146 (Table 'cdrtool.radacct200809' doesn't exist) 64Session halted. Where do I tell CDRTool to use radius.radacctYYYYMM? I only have the cdrtool DB listed for DB_CDRTool and DB_Locker, which is correct. Maybe another setting I am overlooking? Thanks, On 9/30/08 3:17 AM, "Craig Guy" &lt;craig.a.guy(a)gmail.com&gt; wrote: database how/where move The to wrote:

Hi Graham, Sorry for the delay - I've been setting up my own copy of CDRTool with all the fruit. I am not getting that error and neither do I have a radacct table in the cdrtool db. I suspect your data sources in global.inc are probably incorrect. Could you forward me a copy of your global.inc? Craig -----Original Message----- From: Graham Wooden [mailto:graham@g-rock.net] Sent: Wednesday, 1 October 2008 9:30 PM To: Craig Guy Cc: users(a)lists.kamailio.org Subject: RE: [Kamailio-Users] CDRTool 6.6.4 with freeradius-cdrtool Hi Craig, The table is indeed there, and it's being populated. I saw it when I got the correct sql.conf moved over to my freeradius directory. The problem (that I see it) is that the CDRTool GUI is looking in the 'cdrtool' DB for that table. Thoughts? Thanks for the continued guidance, -graham been radacct of. my DB were

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: -- View this message in context: http://www.nabble.com/CDRTool-6.6.4-with-freeradius-cdrtool-tp19723468p1997… Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com. _______________________________________________ Users mailing list Users(a)lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

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: -- View this message in context: http://www.nabble.com/CDRTool-6.6.4-with-freeradius-cdrtool-tp19723468p1997… Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com. _______________________________________________ Users mailing list Users(a)lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

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 &lt;graham(a)g-rock.net&gt; > 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

>>>>> >>>> that >>>>> >>>> for DB_siptrace I use opensips DB rather than cdrtool. >>>>> >>>> >>>>> >>>> The datasource for radacct is DB_radius which you have defined as

_______________________________________________ Users mailing list Users(a)lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

This is working for me on both CDRTool 6.6.4 and 6.6.9 - did you try using my global.inc and modifying for your setup. I am also using Opensips and Mediaproxy exclusively (no Asterisk or other B2BUA). Craig -----Original Message----- From: users-bounces(a)lists.kamailio.org [mailto:users-bounces@lists.kamailio.org] On Behalf Of nasamehdi Sent: Tuesday, 14 October 2008 9:28 PM To: users(a)lists.kamailio.org Subject: Re: [Kamailio-Users] CDRTool 6.6.4 with freeradius-cdrtool 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: -- View this message in context: http://www.nabble.com/CDRTool-6.6.4-with-freeradius-cdrtool-tp19723468p19973 522.html Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com. _______________________________________________ Users mailing list Users(a)lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users _______________________________________________ Users mailing list Users(a)lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users