MariaDB 10.2.9 - Aborted connection to db 'imscp'

**FloRet88** · Nov 2nd 2017

Hello,

i get following messages in services mariadb status

SYSTEM:
I-MSCP 1.5.x (01.11.2017 14:00)
MariaDB 10.2.9
PHP-FPM
Debian Stretch 9.2

WARNINGS:

Shell-Script

Nov 02 12:04:49 xxx mysqld[5931]: 2017-11-02 12:04:49 140084696053504 [Warning] Aborted connection 279 to db: 'imscp' user: 'imscp_srv_user' host: 'localhost' (Got ti
meout reading communication packets)
Nov 02 12:08:33 xxx mysqld[5931]: 2017-11-02 12:08:33 140084696962816 [Warning] Aborted connection 291 to db: 'imscp' user: 'imscp_srv_user' host: 'localhost' (Got ti
meout reading communication packets)
Nov 02 12:11:53 xxx mysqld[5931]: 2017-11-02 12:11:53 140084695750400 [Warning] Aborted connection 384 to db: 'imscp' user: 'imscp_srv_user' host: 'localhost' (Got ti
meout reading communication packets)
Nov 02 12:42:12 xxx mysqld[5931]: 2017-11-02 12:42:12 140085191808768 [Warning] Aborted connection 416 to db: 'imscp' user: 'imscp_srv_user' host: 'localhost' (Got ti
meout reading communication packets)
Nov 02 12:42:32 xxx mysqld[5931]: 2017-11-02 12:42:32 140084696053504 [Warning] Aborted connection 417 to db: 'imscp' user: 'imscp_srv_user' host: 'localhost' (Got ti
meout reading communication packets)
Nov 02 12:53:21 xxx mysqld[5931]: 2017-11-02 12:53:21 140084696962816 [Warning] Aborted connection 433 to db: 'imscp' user: 'imscp_srv_user' host: 'localhost' (Got ti
meout reading communication packets)
Nov 02 13:00:55 xxx mysqld[5931]: 2017-11-02 13:00:55 140085191808768 [Warning] Aborted connection 453 to db: 'imscp' user: 'imscp_srv_user' host: 'localhost' (Got ti
meout reading communication packets)
Nov 02 13:03:36 xxx mysqld[5931]: 2017-11-02 13:03:36 140084696659712 [Warning] Aborted connection 451 to db: 'imscp' user: 'imscp_srv_user' host: 'localhost' (Got ti
meout reading communication packets)

Display More

I am also not able to upgrade to MariaDB 10.2.10 via apt-get update && apt-get upgrade && apt-get dist-upgrade from ip-projects Repo!
Had yesterday 2 hours of conversation with support and Michael.

Any ideas or suggestions? Thank you in advance

Best regards.

**Nuxwin** · Nov 2nd 2017

Quote from FloRet88

Nov 02 12:04:49 xxx mysqld[5931]: 2017-11-02 12:04:49 140084696053504 [Warning] Aborted connection 279 to db: 'imscp' user: 'imscp_srv_user' host: 'localhost' (Got ti
meout reading communication packets)

That warning can have many reasons but because this doesn't seem to affect i-MSCP frontend directly, I presume that this is an application that don't close MySQL connection correctly. The imscp_srv_user SQL user is not used by the i-MSCP frontend, it is used by tools such as PMA, Roundcube... Well here, you should first setup one SQL user per application instead of reusing the imscp_srv_user SQL user (default). Doing this would allows to target the application that is in fault.

Regarding your MariaDB upgrade issue

MariaDB 10.2.10 is not part of Debian repository. How did you processed exactly? I need more details about the failure. An access to the server would be welcome.

**Nuxwin** · Nov 3rd 2017

@FloRet88

Solved. You're now running mariadb 10.2.10. I've also updated your i-MSCP to latest available 1.5.x state

**FloRet88** · Nov 3rd 2017

Hello @Nuxwin

Thank you very much for your support. Any informations about the error / misconfiguration,...?

Best regards.

MariaDB 10.2.9 - Aborted connection to db 'imscp'

Share

Daily visitors