Something weird happened to me in Elastix 1.6: I access the GUI but can't open the PBX tab. I get an empty page. Also the REPORTS tab is empty. When I tried to access myserver.com/admin I get the message DB error.

I still can access the console but I need access to the Freepbx GUI..

What went wrong and how it can be fixed without reinstalling Elastix?

It seems there is a problem with the mysql database.
Try to restart it


If this does not work. Check the apache logs at the moment you try to access the pbx.

Regards and welcome to the Elastix community

Rafael

Thx for your response and greetings.

I've restarted the mysqld - to no avail.
The error.log tells me that:
Wed Jan 13 02:23:51 2010] [error] [client X.XXX.X.120] PHP Fatal error: Call to undefined method DB_Error::escapeSimple() in /var/www/html/admin/functions.inc.php on line 1297, referer: myserver.zapto.org/

Now here is the said line 1297. PHP scripting is beyond the scope of my knowledge can any thing be fixed without restoring the system?



I compared that code with the same code in other installations and found no discrepancy but may be my eye sight is not as used to be..

Any advice?

I had the same problem. There is one more thing. When I tried to open elastix-ip/admin/index.php I got "DB error: connect". I solved the problem changing password in following places:

1. /etc/amportal.conf, parameter AMPDBPASS. I shortened the password to 9 symbols and removed every symbol which is not a letter or number.
2. /etc/asterisk/cbmysql.conf, parameter password - the same password
3. /etc/asterisk/cdr_mysql.conf, parameter password - the same password
4. /etc/asterisk/res_mysql.conf, parameter password - the same password
5. And finally I changed the password for user "asteriskuser" from console:
mysql -u asteriskuser -p
password: old_password
mysql>SET PASSWORD = PASSWORD('new_password');

Hi all,

This last post saved my day. I moved a backup from a server to another and restored it. The problem came when the password of the two systems on DB was not the same, and PBX tab on the web interface couldn't come up. SO i followed your steps and changed the password to the new system's password. A restart after all fixed everything.


Thanks a lot.


E.D

Hi,

I'm having the same error and can't do the commands from scad... a real newbie here would gladly appreciate your help...

thanks!

i cant get by step 5 with an error, is it asking for an old password? what would that be?

[root@voicemail ~]# mysql -u asteriskuser -p
Enter password:
ERROR 1045 (28000): Access denied for user 'asteriskuser'@'localhost' (using password: YES)

to tbooth:
In this place you should type your old password for mysql`s root, which you entered during installation...

Thats the odd part I put in the old password and got that error.

If all passwords are wrong, then you need to reset the root password mysql. www.google.com/search?client=ubuntu&...e=utf-8&oe=utf-8
After this, login to mysql as root and set new password for asteriskuser@localhost. Do not forget to set a new password for mysql's root.