LinuxQuestions.org
Visit Jeremy's Blog.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Debian
User Name
Password
Debian This forum is for the discussion of Debian Linux.

Notices


Reply
  Search this Thread
Old 01-04-2006, 09:25 AM   #1
MangaManiac
LQ Newbie
 
Registered: Jun 2004
Location: The Netherlands
Distribution: Debian 3.0/3.1, Red Hat AS, FreeBSD, Solaris
Posts: 21

Rep: Reputation: 15
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!
 
Old 01-04-2006, 12:02 PM   #2
TigerOC
Senior Member
 
Registered: Jan 2003
Location: Devon, UK
Distribution: Debian Etc/kernel 2.6.18-4K7
Posts: 2,380

Rep: Reputation: 49
The howto on ISP type email describes in detail how you should go about this. It has probably been updated for Sarge.
 
Old 01-05-2006, 05:13 AM   #3
MangaManiac
LQ Newbie
 
Registered: Jun 2004
Location: The Netherlands
Distribution: Debian 3.0/3.1, Red Hat AS, FreeBSD, Solaris
Posts: 21

Original Poster
Rep: Reputation: 15
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.
 
Old 01-13-2006, 03:00 AM   #4
MangaManiac
LQ Newbie
 
Registered: Jun 2004
Location: The Netherlands
Distribution: Debian 3.0/3.1, Red Hat AS, FreeBSD, Solaris
Posts: 21

Original Poster
Rep: Reputation: 15
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
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
connecting to a MySQL database hsa Linux - General 3 09-16-2005 06:34 AM
probs with connecting to mysql database using php ankscorek Linux - Software 4 08-16-2005 07:40 PM
Integrate postfix with existing MySQL database EdMeister Linux - Software 0 04-21-2005 04:52 AM
connecting to MYSQL remote database opsraja Linux - Software 1 02-18-2005 05:52 AM
Connecting Mysql Database on remote server akamol Programming 4 10-16-2003 11:46 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Debian

All times are GMT -5. The time now is 10:20 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration