QUESTION Piaf-green need help

[rick]

This is an old box that needs help, asterisk has to be restart every morning.


Asterisk = ONLINE | Dahdi = ONLINE | MySQL = OFFLINE
SSH = ONLINE | Apache = ONLINE | Iptables = ONLINE
Fail2ban = ONLINE | Internet = ONLINE | Ip6Tables = ONLINE
Disk Free = ADEQUATE| Mem Free = ADEQUATE| NTPD = ONLINE
SendMail = ONLINE | Samba = OFFLINE | Webmin = ONLINE
Ethernet0 = ONLINE | Ethernet1 = N/A | Wlan0 = N/A
PIAF Installed Version = 2.0.6.5 under *HARDWARE*
FreePBX Version = 2.11.0.41 2.11
Running Asterisk Version = 11.7.0
Asterisk Source Version = 11.7.0
Dahdi Source Version = 2.8.0.1
Libpri Source Version = 1.4.14
IP Address = 192.168.0.150 on eth0
Operating System = CentOS release 6.5 (Final)
Kernel Version = 2.6.32-431.1.2.0.1.el6.i686 - 32 Bit

Cannot log into the GUI, the errors are:

DB Error: connect failed
Trace Back
/var/www/html/admin/libraries/db_connect.php:71 die_freepbx()
[0]: DB Error: connect failed

/var/www/html/admin/bootstrap.php:85 require_once()
[0]: /var/www/html/admin/libraries/db_connect.php

/etc/freepbx.conf:9 require_once()
[0]: /var/www/html/admin/bootstrap.php

/var/www/html/admin/config.php:99 include_once()
[0]: /etc/freepbx.conf

Need help to salvage this box and upgrade path. Thanks

 

[geopeterwc]

@rick ... There's really no "direct upgrade" path for the old PIAF-Green. It's good that you're able to get it running, even with a daily restart. But that's really the good part!

My recommendation (and I'm sure the recommendation of others) is to build a new, latest-edition PIAF, like the IncrediblePBX 13-13 that you'll find here. Choose from the variety of offerings - and depending on the size of your installation and the volume of calls, the RasPi versions might be suitable for you rather than the "heavier metal" options. (Personally, I like the "lean" version of 13-13 ... it produces a "cleaner" installation, but without the bells and whistles that @wardmundy has faithfully added to every version of PIAF since the early days of PIAF.)

Get the replacement system operational, and then do cut-and-paste from the marginally functional PIAF-Green system to the new system, and you should be reliably operational in short order.

/Pete./

 

[phonebuff]

@rick

Have to agree Backup everything you can with TAR in case you need to dig through some things and move the files to another system,

Back up any customer voice files and voicemail boxes you need to save with tar and also move them.

Start clean with a version of 13-13 and build from scratch on new harder or at least a new platter --
It's not worth your time to --

 

[krzykat]

I agree with upgrading, but sounds like your DB is corrupted. I'd try repairing your SQL tables - read this for a similar that might help you: https://pbxinaflash.com/community/threads/fix-mysql-db-error.14750/

 

[rick]

Thanks for the response and planning to make a backup this weekend and then try to repair database. Afterwards move to the latest version. Will report back with the results. Thank you again.

 

[rick]

Able to repair db using the following commands:

service mysqld stop
rm -Rf /var/lib/mysql/mysql.sock
service mysqld start

This allows the GUI interface to work and make backups of config. The rebuild is next.
thanks