dovecot - Dec 2005 - problems connecting to the Problems connecting to mysql

Hi,

I'm trying to setup a mailserver running postfix and dovecot with mysql
as database backend. Postfix is already running and delivers mails just
fine. Unfortunately, dovecot has great problems connecting to the
database (using username + password).

Found that two threads about the same issue but none of them solves the
problem

http://dovecot.org/list/dovecot/2005-April/006770.html
http://dovecot.org/list/dovecot/2005-August/008394.html

I am using:
dovecot-1.0.alpha5
mysql 5.0.17-1

Please, can anyone help?
Thanks in advance,

Alfonso
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://dovecot.org/pipermail/dovecot/attachments/20051230/2fc26a04/attachment.html

On Fri, 2005-12-30 at 20:30 +0100, Alfonso Fern?ndez V?zquez
wrote:
> I'm trying to setup a mailserver running postfix and dovecot with
> mysql
> as database backend. Postfix is already running and delivers mails
> just
> fine. Unfortunately, dovecot has great problems connecting to the
> database (using username + password).
http://wiki.dovecot.org/MysqlProblems

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url :
http://dovecot.org/pipermail/dovecot/attachments/20051230/f73c4931/attachment.pgp

Thanks Timo, everything works fine for me now.

But I'm not sure this is true: "MySQL changed PASSWORD() format on 4.1 
server but it seems that C

API library still uses old password format"

because the little program below connects to the database using the new
PASSWORD() format.
So I think it has to be something related to dovecot itself.

#include <mysql.h>
#include <stdio.h>

int main()
{
 MYSQL mysql;
 mysql_init(&mysql);
 if
(mysql_real_connect(&mysql,"localhost","postfixuser","xxxxxx","postfix",0,NULL,0)
== NULL)
    fprintf(stderr, "Failed to connect to database: Error: %s\n",
mysql_error(&mysql));
 else
    fprintf(stderr, "Connected to database\n");
}

gcc p.c -I/usr/include/mysql -lmysqlclient




Timo Sirainen escribi?:
>On Fri, 2005-12-30 at 20:30 +0100, Alfonso Fern?ndez V?zquez wrote:
>  
>
>>I'm trying to setup a mailserver running postfix and dovecot with
>>mysql
>>as database backend. Postfix is already running and delivers mails
>>just
>>fine. Unfortunately, dovecot has great problems connecting to the
>>database (using username + password).
>>    
>>
>
>http://wiki.dovecot.org/MysqlProblems
>
>  
>