Home » Forums » Community Edition » Help

Offloading CDR Reports to another Server

Mezz
Posts: 27
 Member Since:
2009-01-21
Submitted by Mezz on Mon, 06/15/2009 - 3:13am.

For some reason the powers that be want to be able to archive the daily load graphs you can make in the CDR Report module. I can't think of any easy way of automating this short of a program that automatically runs the CDR query via the browser and then saves the resultant page (for the time I'd spend programming it, I might as well do it myself every day).

Is it possible to install the cdr reports module on another server and just amend the database that it looks at?

I've already managed to replicate the database to the other server, I'm just not sure how to go about installing the module on a Windows Server.

From what I can tell on my existing php web server, I need to install PEAR, then the PEAR DB module and then find the CDR Module from somewhere? After that I need to figure out where it looks for the database.

Is there any information floating around that can help with this?

‹ 2.6.2.1 Setup wont load still... Custom phone display ›

&nbsp

elacdude
Posts: 36
 Member Since:
2008-10-01
I had a similar issue. I
Mon, 06/15/2009 - 4:43pm

I had a similar issue. I wrote my own sort of CDR report using php and put it on my webserver which connects to the trixbox cdr database to grab the data.


&nbsp

elacdude
Posts: 36
 Member Since:
2008-10-01
you can modify the mysql
Mon, 06/15/2009 - 4:49pm

you can modify the mysql server on your trixbox to accept connections from elsewhere besides just the localhost by doing this:
-under the "mysql" database on the mysql server of trixbox (the actual database is named 'mysql'), there will be a table named 'user'. create a new user and make sure to set the 'host' column to % or your ip address you are connecting from. or you can also just change the 'host' column for the root user but I wouldn't recommend it because its the root user.

and then after you can connect to the 'asteriskcdrdb' database on the mysql server on the trixbox, the cdr data you need is located at:
database 'asteriskcdrdb', table 'cdr'


&nbsp

Mezz
Posts: 27
 Member Since:
2009-01-21
Thanks for the reply, I've
Tue, 06/16/2009 - 3:10am

Thanks for the reply, I've already got access to the database so thats not a problem. Can I grab the cdr module and install it on a windows server somehow?

From what I can figure out I need PEAR, a PEAR DB addin and then the module itself. I'd rather use the existing module than recreate it, I just can't find any documentation covering this process.


&nbsp

elacdude
Posts: 36
 Member Since:
2008-10-01
i'm sure its possible, it
Tue, 06/16/2009 - 9:20am

i'm sure its possible, it might be diffucult and take some digging through the code to move it though. i doubt there is an easy way to do it, you probably just need a php guy to figure it out (?) :-/


&nbsp

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.