%{listener} not working

2022-05-18 Thread cesco
Hi I'm trying to use the variable %{listener} in the following password mysql query: password_query = SELECT accounts.mcf AS password FROM accounts, domains WHERE user = '%n' AND accounts.domain = '%d' AND accounts.domain = domains.domain AND domains.host = '%{hostname}' AND accounts.service

Re: Duplicate messages if message is moved when using dsync

2022-05-18 Thread Paul Kudla (SCOM.CA Internet Services Inc.)
ok - question when you say dsync are you running that manually or as a cronjob ?? or using replication via dsync there is a difference replication is designed to handle mailbox changes by quing the changes on the fly and then update in the background. replication tracks all changes in a

Re: Message attachments, relocated with Tbird in Dovecot maildir store, not openable; reversible by moving BACK to inbox?

2022-05-18 Thread PGNet Dev
On 5/18/22 4:23 PM, Joseph Tam wrote: On Wed, 18 May 2022, PGNet Dev wrote: checking ls -altr /tmp/pid-59993/SomeFile.pdf     -r+ 1 pgnd pgnd   27 May 18 07:46 'SomeFile.pdf' This may or may not get you closer to the solution After enabling the memory cache per prior

Re: Message attachments, relocated with Tbird in Dovecot maildir store, not openable; reversible by moving BACK to inbox?

2022-05-18 Thread Joseph Tam
On Wed, 18 May 2022, PGNet Dev wrote: checking ls -altr /tmp/pid-59993/SomeFile.pdf -r+ 1 pgnd pgnd 27 May 18 07:46 'SomeFile.pdf' This may or may not get you closer to the solution, but out of curiosity, what's in the 27 bytes worth of data? And are those

Re: Duplicate messages if message is moved when using dsync

2022-05-18 Thread Thom Pol
Never mind. It did not work, issue still exists. I guess my network was a little slower when I thought it worked, so the emails were moved by my local client only after the sync had already happened between the servers. So, back to the original message. Anyone any idea how this moving on

Re: Message attachments, relocated with Tbird in Dovecot maildir store, not openable; reversible by moving BACK to inbox?

2022-05-18 Thread PGNet Dev
On 5/18/22 9:51 AM, Virgo Pärna wrote: ls -al manual_13542AE.pdf -rw-r--r-- 1 pgnd pgnd 27 Apr 1 06:01 manual_13542AE.pdf Try enabling memory cache and setting memory cache size larger, then attachment size. That 27 byte file size is familiar. in Tbird,

Re: FTS Solr -- no commit on message delete

2022-05-18 Thread Shawn Heisey
On 5/18/2022 8:24 AM, Shawn Heisey wrote: Today I discovered a related problem that I think IS in Dovecot.  I did a shift-delete on some messages, and then exited Thunderbird.  Dovecot did delete the messages from Solr, but it did not send a commit to make those changes affect subsequent

FTS Solr -- no commit on message delete

2022-05-18 Thread Shawn Heisey
I've been chasing down oddities in behavior related to FTS Solr for a while now. First the part that isn't a problem with dovecot:  In cases where message deletes bypass the Trash folder (such as shift-delete and normal workflow with the Drafts and Sent folders), Thunderbird does not inform

Upgrading from 2.3.18 --> 2.3.19

2022-05-18 Thread Paul Kudla (SCOM.CA Internet Services Inc.)
Ok currently running 2.3.18 Would like to upgrade to 2.3.19 (to keep current) Since these are production servers can i down grade back to 2.3.18 if nessesary? Issues at hand is there seems to be conflicting messages about the replication being fixed or not ? so would like to basically

Re: Can sync/migrate all mail from remote imap account except the main "INBOX"

2022-05-18 Thread Darren Mobley
Your example pointed me to a solution, excellent ! In my case I only needed one pass, I had to supply both imapc_list_prefix AND imapc_prefix AND the "namespace/inbox/prefix=" options. In case anyone runs into this in the future, here's a decent place to start for debugging: /usr/bin/doveadm

Re: dovecot Digest, Vol 229, Issue 23

2022-05-18 Thread Paul Kudla (SCOM.CA Internet Services Inc.)
Your Welcome Happy Wednesday !!! Thanks - paul Paul Kudla Scom.ca Internet Services 004-1009 Byron Street South Whitby, Ontario - Canada L1N 4S3 Toronto 416.642.7266 Main 1.866.411.7266 Fax 1.888.892.7266 On 5/18/2022 9:04 AM, Thom Pol wrote: I must say I was a bit

Re: Message attachments, relocated with Tbird in Dovecot maildir store, not openable; reversible by moving BACK to inbox?

2022-05-18 Thread PGNet Dev
On 5/18/22 8:00 AM, PGNet Dev wrote: 4/1/22 I see same symptoms when opening a mail in thunderbird 2 or 3 weeks after I received it, without moving it in another folder. But using "repair folder" in TB, I get it back, so for me it looks more like a TB cache problem. I've still not managed

Re: dovecot Digest, Vol 229, Issue 23

2022-05-18 Thread Thom Pol
I must say I was a bit sceptical if this sieve script would resolve it, but it seems like it totally did! Thanks a lot for your reply, hope this helps someone else in the future as well. Kind regards, Thom Pol On 16/05/2022 08:12, Paul Kudla (SCOM.CA Internet Services Inc.) wrote: ok

replication-/sync-problem with 'percent'-sign in foldernames after upgrade to dovecot 2.3.19

2022-05-18 Thread Andreas Piper
Hello, after upgrading my two replicator-hosts from 2.3.18 to 2.3.19, I observe 'failed replication'-counts with "dovecot replicator status". The failure seems to be linked to foldernames containing a 'percent'-sign ('%'): "dovecot replicator status '*' | grep ' y'" now lists some users,

Re: Message attachments, relocated with Tbird in Dovecot maildir store, not openable; reversible by moving BACK to inbox?

2022-05-18 Thread PGNet Dev
4/1/22 I see same symptoms when opening a mail in thunderbird 2 or 3 weeks after I received it, without moving it in another folder. But using "repair folder" in TB, I get it back, so for me it looks more like a TB cache problem. I've still not managed to solve for this problem; 'repair'

Re: Possible to increase connection limit for one user only?

2022-05-18 Thread Stuart Henderson
On 2022-05-17, Kurt Fitzner wrote: > I run a medium-sized virtual domain email server for about 15 domains=2E I= > also use it myself and have 3 or 4 devices using imap=2E I am often usin= > g a VPN to connect to my home network, which makes all my connections appea= > r to come from one

RE: dovecot virtual users with sendmail, my solution

2022-05-18 Thread Marc
> > I wanted to use dovecot virtual users with sendmail. I do not see you use/create/modify sendmail specific files. So can it be your virtual users are not that virtual any more, but real users? > As you probably know, this > doesn't work by default. The more scalable solution is probably