similar to: DOVECOT+SQLITE

Hi everyone, i used postfix, dovecot and mysql. I have virtual users and domains. I have this configuration in dovecot-mysql.conf: db_host = localhost db_port = 3306 db_unix_socket = /var/run/mysqld/mysqld.sock db = postfix db_user = postfix db_passwd = bscidth46 db_client_flags = 0 default_pass_scheme = CRYPT password_query = SELECT password FROM mailbox WHERE username = '%u' user_query

Hi, I configured dovecot IMAP for MySQL authentification. --- start dovecot.conf --- auth_userdb = mysql /etc/dovecot/dovecot-mysql.conf auth_passdb = mysql /etc/dovecot/dovecot-mysql.conf --- end dovecot.conf --- --- start dovecot-mysql.conf --- db_host = localhost db_port = 3306 db_unix_socket = /var/run/mysqld/mysqld.sock db = users db_user = users db_passwd = xxx db_client_flags = 0

I get the following error on auth with mysql on pop3 what am i missing or doing wrong mysql config file db_host = localhost #db_port = 3306 db_unix_socket = /var/lib/mysql/mysql.sock db = ADMIN db_user = mailmaster db_passwd = ******** db_client_flags = 0 default_pass_scheme = PLAIN password_query = SELECT MAILBOX_PASSWORD AS password FROM MAIL WHERE MAILBOX_USERNAME = '%n' AND

Hi all, i installed Dovecot 0.99.14. Everything works fine except that the mysql setup directive "user_query" seems to be ignored - however the password_query works. Instead the default user query in db-mysql.c always takes effect. Might this be a bug or is something worng wit my setup below? (To keep on working i changed the default query in db-mysql.c..) Helmut

System: Redhat AS3 postfix 2.2.5 cyrus-sasl 2.1.15 pam-mysql 0.6 dovecot 0.99.14 ( compile from source tarball) The same email account and machine, using thunderbird 1.06 to get email thru dovecot pop3, it returned "Mail Server does not support secure authentication" But in outlook express , there is no such problem I have tested SASL thru pam-mysql is work properly before install

Hi, I'm running a mixed Debian Woody/Sarge system with Dovecot version: (0.99.12-1) I can't seem to be able to get dovecot working with mysql. It seems to authenticate successfully then crash. This happens when I use the Debian package and also when I've compiled from source. dovecot: Jan 06 12:21:14 Info: Dovecot starting up dovecot-auth: Jan 06 12:21:15 Info: MySQL: connected to

Dear , Dovecot List ( Everyone ) I have some problem about dovecot/postfix/mysql Would u like to tell me about the solution ? sir Thank you very much for advance. Sir Best Regards, Pratchaya ================================== ================================== ================================== This is my problem/error sir 1. ERROR = "" A NO

Hi list, i use dovecot-1.0-1.2.rc15.el5 installed from rpm centos 5.0 I cant get mysql authetication working: this is my /etc/dove-mysql.conf ######dove-mysql.conf should look like this########## #db_host = 127.0.0.1 #db_port = 3306 db = postfix db_user = postfix db_passwd = secret db_client_flags = 0 default_pass_scheme = PLAIN password_query = SELECT password FROM mailbox WHERE username

Hi List. I've got a dovecot running with mysql. All my users data are there. But I intend to use MD5 instead of clear passwords at MySQL. Someone can help-me? []s; Andrey Here's my dovecot-mysql.conf: # Dovecot queries db_host = localhost db_unix_socket = /var/lib/mysql/mysql.sock db_port = 3306 db = mail db_user = my_conn_user db_passwd = my_conn_passwd # # Pehapes i need to

I would like to use SQLRelay for database connection pooling and query- based routing with a Rails application that I am just about done with. It is my first Rails project, and I thought it might be wise to get some feedback on this before I get too far in coding it. >From what I can tell, I am going to have to write a connection adapter for ActiveRecord if I want to use SQLRelay (http://

Hello all.. I'm trying to configure dovecot do athenticate using mysql, but I?m having some troubles... After configuring the mysql athentication in dovecot-mysql.conf and in dovecot.conf, when I try to login I get this mesage in my logs: Dovecot-auth: MySQL: Can't connect to database dovecot: Can't connect to local MySQL server through socket '/var/tmp/mysql.sock' (2)

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

I use dovecot-0.99.11 from RHEL4. dovecot-mysql.conf: === db_host = dbhost db_port = 3306 db = db db_user = dovecot db_passwd = pass default_pass_scheme = PLAIN password_query = SELECT password FROM users WHERE username = '%u' user_query = select maildir AS home,u_id AS uid,g_id AS gid from users WHERE username = '%u' === When I try "telnet localhost 110" and enter

Is possible works with sqlrelay -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://dovecot.org/pipermail/dovecot/attachments/20060411/03026f39/attachment.html>

Hi all, I've just configured Dovecot as my IMAP server in my Ubuntu machine. Everything works fine: I can access my IMAP folders remotely, I have also installed Squirrel webmail to access it thru the web... Although I'm most of the time working with Ubuntu, sometimes I boot my machine with Windows XP. However, since the server is not running then (because I'm not running

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#ffffff" text="#000000"> <pre>Hi, &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspI'm running Dovecot v.

Hi, I''d like to use migrations to build my initial database. Is there a gem or plugin that will generate the migration code for initial db if I point it at a live database or sql file? If yes, then can you automatically generate the incremental migrations as well? Thanks, Jason

Hi, I think, there is missing constructor function supporting remote writing for XapianWritableDatabase class in the php bindings (0.9.7). This code: $db = new XapianWritableDatabase(remote_open($db_host, $db_port), $action); returns: Fatal error: No matching function for overloaded 'new_XapianWritableDatabase' (...) $db = new XapianWritableDatabase($path, $action); works fine.

I've been playing around with Dovecot for the past few months for testing (on a Debian 3.0 system), and initially it was easy to setup and worked well. Recently I upgraded to 0.99.10.9, and when I rebuilt it I enabled MySQL and SSL. The first problem I ran into was upon startup it complained that there was no certificate, which makes sense, except that I hadn't enabled imaps in the

I have a module as shown below and when I extend an active record to use it, I can not access the primary_key method. In a simple test program using a similar approach where active record is not involved, access to the class methods seems to work ok. What can I do to make this work or so that I can access the class methods ? ################################## require