found out it was a chroot problem.
My fix if any comes by the same problem was to add this to the startup script:
if [ -e /var/run/mysqld/mysqld.sock ]; then
if [ -e /var/spool/postfix/var/run/mysqld/mysqld.sock ]; th$
rm /var/spool/postfix/var/run/mysqld/mysqld.sock
fi
mkdir -p /var/spool/postfix/var/run/mysqld
chown mysql /var/spool/postfix/var/run/mysqld
ln /var/run/mysqld/mysqld.sock /var/spool/postfix/var/run/m$
fi
On Thu, Aug 21, 2008 at 4:23 PM, Jes Andersen <[EMAIL PROTECTED]> wrote:
> I have small problem with postfix when trying to switch to mysql for postfix.
>
> I used:
> $sudo postmap -q [EMAIL PROTECTED] hash:/etc/postfix/virtual
> [EMAIL PROTECTED]
> $sudo postmap -q [EMAIL PROTECTED]
> mysql:/etc/postfix/mysql-list.cf mysql:/etc/postfix/mysql.cf
> [EMAIL PROTECTED]
>
> to test the configuration before changing main.cf
> from
> virtual_alias_maps = hash:/etc/postfix/virtual
> to
> virtual_alias_maps = mysql:/etc/postfix/mysql.cf
>
> But it didn't work after a restart of postfix
>
> From /var/log/mail.log:
> [...]
> postfix/smtpd[18039]: warning: connect to mysql server localhost:
> Can't connect to local MySQL server through socket
> '/var/run/mysqld/mysqld.sock' (2)
> [...]
>
> I can't understand why postmap works when smptd doesn't
>
> It is possible for the postfix user to connect to the local server
> through the socket as this command proves
> $sudo -u postfix mysqladmin --protocol=SOCKET
> --socket=/var/run/mysqld/mysqld.sock version
> mysqladmin Ver 8.41 Distrib 5.0.51a, for debian-linux-gnu on i486
> [..]
>
> I do not run the vanilla postfix but the debian modified one but I
> don't think that should be the problem.
> $sudo postconf -d | grep "mail_version ="
> mail_version = 2.5.2
>
> Thanks in advance
> Jes
>