Выходит ошибка в кнопке применить изменения, как решить вопрос?

Question

[Габит Шынарбай]

Постоянно весит кнопка применить изменения, при нажатии на кнопку выходит ошибка:
There was an error during reload: Unknown Error. Please Run: fwconsole reload --verbose
Unknown Error. Please Run: fwconsole reload --verbose
выполняю команду fwconsole reload --verbose
показывает :
Невозможно найти класс FreePBX BMO VoicemailТребуемый модуль может быть отк
лючен или не инсталлирован. Рекомендуемые шаги: (выполнить из командной стр
оки): 1) fwconsole ma install voicemail 2) fwconsole ma enable voicemail

как решить данную ситуацию ?

Comments

[Drno]

Ну там же написанно что сделать...
Модуль VoiceMail - включен и работает?
Что говорит консоль на попытку установки этого модуля и его включение?

[Габит Шынарбай]

Drno, вот что говорит
An exception occurred while executing 'SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_ru
le */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'api_r
efresh_tokens' */ WHERE k.table_name = 'api_refresh_tokens' AND k.table_schema = 'asterisk' /*!50116 AND c.constraint_schema = 'asterisk' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL'
:

SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query

In Database.class.php line 247:

SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query

[Valentin Barbolin]

Габит Шынарбай, Место хоть на сервере есть?
df -h

[Габит Шынарбай]

Andrey Barbolin,
Filesystem Size Used Avail Use% Mounted on
devtmpfs 3.8G 0 3.8G 0% /dev
tmpfs 3.8G 0 3.8G 0% /dev/shm
tmpfs 3.8G 17M 3.8G 1% /run
tmpfs 3.8G 0 3.8G 0% /sys/fs/cgroup
/dev/sdb3 50G 29G 22G 58% /
/dev/sdc1 932G 692M 931G 1% /home
/dev/sdb1 1014M 85M 930M 9% /boot
tmpfs 770M 0 770M 0% /run/user/0

[Drno]

Габит Шынарбай, ну он не видит базу данных

[Valentin Barbolin]

Drno, Если быть точный, то у него проблемы с подключением к базе данный.
Причины
- нет места на диске
- поврежденная база из за неправильного выкюлчения или битого диска
- прилетело обновление которое сломало базу

Этапы решения
- проверяем что есть место
- проверяем что SQL запущен ps aux | grep sql
- проверяем что sql слушает порт netstat -anlp | grep 3306
- проверяем log sql, скорее всего тут /var/log/mysql/error.log
- пробуем подключиться из консоли mysq -uroot -p
-пробуем пофиксить базу mysqlcheck --repair --all-databases

[Габит Шынарбай]

Andrey Barbolin,
ps aux | grep sql
mysql 1299 0.1 1.2 1168248 98768 ? Sl 04:35 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock
mysql 1329 0.0 0.0 113412 1592 ? Ss Oct18 0:00 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
root 1877 0.0 0.0 112808 964 pts/0 S+ 04:40 0:00 grep --color=auto sql

netstat -anlp | grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 1299/mysqld
tcp 0 0 127.0.0.1:55442 127.0.0.1:3306 ESTABLISHED 1492/node /var/www/
tcp 0 0 127.0.0.1:3306 127.0.0.1:55442 ESTABLISHED 1299/mysqld

[root@freepbx ~]# mysqlcheck --repair --all-databases
asterisk.admin
note : The storage engine for the table doesn't support repair
asterisk.adv_recovery_backuprestore_log
note : The storage engine for the table doesn't support repair
asterisk.adv_recovery_heartbeat_log
note : The storage engine for the table doesn't support repair
asterisk.adv_recovery_notifications_log
note : The storage engine for the table doesn't support repair
asterisk.adv_recovery_primary_server_settings
note : The storage engine for the table doesn't support repair
asterisk.adv_recovery_serviceswitch_log
note : The storage engine for the table doesn't support repair
asterisk.ampusers
note : The storage engine for the table doesn't support repair
asterisk.announcement
note : The storage engine for the table doesn't support repair
asterisk.api_access_tokens
note : The storage engine for the table doesn't support repair
asterisk.api_applications
note : The storage engine for the table doesn't support repair
asterisk.api_asynchronous_transaction_history
note : The storage engine for the table doesn't support repair
asterisk.api_auth_codes
note : The storage engine for the table doesn't support repair
mysqlcheck: Got error: 2013: Lost connection to MySQL server during query when executing 'REPAIR TABLE ... '

[Valentin Barbolin]

Габит Шынарбай, Что тут ?
--log-error=/var/log/mariadb/mariadb.log

[Габит Шынарбай]

Andrey Barbolin,
[root@freepbx ~]# less /var/log/mariadb/mariadb.log
210211 11:33:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
210211 11:33:28 [Note] /usr/libexec/mysqld (mysqld 5.5.65-MariaDB) starting as process 8771 ...
210211 11:33:28 InnoDB: The InnoDB memory heap is disabled
210211 11:33:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
210211 11:33:28 InnoDB: Compressed tables use zlib 1.2.7
210211 11:33:28 InnoDB: Using Linux native AIO
210211 11:33:28 InnoDB: Initializing buffer pool, size = 128.0M
210211 11:33:28 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
210211 11:33:28 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
210211 11:33:28 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
210211 11:33:28 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
210211 11:33:28 InnoDB: Waiting for the background threads to start
210211 11:33:29 Percona XtraDB (www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 0
210211 11:33:29 [Note] Plugin 'FEEDBACK' is disabled.
210211 11:33:29 [Note] Server socket created on IP: '0.0.0.0'.
210211 11:33:29 [Note] Event Scheduler: Loaded 0 events
210211 11:33:29 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.65-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
210211 11:34:02 [Note] /usr/libexec/mysqld: Normal shutdown
210211 11:34:02 [Note] Event Scheduler: Purging the queue. 0 events
210211 11:34:02 InnoDB: Starting shutdown...
210211 11:34:04 InnoDB: Shutdown completed; log sequence number 14516021
210211 11:34:04 [Note] /usr/libexec/mysqld: Shutdown complete

210211 11:34:04 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
210211 11:46:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
210211 11:46:47 [Note] /usr/libexec/mysqld (mysqld 5.5.65-MariaDB) starting as process 1465 ...
210211 11:46:47 InnoDB: The InnoDB memory heap is disabled
210211 11:46:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
210211 11:46:47 InnoDB: Compressed tables use zlib 1.2.7
210211 11:46:47 InnoDB: Using Linux native AIO
210211 11:46:48 InnoDB: Initializing buffer pool, size = 128.0M
210211 11:46:48 InnoDB: Completed initialization of buffer pool
210211 11:46:48 InnoDB: highest supported file format is Barracuda.
210211 11:46:50 InnoDB: Waiting for the background threads to start
210211 11:46:51 Percona XtraDB (www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 14516021
210211 11:46:52 [Note] Plugin 'FEEDBACK' is disabled

[Valentin Barbolin]

Габит Шынарбай, Это все?

[Габит Шынарбай]

Andrey Barbolin,
[root@freepbx ~]# less /var/log/mariadb/mariadb.log
InnoDB: Cannot continue operation.
211019 06:59:17 mysqld_safe Number of processes running now: 0
211019 06:59:17 mysqld_safe mysqld restarted
211019 6:59:17 [Note] /usr/libexec/mysqld (mysqld 5.5.65-MariaDB) starting as process 21520 ...
211019 6:59:17 InnoDB: The InnoDB memory heap is disabled
211019 6:59:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins
211019 6:59:17 InnoDB: Compressed tables use zlib 1.2.7
211019 6:59:17 InnoDB: Using Linux native AIO
211019 6:59:17 InnoDB: Initializing buffer pool, size = 128.0M
211019 6:59:17 InnoDB: Completed initialization of buffer pool
211019 6:59:17 InnoDB: highest supported file format is Barracuda.
211019 6:59:17 InnoDB: Starting crash recovery from checkpoint LSN=10771858347
InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
211019 6:59:17 InnoDB: Starting final batch to recover 2 pages from redo log
211019 6:59:18 InnoDB: Waiting for the background threads to start
211019 6:59:19 Percona XtraDB (www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 10771859043
211019 6:59:19 [Note] Plugin 'FEEDBACK' is disabled.
211019 6:59:19 [Note] Server socket created on IP: '0.0.0.0'.
211019 6:59:19 [Note] Event Scheduler: Loaded 0 events
211019 6:59:19 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.65-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
211019 7:09:28 [Note] /usr/libexec/mysqld: Normal shutdown
211019 7:09:28 [Note] Event Scheduler: Purging the queue. 0 events
211019 7:09:28 InnoDB: Starting shutdown...
211019 7:09:30 InnoDB: Shutdown completed; log sequence number 10772182049
211019 7:09:30 [Note] /usr/libexec/mysqld: Shutdown complete

211019 07:09:30 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
211019 07:11:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
211019 7:11:29 [Note] /usr/libexec/mysqld (mysqld 5.5.65-MariaDB) starting as process 1518 ...
211019 7:11:29 InnoDB: The InnoDB memory heap is disabled
211019 7:11:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins
211019 7:11:29 InnoDB: Compressed tables use zlib 1.2.7
211019 7:11:29 InnoDB: Using Linux native AIO
211019 7:11:29 InnoDB: Initializing buffer pool, size = 128.0M
211019 7:11:29 InnoDB: Completed initialization of buffer pool
211019 7:11:30 InnoDB: highest supported file format is Barracuda.
211019 7:11:34 InnoDB: Waiting for the background threads to start
211019 7:11:35 Percona XtraDB (www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 10772182049
211019 7:11:35 [Note] Plugin 'FEEDBACK' is disabled.
211019 7:11:35 [Note] Server socket created on IP: '0.0.0.0'.
211019 7:11:36 [Note] Event Scheduler: Loaded 0 events
211019 7:11:36 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.65-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server

[Valentin Barbolin]

Габит Шынарбай, Ты еще тот извращенец. Может полностью файл сюда загрузишь?

[Габит Шынарбай]

Andrey Barbolin, Ааххахах.