Hello, My answers in your mail. Regards.
Le lundi 05 octobre 2009 C 13:00 +0200, Joachim Schipper a C)crit : > 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. > 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. > 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
