[OpenSIPS-Users] CDRTool date query problem

[Jeff Pyle]

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 at ag-projects.com> 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 at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> 
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090504/65426ab8/attachment.htm