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