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
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

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

Reply via email to