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
