Displaying 20 results from an estimated 4000 matches similar to: "Question about auth-master, deliver, and SQL maps"
2005 Jun 24
1
Any status on timestamp vulnerability fix for 4.X?
Any information on when (or if) the following timestamp vulnerability
will be fixed for 4.X? Any information would be appreciated.
http://www.kb.cert.org/vuls/id/637934
Thanks.
Richard Coleman
rcoleman@criticalmagic.com
2007 Jul 11
1
Can Wiki entry on dovecot LDA/deliver be clarified?
Hi guys,
I am having some problems relating to this "Fixing lda user_query
error introduces new fault in mail delivery" and I'd like to know if
the above wiki comment holds even if a user_query is configured to
return the correct mail folder.
According to this LDA delivers only to the mail_location setting. Does
that mean that it will stick to the value in dovecot.conf or will the
2010 May 04
1
Where should I define mail_uid for deliver LDA?
Hello folks
I'm trying to use Dovecot deliver LDA instead Postfix virtual LDA
The last road block I have to resolve is to define mail_uid, becaus
dovecot.err log has these error messages:
May 04 14:57:19 deliver(user1 at some_domain.com): Error: User
user1 at some_domain.com is missing UID (set mail_uid)
May 04 14:57:19 deliver(user2 at some_domain.com): Error: User
user2 at some_domain.com
2006 Sep 21
1
deliver vda maildir postfix problem
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi @ll,
sorry i am new to dovecot so this may asked before
i this in dovecot.conf
protocols = pop3 imap
ssl_disable = yes
mail_extra_groups = mail
valid_chroot_dirs = /usr/local/virtual/
default_mail_env = maildir:/usr/local/virtual/%d/%n
disable_plaintext_auth = no
protocol lda {
postmaster_address = postmaster at test.de
}
protocol pop3 {
2010 May 04
3
Dovecot deliver LDA problem
Hello folks,
I was trying to set up Dovecot deliver LDA instead of Postfix default
virtual LDA
In Postfix main.cf I specified:
virtual_transport = dovecot
dovecot_destination_recipient_limit = 1
In Postfix master.cf I entered:
dovecot unix - n n - - pipe
user=mailer flags=DRhu
argv=/usr/local/mail/libexec/dovecot/deliver -f ${sender} -d ${recipient}
In
2007 Aug 15
1
Dovecot deliver + sieve + postfix virtual + mysql ?
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.
2010 May 03
4
Dovecot SQL user_query
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
2008 Feb 05
1
Quota + MySQL
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,
2007 Sep 13
1
Dovecot + virtual users
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
2017 Oct 10
1
Mail Alias Stores in mySQL Not working
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:
2011 Jun 05
1
doveadm problem with mail_plugins in database
-----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
2009 Jan 13
2
Can not Create Maildir using userdb
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]
2017 Oct 10
2
Mail Alias Stores in mySQL Not working
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'
2007 Jul 11
1
Fixing lda user_query error introduces new fault in mail delivery
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:
2005 Oct 11
3
FreeBSD Ports Issues
Installed dovecot for the first time, using the FreeBSD port. Found 2 issues
with the port, and I've only been able to resolve one of them.
First of all, the port, (or perhaps dovecot) does work with mysql 4.1
encryption. I had to create a user with access to the mysql table, then do
'set password = old_password('password');' in order to get dovecot to talk
to the server.
The
2020 Mar 19
2
Headsup on feature removal
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
2014 May 27
3
SQL passdb, LDAP userdb
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
2017 Oct 12
1
Mail Alias Stores in mySQL Not working
"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
2006 Oct 24
1
converting from courier questions
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
2005 Jul 02
3
packets with syn/fin vs pf_norm.c
Hi,
First of all, I know that not dropping SYN/FIN isn't really a big deal, it
just makes no sense. But since it doesn't make any sense, I don't see
the reason why not to discard them.
I'm running pf on FreeBSD 5.4-RELEASE-p3 and I scrub any traffic. I've
read some other posts on google and as far as I can tell, clearly invalid
packets (like packets with SYN/RST set) is