[Dovecot] problems connecting to the Problems connecting to mysql

[Alfonso Fernandez]

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