Displaying 20 results from an estimated 6000 matches similar to: "userdb prefetch not working for passdb sql"
2007 Sep 11
2
Possible bug in authentication cache in dovecot 1.1.alpha4
Hello,
it seems that there is some bug in authentication cache code in dovecot
version 1.1.alpha4 - after login attempt with wrong password the correct
password also will fail.
I can reproduce it very easy:
$telnet 10.10.10.30 110
+OK Server. <861.2.46e6c679.jZ8QYpFmU8ZN6XIq7zPhkw==@server2>
user testuser
+OK
pass pass
+OK Logged in.
quit
+OK Logging out.
Connection closed by foreign host.
2014 Dec 07
1
userdb lookup not possible with only userdb prefetch
Am 07.12.2014 um 00:56 schrieb Alexander Dalloz:
> You did fulfill the requzirements for prefetch to work documented in the
> wiki?
>
> http://wiki2.dovecot.org/UserDatabase/Prefetch
Ehm, this is my SQL configuration 'dovecot-sql.conf.ext':
> driver = mysql
> connect = host=**** user=**** password=**** dbname=****
> default_pass_scheme = PLAIN
> password_query = \
2018 Feb 01
2
AuthDatabase CheckPassword broken?
On Thu, 1 Feb 2018 10:02:10 +0200 Aki Tuomi <aki.tuomi at dovecot.fi> wrote:
>
> On 01.02.2018 08:00, Mark Foley wrote:
> > I had been using the CheckPassword authentication interface with dovecot 2.2.15,
> > https://wiki2.dovecot.org/AuthDatabase/CheckPassword, and it was working.
> >
> > After upgrading to 2.2.33.2 CheckPassword no longer works. The
2015 Sep 11
2
Need help on checkpassword userdb/passdb
I'm experimenting with checkpassword as an auth method for usedb and passdb
(http://wiki2.dovecot.org/AuthDatabase/CheckPassword). I've set up the userdb
and passdb *exactly* as the wiki suggests as the "standard way":
passdb {
driver = checkpassword
args = /user/util/bin/checkpassword
}
userdb {
driver = prefetch
}
I've created a checkpassword program that does
2018 Feb 01
2
AuthDatabase CheckPassword broken?
I had been using the CheckPassword authentication interface with dovecot 2.2.15,
https://wiki2.dovecot.org/AuthDatabase/CheckPassword, and it was working.
After upgrading to 2.2.33.2 CheckPassword no longer works. The referenced wiki page says,
Checkpassword Interface
Read <username> NUL <password> NUL from fd 3.
I've checked the information read from fd 3 with 2.2.33.2
2005 Dec 05
2
%d empty even though username has @domain
hello,
Sorry to jump straight in with a question, but I've searched the
archive[0] and I'm pretty sure the answer's not there.
I'm using dovecot to replace courier imap, so authentication is by
vpopmail and the Maildirs are stored in the usual domains/domain/user/
Maildir. Everything seems to work very well, and setting it up has
been easy, so thank you very much for that.
2006 Feb 15
4
One dovecot, multiple domains
Hey guys, I've got dovecot configured to work perfectly for virtual users across
different domains. It's great.
My problem is that, as far as I can tell, dovecot makes me use one SSL
certificate across all my domains. That's not what I want. Is there a way I can
get dovecot to use the cert for mail.foo.com when somebody is logging into a
foo.com account, and the cert for
2006 Jul 10
2
userdb prefetch problem..
I have a setup that I'm working on migrating to Dovecot for thousands of
users across a few dozen domains.. All users are authed from LDAP.. In
LDAP, each user has a unique uidNumber, and varying gidNumber (for use
in other applications)
As far as mail storage, the entire Maildir structure is owned by
UID/GID: vmail/vmail
So, the uidNumber/gidNumber from LDAP is not needed. global uid/gid is
2006 Oct 17
2
allow_nets and mysql question
Hi.
I want to use allow_nets in my configuration, but i have some troubles
which i cant resolve.
To use allow_nets i creates `allow_nets` text field in my mysql users
table. My query is:
from: dovecot/sql.conf:
password_query = SELECT crypt as password, maildir as userdb_mail, 6 AS
userdb_uid,6 AS userdb_gid, allow_nets FROM users WHERE id = '%u'
from dovecot.conf:
auth default {
2014 Dec 06
3
userdb lookup not possible with only userdb prefetch
Hello,
I am setting up a new server and migrating my Dovecot 1.2.9 config to
the new 2.2.9 version. There wasn't much to keep from the old version so
I had to recreate the config from scratch. Now I think I'm done but I
can't login to IMAP. The log says this:
> dovecot: auth: Error: prefetch(box@****.de,2001:****:7765,<bzAOP5QJXwAgAQpgEAXJAZyOMB1qBXdl>): userdb lookup not
2009 Nov 20
2
quota in SQL and static userdb
Hello,
which solution will be working or will be working better
(performance). Using dovecot 1.2.6 (plugin section contains quota_rule
= *:storage=500M:messages=10000 and i need override this default quota
for some users)
A) passdb sql(SELECT userid AS user, pw AS password, quota AS
userdb_quota_rule FROM users WHERE userid = '%u') + userdb static
(uid=500 gid=500 home=/home/mail/%d/%n
2011 Jan 29
2
sql : uid, gid, home ignored ?
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
2005 Dec 08
1
prefetch userdb on 1.0.alpha4
Hi all,
I've a problem with prefetch userdb function on 1.0.alpha4 ?
I get this :
Error: auth(default): ldap(mylogin,10.3.245.xxx): Multiple password
replies
Info: auth(default): ldap(mylogin,10.3.245.xxx):
base=dc=boursorama,dc=fr scope=subtree filter=(&(objectClass=
boursoramaMailAccount)(mailInternalAllowedProtocol=imap))
fields=uid,userPassword
An ldapsearch with the same
2006 Mar 22
1
LDAP and prefetch
SunOS pop01.unix 5.10 Generic_118844-26 i86pc i386 i86pc
dovecot-1.0.beta3
It is most likely something I am doing wrong, but could someone take a look at
why I can not get LDAP prefetch to work?
If I define things like this:
dovecot.conf:
----------------------------------------------
passdb ldap {
args = /usr/local/etc/dovecot-ldap.conf
}
userdb ldap {
args =
2019 Apr 12
2
Using userdb/passdb data in director_username_hash
TL;DR:
Can director_username_hash use %{userdb:...} or %{passdb:...} ?
====================================
This is on Ubuntu Precise, running dovecot 2.2.36. It's a fully production,
director-ized env, so assume everything is working correctly. Happy to post
doveconf if it's relevant but wanted to ask a general question first.
I was curious if there's a way to get userdb/passdb
2006 Apr 03
1
problem with userdb_ on pgsql
# 1
password_query = SELECT login as user, passwd as password
FROM mail.dovecot_passwd_v WHERE login = '%n'
# 2
user_query = SELECT home, 5020 as uid, 5020 as gid
FROM mail.dovecot_passwd_v WHERE login = '%n'
# 3
# password_query = SELECT login as user, passwd as password,
home as userdb_home, 5020 as userdb_uid, 5020 as userdb_gid
FROM mail.dovecot_passwd_v WHERE
2010 Jul 19
1
Unknown column username in where clause
Version: Dovecot 2.0 rc2
I'm testing Dovecot with MySQL quotas but I get always this error for
incoming mails:
tux dovecot: lmtp(4928): Error: user testuser at dlutt.de: Auth USER lookup failed
tux dovecot: auth: Error: mysql: Query failed, retrying: Unknown column 'username' in 'where clause'
I dont' know where the field "username" should come from because I
2013 Nov 12
1
how to make quota per user ??
I use dovecot version 1.2.15 and i put quota for all users , now i want to
give more size for some emails , i already added the quota to user database
, and i added the queries from http://wiki.dovecot.org/Quota/1.1
MySQL:
user_query = select uid, gid, home, \
concat('*:bytes=', quota_bytes) as quota_rule \
from users where userid = '%u'
# MySQL with userdb prefetch: Remember
2018 Oct 04
2
vpopmail
Quoting Eric Broch <ebroch at whitehorsetc.com>:
> On 10/4/2018 7:27 AM, Rick Romero wrote:
>>
>> Quoting Eric Broch <ebroch at whitehorsetc.com
>> <mailto:ebroch at whitehorsetc.com>>:
>>
>>>
>>> On 10/4/2018 6:34 AM, Rick Romero wrote:
>>>>
>> Quoting Aki Tuomi <aki.tuomi at open-xchange.com
>>
2007 Jan 12
1
dovecot Digest, Vol 45, Issue 18
>
> I use postfx 2.3.5 + dovecot (pop3/imap/lda/auth daemon for postfix) rc15.
>
> root at post /etc/postfix# grep dovecot main.cf
> smtpd_sasl_type = dovecot
> virtual_transport = dovecot
> dovecot_destination_recipient_limit = 1
>
> root at post /etc/dovecot# grep password_query dovecot-sql.conf
> password_query = SELECT mail as user, cryptp as password,
>