Article View: pl.comp.os.linux
Article #907217Re: Can't connect to local server through socket '/run/mysqld/mysqld.sock'
From: Marcin Debowski
Date: Fri, 11 Aug 2023 06:41
Date: Fri, 11 Aug 2023 06:41
35 lines
2422 bytes
2422 bytes
On 2023-08-11, Kamil Jońca <kjonca@poczta.onet.pl> wrote: > Marcin Debowski <agatek@INVALID.zoho.com> writes: > > [...] >> Tak jeszcze apropos pewnych nieoczywistości (przynajmniej dla mnie) >> postfixa. Po dalszych grzebaniach odkryłem, że: >> hosts = localhost >> >> nie jest wcale tożsame z >> hosts = 127.0.0.1 >> >> Ten pierwszy zapis postfix interpretuje jako >> hosts = unix:/..socket > > Właściwie to skąd to? > na http://www.postfix.org/postfix-manuals.html nie znalazłem. Z paru twierdzeń (żeby dawać numerycznie) przy podobnych problemach bez wyjasnienia istoty problemu. Tu jest otwarte stwierdzenie: https://workaround.org/ispmail/jessie/postfix-mysql Note: You may be tempted to write “localhost” instead of “127.0.0.1”. Don’t do that because there is indeed a difference in this context. “localhost” will make Postfix look for the MySQL socket file and it can’t find it within it’s chroot jail at /var/spool/postfix because it is at /var/run/mysqld/mysqld.sock by default. But if you tell Postfix to use 127.0.0.1 as described here you make Postfix use a TCP connection to port 3306 on localhost which is working even if Postfix is jailed. Zweryfikowane osobiście, hosts 127.0.0.1 działa poprawnie z chroot bez podmontowywania socketa. Przy deklaracji localhost, Postfix wymaga socketa. -- Marcin
Technical Details
Message-ID:
<dKkBM.476401$tTKa.240729@fx10.ams1>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!2.eu.feeder.erje.net!feeder.erje.net!feeds.phibee-telecom.net!newsreader4.netcologne.de!news.netcologne.de!peer03.ams1!peer.ams1.xlned.com!news.xlned.com!feeder.cambriumusenet.nl!feed.tweaknews.nl!posting.tweaknews.nl!fx10.ams1.POSTED!not-for-mailReferences:
<l6ZAM.88528$xLnb.11230@fx01.ams1> <87wmy3v4o8.fsf@alfa.kjonca> <mj%AM.346291$mIIb.341672@fx11.ams1> <lajBM.476400$tTKa.471031@fx10.ams1> <87jzu2unbl.fsf@alfa.kjonca>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!2.eu.feeder.erje.net!feeder.erje.net!feeds.phibee-telecom.net!newsreader4.netcologne.de!news.netcologne.de!peer03.ams1!peer.ams1.xlned.com!news.xlned.com!feeder.cambriumusenet.nl!feed.tweaknews.nl!posting.tweaknews.nl!fx10.ams1.POSTED!not-for-mail Newsgroups: pl.comp.os.linux From: Marcin Debowski <agatek@INVALID.zoho.com> Subject: Re: Can't connect to local server through socket '/run/mysqld/mysqld.sock' References: <l6ZAM.88528$xLnb.11230@fx01.ams1> <87wmy3v4o8.fsf@alfa.kjonca> <mj%AM.346291$mIIb.341672@fx11.ams1> <lajBM.476400$tTKa.471031@fx10.ams1> <87jzu2unbl.fsf@alfa.kjonca> User-Agent: slrn/1.0.3 (Linux) Mime-Version: 1.0 Lines: 35 Message-ID: <dKkBM.476401$tTKa.240729@fx10.ams1> X-Complaints-To: abuse@tweaknews.nl NNTP-Posting-Date: Fri, 11 Aug 2023 06:41:13 UTC Organization: Tweaknews Date: Fri, 11 Aug 2023 06:41:13 GMT X-Received-Bytes: 2202 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit