🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

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

#907212
From: Marcin Debowski
Date: Thu, 10 Aug 2023 03:48
29 lines
1883 bytes
Dziń dybry.

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

mysql -u vmuser -p --socket=/run/mysqld/mysqld.sock
włazi i dla zwykłego user'a

3306 też otwarty i słucha na localhoscie.

Ki diabeł? 

-- 
Marcin
Technical Details
Message-ID: <l6ZAM.88528$xLnb.11230@fx01.ams1>
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!news-2.dfn.de!news.dfn.de!npeer.as286.net!npeer-ng0.as286.net!peer01.ams1!peer.ams1.xlned.com!news.xlned.com!feeder.cambriumusenet.nl!feed.tweaknews.nl!posting.tweaknews.nl!fx01.ams1.POSTED!not-for-mail

Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!news-2.dfn.de!news.dfn.de!npeer.as286.net!npeer-ng0.as286.net!peer01.ams1!peer.ams1.xlned.com!news.xlned.com!feeder.cambriumusenet.nl!feed.tweaknews.nl!posting.tweaknews.nl!fx01.ams1.POSTED!not-for-mail
Newsgroups: pl.comp.os.linux
From: Marcin Debowski <agatek@INVALID.zoho.com>
Subject: Can't connect to local server through socket '/run/mysqld/mysqld.sock'
User-Agent: slrn/1.0.3 (Linux)
Mime-Version: 1.0
Lines: 29
Message-ID: <l6ZAM.88528$xLnb.11230@fx01.ams1>
X-Complaints-To: abuse@tweaknews.nl
NNTP-Posting-Date: Thu, 10 Aug 2023 03:48:33 UTC
Organization: Tweaknews
Date: Thu, 10 Aug 2023 03:48:33 GMT
X-Received-Bytes: 1704
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit