[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