<HTML>
<HEAD>
<TITLE>Re: [OpenSIPS-Users] CDRTool query display problems</TITLE>
</HEAD>
<BODY>
<FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>Found it. It turned out to be because I hadn’t defined the db_susbcribers table (not to be confused with the db_subscribers table I suppose), it didn’t advance correctly. I defined that approximately, and that seemed to do the trick. Even though there’s nothing in it. Odd.<BR>
<BR>
- Jeff<BR>
<BR>
On 3/31/09 9:58 AM, "Jeff Pyle" <<a href="jpyle@fidelityvoice.com">jpyle@fidelityvoice.com</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>Adrian,<BR>
<BR>
I took a brand new Ubuntu 8.10 install and followed the CDRTool INSTALL directions to the letter. The Next button on the result list and the “Max results per page” option on the query page don’t have any effect. These are the same symptoms I had on a CentOS 5.2 system.<BR>
<BR>
I am doing a few things in a non-standard way. Let me list them here; perhaps one of them will stand out to you as a bad idea. Since we use CDRTool only as a web interface to Asterisk and Opensips CDRs (not for rating), I changed the database defaults to show records already normalized. The only side effect I’ve seen from this is that in-progress calls show up as if they’re completed, with 00:00 duration. I can live with that. Also, I manually populate the Price field of the radius record for Opensips so it shows up on the query result list.<BR>
<BR>
Do you have any ideas on what might cause these functions to break?<BR>
<BR>
<BR>
Thanks,<BR>
Jeff<BR>
<BR>
<BR>
On 3/24/09 4:56 AM, "Adrian Georgescu" <<a href="ag@ag-projects.com">ag@ag-projects.com</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>Sounds like an Apache configuration problem. You may want to review the installation steps related to Apache, maybe this helps.<BR>
<BR>
Adrian<BR>
<BR>
On Mar 24, 2009, at 1:25 AM, Jeff Pyle wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>Hello,<BR>
<BR>
When I run a CDR query in CDRTool, regardless of how many results I tell it<BR>
to display it always shows me 15. Once those 15 are up, the “Next” link at<BR>
the bottom simply reloads the first screen I’m already looking at.<BR>
<BR>
It wasn’t always like this on my system. At some point in the past it used<BR>
to work. I’m not sure when it stopped working, or what I may have done to<BR>
cause it. Any thoughts?<BR>
<BR>
<BR>
Thanks,<BR>
Jeff<BR>
<BR>
<BR>
_______________________________________________<BR>
Users mailing list<BR>
<a href="Users@lists.opensips.org">Users@lists.opensips.org</a><BR>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'><BR>
<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'><BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"></SPAN></FONT><SPAN STYLE='font-size:10pt'><FONT FACE="Lucida Console">_______________________________________________<BR>
Users mailing list<BR>
<a href="Users@lists.opensips.org">Users@lists.opensips.org</a><BR>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><BR>
</FONT></SPAN></BLOCKQUOTE>
</BODY>
</HTML>