Results 1 to 7 of 7
Thread: MySQL
Hybrid View
-
4th February 2022 11:52 #1
MySQL
Ubuntu 20.04, MySQL 8, Dovecot/Postfix . , MySQL :
"dovecot: auth-worker(63732): Error: mysql(localhost): Connect failed to database (mail): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)"
/ , (Outlook, Thunderbird...) 3 .
, , . !
.. , , , .Last edited by sorrow; 4th February 2022 at 12:50. Reason:
-
4th February 2022 14:24 #2
-
4th February 2022 15:17 #3Registered User
Join Date: May:2013
Location: ,
Posts: 69
Last edited by paradox_89; 4th February 2022 at 15:17.
T440s - Intel Core i5-4200U | 12GB RAM | 240GB Transcend SSD + 500GB WD Black 7200 | Linux master race
-
4th February 2022 17:14 #4
, .
Postfix-a , dovecot-mysql.conf , .
, :
. , :Code:2022-02-04T08:14:54.103190Z 0 [ERROR] [MY-011292] [Server] Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible' 2022-02-04T08:14:54.103223Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/mysqld/mysqlx.sock' failed, can't create lock file /var/run/mysqld/mysqlx.sock.lock' 2022-02-04T08:16:24.385891Z 4 [System] [MY-013381] [Server] Server upgrade from '80027' to '80028' started. 2022-02-04T08:21:25.599836Z 4 [System] [MY-013381] [Server] Server upgrade from '80027' to '80028' completed. 2022-02-04T08:21:27.677676Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2022-02-04T08:21:27.677717Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2022-02-04T08:21:27.742804Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory. 2022-02-04T08:21:27.757640Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.28-0ubuntu0.20.04.3' socket: '/tmp/tmp.5C2v3yP4Ok/mysqld.sock' port: 0 (Ubuntu). 2022-02-04T08:21:27.771408Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.28-0ubuntu0.20.04.3). 2022-02-04T08:22:21.681273Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.28-0ubuntu0.20.04.3) (Ubuntu). 2022-02-04T08:22:24.055057Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.28-0ubuntu0.20.04.3) starting as process 64069 2022-02-04T08:22:24.495954Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2022-02-04T08:22:25.155016Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2022-02-04T08:22:25.616409Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2022-02-04T08:22:25.616448Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2022-02-04T08:22:25.629994Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/mysqlx.sock 2022-02-04T08:22:25.630011Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.28-0ubuntu0.20.04.3' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
, . (wordpress , MySQL), dovecot/postfix/roundcube ( ) - , (Outlook, Thunderbird,...), . .Code:dovecot: auth-worker(62831) Error: sql(user@server.bg,192.168.10.1) Password query failed: Not connected to database dovecot: auth-worker(62999) Error: mysql(localhost) Connect failed to database (mail) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) - waiting for 1 seconds before retry
-
4th February 2022 20:04 #5Registered User
Join Date: May:2013
Location: ,
Posts: 69
IMAP SMARTTLS . - (?@*...)? stack overflow default_pass_scheme, ? https://dovecot.org/pipermail/doveco...ch/099907.html
Last edited by paradox_89; 4th February 2022 at 20:07.
T440s - Intel Core i5-4200U | 12GB RAM | 240GB Transcend SSD + 500GB WD Black 7200 | Linux master race
-
4th February 2022 21:12 #6
. - , , , MySQL ѝ, Mysql. , . , . , . , , (Helo command rejected: need fully-qualified hostname) , . . .




Reply With Quote

7th May 2023, 16:02 in PC