Results 1 to 7 of 7

Thread: MySQL

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Error 37 sorrow's Avatar
    Join Date: Jul:2006
    Location:
    Posts: 330

    Unhappy 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:

  2. #2

  3. #3
    Registered 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

  4. #4
    Error 37 sorrow's Avatar
    Join Date: Jul:2006
    Location:
    Posts: 330
    , .


    Quote Originally Posted by paradox_89 View Post
    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)
    . , :

    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
    , . (wordpress , MySQL), dovecot/postfix/roundcube ( ) - , (Outlook, Thunderbird,...), . .

  5. #5
    Registered 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

  6. #6
    Error 37 sorrow's Avatar
    Join Date: Jul:2006
    Location:
    Posts: 330
    . - , , , MySQL ѝ, Mysql. , . , . , . , , (Helo command rejected: need fully-qualified hostname) , . . .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |