Displaying 20 results from an estimated 7000 matches similar to: "Password database extra fields and SQL"
2018 Sep 17
2
Using both starttls and ssl in passdb on proxy results in timeouts
Hi List,
I have a dovecot which proxies to different backends depending on an entry in a mysql-database. The mysql-query sets ?ssl? to ?any-cert? and this works fine. But this causes me a problem: sieve-backends only support STARTTLS and if I set ?ssl? to ?any-cert? (or yes), it will attempt a TLS-connection to the sieve-backends, which fails.
My attempt was to alter the query to include
2007 Sep 10
1
Dovecot "authentication failed" interaction with Postfix
Hi,
I'm not sure if I should be posting this question here or on the Postfix
mailing list, but I'll start here.
When using Dovecot SASL with Postfix, is there a way to return a
login-failed reason in the SMTP AUTH dialog using "nologin", similar to
the way it can be done with Dovecot IMAP and POP?
Details:
I have a Dovecot authentication-only daemon working with a Postfix
2008 Nov 19
2
CRAM-MD5 and proxy_maybe
When using proxy_maybe CRAM-MD5 authentication fails when the connection
is proxied. Is this expected behavior? Is proxy_maybe too simplified for
this case?
We're using SQL so I could rewrite the query with IFs to fake
proxy_maybe and return the password as NULL and nologin as Y, but if it
works that way couldn't it work with proxy_maybe?
This works:
password_query = \
SELECT NULL AS
2020 Aug 31
3
Dovecot Proxy
Hello everyone,
it's my first post here on this mailing list and I hope, I make it right.
I posted a question on
https://serverfault.com/questions/1031441/dovecot-as-proxy-with-submission
and nobody was able to answer it. So I decided to push that question
here (I'm talking about any new dovecot version and I've tested it with
2.3.4.1 (f79e8e7e4)).
I try to run a dovecot proxy
2009 Oct 06
2
Proxy setup & upgrade from 1.0.3 to 1.1.7
Hi guys!
I hope somebody can help me with my problem:
We have a server running dovecot and proxying IMAPS connections to our
internal network. This worked so far very good until we upgraded the
server to a new SUSE Linux version and with it dovecot from version
1.0.3 to 1.1.7.
My guess is that something changed in the way dovecot reads the user
file as the configuration stayed the same:
2020 Sep 01
1
Dovecot Proxy
Hi Philon,
now, it's time for "Mahlzeit" ;-)
Sorry, that I read the wiki1 instead of wiki2. I thought the 1 means
that it is server one of ... my fault. Also not reading the first line
above the menu. My focus was really on the content. ;-)
Also my problem with the doc of Dovecot2 proxy is, that the document
https://doc.dovecot.org/configuration_manual/authentication/proxies/
2010 Apr 29
2
Question about dovecot imap proxy
Hi everyone!
I have dovecot (1.2.11) on one our external mail servers acting as a
proxy. The client (ifor now, my iphone) connects fine via ssl to the
external mailserver but I can't seem to get a secure connection now to
the internal destination imap server (between external mail server and
internal imap server, it's going through port 143). Running tcpdump, I
can clearly see my
2010 Mar 05
2
Bug in driver-mysql.c + fix
I tried to use MySQL stored procedures from dovecot:
password_query = CALL user_pass_check('%n', '%d', '%w')
user_query = CALL user_info('%n', '%d')
This failed with the message:
User query failed: PROCEDURE imap.user_info can't return a result set in the given context
The root of this problem is that mysql_real_connect() needs to be called with
2014 Apr 18
1
doveadm auth and the "nologin" extra field
Hello,
Still busy with details...
Considering, as in my previous example, a password_query returning '!' or NULL for the "nologin" column, depending on an account's status (suspended or not).
Let's consider a suspended user "some.user".
In the case of a successful authentication, one has:
sh-3.2# doveadm auth test some.user goodpassword; echo $?
passdb:
2012 Jan 24
2
Password auth scheme question with mysql
Hi, I have a current auth database using mysql with a "password" column
in plain text. The config has "default_pass_scheme = PLAIN" specified
In preparation for a more adaptable system I changed a password entry
from "asdf" to "{PLAIN}asdf", but now auth fails. Works fine if I
change it back to just "asdf". (I don't believe it's a
2012 Apr 28
2
help with AES_DECRYPT and password lookup - mysql password_query
Hello-
Sorry if this is a noob question, but I cant seem to get my password_query to
work with dovecot + mysql. Im using 'Password verification by SQL server' at:
http://wiki2.dovecot.org/AuthDatabase/SQL
trying to modify it to work with my encrypted passwords in the DB.
Im using the following which isnt working:
password_query = SELECT NULL AS password, \
'Y' as
2013 Sep 03
1
setup of dovecot as proxy to dbmail
Can anyone point me in the direction of a detailed how-to for setting up a postfix and dovecot (proxy) node with dbmail?
In particular I'm looking for a how-to which shows dovecot authenticating against the dbmail database directly.
The only example I've found is this one which requires a duplication of the user database.
2008 Aug 19
1
Authentication cache, failure to login after changed password
Hi,
I have an issue with the authentication cache.
When a user changes his password, the cache doesn't seem to get flushed.
Meaning the user is unable to log in to his IMAP account after changing
his password.
Flow:
- Log into IMAP account using pass1
- Approved
- Stored in auth cache
- Change password to pass2 in MySQL
- Log into IMAP account using pass2
- Access is denied
-
2010 Jan 29
1
Master user and proxying
Hello list,
Still need your help configuring proxy infrastructure.
Today, I really struggle configuring master passwords forwarding.
What
I want:
master user can connect to any other account, on proxy.
Could
please somebody help me, I read both articles about this on wiki, but still
can't connect :(
What I did:
on proxy:
auth_master_user_separator=*
passdb sql {
args =
2009 Mar 16
1
Dovecot as a POP3-/POP3SSL-proxy in front of exchange 2003
Dear all,
im looking for a solution to protect an Exchange 2003 email server from direct "pop3-internet-connects".
Is it possible that Dovecot act as a POP3-/POP3SSL-Proxy, "LDAP-authenticate" all user logins to a Windows 2003 domain controller and forward then all POP3-connects to a single Exchange 2003 server?
Could someone give me some advices or a link for howtos for
2009 Nov 30
1
Dovecot 1.2.x masteruser proxy problem
Greetings to all
I need a masteruser/proxy account for some applications to be implemented
and i am having some problems. Normal users are proxyied through
ldap queries to the remote machine and this is working like it sopose to,
but i can't make the master user to work. Below are both the dovecot.conf
and dovecot-ldap.conf and verbose logs on the proxy machine.
If i log directly on the
2008 Jan 25
2
proxy logging
Hi, I'm testing dovecot 1.1.beta14 on two debian etch with
drbd+ocfs2[active/active], I use qmail+vpopmail(userdb) and three
front-end with openbsd 4.2 with dovecot 1.1.beta14 as proxy with passdb
sql through vpopmail database.
Is posible to add logs into vpopmail.vlog from proxys?, like "update
vlog blah blah..." or in other sql database?
I tried with post login scripting but I
2009 May 17
2
Problem with domain part in user_query in dovecot 1.1.14
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
2020 Jun 23
2
nodelay passdb extra field does not work?
On Tue, Jun 23, 2020 at 5:17 PM Aki Tuomi <aki.tuomi at open-xchange.com>
wrote:
>
> > On 23/06/2020 12:15 Joe Wong <joewong99 at gmail.com> wrote:
> >
> >
> > Hello, I have added 'y' as nodelay in my passdb query and I see the
> following in log:
> >
> > dovecot: imap-login: Debug: Ignoring unknown passdb extra field: nodelay
>
2016 Apr 03
2
managesieve proxying not working
Hi,
I'm setting up the directors for proxying pop3/imap/lmtp/sieve. pop3/imap/lmtp proxying work fine, but sieve not working. The error messages in maillog look not using proxying but local passdb.
Error message:
Apr 03 12:09:25 managesieve-login: Info: Aborted login (no auth attempts in 0 secs): user=<>, rip=10.1.1.4, lip=10.1.1.201, session=<+SIcx4wvRQAKAQEE>
sql in