Re: Updated mysql - dovecot fails

On [DATE], "[NAME]" <[ADDRESS]> wrote:

> 
> 
> On Mon, Sep 7, 2009 at 8:54 PM, Andreas Westvik <[email protected]>
> wrote:
>> Yesterday I ran a full update using apt-get update and such. Now I got the
>> option to update dovecot, but I believe that I choosed to leave the conf like
>> before. But Im sure mysql got updated. Now, dovecot cannot connect to the
>> mysql server.
>> I thought that mysql would give me minimal with problems but..
>> (The rest of my stuff thats using mysql is working as normal, IE websites and
>> such) 
>> This is what the logs are telling me:
>> 
>> ==> /var/log/dovecot.log <==
>> dovecot: Sep 06 12:52:48 Info: IMAP([email protected] <http://[email protected]>
>> ): Disconnected: Logged out bytes=350/1001
>> dovecot: Sep 06 12:52:48 Info: IMAP([email protected] <http://[email protected]>
>> ): Disconnected: Logged out bytes=115/973
>> dovecot: Sep 06 12:52:48 Info: IMAP([email protected] <http://[email protected]>
>> ): Disconnected: Logged out bytes=875/4761
>> dovecot: Sep 06 13:40:49 Warning: Killed with signal 15
>> dovecot: Sep 06 13:40:50 Info: dovecot v1.1.16 starting up (core dumps
>> disabled)
>> dovecot: Sep 06 13:40:50 Error: auth-worker(default): mysql: Connect failed
>> to localhost (vexim): Can't connect to local MySQL server through socket
>> '/var/run/mysqld/mysqld.sock' (2) - waiting for 1 seconds before retry
>> dovecot: Sep 06 13:40:50 Warning: Killed with signal 15
>> dovecot: Sep 06 13:40:50 Info: dovecot v1.1.16 starting up (core dumps
>> disabled)
>> dovecot: Sep 06 13:40:50 Error: auth-worker(default): mysql: Connect failed
>> to localhost (vexim): Can't connect to local MySQL server through socket
>> '/var/run/mysqld/mysqld.sock' (2) - waiting for 1 seconds before retry
>> dovecot: Sep 06 13:40:51 Warning: Killed with signal 15
>> 
> 
> Is mysqld running? Can you login manually to the database?
>  
> *The rest of my stuff thats using mysql is working as normal, IE websites and
> such* <== what is this? :-)
> 
> Websites that require mysql to work, thats what it means:) And I can log into
> the vexim webinterface, add users and such. So I guess its dovecot that fails
> to login. I can log into phpmyadmin as well. No troubles there.
> 
> ps aux | grep mysql
> 
> root     15499  0.0  0.0   1848   528 ?        S    Sep06   0:00 /bin/sh
> /usr/bin/mysqld_safe
> mysql    15613  0.0  2.9 131704 31016 ?        Sl   Sep06   0:28
> /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql
> --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock
> --port=3306
> root     15614  0.0  0.0   3060   608 ?        S    Sep06   0:00 logger -t
> mysqld -p daemon.error
> root     29826  0.0  0.0   3188   744 pts/0    S+   21:49   0:00 grep mysql
> 
> dovecot-sql.conf (if necessary)
> driver = mysql
> connect = host=localhost dbname=vexim user=vexim password=mypasswd
> default_pass_scheme = PLAIN
> password_query = SELECT clear AS password FROM users,domains WHERE
> users.username = '%u' AND users.enabled = '1' AND users.type='local' and
> domains.enabled='1' and domains.domain_id = users.domain_id
> user_query = SELECT pop as home, uid, gid FROM users WHERE username = '%u'
>

_______________________________________________
Vexim mailing list
[email protected]
http://silverwraith.com/mailman/listinfo/vexim