similar to: dovecot + mysql

Hi, I've done some supplementary tests with tcpdump. Apparently, with a login containing the % character, there's no query send to MySQL. Do you know if the % character is filtered by dovecot ? Thanks -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://dovecot.org/pipermail/dovecot/attachments/20050112/03106298/attachment-0002.html>

Is there some limit for the maximum length of the line in dovecot-sql.conf? In particular, I would be writing a long MySQL password query. And further, can a long line be somehow split to several pieces? I tried the common unix-style way of putting backslash as the last character of the first line, but it results in an error immediatedly while restarting Dovecot (while parsing the conf, ie. not a

Hi All, I am using Dovecot 1.0.13 with Vpopmail (Qmail Toaster current) backed by MySQL with one table per domain (--disable-many-domains) . What I cannot figure out is how to have Dovecot authenticate to Vpopmail when Vpopmail uses one table per domain. Basically I need dynamic SQL in the Dovecot-sql.conf file. Currently I have: password_query = select pw_clear_passwd as password from

Hi everybody , Since my version 1.2. I have a problem with the management of quotas. select * from virtual_users; +----+-----------+----------------------------------+---------------------------+----------+----------------+ | id | domain_id | password | email | quota_kb | quota_messages |

Hi, after deciding to use Dovecot 2.0.8 as a postfix LDA using mysql DB I'm running into some issues. I started to follow, http://wiki.dovecot.org/HowTo/DovecotLDAPostfixAdminMySQL but noticed that the auth settings on the config changed, after looking through the dovecot wiki I think I have that issue fixed. However I still can't get the SQL part to work right, below is what I have on the

Hi all, I installed the Dovecot on a Debian by apt-get, it's all working except quota by user.. I have a database with all quotas in bytes, and that lines in /etc/dovecot/dovecot-sql.conf : driver = mysql connect = host=127.0.0.1 dbname=mailserver user=USER password=PASS default_pass_scheme = CRYPT password_query = SELECT email as user, password FROM view_users WHERE email='%u';

I am trying to make a mail server with Postfix using the Dovecot software. At the time of wanting to access my server from a mail client, it does not let me access and see the logs of my server with the command: $ service dovecot status with the following error: dovecot: auth-worker(2769): Error: mysql(127.0.0.1): Connect failed to database (postfix): Access denied for user

SoI had a hell of a time converting my qmail install to dovecot 2.0.5, so I thought I'd pass on what I learned. 1. When using vpopmail, do not use " --disable-many-domains". If you do, you'll need to recompile vpopmail without that setting and use the script found at http://qmailrocks.thibs.com/downloads/scripts/migrate-vpopmail-many-domains to collapse the tables. 2.

Hello- Sorry if this is a noob question, but I cant seem to get my password_query to work with dovecot + mysql. Im using 'Password verification by SQL server' at: http://wiki2.dovecot.org/AuthDatabase/SQL trying to modify it to work with my encrypted passwords in the DB. Im using the following which isnt working: password_query = SELECT NULL AS password, \ 'Y' as

Hi, Thanks. That query doesn't return any parse errors but it does say that it can't save the password. Any ideas? Thanks. Dave. On 3/10/18, David Mehler <dave.mehler at gmail.com> wrote: > Hello, > > Thanks. Trying that query adapted to my database table and getting an > error can not save password, any ideas? > > When you made your initial database tables how

I have dovecot setup and authenticating away for local users, but when I try to add MySQL users from postfix admin, not only does that fail, but all authentication fails. This configuration does not work: doveconf -n # 2.2.5: /usr/local/etc/dovecot/dovecot.conf # OS: FreeBSD 9.1-RELEASE i386 namespace inbox { inbox = yes location = mailbox Drafts { special_use = \Drafts }

Hi. I've just compiled dovecot-1.0.alpha5 with mysql support.from freebsd ports (FreeBSD 6.0-RELEASE). It looks like dovecot has problems connecting to mysql. In the log I'm getting: dovecot: Feb 24 16:57:41 Error: auth-worker(default): mysql: Connect failed to (null) (exim): Access denied for user 'root'@'localhost' (using password: YES) - waiting for 5 seconds before

Hi all, I'm setting up a new email server based on the softwares list below: * Postfix * Dovecot 2.0.9 * MySQL * Postfixadmin 2.3.6 My current problem is I'm unsure whether quota feature is well configured or not. In order to test and validate, I use Roundcubemail GUI which provides percentage of the space used by the mailbox (quota should be applied per mailbox). Here, my

Hi there, I have a postfix/postfixadmin/mysql/dovecot install that was using 'virtual' for the LDA. I tried the 'dovecot' LDA to enable Sieve but ran into trouble with aliases. With domain "some-domain.com" being an alias to "somedomain.com", mail sent to *@somedomain.com would be delivered to the Maildir fine, but the 'dovecot' LDA tossed

Hello all: I understand I can't provide to much information; at the moment, I do not have dovecot installed. Here is the problem. I started out running saslauthd, but there appears to be a problem where memory isn't freed after someone fails to authenticate, which leads to a huge dos attack. I hit this problem a couple of times, and it looks like some poor lonely soul (or bot, as it

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

I'm trying to setup dovecot to use my postfixadmin user accounts on an ubuntu server. dovecot versions: dovecot-common 1.0.beta3-3ubuntu5.3 dovecot-imapd 1.0.beta3-3ubuntu5.3 I have gotten the account up and I can see dovecot query for the password for the user, but I get login failed. In my mail.log I only see this: dovecot: imap-login: Aborted login: user=<user at

================== DOVECOT.CONF ===================== # 1.2.8: /usr/local/etc/dovecot.conf # OS: FreeBSD 8.0-STABLE i386 ufs log_path: /var/log/dovecot-error.log info_log_path: /var/log/dovecot.log protocols: imap imaps pop3 pop3s ssl_cert_file: /etc/ssl/dovecot/cert.pem ssl_key_file: /etc/ssl/dovecot/key.pem disable_plaintext_auth: no login_dir: /var/run/dovecot/login login_executable(default):

Hey there guys. I have successful postfix + mysql + sagator + clamav + spamassassin + dovecot setup (it was a really crazy month full of tweaking :]) and the only thing i miss is some per maildir specific filtering. i decided to use sieve. everything is fine except that dovecot's deliver process doesn't see the actual .dovecot.sieve file with filtering rules in the root of a maildir.

Hi everyone, since some time I got problems with dovecot & mysql. I got the problem with version 2.0.x and upgraded to 2.1.7 to check if its gone. But its not :( The logs just tell me this: dovecot: auth: Error: auth worker: Aborted request: Worker process died unexpectedly If I change to a sqlite setup, everything works fine. Here are some informations. I hope someone can tell me whats