Thirdlane.com logo

MySQL CDR Viewing within TL

Posted by Ariel on Mon, 03/30/2009
Forums
Thirdlane platform General Questions

I have successfully made my TL install write CDR to a separate MySQL server. However, when I attempt to view CDR data, no records show, and no records are listed, no matter the search parameters. Is this a condition of being logged in as root? Are there some configurational issues that I can check to ensure that record viewing is available?

Thanks,

Ariel

Submitted by Ariel on Mon, 04/06/2009 Permalink

Asterisk is writing CDR records to the table.

tl-st*CLI> cdr mysql status

Connected to asterisk on socket file /var/lib/mysql/mysql.sock using table cdr for 5 days, 23 hours, 58 minutes, 43 seconds.

Wrote 6 records since last restart and 5 records since last reconnect.

What config files would be useful to see?

Submitted by Ariel on Thu, 04/23/2009 Permalink

Since I posted this, the problem has not changed. I have confirmed that records are writing (over 300 since I last restarted). We have another asterisk server writing its records to the same table. Would that make the request that the gui is doing get messed up? Are there perhaps firewall issues that I should consider? since the Thirdlane server can write, it should certainly be able to read.

Thanks,

Ariel.

Submitted by eeman on Thu, 04/23/2009 Permalink

is the database on a different server? did you choose the option to use the database when viewing records?

Submitted by Ariel on Sun, 04/26/2009 Permalink

The database is on a separate server. I have selected MySQL as the source in the CDR viewing page. Is there another config element that I missed?

Submitted by eeman on Mon, 04/27/2009 Permalink

System Settings --> CDR Settings

can you tell me what you have for

Database host address:

Database name:

Database user:

Submitted by Ariel on Mon, 06/29/2009 Permalink

Database host address: 66.241.x.x (remote mysql in our network)

database name: asterisk

Database user: asterisk

When attempting to view CDR, I get this error when I click select:

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4.0; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729)

Timestamp: Mon, 29 Jun 2009 22:28:14 UTC

Message: 'document.mainForm.rpage' is null or not an object

Line: 118

Char: 2

Code: 0

URI: http://x.x.x.x/asterisk/viewcdr.cgi

Thanks for your help.

Submitted by Ariel on Thu, 07/02/2009 Permalink

On further testing, I have it set to record to CSV as well as MySQL. If I select CSV as the default view on the CDR settings page, it will show the most recent calls from CSV on the CDR display page. If I narrow the results using search terms, the select button works and shows the proper results. If I switch to MySQL as the source, the select button does not do anything. If I switch back to CSV, all while still on the same page, it will not show the CSV records that it had just shown before.

Do you think that I should submit this as a bug? Are there ports that I must ensure are open for the viewing of data since it has been confirmed that it is writing the data?

Thanks