Roundcube mysql gone away!

[shahzaibcb]

Hi,

Recently we switched from apache+nginx to nginx+php-fpm and roundcube started giving database connection failed error. We try to update the roundcube but it gives mysql gone away:

Found MySQL version 8.0
Granting access: GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,LOCK TABLES,INDEX,REFERENCES ON da_roundcube.* TO 'da_roundcube'@'localhost';
Setting password: ALTER USER 'da_roundcube'@'localhost' IDENTIFIED WITH mysql_native_password BY '5iil8lWiCWN2QA';
Editing roundcube configuration...
Roundcube 1.4.5 has been installed successfully.
WARNING: Changed defaults (These config options have new default values):
- 'skin'
- 'smtp_port'
- 'smtp_user'
- 'smtp_pass'
- 'jquery_ui_skin_map'
Executing database schema update.
ERROR: SQLSTATE[HY000] [2006] MySQL server has gone away
ERROR: Failed to connect to database
Reloading php-fpm73.

 

[smtalk]

MySQL server has gone away

You likely need to increase max_allowed_packet in MySQL configuration.

 

[shahzaibcb]

You likely need to increase max_allowed_packet in MySQL configuration.

Hi, already increased it to 1024M in /etc/my.cnf and /usr/local/directadmin/conf/mysql.conf as well but all in vain.

+---------------------------+------------+
| Variable_name             | Value      |
+---------------------------+------------+
| max_allowed_packet        | 1073741824 |
| mysqlx_max_allowed_packet | 67108864   |
| slave_max_allowed_packet  | 1073741824 |
+---------------------------+------------+

 

[smtalk]

Please check MySQL error log then, anything there?

 

[shahzaibcb]

Please check MySQL error log then, anything there?

Hi, i enabled log_error and here is the only logs coming:

Redirecting to /bin/systemctl restart mysqld.service
[root@customer conf]# tail -f /var/log/mysqld.log
2020-06-17T11:08:15.031244Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2020-06-17T11:08:15.162635Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-06-17T11:08:15.206146Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.20'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server - GPL.
2020-06-17T11:16:18.465607Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.20)  MySQL Community Server - GPL.
2020-06-17T11:16:19.670283Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20) starting as process 14463
2020-06-17T11:16:19.722523Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-06-17T11:16:20.041922Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-06-17T11:16:20.214995Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2020-06-17T11:16:20.345957Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-06-17T11:16:20.388191Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.20'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server - GPL.

 

[smtalk]

If your license has any support, I'd suggest opening DA ticket for it.