CentOS - Jun 2012 - Error dovecot restart

Dear all,

i have a problem when install dovecot on CentOS 5, below my configuration

[root at mail home]# vim /etc/dovecot-sql.conf
driver = mysql
connect = host = localhost dbname=postfix user=mail password=password
default_pass_scheme = PLAIN
password_query = SELECT password FROM mailbox WHERE username = '%u'

[root at mail home]# vim /etc/dovecot.conf
log_path = /var/log/dovecot.log
auth_username_format = %Lu

passdb sql {
args = /etc/dovecot-sql.conf
}

userdb static {
args = uid=501 gid=501 home=/home/vmail/%d/%n
}

[root at mail home]# service dovecot restart
Stopping Dovecot Imap:                                     [FAILED]
Starting Dovecot Imap: Error: Can't write to log directory /var/log:
Permission denied
Fatal: Invalid configuration in /etc/dovecot.conf
                                                           [FAILED]

i have try searching but i don't see step fix it,

-- 
http://mafatahna.web.id

> man touch
> man chmod
> man chown
file has ready, chmod use 755 and chown use vmail, this below :

[root at mail ~]# ls -la /etc/dovecot*
-rwxr-xr-x 1 vmail vmail 42989 Jun 11 17:08 /etc/dovecot.conf
-rwxr-xr-x 1 vmail vmail   181 Jun 11 15:27 /etc/dovecot-sql.conf
[root at mail ~]#

[root at mail ~]# ls -la /var/log/dovecot.log
-rwxr-xr-x 1 vmail vmail 1180 Jun 11 16:42 /var/log/dovecot.log
[root at mail ~]#

there is something wrong on my configuration

-- 
http://mafatahna.web.id

On 6/11/12 10:05 AM, Muhammad A. Fatahna wrote:
> Dear all,
>
> i have a problem when install dovecot on CentOS 5, below my configuration
>
> [root at mail home]# vim /etc/dovecot-sql.conf
> driver = mysql
> connect = host = localhost dbname=postfix user=mail password=password
> default_pass_scheme = PLAIN
> password_query = SELECT password FROM mailbox WHERE username = '%u'
>
> [root at mail home]# vim /etc/dovecot.conf
> log_path = /var/log/dovecot.log
> auth_username_format = %Lu
>
> passdb sql {
> args = /etc/dovecot-sql.conf
> }
>
> userdb static {
> args = uid=501 gid=501 home=/home/vmail/%d/%n
> }
>
> [root at mail home]# service dovecot restart
> Stopping Dovecot Imap:                                     [FAILED]
> Starting Dovecot Imap: Error: Can't write to log directory /var/log:
> Permission denied
> Fatal: Invalid configuration in /etc/dovecot.conf
>                                                             [FAILED]
>
> i have try searching but i don't see step fix it,
Hi, it seems that you want to read user & pass info from the MySQL DBMS.
Problem 1 seems to be permission issue, since it cannot write.
Problem 2 is misconfiguration related mysql with dovecot. SEE RED TEXT
because it is working, i have the following in "/etc/dovecot.conf" and
"/etc/dovecot-sql.conf", that concern to authentication. Either you
have
not provided the full information or cross check your configuration. 
configuration is missing that i feel.


*" /etc/dovecot.conf"*
> passdb sql {
>          args = etc/dovecot-sql.conf
>    }
>
> userdb sql {
>          args = /etc/dovecot-sql.conf
> }
*## Authentication processes*

auth_username_chars = 
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ01234567890.-_@
auth default {
mechanisms = plain login

passdb sql {
         args = /usr/local/etc/dovecot-sql.conf
   }

userdb sql {
         args = /usr/local/etc/dovecot-sql.conf
}
*

" /etc/dovecot-sql.conf"*

driver = mysql
connect = host=localhost dbname=postfix user=postfix password=your_pass_word
default_pass_scheme = MD5
password_query = SELECT password FROM mailbox WHERE username = '%u'
*user_query *= SELECT maildir, 125 AS uid, 125 AS gid, 
CONCAT('*:messages=10000:bytes=', quota) AS quota_rule FROM mailbox 
WHERE username = '%u' AND active = '1'