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.
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 < diego@fasternet.com.br> 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
Thanks for reply DanB.
Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org ; users@lists.opensips.org Sent: Monday, September 29, 2008 10:05 AM Subject: Re: [Kamailio-Users] CDRTool 6.6.4 with freeradius-cdrtool
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 diego@fasternet.com.br 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
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 < diego@fasternet.com.br> 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
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@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 afternoon.
Cheers, DanB
On Mon, Sep 29, 2008 at 3:02 PM, Diego Zuaneti Arruda < diego@fasternet.com.br> 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
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 graham@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 afternoon.
Cheers, DanB
On Mon, Sep 29, 2008 at 3:02 PM, Diego Zuaneti Arruda < diego@fasternet.com.br> 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
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@lists.kamailio.org [mailto:users-bounces@lists.kamailio.org] 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 graham@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
afternoon.
Cheers, DanB
On Mon, Sep 29, 2008 at 3:02 PM, Diego Zuaneti Arruda < diego@fasternet.com.br> 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
Thank you Craig - I must have the wrong sql.conf in there. I will swap it out later tonight and see how it does. Thanks,
-graham
On 9/29/08 11:37 AM, "Craig Guy" craig.a.guy@gmail.com 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: users-bounces@lists.kamailio.org [mailto:users-bounces@lists.kamailio.org] 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 graham@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
afternoon.
Cheers, DanB
On Mon, Sep 29, 2008 at 3:02 PM, Diego Zuaneti Arruda < diego@fasternet.com.br> 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
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" craig.a.guy@gmail.com 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: users-bounces@lists.kamailio.org [mailto:users-bounces@lists.kamailio.org] 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 graham@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
afternoon.
Cheers, DanB
On Mon, Sep 29, 2008 at 3:02 PM, Diego Zuaneti Arruda < diego@fasternet.com.br> 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
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@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" craig.a.guy@gmail.com 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: users-bounces@lists.kamailio.org [mailto:users-bounces@lists.kamailio.org] 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 graham@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
afternoon.
Cheers, DanB
On Mon, Sep 29, 2008 at 3:02 PM, Diego Zuaneti Arruda < diego@fasternet.com.br> 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
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" craig.a.guy@gmail.com 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:graham@g-rock.net] 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" craig.a.guy@gmail.com 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: users-bounces@lists.kamailio.org [mailto:users-bounces@lists.kamailio.org] 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 graham@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
afternoon.
Cheers, DanB
On Mon, Sep 29, 2008 at 3:02 PM, Diego Zuaneti Arruda < diego@fasternet.com.br> 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
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@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" craig.a.guy@gmail.com 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:graham@g-rock.net] 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" craig.a.guy@gmail.com 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: users-bounces@lists.kamailio.org [mailto:users-bounces@lists.kamailio.org] 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 graham@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
afternoon.
Cheers, DanB
On Mon, Sep 29, 2008 at 3:02 PM, Diego Zuaneti Arruda < diego@fasternet.com.br> 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
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:graham@g-rock.net] 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" craig.a.guy@gmail.com 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:graham@g-rock.net] 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" craig.a.guy@gmail.com 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: users-bounces@lists.kamailio.org [mailto:users-bounces@lists.kamailio.org] 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 graham@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
afternoon.
Cheers, DanB
On Mon, Sep 29, 2008 at 3:02 PM, Diego Zuaneti Arruda < diego@fasternet.com.br> 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
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@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:graham@g-rock.net] 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" craig.a.guy@gmail.com 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:graham@g-rock.net] 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" craig.a.guy@gmail.com 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: users-bounces@lists.kamailio.org [mailto:users-bounces@lists.kamailio.org] 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 graham@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
afternoon.
Cheers, DanB
On Mon, Sep 29, 2008 at 3:02 PM, Diego Zuaneti Arruda < diego@fasternet.com.br> 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
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" craig.a.guy@gmail.com 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@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:graham@g-rock.net] 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" craig.a.guy@gmail.com 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:graham@g-rock.net] 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" craig.a.guy@gmail.com 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: users-bounces@lists.kamailio.org [mailto:users-bounces@lists.kamailio.org] 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 graham@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
afternoon.
> > Cheers, > DanB > > On Mon, Sep 29, 2008 at 3:02 PM, Diego Zuaneti Arruda < > diego@fasternet.com.br> 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
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@g-rock.net] Sent: Tuesday, 7 October 2008 10:57 PM To: Craig Guy Cc: users@lists.kamailio.org Subject: RE: [Kamailio-Users] CDRTool 6.6.4 with freeradius-cdrtool
Hi Craig, it's attached. Thanks,
-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@g-rock.net] Sent: Tuesday, 7 October 2008 10:57 PM To: Craig Guy Cc: users@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@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
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@g-rock.net] Sent: Tuesday, 7 October 2008 10:57 PM To: Craig Guy Cc: users@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@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-tp19723468p19973... Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.
Users mailing list Users@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:
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@g-rock.net] Sent: Tuesday, 7 October 2008 10:57 PM To: Craig Guy Cc: users@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@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-tp19723468p19973... Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.
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
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@g-rock.net] Sent: Tuesday, 7 October 2008 10:57 PM To: Craig Guy Cc: users@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@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-tp19723468p19973... Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.
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
-- View this message in context: http://www.nabble.com/CDRTool-6.6.4-with-freeradius-cdrtool-tp19723468p19974... Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.
Users mailing list Users@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 graham@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@g-rock.net] Sent: Tuesday, 7 October 2008 10:57 PM To: Craig Guy Cc: users@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@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-tp19723468p19973...
Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.
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
-- View this message in context:
http://www.nabble.com/CDRTool-6.6.4-with-freeradius-cdrtool-tp19723468p19974...
Sent from the OpenSER Users Mailing List mailing list archive at
Nabble.com.
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
Sure thing Tiago I have got quite a few responses from folks so I will post a link to the software by end of the weekend. I am going to be away until then, but that will give me enough time to make it available.
Thanks for the interest ...
-graham
On 10/14/08 10:44 AM, "Tiago Rés" tiagores@gmail.com wrote:
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@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@g-rock.net] >>>> Sent: Tuesday, 7 October 2008 10:57 PM >>>> To: Craig Guy >>>> Cc: users@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@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-tp19723468p199 73522.html
>> Sent from the OpenSER Users Mailing List mailing list archive at >> Nabble.com. >> >> >> _______________________________________________ >> 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
-- View this message in context:
http://www.nabble.com/CDRTool-6.6.4-with-freeradius-cdrtool-tp19723468p19974 473.html
Sent from the OpenSER Users Mailing List mailing list archive at
Nabble.com.
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
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@lists.kamailio.org [mailto:users-bounces@lists.kamailio.org] On Behalf Of nasamehdi Sent: Tuesday, 14 October 2008 9:28 PM To: users@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:
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@g-rock.net] Sent: Tuesday, 7 October 2008 10:57 PM To: Craig Guy Cc: users@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@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
hi,
Thanks for reply I installed CDRTool 6.6.10 I don't have earlier versions of CDRTool Could you forward me CDRTool 6.6.9
Thanks Mahdi
Craig Guy wrote:
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@lists.kamailio.org [mailto:users-bounces@lists.kamailio.org] On Behalf Of nasamehdi Sent: Tuesday, 14 October 2008 9:28 PM To: users@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:
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@g-rock.net] Sent: Tuesday, 7 October 2008 10:57 PM To: Craig Guy Cc: users@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@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-tp19723468p19973 522.html Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.
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
-
Craig Guy -
DanB -
Diego Zuaneti Arruda -
Graham Wooden -
nasamehdi -
Tiago Rés