Thirdlane.com logo

retrieving CDR (mysql)

Posted by hkhan on Thu, 06/13/2013
Forums
Thirdlane platform General Questions

Hi there

am trying to retrieve the CDRs (which are streamed to a mysql server) via thirdlane UI. have enabled "mysql" from CDR setting under System setting.

everything is working fine apart from that i can only pull the first page. when i flip to page2, it just goes back to main CDR query page and upon running the query again, you will still see only first page.

any help would be much appreciated

Submitted by hkhan on Wed, 07/31/2013 Permalink

Hi All
am still having this issue i.e. to view the CDRs which are streamed to a remote mysql server. upon running the query it only display the first page. when you select page 2, it doesn't display any records.

i can see following in webmin log
192.168.x.y - root [31/Jul/2013:16:09:18 +0100] "POST /asterisk/viewcdr.cgi HTTP/1.1" 200 18142
192.168.x.y - root [31/Jul/2013:16:09:34 +0100] "POST /asterisk/viewcdr.cgi HTTP/1.1" 200 11771
192.168.x.y - root [31/Jul/2013:16:15:39 +0100] "POST /asterisk/viewcdr.cgi HTTP/1.1" 200 18142
192.168.x.y - root [31/Jul/2013:16:15:51 +0100] "POST /asterisk/viewcdr.cgi HTTP/1.1" 200 11771

for the row ending in 18142, it displays the first page of cdr. when i flip to page 2, i can see the row ending in 11771 but it does nt display anything

could nt see anything in mysql log

would really appreciate any help in this regard,

Rgds
Hash

Submitted by hkhan on Wed, 07/31/2013 Permalink

also wanted to add that i have tried mysql both on local and a remote host, having the same issue on both

Rgds
Hash