similar to: SQL user_query question

Hi, I've been working on configuring a new Postfix+Dovecot+Cyrus-SASL +Postgres server to perform multi-domain virtual hosting with non-unix accounts. I believe I have everything working correctly and have tested both the SASL portion and POP authentication through telnet and all works as expected, with one exception. When I authenticate using POP3: # telnet mail.host 110 Trying

Hello, I'm setting up a new mail server using freebsd 6.2, postfix, dovecot with SASL and, eventually, squirrelmail. I've gone through http://wiki.dovecot.org/TestPop3Installation the program is running, plain works over telnet from local host or from a remote machine. I can do stat and retr commands. however, when I try to use the login method (that is what the command 1 login

Hi, I plan on upgrading from 1.1.13 to 1.2.4 using an RPM. I have read the wiki [1] and have a question about the mail_location variable. Currently, in 1.1.13, I use: mail_location = maildir:/var/spool/virtual_mailboxes/%h with virtual mailboxes. However, I am planning to change it to use: home=/var/spool/virtual_mailboxes mail_location = maildir:%h as part of the new configuration. Is

Hello, Using Dovecot's deliver MDA, all mails are stored with the line "From <sender> <date>" appended. When forwarding these mails as attachements, the recipients get the source code. When Postfix delivers emails directly in the Maildirs, this first line is not appended, and there is no problem when forwarding the mails. Why is this line appended by deliver ? Is

hi there! i'm trying to run dovecot 1.2.4 managesieve service with mysql auth. authentication is obviously going fine, i have debug_auth set to on and can see log lines indicating auth success: 2009-11-18 16:04:24 auth(default): Info: client in: AUTH 1 PLAIN service=pop3 secured lip=127.0.0.1 rip=127.0.0.1 lport=10100 rport=42497 resp=<hidden>

-- You only had to look into Teatime's mismatched eyes to know one thing, which was this: if Teatime wanted to find you he would not look everywhere. He'd look in only one place, which would be the place where you were hiding. --Hogfather > On 06 Mar 2018, at 13:13, Rob Hoelz <rob+dovecot at hoelz.ro> wrote: > > I've had success using "doveadm mailbox list? #

Hello, I have been looking at enforcing quotas for users of my mail system (postfix and Dovecot v1.2). Have tried to follow a few tuts on the web but its not having the desired effect. Essentially I can still send and receive mail on an account that I believe has had its quota exceeded. In my main.cf, I have: userdb sql { args = /etc/dovecot/mysql/dovecot-mysql.conf } passdb sql {

I'm new to dovecot and it's configurations. Reading the config file, I have a question regarding having multiple auth= lines in there. Is this some sort of a pass-through or fail-through system of authentications like where if a user is not authenticated using 'pam', then the second method is tried (which might be sql or plain passwd-txt) ? Am I assuming the right thing here ? I

Hi, I have a mail server (postfix/dovecot) running so far with normal local /etc/passwd users for domain example.com. mail_location = maildir:~/Maildir passdb pam { } userdb passwd { } Is it possible to add virtual domains/users to my setup without changing example.com to a virtual domain? I can do the postfix part with http://www.postfix.org/VIRTUAL_README.html#virtual_mailbox but

On 08.03.2018 03:09, @lbutlr wrote: > On 2018-03-06 (14:41 MST), "@lbutlr" <kremels at kreme.com> wrote: >>> and using "doveadm search mailbox $VIRTUAL_MAILBOX? >> # doveadm search mailbox "@virtual.day" -u kremels >> # > Any clues on this? As far as I can tell from the documentation and the list this should work, but it is not. > You

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

Hello, As per a previous reply regarding POP3 I'm now trying to configure the virtual plugin. However I don't really understand how to modify the sql user_query to properly indicate inbox=yes. I created 3 namespaces as per wiki instructions and I've modified the password and user queries as bellow: password_query = \ SELECT email, password, login , concat('*:bytes=',

Let's say one has a SQL table with following fields for John Doe: login: u0007 password: {SHA1}... mailhome: /path/to/joeshome email: john.doe at example.com To log in, for internal policy reasons, John MUST make use of his userid "u0007". So, in the password_query, one would need something like: ... WHERE login = '%u' ... On the other hand, for receiving mail thru

-----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

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:

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

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:

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

Hi Everyone, I thought I'd try asking here before joining the postfix mail list since I'm running postfix on a CentOS 7 box. I want to look up accounts via LDAP (an IPA server also on CentOS 7). I created an "ldap_aliases" file and successfully tested it with the postmap command: I can get the email address for an arbitrary user. But, when I add the very same file to main.cf, I

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