Question about mail_location

2017-08-15 Thread Laura Steynes
In using mysql, in the configuration file we need to specify, in the user query, '/path/ as home, yet but in dovecot.conf, we also are setting mail_location, the same thing is it not, so unless I've missed something, do we still need to use the path as home in the user query? Do we only need set

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

2017-08-15 Thread voytek
On Wed, August 16, 2017 7:50 am, Noel Butler wrote: > On 15/08/2017 22:58, voy...@sbt.net.au wrote: > Use: CRYPT > This allows you to use whatever your system supports in your database > password fields, with modern OS's thats anything from md5 (shudder the > thought) to salted sha512 and

Re: namespace configuration error

2017-08-15 Thread Noel Butler
On 16/08/2017 04:31, Jeff Ross wrote: > namespace Snarf { > hidden = yes > list = no > location = mbox:/home/%u/mbox:INBOX=/var/spool/mail/%u:INDEX=MEMORY > prefix = ~~Snarfbox/ Is there supposed to be two tilde's here? (maybe perfectly valid, I haven't looked into it) > separator = / > } >

Re: Failback mailboxes?

2017-08-15 Thread Matt Bryant
hmm if message cannot be written to disk surely it remains on mda queue as not delviered and does not just disappear ? or am i reading this wrong ?! > Dag Nygren > 16 August 2017 at 7:14 am > Thanks for all the advice on how to configure systemd > not to loose my emails

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

2017-08-15 Thread Noel Butler
On 15/08/2017 22:58, voy...@sbt.net.au wrote: > On Tue, August 15, 2017 10:27 pm, Noel Butler wrote: > >> HUH? >> Are you trying to login to mysql using the hash itself? > > Noel, thanks!! > > oops, misunderstood instruction... > > this is better: > > USER voy...@x.tld > +OK > PASS

Re: Failback mailboxes?

2017-08-15 Thread Dag Nygren
Thanks for all the advice on how to configure systemd not to loose my emails after every update. Much appreciated. But there could be other reasons for the mailboxes not being writable and what I am really asking for is for dovecot-lda not to loose the incoming emails into thin air in these

v2.2.32 release candidate released

2017-08-15 Thread Timo Sirainen
https://dovecot.org/releases/2.2/rc/dovecot-2.2.32.rc1.tar.gz https://dovecot.org/releases/2.2/rc/dovecot-2.2.32.rc1.tar.gz.sig There are various changes in this release that can be used to significantly reduce disk IO with: 1) NFS storage especially, but I guess also other remote filesystems

namespace configuration error

2017-08-15 Thread Jeff Ross
I've got a few errors I'm trying to track down, probably all related... Aug 15 14:03:14 xyzzy dovecot: imap-login: Login: user=, method=PLAIN, rip=100.8.22.62, lip=132.238.254.34, mpid=4803, TLS, session= Aug 15 14:03:14 xyzzy dovecot: imap(jeff): Error: namespace configuration

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

2017-08-15 Thread voytek
On Tue, August 15, 2017 10:27 pm, Noel Butler wrote: > HUH? > Are you trying to login to mysql using the hash itself? Noel, thanks!! oops, misunderstood instruction... this is better: USER voy...@x.tld +OK PASS ** +OK Logged in. LIST +OK 0 messages: > That wont work, and its not

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

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

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

2017-08-15 Thread Noel Butler
On 15/08/2017 21:25, voy...@sbt.net.au wrote: > On Tue, August 15, 2017 8:03 pm, Sami Ketola wrote: > On 15 Aug 2017, at 2.50, voy...@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

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

2017-08-15 Thread voytek
On Tue, August 15, 2017 9:31 pm, Ivan Warren wrote: > MariaDB [test]> GRANT SELECT on test to 'test'@'127.0.0.1' identified by > >> pasword('test1234'); ERROR 1064 (42000): You have an error in your SQL >> syntax; check the manual that corresponds to your MariaDB server version >> for the right

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

2017-08-15 Thread voytek
> the other one gives syntax error: > > MariaDB [(none)]> GRANT SELECT on test to 'test'@'127.0.0.1' identified > by pasword('test1234'); ERROR 1046 (3D000): No database selected > MariaDB [(none)]> use test; > Database changed > MariaDB [test]> GRANT SELECT on test to 'test'@'127.0.0.1'

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

2017-08-15 Thread voytek
On Tue, August 15, 2017 8:03 pm, Sami Ketola wrote: > >> On 15 Aug 2017, at 2.50, voy...@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

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

2017-08-15 Thread Sami Ketola
> On 15 Aug 2017, at 2.50, voy...@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

Re: Metrics service

2017-08-15 Thread Sami Ketola
> On 14 Aug 2017, at 18.16, Matt Simpson wrote: > > >> On Aug 14, 2017, at 5:42 AM, Aki Tuomi wrote: >> >> Hi! >> >> We are open for any feedback, questions or comments for this service. >> > > Two questions. First one is I guess just a newbie