Hello,

My answers in your mail.
Regards.

Le lundi 05 octobre 2009 C  13:00 +0200, Joachim Schipper a C)crit :
quoted text
> 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.

If this is trying out to solve my problem by reading the doc and trying
various things by myself, yes I did this. The problem is that it's not
clear in my head how the things work together so it's very difficult for
me to understand what I should do. That's why I ask if someone has an
example of dovecot.conf wokring on openbsd with a mysql acocunt
database, in order to get it clearer how the config file is actually
written. Things are the error out of dovecot when I try to launch it
makes it not easy to understand where exactly is my problem.

quoted text
> 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

Ok. I tried the dovecot-sql-example.conf. Is that a mistake ?
If the password is a complete sentence, how to handle it ? with
password='password is yet another sentence' or maybe with "" ?
That's another point where I could not find much detailed answer to in
the Dovecot project documentation.

quoted text
> 	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