On Mon, Oct 05, 2009 at 12:25:25PM +0200, jean-francois wrote:
> Le lundi 05 octobre 2009 ` 01:57 +0200, Joachim Schipper a icrit :
> > On Sun, Oct 04, 2009 at 10:25:07PM +0200, jean-francois wrote:
> > > (...) I am having difficulties with dovecot and mysql. [MySQL
> > > works.]
> > >
> > > I could not make a correct config file of dovecot, it simply makes fatal
> > > error at the time I try to start Dovecot.
> > >
> > > If someone has properly configured dovecot.conf with running along with
> > > mysql as accounts database, would the file be sent to me as an example
> > > or some help be given please ?
> >
> > (...) Do you have the -mysql flavour
> > installed?
> >
> > You are likely to get more useful responses if you can post the output
> > of Dovecot. This can typically be found in /var/log/maillog.
>
> Yes I do. It is just a matter of making the conf file correct.
>
> The BD by itself works but dovecote states different kind of crash at
> starting.
>
> My problem is that I can't find how to properly set the conf file for
> working with MySQL. I try to but it does'nt work.
>
> The mail list in Dovecot did not answer to that problem yet - I assume
> working the conf file for openbsd is quite special.
I'm sorry, but you give no indication at all of having done your
homework and basically refuse to make it possible to help you.
You should most likely use "userdb passwd-file" "passdb passwd-file".
You can almost certainly manage your list of users by hand or with a
small script.
If you do want to use SQL, install dovecot-mysql, look at
dovecot-example.conf, enable "userdb prefetch" and "passdb sql", disable
all other userdb/passdb entries, and look at dovecot-sql-example.conf.
Create a MySQL user and table as suggested at the top of that file and
put the line
connect = host=127.0.0.1,table=<table>,user=<user>,password=<pass>
somewhere in that file. Use the example password_query. Things should
now work.
Joachim
