Results 1 to 7 of 7

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
    MEGADETH mkp's Avatar
    Join Date: Jul:2003
    Location: _
    Posts: 1,746
    Âèæ íà òîçè ëèíê äàëè íÿêîå ïðåäëîæåíèå ùå ñâúðøè ðàáîòà:

    https://phoenixnap.com/kb/mysql-serv...-mysqld-sock-2

  3. #3
    Registered User
    Join Date: May:2013
    Location: Áúëãàðèÿ,Ñìîëÿí
    Posts: 69
    Ìèñëÿ ÷å òîâà ìîæå äà ïîìîãíå https://stackoverflow.com/questions/...ed-to-database
    Ïîòðåáèòåëÿò â dovecot èìà ëè ðàçðåøåíèÿ äà ðàáîòè ñ áàçàòà?
    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 mkp View Post
    Âèæ íà òîçè ëèíê äàëè íÿêîå ïðåäëîæåíèå ùå ñâúðøè ðàáîòà:

    https://phoenixnap.com/kb/mysql-serv...-mysqld-sock-2
    Íàïðàâèõ âñè÷êî îò ëèíêà, íî íå ñå îïðàâè.


    Quote Originally Posted by paradox_89 View Post
    Ìèñëÿ ÷å òîâà ìîæå äà ïîìîãíå https://stackoverflow.com/questions/...ed-to-database
    Ïîòðåáèòåëÿò â dovecot èìà ëè ðàçðåøåíèÿ äà ðàáîòè ñ áàçàòà?
    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 | Ìàãàçèí çà åëåêòðîííè öèãàðè