[Kamailio-Users] CDRTool 6.6.4 with freeradius-cdrtool

Tiago Rés tiagores at gmail.com
Tue Oct 14 17:44:14 CEST 2008


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 <graham at g-rock.net>

> 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 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:graham at g-rock.net]
> >>>> Sent: Tuesday, 7 October 2008 10:57 PM
> >>>> To: Craig Guy
> >>>> Cc: users at 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 at 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 at lists.kamailio.org
> >>> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
> >>>
> >>
> >>
> >>
> >>
> >> _______________________________________________
> >> Users mailing list
> >> Users at 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-tp19723468p19974473.html
> > Sent from the OpenSER Users Mailing List mailing list archive at
> Nabble.com.
> >
> >
> > _______________________________________________
> > Users mailing list
> > Users at lists.kamailio.org
> > http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
> >
>
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.kamailio.org
> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20081014/da35d84f/attachment.htm 


More information about the Users mailing list