LinuxQuestions.org - Postfix connecting through MySQL to user database/directories

- Debian (https://www.linuxquestions.org/questions/debian-26/)

- - Postfix connecting through MySQL to user database/directories (https://www.linuxquestions.org/questions/debian-26/postfix-connecting-through-mysql-to-user-database-directories-399443/)

Postfix connecting through MySQL to user database/directories

Hello all.

I'm having some difficulties configuring my Debian server with the following:
- Postfix 2.2
- MySQL 4.0
- Courier-imap/pop

Postfix is configured to obtain all information regarding Maildirs, emailadresses and usernames through the MySQL database. I've followed a How to on the web to configure the server and all seems to work just fine except Postfix cannot get into the directory I suppied the database with. The following error occurs:

Code:

Jan  4 16:15:19 carrier postfix/qmgr[26679]: warning: connect to transport /var/spool/postfix/virtual/testuser/Maildir/: No such file or directory

Of course the directory exists, also tried chmodding the directory to 777 and changing ownership to postfix.postfix . Read somewhere on the web that it has something to do with Postfix being run in chroot, to which the following might help:

Code:

 if [ -e /var/spool/postfix/var/run/mysqld/mysqld.sock ]; then

  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

... but it didn't.

If someone here has this kind of configuration working, and might be able to help me, I'd be ever so thankfull! I can be reached at david.laporta@gmail.com or here in this thread.

Thanks in advance!

The howto on ISP type email describes in detail how you should go about this. It has probably been updated for Sarge.

Quote:

Originally Posted by TigerOC

The howto on ISP type email describes in detail how you should go about this. It has probably been updated for Sarge.

Thank you very much! I decided to start over again with my configuration because I couldn't find out where to start troubleshooting :) I'll use this manual now, hopefully I get it to work properly now.

Excellent, this worked beautifully! Now all I need is to get quote running through sql tables and all so I can add some maximum mailbox sizes :)