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
