CDRTool date query problem

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

CDRTool date query problem

Jeff Pyle
CDRTool date query problem Hello,

In CDRTool v6.7.5, I have the following towards the top of my Opensips data source definition:

"table"              => "radacct".date("Ym"),

This is per the instruction right there in the file, if I’m running the mysql procedure to auto-rotate tables.  I am.  The problem is that CDRTool appears to query only the current month and year.

Today I tried to select records on April 28 from 16:00 to 16:30.  A network capture of the traffic from CDRTool to the mysql server showed the following query:

select count(*) as records\n            from radacct200905 where  (AcctStartTime >= '2009-04-28 16:00' and AcctStartTime < '2009-04-28 16:30')

Queries looking for call in May work just fine, as one might expect.  Is this a misconfiguration or a bug?


Thanks,
Jeff

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: CDRTool date query problem

Adrian Georgescu
Jeff,

The search screen clearly displays a list of monthly tables. You should select the table you want, 200904 in this case.

Adrian

On May 4, 2009, at 4:34 PM, Jeff Pyle wrote:

Hello,

In CDRTool v6.7.5, I have the following towards the top of my Opensips data source definition:

"table"              => "radacct".date("Ym"),

This is per the instruction right there in the file, if I’m running the mysql procedure to auto-rotate tables.  I am.  The problem is that CDRTool appears to query only the current month and year.

Today I tried to select records on April 28 from 16:00 to 16:30.  A network capture of the traffic from CDRTool to the mysql server showed the following query:

select count(*) as records\n            from radacct200905 where  (AcctStartTime >= '2009-04-28 16:00' and AcctStartTime < '2009-04-28 16:30')

Queries looking for call in May work just fine, as one might expect.  Is this a misconfiguration or a bug?


Thanks,
Jeff
_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: CDRTool date query problem

Jeff Pyle
Re: [OpenSIPS-Users] CDRTool date query problem Adrian,

I completely missed that.  Wow.  It appears the misconfiguration was between the keyboard and chair.


- Jeff



On 5/4/09 10:36 AM, "Adrian Georgescu" <ag@...> wrote:

Jeff,

The search screen clearly displays a list of monthly tables. You should select the table you want, 200904 in this case.

Adrian

On May 4, 2009, at 4:34 PM, Jeff Pyle wrote:

Hello,
 
 In CDRTool v6.7.5, I have the following towards the top of my Opensips data source definition:
 
 
"table"              => "radacct".date("Ym"),
 
This is per the instruction right there in the file, if I’m running the mysql procedure to auto-rotate tables.  I am.  The problem is that CDRTool appears to query only the current month and year.
 
 Today I tried to select records on April 28 from 16:00 to 16:30.  A network capture of the traffic from CDRTool to the mysql server showed the following query:
 
 
select count(*) as records\n            from radacct200905 where  (AcctStartTime >= '2009-04-28 16:00' and AcctStartTime < '2009-04-28 16:30')
 
Queries looking for call in May work just fine, as one might expect.  Is this a misconfiguration or a bug?
 
 
 Thanks,
 Jeff
  
  _______________________________________________
Users mailing list
Users@...
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users