Issue Cannot issue Let's Encrypt

[cipcip]

Hi guys,

I have just purchased a domain today and want to add a certificate for it in my plesk. The other ones work fine, renew fine.
Issue is when adding new ones.

I got the error below:

Could not issue an SSL/TLS certificate for imigi.xyz
Details
Could not install mail certificate: PHP Warning: Error while sending QUERY packet. PID=8954; File: /opt/psa/admin/plib/vendor/plesk/zf1/library/Zend/Db/Adapter/Pdo/Abstract.php, Line: 307

PHP Warning: Error while sending QUERY packet. PID=8954 in /opt/psa/admin/plib/vendor/plesk/zf1/library/Zend/Db/Adapter/Pdo/Abstract.php on line 307
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

Please help me in troubleshooting this.

EDIT: It seems that despite the warning, the certificate was added. What was the cause here ?!

Thanks,
Cristian

 

[IgorG]

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

Usually, it is caused by insufficient 'max_connections' value for mysql. Try to fix it with following steps:

Back up /etc/my.cnf file and open it with a text editor:

# cp -p /etc/my.cnf{,.backup}
# vi /etc/my.cnf

Increase the parameter value under [mysqld] section, for example:

max_connections = 600

Restart MySQL:

# systemctl restart mysql || systemctl restart mysqld || systemctl restart mariadb

 

[cipcip]

Thank you Igor