[SOGo] BTS activities for Saturday, November 24 2018
Title: BTS activities for Saturday, November 24 2018 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Saturday, November 24 2018 idlast updatestatus (resolution)categorysummary 941 2018-11-24 10:35:42 updated (open) Backend Calendar send invitations in quoted-printable encoding 3209 2018-11-24 08:00:09 updated (open) Web Preferences Skip ManageSieve sync if user has not modified filter Preferences -- users@sogo.nuhttps://inverse.ca/sogo/lists
AW: [SOGo] Performance BD (Mysql or Postgres)
Hello Marcus, first of all, thanks for your quick answer, secondly I'll complete my work collegue's e-mail for more information about our enviroment and necessities.Nowadays we have an enviroment with the followings components: Cyrus-Imap Agregator, being 5 Frontends and 5 Backends Postfix servers for SMTP and submission protocol Openldap servers PostrgeSQL data base Apache Web Servers We use as application a Groupware called expressobr, It is almost completly based on tine20 germany Groupware and we support around 10k users. Oficial SOGo document instalation has a PostrgeSQL approach then because of that and also because our enviroment, we are asking about any kind of recommendation regards database performance, specially If there is any favourite between PostgreSQL and MySQL. Best wishes. Thankful -- Miguel Moreira Gerente DPR/SRE/GSR - Gerência de Serviços de Rede +55(31)3339-1401 PRODEMGE - Companhia de Tecnologia da Informação do Estado de Minas Gerais Aviso: Esta mensagem é destinada exclusivamente para a(s) pessoa(s) a quem é dirigida, podendo conter informação sigilosa e legalmente protegida. O uso impróprio será tratado conforme as normas da empresa e a legislação em vigor. Caso não seja o destinatário, favor notificar o remetente, ficando proibidas a utilização, divulgação, cópia e distribuição. Em Sábado, Novembro 24, 2018 09:23 -02, "Michael Hekeler" (mich...@hekeler.com) escreveu: "Performance"...regarding what? For example if you don't know how to use mysql but are confident with postgresql then postgresql "performs" much better for you.Von: "Wilton Cesar Goncalves" (wilton.goncal...@prodemge.gov.br)Gesendet: Freitag, 23. November 2018 15:30An: users@sogo.nuAntwort an: users@sogo.nuBetreff: [SOGo] Performance BD (Mysql or Postgres) Hello, I'm installing SOGo in my company and I'd like to know what BD is better in performance Mysql or Postgres? Thanks, -- Wilton César GonçalvesGSR - Gerência de Serviços de Rede Companhia de Tecnologia da Informação do Estado de Minas Gerais - PRODEMGE Aviso: Esta mensagem é destinada exclusivamente para a(s) pessoa(s) a quem é dirigida, podendo conter informação sigilosa e legalmente protegida. O uso impróprio será tratado conforme as normas da empresa e a legislação em vigor. Caso não seja o destinatário, favor notificar o remetente, ficando proibidas a utilização, divulgação, cópia e distribuição. -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
AW: [SOGo] Performance BD (Mysql or Postgres)
Michael not Marcus. Sorry by my mistake. Thanks -- Miguel Moreira Gerente DPR/SRE/GSR - Gerência de Serviços de Rede +55(31)3339-1401 PRODEMGE - Companhia de Tecnologia da Informação do Estado de Minas Gerais Aviso: Esta mensagem é destinada exclusivamente para a(s) pessoa(s) a quem é dirigida, podendo conter informação sigilosa e legalmente protegida. O uso impróprio será tratado conforme as normas da empresa e a legislação em vigor. Caso não seja o destinatário, favor notificar o remetente, ficando proibidas a utilização, divulgação, cópia e distribuição. Em Sábado, Novembro 24, 2018 22:56 -02, "Miguel Mucio Santos Moreira" escreveu: Hello Marcus, first of all, thanks for your quick answer, secondly I'll complete my work collegue's e-mail for more information about our enviroment and necessities.Nowadays we have an enviroment with the followings components: Cyrus-Imap Agregator, being 5 Frontends and 5 Backends Postfix servers for SMTP and submission protocol Openldap servers PostrgeSQL data base Apache Web Servers We use as application a Groupware called expressobr, It is almost completly based on tine20 germany Groupware and we support around 10k users. Oficial SOGo document instalation has a PostrgeSQL approach then because of that and also because our enviroment, we are asking about any kind of recommendation regards database performance, specially If there is any favourite between PostgreSQL and MySQL. Best wishes. Thankful -- Miguel Moreira Gerente DPR/SRE/GSR - Gerência de Serviços de Rede +55(31)3339-1401 PRODEMGE - Companhia de Tecnologia da Informação do Estado de Minas Gerais Aviso: Esta mensagem é destinada exclusivamente para a(s) pessoa(s) a quem é dirigida, podendo conter informação sigilosa e legalmente protegida. O uso impróprio será tratado conforme as normas da empresa e a legislação em vigor. Caso não seja o destinatário, favor notificar o remetente, ficando proibidas a utilização, divulgação, cópia e distribuição. Em Sábado, Novembro 24, 2018 09:23 -02, "Michael Hekeler" (mich...@hekeler.com) escreveu: "Performance"...regarding what? For example if you don't know how to use mysql but are confident with postgresql then postgresql "performs" much better for you.Von: "Wilton Cesar Goncalves" (wilton.goncal...@prodemge.gov.br)Gesendet: Freitag, 23. November 2018 15:30An: users@sogo.nuAntwort an: users@sogo.nuBetreff: [SOGo] Performance BD (Mysql or Postgres) Hello, I'm installing SOGo in my company and I'd like to know what BD is better in performance Mysql or Postgres? Thanks, -- Wilton César GonçalvesGSR - Gerência de Serviços de Rede Companhia de Tecnologia da Informação do Estado de Minas Gerais - PRODEMGE Aviso: Esta mensagem é destinada exclusivamente para a(s) pessoa(s) a quem é dirigida, podendo conter informação sigilosa e legalmente protegida. O uso impróprio será tratado conforme as normas da empresa e a legislação em vigor. Caso não seja o destinatário, favor notificar o remetente, ficando proibidas a utilização, divulgação, cópia e distribuição. -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Unicode characters in the headers
On 2018-11-24 13:21, André Rodier wrote: Hello, I am using SOGo 3 on Debian Stretch. When an email alert for a calendar event is sent to me by SOGo, my name (André Rodier) is displayed as this: "=?utf-8?q?Andr=C3=A9?= Rodier" How can I avoid this,? Thanks for your help. André Rodier This might be a bug in SOGo, as the header is encoded twice with the quoted-printable scheme. Here the source of the original message: --- Return-Path: Received: from osaka.rodier.me by osaka.office.pmc with LMTP id eAczFqbJ+VuoZQAAnYgw/w ; Sat, 24 Nov 2018 21:59:02 + Received: from osaka.rodier.me (localhost [127.0.0.1]) by osaka.rodier.me (Postfix) with ESMTP id 45BF2208D3 for ; Sat, 24 Nov 2018 21:59:02 + (GMT) Received: from localhost (localhost [127.0.0.1]) by osaka.rodier.me (Postfix) with ESMTP id 25BC6208CD for ; Sat, 24 Nov 2018 21:59:02 + (GMT) To: =?utf-8?q?=3D=3Futf-8=3Fq=3FAndr=3DC3=3DA9=3F=3D_Rodier?= X-Priority: 1 Subject: Yo Importance: high MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <6668-5bf9c9a6-1-1bbecc54@189782116> Content-Type: text/plain; charset="utf-8" From: =?utf-8?q?=3D=3Futf-8=3Fq=3FAndr=3DC3=3DA9=3F=3D_Rodier?= Date: Sat, 24 Nov 2018 21:59:02 + User-Agent: SOGo Alarms Notifier/1.0 X-AV-Checked: ClamSMTP (Client IP: 127.0.0.1) eryhwhw wrthwthwthwht wrthwthwhwthw --- As a result, the email client displays the "To" field decoded once, which left an encoded header. This is only happening when the reminders are sent, not when an event is created. -- https://github.com/progmaticltd/homebox -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] AppArmor for sogod
Hello, I am building an AppArmor profile for SOGo (Debain Stretch / Sogo 3.2.6-2), and in complain mode, I have this log entry: - Nov 24 20:26:56 osaka kernel: audit: type=1400 audit(1543091216.708:3689): apparmor="DENIED" operation="getattr" profile="/usr/sbin/sogod" name="/" pid=3288 comm="sogod" requested_mask="r" fsuid=132 ouid=0 - Why the SOGo daemon is reading the attributes of the root folder "/" on start ? -- https://github.com/progmaticltd/homebox -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] AppArmor for sogod
On 2018-11-24 20:32, André Rodier wrote: Hello, I am building an AppArmor profile for SOGo (Debain Stretch / Sogo 3.2.6-2), and in complain mode, I have this log entry: - Nov 24 20:26:56 osaka kernel: audit: type=1400 audit(1543091216.708:3689): apparmor="DENIED" operation="getattr" profile="/usr/sbin/sogod" name="/" pid=3288 comm="sogod" requested_mask="r" fsuid=132 ouid=0 - Why the SOGo daemon is reading the attributes of the root folder "/" on start ? Again, the same issue, when the sogo alarm notify script is started: --- Nov 24 21:48:01 osaka audit[23806]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/sogo-ealarms-notify" name="/" pid=23806 comm="sogo-ealarms-no" requested_mask="r" denied_mask="r" fsuid=132 ouid=0 Nov 24 21:48:01 osaka kernel: audit: type=1400 audit(1543096081.831:5072): apparmor="DENIED" operation="open" profile="/usr/sbin/sogo-ealarms-notify" name="/" pid=23806 comm="sogo-ealarms-no" requested_mask="r" denied_mask="r" fsuid=132 ouid=0 --- -- https://github.com/progmaticltd/homebox -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Convert quoted-printable headers
On 2018-11-24 15:52, Richard Damon wrote: On 11/24/18 10:24 AM, André Rodier wrote: On 2018-11-24 15:16, Richard Damon wrote: On 11/24/18 9:41 AM, André Rodier wrote: Hello, I have a program (SOGo), installed on my mail server, that send emails using the quoted-printable encoding for From/To headers. Unfortunately, none of the email clients I use seems to display them correctly: --- From =?utf-8?q?Andr=C3=A9?= Rodier To =?utf-8?q?Andr=C3=A9?= Rodier --- Is there any reason for that ? is a header missing: Thanks for your help André Rodier First, are your clients compliant with the RFC that define encoding of headers (which are later/less supported than those that define the encoding of the body)? For example, RFC 2047 (I think the latest RFC that defines this encoding). I don't think you need any header to enable this support, just a compliant MUA. Thanks for your answer. I would think it is a bug in the SOGo software, because other emails are using quoted-printable too, but are displayed correctly, for instance this one: Return-Path: Received: from osaka.rodier.me by osaka.office.pmc with LMTP id 0P2UH/1p+VvAFAAAnYgw/w ; Sat, 24 Nov 2018 15:10:53 + Received: from osaka.rodier.me (localhost [127.0.0.1]) by osaka.rodier.me (Postfix) with ESMTP id 6406A2063B for ; Sat, 24 Nov 2018 15:10:53 + (GMT) Received: by osaka.rodier.me (Postfix, from userid 132) id 431B720662; Sat, 24 Nov 2018 15:10:53 + (GMT) Content-Type: text/html; charset="utf-8" To: =?utf-8?q?Andr=C3=A9_Rodier?= MIME-Version: 1.0 Date: Sat, 24 Nov 2018 15:10:53 + Subject: The event =?utf-8?q?=22Hello=22?= was created Message-ID: <1403-5bf96a00-5-79d0b280@98295310> From: =?utf-8?q?Andr=C3=A9_Rodier?= X-AV-Checked: ClamSMTP (Client IP: 127.0.0.1) Fortunately, Thunderbird, Evolution and Roundcube are behaving the same. I use Thunderbird myself, and your message displays fine. The one difference I see is that the character set and encoding in your mail client is coming in upper case, while the example has it in lower case. I thought the RFC said that this was case insensitive, but maybe some implementations are case sensitive. I forgot to mention something important. The first copied line are a copy as they are displayed in the email client. The raw headers: Return-Path: Received: from osaka.rodier.me by osaka.office.pmc with LMTP id mE3/EPJu+VtmHgAAnYgw/w ; Sat, 24 Nov 2018 15:32:02 + Received: from osaka.rodier.me (localhost [127.0.0.1]) by osaka.rodier.me (Postfix) with ESMTP id 2CE4920664 for ; Sat, 24 Nov 2018 15:32:02 + (GMT) Received: from localhost (localhost [127.0.0.1]) by osaka.rodier.me (Postfix) with ESMTP id 0E6432063B for ; Sat, 24 Nov 2018 15:32:02 + (GMT) To: =?utf-8?q?=3D=3Futf-8=3Fq=3FAndr=3DC3=3DA9=3F=3D_Rodier?= X-Priority: 1 Subject: test Importance: high MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <25d7-5bf96ef1-1-7d77729b@234960090> Content-Type: text/plain; charset="utf-8" From: =?utf-8?q?=3D=3Futf-8=3Fq=3FAndr=3DC3=3DA9=3F=3D_Rodier?= Date: Sat, 24 Nov 2018 15:32:01 + User-Agent: SOGo Alarms Notifier/1.0 X-AV-Checked: ClamSMTP (Client IP: 127.0.0.1) So, yes, the message is encoded twice... -- https://github.com/progmaticltd/homebox -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] How to add contact to addressbook from email view?
I'm trying to add a contact to addressbook from email view or email compose. There is no drop down or any option that I see that would let me add someone to my personal addressbook. Is there no way to add someone without manually going to addressbook tab and clicking add new addressbook card and manually entering the information? -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Convert quoted-printable headers
On 2018-11-24 15:26, Matus UHLAR - fantomas wrote: On 24.11.18 14:41, André Rodier wrote: I have a program (SOGo), installed on my mail server, that send emails using the quoted-printable encoding for From/To headers. this is not a postfix issue, it belongs to the sogo support, not postfix. Unfortunately, none of the email clients I use seems to display them correctly: --- From=?utf-8?q?Andr=C3=A9?= Rodier To =?utf-8?q?Andr=C3=A9?= Rodier --- Is there any reason for that ? To: =?utf-8?q?=3D=3Futf-8=3Fq=3FAndr=3DC3=3DA9=3F=3D_Rodier?= this looks to me like encoded twice, so all clients that decode it once will show once encoded string. Thank you, I reached the same conclusion. Yes, I realise this is a bug in SOGo, I will continue the thread on this mailing list. André -- https://github.com/progmaticltd/homebox -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Changing main coulours
Hello, I am using SOGo3 on Debian Stretch. Is there a simple and quick way to change the main colours in the theme, please? This is a minor thing, so I will accept answers like "No". -- https://github.com/progmaticltd/homebox -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Unicode characters in the headers
Hello, I am using SOGo 3 on Debian Stretch. When an email alert for a calendar event is sent to me by SOGo, my name (André Rodier) is displayed as this: "=?utf-8?q?Andr=C3=A9?= Rodier" How can I avoid this,? Thanks for your help. André Rodier -- users@sogo.nu https://inverse.ca/sogo/lists
AW: [SOGo] Performance BD (Mysql or Postgres)
"Performance"...regarding what? For example if you don't know how to use mysql but are confident with postgresql then postgresql "performs" much better for you. Von: "Wilton Cesar Goncalves" (wilton.goncal...@prodemge.gov.br)Gesendet: Freitag, 23. November 2018 15:30An: users@sogo.nuAntwort an: users@sogo.nuBetreff: [SOGo] Performance BD (Mysql or Postgres)Hello, I'm installing SOGo in my company and I'd like to know what BD is better in performance Mysql or Postgres? Thanks,-- Wilton César GonçalvesGSR - Gerência de Serviços de RedeCompanhia de Tecnologia da Informação do Estado de Minas Gerais - PRODEMGE Aviso: Esta mensagem é destinada exclusivamente para a(s) pessoa(s) a quem é dirigida, podendo conter informação sigilosa e legalmente protegida. O uso impróprio será tratado conforme as normas da empresa e a legislação em vigor. Caso não seja o destinatário, favor notificar o remetente, ficando proibidas a utilização, divulgação, cópia e distribuição. -- users@sogo.nuhttps://inverse.ca/sogo/lists -- users@sogo.nuhttps://inverse.ca/sogo/lists
Re: [SOGo] ActiveSync: Search no longer shows more messages than "Sync Period" and inline images are not displayed
Thanks!
Meanwhile I'm trying to compile with patch you sent but is not an easy task
in CentOS..
Cheers
Il giorno ven 23 nov 2018, 23:40 "Thomas Fuehrer" ha
scritto:
> I’ve sent a few fixes to Ludovic for review….
>
>
>
> Regards,
>
> Thomas
>
>
>
> *Von:* users-requ...@sogo.nu *Im Auftrag von *Riccardo
> Bicelli
> *Gesendet:* Freitag, 23. November 2018 18:24
> *An:* users@sogo.nu
> *Betreff:* Re: [SOGo] ActiveSync: Search no longer shows more messages
> than "Sync Period" and inline images are not displayed
>
>
>
> Filed a bug.
>
> Meanwhile I found other messages that cause parsing errors.
>
>
>
> Cheers
>
>
>
> Il giorno ven 23 nov 2018, 17:03 Thomas Führer ha scritto:
>
> Received your mail with an "empty" attached. Can you please resend it, or
> file a bug and attach it ... what ever you prefere ...
>
> Thanks,
> Thomas
>
> Am Freitag, November 23, 2018 08:18 CET, "Riccardo Bicelli" (
> r.bice...@gmail.com) schrieb:
>
>
> Hi Thomas!
>
> Attached the message.
>
>
>
> For other problems regarding search, is it ok to file some bugs?
>
>
>
> Cheers!
>
>
>
> Il giorno gio 22 nov 2018 alle ore 21:01 Thomas Führer ha
> scritto:
>
> Riccardo, provide me the eml file. I can try to fix the xml parse error.
>
> Regards, Thomas
>
>
>
> Riccardo Bicelli schrieb
>
>
> Hi Thomas!
>
> Sure I can identify the message. If you need it can provide the .eml file
> from thunderbird.
>
>
>
> Doing my tests I found that, regardless of what I set in sogo.conf or in
> httpd config, if the search takes more than 30 seconds it throws error on
> Gmail App but search continues on sogo process.
>
> Isn't there a paged search option or a way to speedup search in dovecot
> with large mailboxes?
>
> Same behavior on IOS App.
>
> On outlook Side no way to test it due to the CollectionID=0 problem.
>
>
>
> Cheers!
>
> Riccardo
>
>
>
>
>
>
>
>
>
>
>
> Il giorno gio 22 nov 2018 alle ore 18:26 Thomas Führer ha
> scritto:
>
> Hi Riccardo,
> without access to to /tmp/rp_[masked]_dc4_21a6e764_0.data it's hard to
> find the problem.
>
> What you can try is to identify the original email with the content of
> /tmp/rp_[masked]_dc4_21a6e764_0.data.
> If you are able to tack down the problem to a specific mail you can then
> try rephrase the search pattern so that you get only that mail in the
> result.
> When you know the culprit mail you can try to identify the cause: a
> special formating, character,
>
> Regards,
> Thomas
>
> Am Donnerstag, November 22, 2018 14:41 CET, "Riccardo Bicelli" (
> r.bice...@gmail.com) schrieb:
>
>
> Hello, I went a little further.
>
> I moved to gmail app where I don't have the "CollectionID Problem".
>
>
>
> Using gmail app the IMAP Search rolls fine but at the time for response in
> the log appears
>
>
>
> [0x5574ec51ac58]: 995 OK Sort completed (0.000 secs).
>
> C[0x5574ec709a88]: 996 select "Archives/2015"
>
> S[0x5574ec51ac58]: * OK [CLOSED] Previous Nov 22 14:32:19 sogod [3524]:
> [ERROR] <0x0x5574ec557918[NGImap4Connection]> could not select URL:
> imaps://[MASKED]/Public/: {RawResponse = "{ResponseResult = {description =
> \"Mailbox doesn't exist: Public\"; result = no; tagId = 1000; }; ok =
> {CLOSED = \"Previous mailbox closed.\"; }; }"; reason = "Mailbox doesn't
> exist: Public"; result = 0; }
>
> Nov 22 14:32:20 sogod [3524]: [ERROR] <0x0x5574f13b17c8[NSDataMalloc]>
> xml2wbxmlFromContent: failed: Parsing of XML Document Failed
>
>
>
> Checking document with xmllint:
>
>
>
> xmllint --format /tmp/rp_[masked]_dc4_21a6e764_0.data
>
> /tmp/rp_[masked]_dc4_21a6e764_0.data:450: parser error : PCDATA invalid
> Char value 4
>
> ef=
> https://twitter.com/share?mid=41847eid=CVMWR09023319text=
>
>
> ^
>
> /tmp/rp_[masked]_dc4_21a6e764_0.data:8960: parser error : PCDATA invalid
> Char value 4
>
> quot; data-imagelibrary=%7B%22width%3A0 ꊧ
> 4.642275e-310ight%3A0
>
>
> ^
>
> /tmp/rp_[masked]_dc4_21a6e764_0.data:9680: parser error : PCDATA invalid
> Char value 4
>
> quot; data-imagelibrary=%7B%22width%3A0 Ý
> 4.642275e-310ight%3A0
>
>
>
> Any help appreciated
>
>
>
> Cheers
>
> Riccardo
>
>
>
> Il giorno mar 20 nov 2018 alle ore 14:52 Thomas Führer ha
> scritto:
>
> Hi,
> can you try to find out under what circumstands the CollectionId=0 is
> included by the Outlook mobile app.
> If there is no CollectionId in the search request the server will search
> all folders. This could take longer than the client is willing to wait ...
> which then could result in the error you have mentioned.
> Does the problem always occure, regadless how large the mailbox is and how
> main imap-folder exists in the mailbox?
>
> I think that processSearchMailbox needs to be changed to avoid looping
> over all folders and to return after the requested number of mails have
> been found.
>
> Regards,
> Thomas
>
> Am Montag, November 19, 2018 19:29 CET, "Riccardo Bicelli" (
> r.bice...@gmail.com) schrieb:
>
>
> Hi!
>
> When searching in Gmail App the search through imap begins but after some
> seconds
