🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: pl.comp.os.linux
Article #907217

Re: Can't connect to local server through socket '/run/mysqld/mysqld.sock'

#907217
From: Marcin Debowski
Date: Fri, 11 Aug 2023 06:41
35 lines
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-mail
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>

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