similar to: FreeBSD Ports Issues

Hello folkz, Is it possible to setup in dovecot-sql.conf file to run user_query twice if its first run didn't yield any values. And likewise don't proceed with the second run if the first user_query execution produced the result. I have to query two tables which specify there email messages shall be delivered via Dovecot deliver LDA depending on the incoming email addresses. Please

Hello, Im having problems getting Dovecot to read the quota info from MySQL. My current dovecot.conf file is below. If I run the user_query of: user_query = SELECT 1000 AS uid, 1000 AS gid, maildir AS home FROM mailbox WHERE username = '%u' AND active = '1' Everything works fine but if I run the user_query of: user_query = SELECT 1000 AS uid, 1000 AS gid, maildir AS home,

Hi, I'm running FreeBSD, Dovecot, Postfix (virtual users), MySQL, Squirrelmail. I have installed squirrelmail-quota_usage-plugin, but I cannot make it work. It mentions "If you have an IMAP server with QUOTA Extension capability...". In dovecot.conf I have enabled "mail_plugins = quota" near protocol pop3 and protocol lda, near protocol imap I have "mail_plugins

This apparently was a problem that i was not aware since i redid my mail server configuration to make use of Postfixadmin. I have update the conf files using the postfix document fromthe down load. The download document seems to be fpr an early version of dovecot (I am using 2.2.4) as it focuse of dovecot.conf which is now broken into file in the conf.d subdirectory I get "dovecot:

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, I use this user_query: - -------------------------------%<-------------------------------- user_query = SELECT LOWER(CONCAT(t2.login,'@',t1.name)) AS user,t2.home,t2.mail,5000 AS uid,5000 AS gid,CONCAT('*:storage=',quota_mb,'MB') AS quota_rule,t2.acl_groups,case when '%s'='lda' then 'acl quota

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

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]

First of all excuse.. I am having an issue getting maillist responses so I may be responding to this worng No on topic I commented out the first user_quesry The second query was not copied correctly , reads user_query = SELECT CONCAT('/var/vmail/mail/', maildir) AS home, 5000 AS uid, 5000 AS gid, CONCAT('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = '%u'

I was getting these errors below and after fixing it delivery errors were introduced dovecot/error_log ============== dovecot: Jul 11 06:19:28 Error: auth-worker(default): sql(user at domain.com): User query failed: Table 'postfix.users' doesn't exist deliver(user at domain.com): Jul 11 06:19:28 Error: BUG: Unexpected input from auth master: FAIL 1 dovecot: Jul 11 06:21:41 Error:

I have been running Postfix/Dovecot with a Postgresql backend for several months, and everything has been running great. Now I want to add server side filtering, so I'm attempting to configure deliver. The SQL maps for Postfix are all keyed upon the recipient email address. The SQL map (user_query) for Dovecot is keyed upon the IMAP login name, which is potentially unrelated to the email

Il 19/03/20 02:01, John Stoffel ha scritto: > Alessio> ### user_query for vpopmail > Alessio> user_query = SELECT pw_dir AS home, 89 AS uid, 89 AS gid, > Alessio> concat('*:backend=', pw_shell) AS quota_rule FROM vpopmail > Alessio> WHERE pw_name = '%n' AND pw_domain = '%d' > > Careful! You need to explain that 89 is the UID and GID of the

Hi, in my current setup, LDAP authentication + userdb works fine. I'd like to integrate Dovecot with Shibboleth. I have a custom module at the IdP (*) that inserts short-time tokens to an SQL table at user authentication, and I want Dovecot to use the token table for passdb but keep LDAP for storing the userdb (uid, quota, etc) I thought it was simple as omitting the sql user_query, but I

"In an earlier post you said your user_query was: user_query = SELECT CONCAT('/var/vmail/mail/', maildir) AS home, 5000 AS uid, 5000 AS gid, CONCAT('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = '%u' AND active=?1' Last post you said: mail is stored at /var/mail/vhosts and: mail_location = maildir:/var/mail/vhosts/%d/%n These don't agree

I currently run postfix and courier on my mail servers with squirrelmail. The problem with courier is it seems to run so slow. The webmail takes forever to load if you have many mails. I have this set up in virtual domains with all longin and path info in an mysql database. I just joined the list and DID google before asking, hope this isn't a common question. With courier it looks for a

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, I have a problem with mail_plugins in dovecot-2.0.x. I will use mail_plugins within a database, so that I can define plugins for users in the database. But I get errors like this. - -----------------------------%<------------------------------------ lmtp(3933): Error: Can't load plugin imap_quota_plugin: Plugin is intended to be

Hi there, I'm setting up a new email server with Dovecot(2.2.9) and MySQL. My Dovecot configuration: #/etc/dovecot/conf.d/90-quota.conf service quota-warning { executable = script /usr/local/bin/quota-warning.sh user = dovecot unix_listener quota-warning { user = vmail } } plugin { quota = maildir:User quota quota_warning = storage=95%% quota-warning 95 %u@%d

Dovecot (1.1.1) criticises a sql user_query that's working on the sql console and thats correct. DOVECOT-LOG: "dovecot: Jul 06 22:58:29 Error: auth(default): sql(nti): User query failed: ERROR: syntax error at or near "mbox" dovecot: Jul 06 22:58:29 Error: auth(default): LINE 1: ...gid, home, (CASE WHEN smtp like '/var/pop3/ THEN 'mbox:' || ..." QUERY:

How do I get IMAP+POP3 vs. LDA to use different user_query statements? The problem is that the input fields are different. IMAP/POP3 is an email address LDA is a username I have written a long statement to try and cater for both however it still only works 99% of the time, and the remaining 1% fails. The 1% that fails sees the mail being delivered to the wrong mbox. In this particular case

Hello, I have a general question about userdb and passdb lookups, in my case related to driver=sql. The documentation and most examples in the internet seem to assume that a user's login username to access a mailbox is identical to his email-address, or at least to the local-part of this email-address. This setup works fine. But I don't understand how to setup dovecot, when login

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