Freepbx GUI unreachealble

General Help
1

Hi ,
Sudentely today , i was try to access Freepbx GUI and the web page cannot be loaded .
I try to ssh into it - everytime by the time i enter the user name , ssh is gone - the ip of the pbx is reacheable on the network but actually i cannot ssh to it nor GUI into it .
Can you please help on that .

Thanks !

2

After a hard reboot ,
Here is what i get from the CLI

Exception: SQLSTATE[HY000] [2002] Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)::SQLSTATE[HY000] [2002] Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111) in file /var/www/html/admin/libraries/utility.functions.php on line 120
Stack trace:

    1. Exception->() /var/www/html/admin/libraries/utility.functions.php:120*
    1. die_freepbx() /var/www/html/admin/libraries/BMO/Database.class.php:150*
    1. PDOException->() /var/www/html/admin/libraries/BMO/Database.class.php:144*
    1. PDO->__construct() /var/www/html/admin/libraries/BMO/Database.class.php:144*
    1. FreePBX\Database->__construct() /var/www/html/admin/libraries/BMO/FreePBX.class.php:77*
    1. FreePBX->__construct() /var/www/html/admin/bootstrap.php:144*
    1. require_once() /etc/freepbx.conf:11*
    1. include_once() /var/lib/asterisk/bin/fwconsole:12*
      Exception: SQLSTATE[HY000] [2002] Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)::SQLSTATE[HY000] [2002] Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111) in file /var/www/html/admin/libraries/utility.functions.php on line 120
      Stack trace:
    1. Exception->() /var/www/html/admin/libraries/utility.functions.php:120*
    1. die_freepbx() /var/www/html/admin/libraries/BMO/Database.class.php:150*
    1. PDOException->() /var/www/html/admin/libraries/BMO/Database.class.php:144*
    1. PDO->__construct() /var/www/html/admin/libraries/BMO/Database.class.php:144*
    1. FreePBX\Database->__construct() /var/www/html/admin/libraries/BMO/FreePBX.class.php:77*
    1. FreePBX->__construct() /var/www/html/admin/bootstrap.php:144*
    1. require_once() /etc/freepbx.conf:11*
    1. include_once() /var/lib/asterisk/bin/fwconsole:12*
      ±-----------------------------------------------------------+
      ±-----------------------------------------------------------+
3

systemctl status mysql ?

4

I ll be passing this cmd when iam back to office .

Thank !

5

Below are the outpout

● freepbx.sangoma.local
State: degraded
Jobs: 0 queued
Failed: 3 units
Since: Mon 2023-07-03 11:48:24 UTC; 2min 8s ago
CGroup: /
├─1 /usr/lib/systemd/systemd --switched-root --system --deserialize 22
├─user.slice
│ └─user-0.slice
│ ├─session-5.scope
│ │ ├─1892 sshd: root@pts/0
│ │ ├─1894 -bash
│ │ ├─1948 systemctl status
│ │ └─1949 less
│ └─session-2.scope
│ ├─1070 login – root
│ ├─1821 -bash
│ ├─1875 systemctl status
│ └─1876 less
└─system.slice
├─sangoma-pnpd.service
│ └─1793 /usr/bin/python /usr/local/bin/pnp_server
├─crond.service
│ └─1050 /usr/sbin/crond -n
├─atd.service
│ └─1049 /usr/sbin/atd -f
├─httpd.service
│ ├─1035 /usr/sbin/httpd -DFOREGROUND
│ ├─1735 /usr/sbin/httpd -DFOREGROUND
│ ├─1736 /usr/sbin/httpd -DFOREGROUND
│ ├─1737 /usr/sbin/httpd -DFOREGROUND
│ ├─1738 /usr/sbin/httpd -DFOREGROUND
│ └─1739 /usr/sbin/httpd -DFOREGROUND
├─vega_bridge.service
│ └─1118 /usr/bin/python3.6 -m aiohttp.web aiovega.web:app_factory -H 127.0.0.1 -P 4000
├─rsyslog.service
│ └─1025 /usr/sbin/rsyslogd -n
├─redis.service
│ └─1024 /usr/bin/redis-server 127.0.0.1:6379
├─tuned.service
│ └─1023 /usr/bin/python2 -Es /usr/sbin/tuned -l -P
├─postfix.service
│ ├─1532 /usr/libexec/postfix/master -w
│ ├─1535 pickup -l -t unix -u
│ └─1536 qmgr -l -t unix -u
├─sshd.service
│ └─1015 /usr/sbin/sshd -D
├─mongod.service
│ └─1652 /usr/bin/mongod --quiet -f /etc/mongod.conf run
├─xinetd.service
│ └─1020 /usr/sbin/xinetd -stayalive -pidfile /var/run/xinetd.pid
├─dnsmasq.service
│ └─1012 /usr/sbin/dnsmasq -k
├─avahi-daemon.service
│ ├─777 avahi-daemon: running [freepbx.local
│ └─814 avahi-daemon: chroot helpe
├─incrond.service
│ └─779 /usr/sbin/incrond
├─polkit.service
│ └─775 /usr/lib/polkit-1/polkitd --no-debug
├─systemd-logind.service
│ └─774 /usr/lib/systemd/systemd-logind
├─chronyd.service
│ └─844 /usr/sbin/chronyd -f /etc/sangoma_chrony.conf
├─irqbalance.service
│ └─767 /usr/sbin/irqbalance --foreground
├─dbus.service
│ └─764 /usr/bin/dbus-daemon --system --address=systemd: --nofork --nopidfile --systemd-activation
├─rpcbind.service
│ └─765 /sbin/rpcbind -w
├─auditd.service
│ └─740 /sbin/auditd
├─systemd-udevd.service
│ └─594 /usr/lib/systemd/systemd-udevd
├─lvm2-lvmetad.service
│ └─576 /usr/sbin/lvmetad -f
└─systemd-journald.service
└─563 /usr/lib/systemd/systemd-journald

6

systemctl status mysql
Unit mysql.service could not be found.

No return for this cmd.

7

Might be called mysqld on a RH system.

8

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.