🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

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

#907215
From: Marcin Debowski
Date: Fri, 11 Aug 2023 04:54
30 lines
2340 bytes
On 2023-08-10, Marcin Debowski <agatek@INVALID.zoho.com> wrote:
> On 2023-08-10, Kamil Jońca <kjonca@poczta.onet.pl> wrote:
>> Marcin Debowski <agatek@INVALID.zoho.com> writes:
>>> Mam taki dziwny problem przy konfiguracji postfixa dla domen 
>>> wirtualnych, gdzie tablice są w bazie sql. 
>>>
>>> postfix/trivial-rewrite[33613]: dict_mysql_get_active: attempting to connect to host localhost
>>> postfix/trivial-rewrite[33613]: warning: connect to mysql server localhost: Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2)
>>> postfix/trivial-rewrite[33613]: warning: virtual_alias_domains: mysql:/etc/postfix/virtual-alias-maps.cf: table lookup problem
>>> postfix/trivial-rewrite[33613]: warning: virtual_alias_domains lookup failure
>>>
>>> Fajnie, tylko, że:
>>> postmap -q alias@mdomena.xx mysql:/etc/postfix/virtual-alias-maps.cf
>>>
>>> nie ma tego problemu i zwraca poprawną wartość "destination".
>>>
>>> i to zarówno dla hosts = unix:/run/mysqld/mysqld.sock jak i hosts = localhost

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

-- 
Marcin
Technical Details
Message-ID: <lajBM.476400$tTKa.471031@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!3.eu.feeder.erje.net!feeder.erje.net!feeder1.feed.usenet.farm!feed.usenet.farm!peer02.ams4!peer.am4.highwinds-media.com!news.highwinds-media.com!peer01.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>

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!3.eu.feeder.erje.net!feeder.erje.net!feeder1.feed.usenet.farm!feed.usenet.farm!peer02.ams4!peer.am4.highwinds-media.com!news.highwinds-media.com!peer01.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>
User-Agent: slrn/1.0.3 (Linux)
Mime-Version: 1.0
Lines: 30
Message-ID: <lajBM.476400$tTKa.471031@fx10.ams1>
X-Complaints-To: abuse@tweaknews.nl
NNTP-Posting-Date: Fri, 11 Aug 2023 04:54:41 UTC
Organization: Tweaknews
Date: Fri, 11 Aug 2023 04:54:41 GMT
X-Received-Bytes: 2130
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit