SQLSTATE[HY000] [2006] MySQL server has gone away in DB configuration page

[davide445]

Installing on Synology DS using PHP 7.2, MariaDB 10 and Nginx embedded in Web Station.
PHP with all extensions loaded, solved the directory access problem, used 127.0.0.1 instead of localhost
Testing the connection I got this error

[emillod]

Is that possible that you've turned off your database? Or restarted?

[Maximus]

Hi,
Does this error occur upon creating DB (action after 'Requirements Check Page')? If so, then does this issue occur right after you clicked the button or after a while?
- If it occurred right after then try to increase the 'max_allowed_packet' parameter in the DB config file. Then restart DB service and try again. E.g.:

max_allowed_packet = 64M

- If it occurred after a while then try to increase the 'wait_timeout' parameter in the DB config file. Then restart DB service and try again. E.g.:

wait_timeout = 600

[davide445]

emillod was always up
Maximus yes was in the first screen of the DB configuration, the error happen pressing the Test connection button. Tried setting wait_timeout to 600 using phpMyAdmin but got the same error. Restarting the DB seems his value returned to the default 28800.
Was trying to look at the MariaDB log files but they are not accessible even from my admin account on Synology. Need to say using Synology it's a pain, never tought in 2020 I can't have a GUI, but maybe it's jut me.

[item]

Hello,
can you give the model of your synology ? model ? type ? ram ? processor ? type of hdd ?
crm is a big challenge .. need a good/perfect computer .. i don't think a synology can do the trick.

[emillod]

item i was trying to run EspoCRM on synology DS215j, it was pretty bad idea...
davide445 maybe you could use SSH to change mysql params?

[davide445]

item DS213, 512MB RAM, MARVELL Kirkwood 88F6282, 2xST2000VX00
Installed previously vTiger and works, so I suppose EspoCRM can work also.

Btw I was able to access the DS .err file and think worth reporting his content

2020-11-10 23:22:00 0 [Note] InnoDB: Using Linux native AIO
2020-11-10 23:22:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-11-10 23:22:00 0 [Note] InnoDB: Uses event mutexes
2020-11-10 23:22:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2020-11-10 23:22:00 0 [Note] InnoDB: Number of pools: 1
2020-11-10 23:22:00 0 [Note] InnoDB: Using generic crc32 instructions
2020-11-10 23:22:00 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-11-10 23:22:00 0 [Note] InnoDB: Completed initialization of buffer pool
2020-11-10 23:22:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed
. See the man page of setpriority().
2020-11-10 23:22:00 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-11-10 23:22:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-11-10 23:22:00 0 [Note] InnoDB: Setting file '/var/packages/MariaDB10/target/mysql/ibtmp1' size to 12 MB. Physically wr
iting the file full; Please wait ...
2020-11-10 23:22:00 0 [Note] InnoDB: File '/var/packages/MariaDB10/target/mysql/ibtmp1' size is now 12 MB.
2020-11-10 23:22:01 0 [Note] InnoDB: Waiting for purge to start
2020-11-10 23:22:01 0 [Note] InnoDB: 10.3.21 started; log sequence number 26364704; transaction id 53121
2020-11-10 23:22:01 0 [Note] InnoDB: Loading buffer pool(s) from /volume1/@database/mariadb10/ib_buffer_pool
2020-11-10 23:22:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-11-10 23:22:01 0 [Note] Reading of all Master_info entries succeeded
2020-11-10 23:22:01 0 [Note] Added new Master_info '' to hash table
2020-11-10 23:22:01 0 [Note] /usr/local/mariadb10/bin/mysqld: ready for connections.
Version: '10.3.21-MariaDB' socket: '/run/mysqld/mysqld10.sock' port: 0 Source distribution
2020-11-10 23:22:01 8 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2020-11-10 23:22:01 0 [Note] InnoDB: Buffer pool(s) load completed at 201110 23:22:01
2020-11-11 0:27:19 47 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2020-11-11 0:27:19 48 [Warning] Access denied for user 'root'@'localhost' (using password: NO)

[item]

Hi.
try to adapt in data/config.php

'database' => [
'driver' => 'pdo_mysql',
'host' => 'localhost',
'port' => '',
'charset' => 'utf8mb4',
'dbname' => 'XXX',
'user' => 'YYY',
'password' => 'ZZZ'
], 

adapt XXX, YYY, ZZZ.. but 512ram ..and so.. no luck for have something useable i think

[davide445]

item tried editing using the Synology Text editor but seems didn't save any change.
Just an idea, will be possible to try an installation on Windows WSL? Will be happy to test later again on Synology, but so far want just to try his "clean" version with no addon.

[item]

Hello,
i don't know what is Windows WSL .. but on any linux.. no problem
just follow requirement .. https://docs.espocrm.com/administration/installation/

[emillod]

item tried editing using the Synology Text editor but seems didn't save any change.
Just an idea, will be possible to try an installation on Windows WSL? Will be happy to test later again on Synology, but so far want just to try his "clean" version with no addon.

Yes. It's possible to do so on WSL. But you need basic knowledge to do so, and there you will not have that nice interface which you have on synology

[davide445]

Installed on my workstation (64GB RAM) on WSL using the official docker image, was easy as I wanted (a whole package already configured without messing around with the various elements and configurations) and is working fast for my tests, so all fine so far.