[Workaround.org] Dovecot can't connect to Mysql-Server

Gerret Geilich ggeilich at googlemail.com
Tue Mar 25 21:12:13 CET 2008


Am Dienstag, den 25.03.2008, 08:12 -0400 schrieb burt:
> Gerret Geilich wrote:
> >
> >
> > 2008/3/25, burt <be80be at gmail.com <mailto:be80be at gmail.com>>:
> >
> >     Gerret Geilich wrote:
> >     > Hy there,
> >     >
> >     > I just did the workaround for Postfix/Dovecot install and now I am
> >     > stuck in
> >     > the end of chapter 6.
> >     >
> >     > Everything worked fine, but when I start dovecot I get an error in
> >     > /var/log/mail.log :
> >     > 'dovecot: auth-worker(default): mysql: Connect failed to localhost
> >     > (mailserver): Access denied for user 'mailuser'@'localhost' (using
> >     > password: NO)'
> >     >
> >     > I think there's a problem with the MySQL-Connection or the
> >     > /etc/dovecot/dovecot-sql.conf.
> >     >
> >     > "the connect - string : 'connect = host=localhost dbname=mailserver
> >     > user=mailuser password=1234'"
> >     >
> >     > Any Idea ?
> >     >
> >     > Greetings and thanks
> >     >
> >     > G
> >     >
> >     >
> >     >
> >     ------------------------------------------------------------------------
> >     >
> >     > _______________________________________________
> >     > Workaround-chitchat mailing list
> >     > Workaround-chitchat at workaround.org
> >     <mailto:Workaround-chitchat at workaround.org>
> >     > http://workaround.org/cgi-bin/mailman/listinfo/workaround-chitchat
> >     >
> >     You didn't set a password for mailuser thats why it said
> >     > (using password: NO)'  you need to check your password for your
> >     > mailuser if you have mysql-admin you can use that to check the
> >     > password and make sure that  the dovecot-sql.conf is chown right
> >
> >     _______________________________________________
> >     Workaround-chitchat mailing list
> >     Workaround-chitchat at workaround.org
> >     <mailto:Workaround-chitchat at workaround.org>
> >     http://workaround.org/cgi-bin/mailman/listinfo/workaround-chitchat
> >
> >
> >
> > A Password for mailuser is set, login per console works fine,  
> > phpmyadmin,too.
> > Dovecot-sql.conf has 600 root:root.
> >
> >
> > You shouldnt put any thing in dovecot-sql.conf about passwords for 
> > mailuser it should be in postfix in mysql-virtual-alias-maps.cf  
> > mysql-virtual-mailbox-domains.cf mysql-virtual-mailbox-maps.cf 
> > mysql-email2email.cf
> >
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > Workaround-chitchat mailing list
> > Workaround-chitchat at workaround.org
> > http://workaround.org/cgi-bin/mailman/listinfo/workaround-chitchat
> >   
> 
> _______________________________________________
> Workaround-chitchat mailing list
> Workaround-chitchat at workaround.org
> http://workaround.org/cgi-bin/mailman/listinfo/workaround-chitchat

Thanks for the hint, but in the workaround I have to change the
dovecot-sql.conf settings like this :

driver = mysql
connect = host=127.0.0.1 dbname=mailserver user=mailuser password=mailuser2007
default_pass_scheme = PLAIN-MD5
password_query = SELECT email as user, password FROM view_users WHERE email='%u'; 

Do you think this will try a double login ??



More information about the Workaround-chitchat mailing list