similar to: dovecot last logged in via sql

I tried to set a quota setting. I installed dovecot with newest version, patched it and started it. dovecot -n: # 1.2.15: /etc/dovecot/dovecot.conf # OS: Linux 2.6.32-5-amd64 x86_64 Debian 6.0.3 ext4 log_timestamp: %Y-%m-%d %H:%M:%S protocols: imap imaps pop3 pop3s ssl_listen: 143 ssl_cipher_list: ALL:!LOW:!SSLv2 disable_plaintext_auth: no login_dir: /var/run/dovecot/login

Hi, I am working through setting up a virtual hosting system using Dovecot, Postfix and Postgres on a CentOS 5 box running an install of the dovecot-1.0-1.2.rc15.el5 RPM. The question I have is, given this password_query SELECT clause, which all return valid values from the database: user password domain can I use a %d in the WHERE clause of my user_query? The reason I ask is that the

Hello Everyone, First wanted to say thanks for any help in advance. I have a clustered mail system each running on centos 5.2. I have a test box that I am running the newest version on dovecot on and I am getting some random authnication failed errors. Here is the error below: Nov 04 17:31:22 auth(default): Error: worker-server(xxx at xxxx.com): Aborted: Lookup timed out Nov 04 17:31:23

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 |

In order to deal with case-sensitive issues, I am thinking to use the variable %L (adding it to my current configs --as suggested before by other users in this list) in the configuration files in this way: In Dovecot.conf: mail_location = maildir:/vmail/%Ld/%Ln/Maildir:INDEX=/indexes/%Ld/%Ln auth default: username_format: %Lu passdb: driver: sql args:

No support help needed, just a success report having Dovecot integrate with Vexim (exim with web based frontend and sql db): http://silverwraith.com/vexim/ Just wanted to forward some configs to the list if anyone finds them useful. I just switched from vexim's normal "virtual_delivery" to "dovecot_virtual_delivery" so I could use sieve, which works nicely with

Hi I have been attempting to do a mapping on the last_logon plugin. I have been reading the documentation on mapping. is there any way to customise a little more and create a individual SQL query for each of the functions SELECT and UPDATE, my current SQL setup has the username and domain in separate tables and my user_query and password_query are concat which I do not believe can be defined

This just isn't working for me. I've tried everything. Trailing the logs with debug and vebose... we connect fine === Oct 15 22:51:35 rsrr1 dovecot: Killed with signal 15 Oct 15 22:51:37 rsrr1 dovecot: Dovecot v1.0.alpha3 starting up Oct 15 22:51:38 rsrr1 dovecot: auth(default): pgsql: Connected to vmail === and then we die: === Oct 15 23:02:07

Thank you for your reply. So, you mean that both user_query and password_query should have the same amount of parameter and the mail parameter from user_query should have the exact parameter as userdb_mail from password_query? And also I've to turn on userdb prefetch {} Kind Regards, Henry From: Timo Sirainen [mailto:tss at iki.fi] To: Dovecot Mailing List [mailto:dovecot at dovecot.org]

Hello, I'm trying to setup a dovecot imap server. version is 2.0.9 I've setup a mysql database using: user_query = \ SELECT home, uid, gid, home as userdb_home, uid as userdb_uid, gid as userdb_gid, \ FROM user WHERE username = '%n' AND domain = '%d' AND active = 'Y' password_query = \ SELECT username AS user, password, home as userdb_home, uid as

I upgraded to 1.0a3 - i have everything in the config migrated over, but I'm unsure about the way i should be querying postgres my db handles virtual accounts only, and is set as such: CREATE TABLE accounts ( local_part VARCHAR(64) NOT NULL, domain VARCHAR(64) NOT NULL, password VARCHAR(64) NULL, home_dir VARCHAR(256) NOT NULL, uid INTEGER DEFAULT

Hi. I'm using dovecot 1.1.14 with pgsql. I tried to configure dovecot to get the domain part in user_query by specifying different variants of auth_username_format variable such as %Lu, %Lu@%Ld, %Lu-at-%Ld and so on... So dovecot gets domain part in password_query, but not in user_query. I noticed the username is changed like this: kostas at mgupb.net->kostas in log. For some reason it

For many years I had the following in my dovecot.conf: userdb { args = /usr/local/etc/dovecot/dovecot-sql.conf.ext default_fields = uid=vpopmail gid=vchkpw mail_location=/usr/local/virtual/%u/Maildir mail=maildir:/usr/local/virtual/%u/Maildir driver = sql } Recently, I started having quite a lot of errors on one MySQL account (used as a bcc backup account) along the lines of Fatal:

I'm trying to setup a new server on centos 6, from old dovecot 1.x I installed 'dovecot --version 2.1.1' from dovecot rpm I converted conf file as per migration specs, also, copied sql conf across when I try to retrieve email, log has *1: dovecot.conf -m *2 and sql conf *3 follows *1------------------------------- dovecot: master: Dovecot v2.1.1 starting up (core dumps disabled)

Hello, I have two installations of dovecot configured to replicate mailboxes between them. recently, i upgraded the operating system on one of them (mx2.example.com) and now i'm running one installation on version 2.2.27 (debian stretch) and another on version 2.3.4.1 (mx1.example.com debian buster). My setup includes 3 shared namespaces that point to the mailboxes of 3 accounts. these

Hello, I have a problem :(... I try to define User Quotas in Dovecot (in my DB mySQL) but default quotas (in my dovecot.conf) are always set for all users. I've defined default quota to 500M. I set 0 to one account in my DB but when i see my logs, this account have a 500M quota ! Could you help me ? My configuration : # 1.2.11: /etc/dovecot/dovecot.conf # OS: Linux 2.6.18-xenU i686

Hi Aki and Remo, switch from vpopmail driver to SQL driver (if you are using vpopmail with mysql as backend) is very simple. First you need to setup the right query for vpopmail database: # cat /etc/dovecot/dovecot-sql.conf.ext ### Vpopmail driver = mysql connect = host=192.168.1.2 dbname=vpopmail user=vpopmail password=Vp0pM4iL default_pass_scheme = MD5-CRYPT ### Query to get a list of all

Greetings, I am trying to add the second virtual mailbox domain (transco.org.au) to an existing Postfix/Dovecot/MySQL mail server. Users of the first virtual mailbox domain (transylvania.org.au) have no problems sending and receiving mail. Users belonging to the second virtual mailbox domain can successfully send mail to outside, however they won't receive the mail, though Postfix

Im upgrading my dovecot from 2.1.14 to dovecot 2.2.1 on linux. Im using the same configuration file against my MySQL db and getting the following error: doveconf -n # 2.2.1: /opt/dovecot221/etc/dovecot/dovecot.conf doveconf: Fatal: Error in configuration file /opt/dovecot221/etc/dovecot/conf.d/dovecot-sql.conf line 2: Unknown setting: driver dovecot-sql.conf: # The mysqld.sock socket may be in

??? Here i have SSHA256 working with: default_pass_scheme = PLAIN ??? and my database scheme just received the hashed password prefixed by the SSHA indicator, just like: mysql> select * from emails where endereco = 'solutti at XXXXXXXXX'\G *************************** 1. row *************************** ????????????? endereco: solutti at XXXXXXXXXXXXXX ????????????? password: