similar to: migrating 2.1 to 3.x, sql pass scheme, pass value?

On Tue, August 15, 2017 8:54 am, Noel Butler wrote: > On 15/08/2017 08:18, voytek at sbt.net.au wrote: > Forget looking at dovecot at teh moment, your problem maybe mysql (I'd > hope you meant mariadb but either way...) > > use command line mysql as vmail user from your dovecot machine to test > password further BEFORE tinkering with dovecot. > > ~$ mysql -p -v vmail

On Tue, August 15, 2017 8:03 pm, Sami Ketola wrote: > >> On 15 Aug 2017, at 2.50, voytek at sbt.net.au wrote: >> >> >> how do I generate hashed string from my password ? > > use this sql command: > > GRANT SELECT ON vmail TO ?vmail?@?127.0.0.1? IDENTIFIED BY > PASSWORD(?yourpassword?); > > > or if you just want to see the hash: > > SELECT

On 15/08/2017 22:23, Noel Butler wrote: > On 15/08/2017 21:25, voytek at sbt.net.au wrote: > >> On Tue, August 15, 2017 8:03 pm, Sami Ketola wrote: >> On 15 Aug 2017, at 2.50, voytek at sbt.net.au wrote: >> >> how do I generate hashed string from my password ? >> use this sql command: >> >> GRANT SELECT ON vmail TO

On 15/08/2017 08:18, voytek at sbt.net.au wrote: > I've also dumped MySQL 'vmail' and imported database, created user vmail, > vmailadmin > > Aug 15 08:05:31 auth-worker(9763): Error: mysql(127.0.0.1): Connect failed > to database (vmail): Access denied for user 'vmail'@'localhost' (using > password: YES) - waiting for 1 seconds before retry Forget

On Fri, May 31, 2019 10:18 am, Ralph Seichter via dovecot wrote: > * Voytek Eymont via dovecot: > Try runing "sievec -u {your_linux_user} /path/to/whatever.sieve" from a > shell and check the resulting error messages. Raplh, thanks so, am I'm missing sql lookup for sieve...? # sievec -u voytek dovecot.sieve sievec(voytek)<9667><>: Error: user voytek: Auth

On 15/08/2017 21:25, voytek at sbt.net.au wrote: > On Tue, August 15, 2017 8:03 pm, Sami Ketola wrote: > On 15 Aug 2017, at 2.50, voytek at sbt.net.au wrote: > > how do I generate hashed string from my password ? > use this sql command: > > GRANT SELECT ON vmail TO 'vmail'@'127.0.0.1' IDENTIFIED BY > PASSWORD('yourpassword'); > > or if you

On Sat, June 1, 2019 8:47 am, Voytek Eymont via dovecot wrote: I'm still not sure what/where am I missing...? do I need some tables in the mailbox sql file ...? or where is the extra 'c' from ? "Unknown column 'mailbox.enablesievec'" I currently have like in mailbox table: ... enablelda | tinyint(1) | NO | MUL | 1 |

installed new Dovecot 2.2 on Centos 7, and, migrated some users from old server # dovecot --version 2.2.33.2 (d6601f4ec) works OK, but, noticed some sql and index.cache errors what am I missing ? only noticed this one so far ------------------ # grep "Too many open files" /var/log/dovecot.log Jan 02 15:22:16 auth-worker(1411): Warning: mysql: Query failed, retrying: Got error 24

since moving/upgrading system I've noticed I no longer get sieve script compiled, there is no dovecot.svbin created in /var/vmail/vmail1/sbt.net.au/voytek at tld.au/sieve what am I missing, how to check ? also, looking at sieve.log, I see a lot of May 31 06:32:50 lda(voytek at sbt.net.au)<1234><c4aVBfI98FzSBAAAyLbbsQ>: Error: sieve: Failed to initialize script execution: Invalid

Please read between the lines =) at least you should remove autocreate plugin. > On December 15, 2017 at 4:47 PM voytek at sbt.net.au wrote: > > > I have an old Centos 6 running dovecot 2.1.17 with Postfix 2.1x, mysql > virtual domains, in the process of setting a new Centos 7 to migrate, > copied /etc/dovecot, made some minor edits to get rid of errors, added >

On Thu, August 17, 2017 5:03 pm, Aki Tuomi wrote: > >> On August 17, 2017 at 8:56 AM voytek at sbt.net.au wrote: > > autocreate and autosubscribe are moved under mailbox settings > > namespace { mailbox FooBox { auto = create } > mailbox Trash { auto = subscribe } > } Aki, thanks I've inserted it, but, maybe not in the correct place ? Aug 17 17:22:43 imap(ve at

I have an old Centos 6 running dovecot 2.1.17 with Postfix 2.1x, mysql virtual domains, in the process of setting a new Centos 7 to migrate, copied /etc/dovecot, made some minor edits to get rid of errors, added Letsencrypt in place of self certified certs, it seems to work, using mail client I can log on StartSSL/110/143, TLS/995/993 with no visible errors when login on is there any other sanity

> On 15 Aug 2017, at 2.50, voytek at sbt.net.au wrote: > > how do I generate hashed string from my password ? use this sql command: GRANT SELECT ON vmail TO ?vmail?@?127.0.0.1? IDENTIFIED BY PASSWORD(?yourpassword?); or if you just want to see the hash: SELECT PASSWORD(?yourpassword?); Sami

I'm trying to move from my exising server to a new site. In preparation for this I've set up the new server as per the first attachment. I've added additional (temporary) setting to the new site as per these instructions https://wiki2.dovecot.org/Migration/Dsync but when I try to do a backup with the following command from the old to the new site sudo doveadm -D -o

Am 30.12.18 um 10:53 schrieb Sami Ketola: > >> On 29 Dec 2018, at 23.49, Hans Brage <hans at plattformen.se> wrote: >> >> Hi! >> >> I'm currently running an small imap-server on Dovecot 2.2.4 but will retire that server. I've set up an new server with Dovecot 2.3.4 and will migrate the mailboxes (maildir-format) from the old to the new server.

On 8.3.2019 14.07, Voytek Eymont wrote: > On Fri, March 8, 2019 10:45 pm, Aki Tuomi via dovecot wrote: >> On 8.3.2019 13.44, Voytek Eymont via dovecot wrote: >> >>> I have Centos 7 with dovecot/postfix/mysql Maildir >>> >>> >>> I want to bring in a new server, new server will have same hostname as >>> current, but, different IP

On Sat, December 16, 2017 2:34 am, Aki Tuomi wrote: > Please read between the lines =) > at least you should remove autocreate plugin. Aki, thanks. I forgot to write this is meant as a plain vanilla pop/imap multi user/multi domain server, no special requirements or deviations should be needed >> mail_gid = 2000 mail_location = maildir:/%Lh/Maildir/:INDEX=/%Lh/Maildir/ >>

Thanks! That was a really useful answer. // Hans Den 2018-12-30 kl. 10:53, skrev Sami Ketola: >> On 29 Dec 2018, at 23.49, Hans Brage <hans at plattformen.se> wrote: >> >> Hi! >> >> I'm currently running an small imap-server on Dovecot 2.2.4 but will retire that server. I've set up an new server with Dovecot 2.3.4 and will migrate the mailboxes

I have Centos 7 with dovecot/postfix/mysql Maildir I want to bring in a new server, new server will have same hostname as current, but, different IP I was intending to rsync -avzhe ssh vmail at oldserver:/var/vmail/vmail1 /var/vmail/vmail1 and, then, re run as necessary when/if mail still arrives on old server is that "a good plan" ...? TIA, V

On Fri, March 8, 2019 10:45 pm, Aki Tuomi via dovecot wrote: > > On 8.3.2019 13.44, Voytek Eymont via dovecot wrote: > >> I have Centos 7 with dovecot/postfix/mysql Maildir >> >> >> I want to bring in a new server, new server will have same hostname as >> current, but, different IP >> >> I was intending to >> rsync -avzhe ssh vmail at