🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

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

#907214
From: Marcin Debowski
Date: Thu, 10 Aug 2023 06:18
31 lines
2294 bytes
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
>>
>> # ls -la /run/mysqld/mysqld.sock
>> srwxrwxrwx 1 mysql mysql 0 Aug 10 02:58 /run/mysqld/mysqld.sock
>
> Gupie pytanie. W debianie postfix jest w chroocie. więc może on tego
> socketa szuka w /var/spool/postfix/run/mysqld/mysqld.sock

Zrobiłem 
mount --bind /run/mysqld/ /var/spool/postfix/run/mysqld/

i wygląda, że działa :)
Dzieki :)

-- 
Marcin
Technical Details
Message-ID: <mj%AM.346291$mIIb.341672@fx11.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!feeder1.feed.usenet.farm!feed.usenet.farm!peer03.ams4!peer.am4.highwinds-media.com!news.highwinds-media.com!peer03.ams1!peer.ams1.xlned.com!news.xlned.com!feeder.cambriumusenet.nl!feed.tweaknews.nl!posting.tweaknews.nl!fx11.ams1.POSTED!not-for-mail
References: <l6ZAM.88528$xLnb.11230@fx01.ams1> <87wmy3v4o8.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!feeder1.feed.usenet.farm!feed.usenet.farm!peer03.ams4!peer.am4.highwinds-media.com!news.highwinds-media.com!peer03.ams1!peer.ams1.xlned.com!news.xlned.com!feeder.cambriumusenet.nl!feed.tweaknews.nl!posting.tweaknews.nl!fx11.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>
User-Agent: slrn/1.0.3 (Linux)
Mime-Version: 1.0
Lines: 31
Message-ID: <mj%AM.346291$mIIb.341672@fx11.ams1>
X-Complaints-To: abuse@tweaknews.nl
NNTP-Posting-Date: Thu, 10 Aug 2023 06:18:58 UTC
Organization: Tweaknews
Date: Thu, 10 Aug 2023 06:18:58 GMT
X-Received-Bytes: 2103
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit