On 11/03/2014 07:04 AM, Kurt Petersen wrote: > Hi > > I've just installed Debian with Postfix and MySQL. Later I found out > that I also needed the postfix-mysql package. > > I now get an error that Postfix cannot connect to > /var/run/mysqld/mysqld.sock . > > Does anybody got a hint? > > Thanks! > > Kurt >
1. Did you start MySQL? (That's my favorite bone-head blunder) 2. After starting, is the socket at the path indicated? 3. If not, does your MySQL implementation let you specify where to put the socket? 4. How about using the configuration capability in Postfix? From the man page mysql_table: > MYSQL PARAMETERS > hosts The hosts that Postfix will try to connect to and query from. > Specify unix: for UNIX domain sockets, inet: for TCP > connections (default). Example: > hosts = host1.some.domain host2.some.domain:port > hosts = unix:/file/name > > The hosts are tried in random order, with all connections > over UNIX domain sockets being tried before those over > TCP. The connections are automatically closed after being idle > for about 1 minute, and are re-opened as necessary. > Postfix versions 2.0 and earlier do not randomize the host > order. > > NOTE: if you specify localhost as a hostname (even if you > prefix it with inet:), MySQL will connect to the default > UNIX domain socket. In order to instruct MySQL to connect to > localhost over TCP you have to specify > hosts = 127.0.0.1 So, from the documentation, the first fix to try is to get the path to the socket right. The second fix to try is to specify 127.0.0.1:3306
