Displaying 20 results from an estimated 6000 matches similar to: "iterate_query with static userdb ?"
2020 May 17
0
iterate_query with static userdb ?
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
<br>
</div>
<blockquote type="cite">
<div>
On 17/05/2020 12:34 Laura Smith <<a href="mailto:n5d9xq3ti233xiyif2vp@protonmail.ch">n5d9xq3ti233xiyif2vp@protonmail.ch</a>> wrote:
2020 May 17
2
iterate_query with static userdb ?
On Sunday, 17 May 2020 10:38, Aki Tuomi <aki.tuomi at open-xchange.com> wrote:
> > On 17/05/2020 12:34 Laura Smith <n5d9xq3ti233xiyif2vp at protonmail.ch> wrote:
> >
> > Hi,
> >
> > Going by the "static userdb" example? on this page (https://wiki.dovecot.org/VirtualUsers#homedirs), tried to achieve a similar setup in conjunction with pgsql for
2020 May 17
1
"/etc/dovecot/dovecot.conf: passdb is missing driver"
Hi,
I'm trying to get dovecot working with postgres, I'm on Debian 10 and have installed dovecot-pgsql from the Dovecot repo (https://repo.dovecot.org/ce-2.3-latest/debian/....).
I have the following in my local.conf :
passdb sql {
? args = /etc/dovecot/local_sql_users.conf
}
And the following in the referenced file:
driver = pgsql
connect = host=localhost dbname=foobar user=bar
2020 May 22
1
Dovecot passdb and postfix login
Hi,
Long story short I've got a fully functional Dovecot IMAP instance and I am now looking to upgrade some perimiter authenticated SMTP relays to authenticate against the Dovecot instance.
Trouble is that I am seeing errors such as "auth: Warning: sql: Ignoring changed user_query in /etc/dovecot/local_sql_users.conf, because userdb sql not used." in my Postfix server logs and not
2014 Aug 15
1
Server dovecot: auth: Warning: sql: Ignoring changed iterate_quer
Hello,?
I am having an issue with Dovecot. I am using Roundcube to access my mailboxes, which I have set up using ViMbAdmin.?
However when I go to the Roundcube, I get login Failed.?
So looking in the mail.log I can see the following:?
Aug 15 13:20:09 Server dovecot: auth: Warning: sql: Ignoring changed iterate_query in /etc/dovecot/dovecot-sql.conf.ext, because userdb sql not used. (If this
2012 Oct 11
1
iterate_query does not use userdb - mail_location not found
Hi dovecot-comminity,
can't get iterate_query working. doveadm cannot find mail_location
which comes from userdb query. dovecot itself works fine with sql.
Whats wrong? please help:
[root at glen exim]# /opt/dovecot/bin/doveadm search -A mailbox Trash savedbefore 90d
doveadm(uwe at mitmachnet.de): Error: user uwe at mitmachnet.de: Initialization failed:
2012 Mar 21
1
ldap userdb warning in v2.1.1
Hi,
I've upgraded from 2.0.13 to 2.1.1 and when I started the service, I got
the following warning:
Mar 21 10:07:23 imapserver dovecot: master: Dovecot v2.1.1 starting up
(core dumps disabled)
Mar 21 10:08:17 imapserverdovecot: auth: Warning: ldap: Ignoring changed
user_attrs in /etc/dovecot/dovecot-passdb-ldap.conf, because userdb ldap
not used. (If this is intentional, set
2018 Oct 11
2
Struggling to get dovecot working with postfix auth
On Thursday, October 11, 2018 1:29 PM, Aki Tuomi <aki.tuomi at open-xchange.com> wrote:
> > On 11 October 2018 at 15:02 Laura Smith n5d9xq3ti233xiyif2vp at protonmail.ch wrote:
> >
> > > That's a permission error. Somewhere in your directory hierarchy things
> > > are off. See Postfix' set-permissions command.
> >
> > But surely if Dovecot
2019 Oct 24
1
SQL iterate_query
I've been hunting some ghost mailboxes - and I *think* I found the source.
I use the complete email address as the username, and store such in a
database. The storage structure is location=/var/mail/%d/%n. Not unusual
I think.
So all I *should* see from "ls /var/mail" would be a list of domains.
But I keep seeing empty mailboxes being created at this level. Having
corrected a
2020 May 24
3
Current thinking on backups ?
Hi,
What are people doing for backups ?
My current process is LVM snapshot and backup from that to NFS share.
But there seems to be hints around the internet that people use/abuse "doveadm backup" for backup purposes even though it seems its original intention was for transferring mailboxes between dovecot instances.
Assuming its ok to "doveadm backup" to an NFS share, is it
2019 Aug 09
2
What does `iterate_query` for SQL want as output?
Hi all,
In an earlier thread, https://dovecot.org/pipermail/dovecot/2019-August/116694.html I got a lot of useful help about migration. On my older host, everything was static; on the newer host, I?m storing user information in Postgres. usernames are of the form <login at REALM>, say ?hile at coyhile.com? as basically a Kerberos principal, and authentication and individual lookups work.
2020 May 17
0
iterate_query with static userdb ?
On 17/05/2020 10:43, Laura Smith wrote:
> Because I wanted to avoid storing uid/gid/home in the database ?
I use:
user_query = "SELECT 'vmail' AS uid, 'vmail' AS gid, allow_nets,
'*:storage=' || quota || 'M' AS quota_rule FROM mailbox WHERE username =
'%n' AND domain = '%d';"
... uid and gid are not stored in my database but are
2020 May 27
2
Determinant of umask for sieve_pipe_bin_dir scripts?
Hi,
What determines the umask of sieve_pipe_bin_dir scripts ?
The results from my script are always being set to 0600.
My script is simple and shown below, even if I adjust the right line to add " && chmod 644", the actual resulting file still remains at 0600 ?!?
#!/bin/bash
# Usage: imapsieve_copy <email> <spam|ham>
MSG_USER="$1"
MSG_TYPE="$2"
2020 May 31
4
Simple backup of maildir folder
On 29 May 2020, at 23:49, Admin Beckspaced <admin at beckspaced.com> wrote:
> I also have maildir as mailbox format and use the following script to do daily backups
>
> https://github.com/tachtler/dovecot-backup
A couple of notes on this quite useful script:
My mktemp does not support -p (FreeBSD 12.1) is I had to change the script to:
DIR_TEMP=$($MKTEMP_COMMAND -d $TMP_FOLDER
2019 Aug 09
2
What does `iterate_query` for SQL want as output?
> On Aug 9, 2019, at 3:45 PM, Aki Tuomi <aki.tuomi at open-xchange.com> wrote:
>
>
>> On 09/08/2019 22:16 Coy Hile via dovecot <dovecot at dovecot.org> wrote:
>>
>>
>> Hi all,
>>
>> In an earlier thread, https://dovecot.org/pipermail/dovecot/2019-August/116694.html I got a lot of useful help about migration. On my older host, everything
2011 Oct 24
1
iterate_query not working
Hi,
I have got iterate_query defined in dovecot-sql.conf.ext. However when I
run a command like:
doveadm search -A BEFORE 10d
I receive an error message (Failed to iterate ...)
There is an error message in a log file too:
Error: Trying to iterate users, but userdbs don't support it
The problem is that monitoring a database server shows that dovecot does
not try to execute any query. What
2018 Oct 11
3
Struggling to get dovecot working with postfix auth
> That's a permission error. Somewhere in your directory hierarchy things
> are off. See Postfix' set-permissions command.
>
But surely if Dovecot is staring as root then directory permissions are relevant, especially if I'm then asking the config to chmod the file anway ?
To me, it seems dovecot is not behaving correctly, because if it is not using root to access the
2020 Jul 13
1
Static users and doveadm
Hello Dovecot users?
I wanted to ask is using a static userdb will cause issues with some of the account and user related doveadm commands? If so, any suggestions on how to use doveadm in such a configuration?
I have pasted both the cmd + error and userdb config below ? Thanks in advance?
sudo doveadm mailbox list -A
Error: auth-master: userdb list: User listing returned failure
doveadm:
2009 Nov 09
2
Missing 'mailbox' variable ?
Hi,
I'm using Dovecot with LDAP.
My users have an home directory and a field named 'mailMessageStore'.
Then the full mailbox path is 'homeDirectory/mailMessageStore'
In dovecot-ldap.conf i configured as follows :
user_filter = (&(objectClass=qmailUser)(cn=%u))
user_attrs =
qmailUID=uid,qmailGID=gid,homeDirectory=home,mailMessageStore=mail=maildir:~/%$
Everything is
2017 Nov 28
2
How to make dovecot access a MySQL database with a certain domain?
I am trying to make a mail server with Postfix using the Dovecot software. At the time of wanting to access my server from a mail client, it does not let me access and see the logs of my server with the command:
$ service dovecot status
with the following error:
dovecot: auth-worker(2769): Error: mysql(127.0.0.1): Connect failed to database (postfix): Access denied for user