[Dovecot] auth_passdb using MySQL fails at starup
Josh Joslyn
josh at joslyn.com
Sun Aug 7 01:46:19 EEST 2005
I've got dovecot v0.99.14, MySql 4.1.11 and postfix on fedora core 4.
when using uxix socket I get:
dovecot-auth: MySQL: Can't connect to database vmail: Can't connect to
local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
when using tcp socket I get:
dovecot-auth: MySQL: Can't connect to database vmail: Can't create
TCP/IP socket (13)
* the mysql.sock exists
* I can connect to mysql -u vmail and select on the table mailbox
* I can run mysqladmin successfully using the port or the socket
As you can see below I modified the password query to be very simple.
I am surprised to get the error on startup since the password query
should not be executed at this point.
The problem is not MySql as I am able to query all day long the the
vmail database table called mailbox with the vmail user.
Not sure what else I can check
Dovecot error message lacks the reason it can not connect - unless the
(13) means anything to anybody???
Anybody have any ideas???
dovecot.conf :
.
auth_assdb = mysql /etc/dovecot-mysql.conf
dovecot-mysql.conf :
db_host = localhost
db_unix_socket = /var/lib/mysql/mysql.sock
#db_port = 3306
db = vmail
db_user = vmail
db_passdb = temp
password_query = SELECT 'test' as password from mailbox
vmail.sql:
create database vmail;
use vmail;
grant insert,select,update,delete on vmail.* to 'vmail'@'localhost'
identified by 'temp';
CREATE TABLE mailbox (
user varchar(20) not null,
domain varchar(30) not null,
password varchar(20) not null,
status char,
PRIMARY KEY (user,domain)
);
insert into mailbox values('someone', 'domain.org', 'secret',
'Y');
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://dovecot.org/pipermail/dovecot/attachments/20050806/ce0a76c9/attachment.htm
More information about the dovecot
mailing list