LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 12-26-2007, 01:24 AM   #1
csdhiman
Member
 
Registered: Mar 2007
Posts: 47

Rep: Reputation: 15
postfix mysql dovecot


I am using Fedora 4 for postfix + mysql + dovecot setup
I done the postfix+mysql settings, but there is problem in dovecot settings

my database structure is
-------------+---------+----------+------------------------------------
| username | passwd | domain | uid | gid | maildrop | pppuser |+----------+--------+--------------+-----+------+-------+----------+-------+----
| test | test123 | test.com | 1 | 0 | /var/spool/mail |abhina |+----------+--------+--------------+-----+------+-------+----------+-------+----

i want to fetch mail threw dovecot . for this i did
/etc/dovecot.conf
auth_userdb = mysql /etc/dovecot-mysql.conf
auth_passdb = mysql /etc/dovecot-mysql.conf
first_valid_uid = 500
default_mail_env = mbox:/var/spool/mail/:INDEX=/var/indexes/%u

/etc/dovecot-mysql.conf
db_host = 127.0.0.1
db_port = 3306
db = sendmail
db_user = csdhiman
db_passwd = csdhiman
db_client_flags = 0
default_pass_scheme = PLAIN
password_query = SELECT passwd FROM users WHERE username = '%u'
user_query = SELECT maildrop, 500 AS uid, 500 AS gid FROM users WHERE username = '%u'

I can authenticate my passwords but cannt download mails
Please check for changes ....
 
Old 12-26-2007, 06:27 PM   #2
pljvaldez
Guru
 
Registered: Dec 2005
Location: Somewhere on the String
Distribution: Debian Squeeze (x86)
Posts: 6,092

Rep: Reputation: 269Reputation: 269Reputation: 269
I'm not an expert at any of this, but it seems like your database has a UID of "1" and your dovecot settings all say valid UID's need to be 500 or greater.
 
Old 10-03-2009, 12:26 PM   #3
avandenbroeck
LQ Newbie
 
Registered: May 2008
Posts: 8

Rep: Reputation: 1
Quote:
Originally Posted by csdhiman View Post
I am using Fedora 4 for postfix + mysql + dovecot setup
I done the postfix+mysql settings, but there is problem in dovecot settings

my database structure is
-------------+---------+----------+------------------------------------
| username | passwd | domain | uid | gid | maildrop | pppuser |+----------+--------+--------------+-----+------+-------+----------+-------+----
| test | test123 | test.com | 1 | 0 | /var/spool/mail |abhina |+----------+--------+--------------+-----+------+-------+----------+-------+----

i want to fetch mail threw dovecot . for this i did
/etc/dovecot.conf
auth_userdb = mysql /etc/dovecot-mysql.conf
auth_passdb = mysql /etc/dovecot-mysql.conf
first_valid_uid = 500
default_mail_env = mbox:/var/spool/mail/:INDEX=/var/indexes/%u

/etc/dovecot-mysql.conf
db_host = 127.0.0.1
db_port = 3306
db = sendmail
db_user = csdhiman
db_passwd = csdhiman
db_client_flags = 0
default_pass_scheme = PLAIN
password_query = SELECT passwd FROM users WHERE username = '%u'
user_query = SELECT maildrop, 500 AS uid, 500 AS gid FROM users WHERE username = '%u'

I can authenticate my passwords but cannt download mails
Please check for changes ....
I got the same problem, were you able to solve your?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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
postfix + mysql + dovecot (not reciving email) btaylor1988 Linux - Server 17 05-31-2007 05:59 AM
Guide for postfix/dovecot/mysql authentication gnetcon Linux - Software 2 10-30-2006 08:11 AM
Etch Horde Postfix Dovecot MySQL grant-skywalker Debian 0 08-05-2006 02:04 PM
postfix dovecot mysql permissions issue gnetcon Linux - Software 4 08-03-2006 11:05 AM
mysql, postfix, dovecot & spamassassin dadams Fedora 1 10-18-2004 08:40 PM


All times are GMT -5. The time now is 12:23 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration