No worries Craig; I will forward you a copy tonight. But, to restate the issue ... My radacct tables are in my radius DB, which I believe are correct, however CDRTool is looking for them in the cdrtool db. I have reviewed the global.inc to the best of my knowledge - maybe a second pair of eyes can locate the problem.
Thanks again, -graham On 10/6/08 3:40 AM, "Craig Guy" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > Sent: Wednesday, 1 October 2008 9:30 PM > To: Craig Guy > Cc: users@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. > >>> MySQL error: 1146 (Table 'cdrtool.radacct200809' doesn't exist) > > Thoughts? > Thanks for the continued guidance, > > -graham > > > >> 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:[EMAIL PROTECTED] >> Sent: Wednesday, 1 October 2008 8:42 AM >> To: Craig Guy; users@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" <[EMAIL PROTECTED]> wrote: >> >>> 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:[EMAIL PROTECTED] >>> Sent: Tuesday, 30 September 2008 7:53 AM >>> To: Craig Guy >>> Cc: users@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" <[EMAIL PROTECTED]> wrote: >>> >>>> 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: [EMAIL PROTECTED] >>>> [mailto:[EMAIL PROTECTED] On Behalf Of Graham Wooden >>>> Sent: Monday, 29 September 2008 9:46 PM >>>> To: users@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 >>>> >>>> >>>>> 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 <[EMAIL PROTECTED]> >> 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 >>>> afternoon. >>>>>>> >>>>>>> Cheers, >>>>>>> DanB >>>>>>> >>>>>>> On Mon, Sep 29, 2008 at 3:02 PM, Diego Zuaneti Arruda < >>>>>>> [EMAIL PROTECTED]> wrote: >>>>>>> >>>>>>>> Hi all, >>>>>>>> >>>>>>>> Someone has a patch for use freeradius-cdrtool with the latest >>>> version >>>>>> of >>>>>>>> cdrtool ? >>>>>>>> The stable versions of cdrtool not have multiple commands that > were >>>> in >>>>>>>> earlier versions. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> Thanks. >>>>>>>> Diego. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> _______________________________________________ >>>>>>>> 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
