Reporting in PBX stopped working

Discussion in 'General' started by ashboy34, Jan 22, 2010.

  1. ashboy34

    Joined:
    Jan 22, 2010
    Messages:
    4
    Likes Received:
    0
    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
     
  2. jgutierrez

    Joined:
    Feb 28, 2008
    Messages:
    5,737
    Likes Received:
    0
    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
     
  3. saleh

    Joined:
    Apr 18, 2007
    Messages:
    249
    Likes Received:
    0
    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
     
  4. ashboy34

    Joined:
    Jan 22, 2010
    Messages:
    4
    Likes Received:
    0
    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
     
  5. ashboy34

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

    thanks
    Dean
     
  6. dicko

    Joined:
    Oct 24, 2008
    Messages:
    4,099
    Likes Received:
    0
    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.
     
  7. ashboy34

    Joined:
    Jan 22, 2010
    Messages:
    4
    Likes Received:
    0
    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
     
  8. dicko

    Joined:
    Oct 24, 2008
    Messages:
    4,099
    Likes Received:
    0
    Unfortunately not, at this point in time consider it one of the "more complex items"
     
  9. saleh

    Joined:
    Apr 18, 2007
    Messages:
    249
    Likes Received:
    0
    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
     

Share This Page