- dovecot - dovecot.org

Re: migrating 2.1 to 3.x, sql pass scheme, pass value?
by voytek＠sbt.net.au 15 Aug '17

15 Aug '17

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 syntax to use near 'pasword('test1234')' at line 1 MariaDB >> [test]> >> > A bit OT but... > > > It's either identified by 'YourPassword'; > or Identified by password 'YourPasswordHash'; > > > https://dev.mysql.com/doc/refman/5.7/en/create-user.html Ivan, thanks! syntax fixed, I'll try as root MariaDB [test]> GRANT SELECT on test to 'test'@'127.0.0.1' identified by 'test1234'; ERROR 1142 (42000): GRANT command denied to user 'test'@'localhost' for table 'test' MariaDB [test]> GRANT SELECT on test to 'test'@'127.0.0.1' identified by password'*3D3B92F242033365AE5BC6A8E6FC3E1679F4140A'; ERROR 1142 (42000): GRANT command denied to user 'test'@'localhost' for table 'test'

1 0

Metrics service
by Aki Tuomi 15 Aug '17

15 Aug '17

Hi! All of you running dovecot v2.2.27 or later, are now able to take advantage of our free metrics service at https://metrics.dovecot.org. To use it, set auth_stats=yes mail_plugins = $mail_plugins stats stats_carbon_server = 94.237.81.63 # or stats_carbon_server = [2a04:3542:1000:910:acc1:5bff:fe5e:8c2] stats_carbon_name = some-fancy-identifier-without-a-dot plugin { stats_refresh = 30s } And your server should become listed once someone logs in. Note that it will only work from backends today, it will not work from proxies or directors. This service is provided for free, and we might add or remove metrics from it. Please do not spam it (keep refresh and stats_carbon_interval *AT LEAST* 30 seconds). Also note that since this is a public service, all stats are viewable by anyone. We are open for any feedback, questions or comments for this service. Regards, Aki Tuomi Dovecot oy

3 2

Mailbox Alias
by zyrixx 15 Aug '17

15 Aug '17

Hello, I have dovecot with Outlook and Roundcube in the employment and with me the Mailboxaliase does not work. The folders are still different and each client creates its own. I thought that the aliases then fell away. Even on a new test system is not. local.conf: namespace inbox { mailbox Sent { auto = create # or subscribe special_use = \Sent } mailbox Trash { auto = create special_use = \Trash } } mail_plugins = $mail_plugins mailbox_alias plugin { mailbox_alias_old = Trash mailbox_alias_new = Deleted mailbox_alias_old2 = Sent mailbox_alias_new2 = Sendet mailbox_alias_old3 = Trash mailbox_alias_new3 = Gel&APY-schte Elemente mailbox_alias_old4 = Sent mailbox_alias_new4 = Gesendete Elemente mailbox_alias_old5 = Trash mailbox_alias_new5 = Trasher mailbox_alias_old6 = Sent mailbox_alias_new6 = Sender } Does somebody has any idea? Tanks for all.

3 4

Latest Virtual Plugin changes seem to have broken flag changes: 2.2.devel (bf2fa36)
by Thomas Leuxner 14 Aug '17

14 Aug '17

Hi, I’m using several views like this: # cat Dovecot/dovecot-virtual :public/Archive/Mailing-Lists/Dovecot/* :public/Mailing-Lists/Dovecot all Before the recent changes read mail stayed in sync with the virtual folder. Now regardless whether mail is read in the original Folder or the virtual Folder, the flags are not synchronized anymore. Read mail is flagged unread in the corresponding folder. Regards Thomas

2 6

Postfix+PostfixAdmin+Dovecot
by Randy Gordey 14 Aug '17

14 Aug '17

I got postfix and PostfixAdmin working and I am trying to get Dovecot to use the same SQL databases. This is all it says when I telnet in: [root@fedora dovecot]# telnet 192.168.1.200 143 Trying 192.168.1.200... Connected to 192.168.1.200. Escape character is '^]'. * BYE Disconnected: Auth process broken Connection closed by foreign host. [root@fedora dovecot]# Please help me diagnose what is wrong? [root@fedora dovecot]# dovecot --version 2.2.31 (65cde28) [root@fedora dovecot]# [root@fedora dovecot]# dovecot -n # 2.2.31 (65cde28): /etc/dovecot/dovecot.conf doveconf: Warning: NOTE: You can get a new clean config file with: doveconf -n > dovecot-new.conf doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:128: protocol { ssl_listen } has been replaced by service { inet_listener { address } } # OS: Linux 4.11.11-300.fc26.x86_64 x86_64 Fedora release 26 (Twenty Six) auth_default_realm = gordeys.com auth_mechanisms = plain login disable_plaintext_auth = no first_valid_uid = 2222 listen = * mail_location = maildir:/var/mail/vmail/%u/ mbox_write_locks = fcntl namespace inbox { inbox = yes location = mailbox Drafts { special_use = \Drafts } mailbox Junk { special_use = \Junk } mailbox Sent { special_use = \Sent } mailbox "Sent Messages" { special_use = \Sent } mailbox Trash { special_use = \Trash } prefix = } passdb { driver = pam } passdb { args = /etc/dovecot/dovecot-sql.conf driver = sql } service imap-login { inet_listener imaps { address = * } } service pop3-login { inet_listener pop3s { address = * } } ssl_cert = </etc/pki/dovecot/certs/dovecot.pem ssl_cipher_list = PROFILE=SYSTEM ssl_key = # hidden, use -P to show it userdb { driver = passwd } userdb { args = /etc/dovecot/dovecot-sql.conf driver = sql } [root@fedora dovecot]# [root@fedora dovecot]# more dovecot-sql.conf connect = host=localhost dbname=postfix user=postfix password=postfix # Use either driver = mysql # Or # driver = pgsql # Default password scheme - change to match your Postfixadmin setting. # depends on your $CONF['encrypt'] setting: # md5crypt -> MD5-CRYPT # md5 -> PLAIN-MD5 # cleartext -> PLAIN default_pass_scheme = MD5-CRYPT # Query to retrieve password. user can be used to retrieve username in other # formats also. password_query = SELECT username AS user,password FROM mailbox WHERE username = '%u' AND active='1' # Query to retrieve password. user can be used to retrieve username in other # formats also. password_query = SELECT username AS user,password FROM mailbox WHERE username = '%u' AND active='1' # Query to retrieve user information, note uid matches dovecot.conf AND Postfix virtual_uid_maps param eter. user_query = SELECT maildir, 1001 AS uid, 1001 AS gid FROM mailbox WHERE username = '%u' AND active='1 ' # MYSQL : user_query = SELECT CONCAT('/var/vmail/mail/', maildir) AS home, 1001 AS uid, 1001 AS gid, CONCAT('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = '%u' AND active='1' # PostgreSQL : (no Quota though) : # user_query = SELECT '/var/vmail/mail/' || maildir AS home, 1001 as uid, 1001 as gid FROM mailbox WHE RE username = '%u' AND active = '1' [root@fedora dovecot]#

1 0

Re: Certificate cache on iOS with sending mail
by Alef Veld 14 Aug '17

14 Aug '17

Sent from my iPhone > On 14 Aug 2017, at 13:03, Alef Veld <alefveld(a)outlook.com> wrote: > > Hey Mike. > The iPhone and MacBook started working, but the two remaining iMacs still have problems. It's really weird. But if the first 2 are working it MUST be something local right? > > I removed the servers and re-added but no go. Maybe I'll need to remove the plist files. I'm just desperate as I have clients that are working. > > Sent from my iPhone > >> On 14 Aug 2017, at 07:48, Mike Bobkiewicz <netadmin(a)heinatz.hamburg> wrote: >> >> Hi Alef, >> >> most of the times the problem is with Apple´s Mail apps: best bet is to delete the smtp servers on both Mac and iOS and add them again. I´ve spend quite some time figuring out what might be wrong with serveral mail servers but sometimes the Mail apps just kill their prefs. >> >> If you´re still searching the certs on the Mac side: They´re stored in the key chain. >> >> Hope that helps, >> >> Mike >> >> >>> Am 11.08.2017 um 01:15 schrieb Alef Veld: >>> And iPhone just sits there for a long time, "sending". Sometimes it goes through sometimes it doesn't. >>> >>> It's super weird but it has to do with SSL_accept and not reading the message fully. >>> >>> I might restore my old certs see if that solves it. I'll try some other clients and ip addresses as well, outlook or something. >>> >>> Sent from my iPhone >>> >>>> On 11 Aug 2017, at 00:08, Alef Veld <alefveld(a)outlook.com> wrote: >>>> >>>> I deleted the certificate already, but I think it only uses that for imap/dovecot. I don't think it actually stores one for smtps (or am I not talking sense here). >>>> >>>> Sent from my iPhone >>>> >>>>> On 10 Aug 2017, at 23:25, Joseph Tam <jtam.home(a)gmail.com> wrote: >>>>> >>>>> >>>>>> On Thu, 10 Aug 2017, Larry Rosenman wrote: >>>>>> >>>>>> Which mail client on iOS? >>>>> Sorry, maybe not iOS, but definitely MacOSX Mail app. >>>>> >>>>> Joseph Tam <jtam.home(a)gmail.com> >> >> -- >> Mit freundlichen Grüßen >> >> Mike Bobkiewicz >> Heinatz GmbH >> >> Gutenbergring 9 >> 22848 Norderstedt >> >> 0049 40 527 20 30 >> 0049 40 527 86 49 >> >> e-mail: netadmin(a)heinatz.hamburg >> www.heinatz.hamburg >> >> Heinatz GmbH >> Firmensitz: Gutenbergring 9, 22848 Norderstedt >> Registergericht: Amtsgericht Kiel, HRB 4787 NO >> Geschäftsführer: Frank Heinatz >> >>

1 0

Puzzled about LIST "" * behaviour
by Benoit Panizzon 14 Aug '17

14 Aug '17

Hi there I'm preparing to copy emails from one dovecot to another dovecot server via imapsync. Now imapsync does not get the folder list. So I sniffed the connection and I am trying to reproduce via telnet. I do via different concurrent connections. . login user password . list "" * Now this is what completely puzzles me. sometimes I get the list of all folders, sometimes I only get the INBOX imapsync seems to only ever get the INBOX and no other folders. But I type in the very same commands! I have not yet figured out what sometimes causes me to get the full list and sometimes only a partial one. Is it some timing issue? Does it matter if the user is already logged in from another ip? Any hints welcome. -Benoît Panizzon- -- I m p r o W a r e A G - Leiter Commerce Kunden ______________________________________________________ Zurlindenstrasse 29 Tel +41 61 826 93 00 CH-4133 Pratteln Fax +41 61 826 93 01 Schweiz Web http://www.imp.ch ______________________________________________________

1 0

[Dovecot] [PATCH, RFC] add APOP authentication mechanism
by Andrey Panin 14 Aug '17

14 Aug '17

Hello all, this patch add APOP authentication mechanism to dovecot 1.0-test23. Please take a look. Best regards. -- Andrey Panin | Linux and UNIX system administrator pazke(a)donpac.ru | PGP key: wwwkeys.pgp.net

3 2

(Solved) Re: Upgrade path from MySQL to MariaDB broken? (Akonadi)
by Volker Wysk 14 Aug '17

14 Aug '17

Hello! I've found it out, how you can solve/work around the problem: Nextcloud needs MariaDB. It won't work (so it seems) with MySQL. So mariadb- server needs to be installed. This replaces MySQL (mysql-server-core-5.7 and mysql-client-core-5.7) with MariaDB. The problem is that after that, Akonadi won't start any longer. "aconadictl start" outputs a lot of messages. The problem can be repaired by doing this, after the installation of MariaDB: akonadictl stop rm -r ~/.local/share/akonadi akonadictl start Bye, Volker

1 1

2.1 to 2.2.31 on new server?
by voytek＠sbt.net.au 13 Aug '17

13 Aug '17

I have a Centos 6 server with Dovecot 2.1.17/mysql/virtual domains I'm setting a new Centos 7 server, and, aim to install 2.2.31 from Ghetoforge dumb question, can I install 2.3 on new server, then, copy old /etc/dovecot tree to new /etc/dovecot ? appreciate any tips and advice, V

3 2