Hi there, ive been stucked for a couple of days trying to solve this isue:
Errors occurred during installation
A database error has occurred: MySQL server has gone away
Im using PHP 7.3.6, 10.4.5-MariaDB, on a Centos 7.6.
The installation program actually creates a new database as intended, it stay working for a few seconds trying to install, it also creates some new folders/archives inside the installation location, and then the same error message appears.
Any advise would be really apreciated.
Thanks a lot!
Hey @RPD_UNAM
If you have access to the my.cnf file for MySQL, perhaps in /etc/mysqld, look for a configuration directive called max_allowed_packet. It should be in the [mysqld] section. Your default value may be too low. Try setting it to 100M or something. You can also do this while MySQL is running by connecting to the mysql instance via command line, as your root user, and running:
set global max_allowed_packet=104857600
which will do the same thing.
Cheers,
Jason
Hi Jason, tank you for answering, i really apreciate it.
I’ve already tried this:
GNU nano 2.3.1 File: /etc/my.cnf
This group is read both both by the client and the server
use it for options that affect everything
[client-server]
[mysqld]
max_allowed_packet = 2G
innodb_log_file_size = 2G
include all files from the config directory
!includedir /etc/my.cnf.d
At first i tried with 100M, 200M, 300M, etc, (im desperate, lol)
I found the innodb_log_size thing in stackoverflow, didnt work either.
I would really apreciate any other idea, or advise.
Thanks.
Hmmm, have you tried setting persistent connections on? There’s a config option in config.inc.php for OJS that enables this:
persistent = On
Which may help.
Cheers,