Reporting in PBX stopped working

ashboy34

Joined
Jan 22, 2010
Messages
4
Likes
0
Points
0
#1
About a month after we had our phone system installed. We can no longer run reports after the date of December 2nd 2009. Any idea on why this would happen and how to fix it?

Thanks

Dean
 

jgutierrez

Joined
Feb 28, 2008
Messages
5,737
Likes
0
Points
0
#2
That is due to number of registers that are on your report, I will suggest you any of these options:
1. Narrow the date criteria field, lets say, per months
2. Increase the php resources at /etc/php.ini
Code:
;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;

max_execution_time = 30     ; Maximum execution time of each script, in seconds
max_input_time = 60     ; Maximum amount of time each script may spend parsing request data
memory_limit = 16M      ; Maximum amount of memory a script may consume
And double the values that you have for max_execution_time, max_input_time, memory_limit. Just take into account, that icreasing those values, will make elastix to use more resources for appache.

And finally do:
service httpd restart
 

saleh

Joined
Apr 18, 2007
Messages
249
Likes
0
Points
0
#3
Do you mean the "CDR Report".
When you use the "Unembedded freePBX" work the Reports.
Have you change the default elastix mysql root password?

Best Regards,

Saleh
 

ashboy34

Joined
Jan 22, 2010
Messages
4
Likes
0
Points
0
#4
Yes it is the CDR Report. The date only goes to the 2nd of December 2009 in both the standard GUI interface and in the FreePBX. There are 2 different passwords to get into each of them.
The company that setup this phone system may have changed the myspl root password, though I'm not sure. It's just strange that the reports would stop working after 3 weeks of the phone system being online. Anyway, if the password had been changed what would I need to do?

Thanks
Dean
 

ashboy34

Joined
Jan 22, 2010
Messages
4
Likes
0
Points
0
#5
Thanks, I will have our vendor who manages the more complex items in the phone system take a look at this.

thanks
Dean
 

dicko

Joined
Oct 24, 2008
Messages
4,099
Likes
0
Points
0
#6
Your calls should also be in:

/var/log/asterisk/cdr-csv/Master.csv

so

tail /var/log/asterisk/cdr-csv/Master.csv

will show the last few calls,

you can import the ones after December 2 back into the mysql database after you fix the permissions/passwords, google being your friend their.
 

ashboy34

Joined
Jan 22, 2010
Messages
4
Likes
0
Points
0
#7
Thanks. Can I navigate to those reports through the FreePBX or the standard GUI? Unfortunately I know very little about navigating around the current operating system to find files etc.

Dean
 

dicko

Joined
Oct 24, 2008
Messages
4,099
Likes
0
Points
0
#8
Unfortunately not, at this point in time consider it one of the "more complex items"
 

saleh

Joined
Apr 18, 2007
Messages
249
Likes
0
Points
0
#9
I think the best way for you to change the mysql root password and asteriskuser DB password to the elastix default passwords

Elastix Default DB PassWords:

root => eLaStIx.2oo7
asteriskuser => eLaStIx.asteriskuser.2oo7

but when you need to change the default elastix passwords for DB, too many files musst be changed for asteriskuser

/etc/amportal.conf
/etc/asterisk/cbmysql.conf
/etc/asterisk/cdr_mysql.conf
/etc/asterisk/res_mysql.conf

and too many files under the path /var/www/html/modules for root mysql user and asteriskuser

more help in this link
Elastix MySQL password change

Best Regards,

Saleh
 

Members online

No members online now.

Latest posts

Forum statistics

Threads
30,901
Messages
130,885
Members
17,562
Latest member
colak
Top