RE: [SOGo] strange problem with just one user's personal address book

[Kai-Uwe Rommel - ARS]

Ok, running the database upgrade script again probably fixed it ... although it 
complained
"Duplicate column name 'c_hascertificate'" so it already has been there? Hmm.

Kai-Uwe Rommel


From: Kai-Uwe Rommel - ARS
Sent: Friday, May 6, 2022 10:05 AM
To: users@sogo.nu
Subject: strange problem with just one user's personal address book

Hi, I'm running an old 2.4 SOGo server and have a strange problem:
Several users use e-mail, calendar and contacts. They mostly use Thunderbird on 
the PC
with IMAP/CalDAV/CardDAV, some also use the browser interface and most have a
smartphone connected to the same data via ActiveSync. All those work fine but 
for one
user the contacts "do not work":

The user has 76 contacts, created from Thunderbird, originally in Thunderbirds 
local
address book. I have helped the user and exported the contacts, connected the
SOGo personal address book into his Thunderbird via the CardDAV URL and imported
the contacts into this. No error or warnings. The contacts are visible in his 
Thunderbird
in the CardDAV folder and clicking "Synchronize" does not yield any error. But 
when the
user logs in to the SOGo web UI, the personal address book there is just empty.
I tried importing the same contacts vCard file in the web UI as well and again 
had no
error or warning (e.g. "76 contacts imported") but they do not show up.
On the connected smartphone (Android running "BlueMail") the contacts also do 
not
show up (but e-mail and calendar do).
In the user's web UI I then created a "new address book" in addition to the 
standard
personal address book. Imported the vCard file into this and it works fine, all 
contacts
are shown in this new address book.
But, obviously, this does not really work, I need to make the standard "personal
address book" work.

The only error I see in sogo.log (when trying to copy a single contact from the 
"new
address book" to the non-working "personal address book") is:

May 06 10:02:06 sogod [22977]: <0x0x55fffdfb8638[GCSFolder]> ERROR(-[GCSFolder 
writeContent:fromComponent:container:toName:baseVersion:]): cannot insert 
content :  NAME:ExecutionFailed REASON:Unknown 
column 'c_hascertificate' in 'field list'
May 06 10:02:06 sogod [22977]: [ERROR] 
<0xFE07B168[SOGoContactGCSEntry]:59C1-6274D600-B7-49476E80.vcf> write failed: 
 NAME:ExecutionFailed REASON:Unknown column 
'c_hascertificate' in 'field list'

Does anyone have an idea what might be the problem? I have not seen such a 
problem
before ...

Kai-Uwe Rommel

ARS Computer und Consulting GmbH, www.ars.de
ein Unternehmen der TIMETOACT Group
Garmischer Straße 7, 80339 München, Deutschland

ARS - The Art of Software Engineering
Software-Entwicklungsprojekte, Software-Architektur, Cloud-Transformation, 
Mainframe- und Legacy Java-Modernisierung

Handelsregister München, HRB 101829, USt-ID: DE 155 068 909
Geschäftsführer: Stefan Schäffer, Michael Arbesmeier
Datenschutzerklärung: https://www.ars.de/datenschutz/
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] strange problem with just one user's personal address book

[Kai-Uwe Rommel - ARS]

Hi, I'm running an old 2.4 SOGo server and have a strange problem:
Several users use e-mail, calendar and contacts. They mostly use Thunderbird on 
the PC
with IMAP/CalDAV/CardDAV, some also use the browser interface and most have a
smartphone connected to the same data via ActiveSync. All those work fine but 
for one
user the contacts "do not work":

The user has 76 contacts, created from Thunderbird, originally in Thunderbirds 
local
address book. I have helped the user and exported the contacts, connected the
SOGo personal address book into his Thunderbird via the CardDAV URL and imported
the contacts into this. No error or warnings. The contacts are visible in his 
Thunderbird
in the CardDAV folder and clicking "Synchronize" does not yield any error. But 
when the
user logs in to the SOGo web UI, the personal address book there is just empty.
I tried importing the same contacts vCard file in the web UI as well and again 
had no
error or warning (e.g. "76 contacts imported") but they do not show up.
On the connected smartphone (Android running "BlueMail") the contacts also do 
not
show up (but e-mail and calendar do).
In the user's web UI I then created a "new address book" in addition to the 
standard
personal address book. Imported the vCard file into this and it works fine, all 
contacts
are shown in this new address book.
But, obviously, this does not really work, I need to make the standard "personal
address book" work.

The only error I see in sogo.log (when trying to copy a single contact from the 
"new
address book" to the non-working "personal address book") is:

May 06 10:02:06 sogod [22977]: <0x0x55fffdfb8638[GCSFolder]> ERROR(-[GCSFolder 
writeContent:fromComponent:container:toName:baseVersion:]): cannot insert 
content :  NAME:ExecutionFailed REASON:Unknown 
column 'c_hascertificate' in 'field list'
May 06 10:02:06 sogod [22977]: [ERROR] 
<0xFE07B168[SOGoContactGCSEntry]:59C1-6274D600-B7-49476E80.vcf> write failed: 
 NAME:ExecutionFailed REASON:Unknown column 
'c_hascertificate' in 'field list'

Does anyone have an idea what might be the problem? I have not seen such a 
problem
before ...

Kai-Uwe Rommel

ARS Computer und Consulting GmbH, www.ars.de
ein Unternehmen der TIMETOACT Group
Garmischer Straße 7, 80339 München, Deutschland

ARS - The Art of Software Engineering
Software-Entwicklungsprojekte, Software-Architektur, Cloud-Transformation, 
Mainframe- und Legacy Java-Modernisierung

Handelsregister München, HRB 101829, USt-ID: DE 155 068 909
Geschäftsführer: Stefan Schäffer, Michael Arbesmeier
Datenschutzerklärung: https://www.ars.de/datenschutz/
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Migration to Mailcow, any experiences/tutorials/hints?

[Kai-Uwe Rommel - ARS]

Hello,

I'm currently running an old server on CentOS 6 with postfix/dovecot and SOGo 
2.4 and MySQL DB as authentication source for the users.
I need to do a complete overhaul to current software levels, obviously. After 
thinking over this for a while and looking around I found that it seems
to make the most sense for me to move to a new Ubuntu VM and run a local 
Mailcow dockerized deployment.
That seems to offer about the same moving parts (postfix, dovecot, SOGo, 
MariaDB), in a more integrated and easily upgradable way.
Did anyone do such a migration from a conventional manual setup into a Mailcow 
setup, e.g. including user/data migration
and could share the experience, hints, warnings etc.? Thanks.
In particular, I'd like to know how to

  *   move the user name/password table(s)
  *   move the mail data of dovecot
  *   move the calendar/contact data of SOGo
I haven't yet seen a tutorial or similar for such a migration.

Kai-Uwe Rommel


ARS Computer und Consulting GmbH, www.ars.de
ein Unternehmen der TIMETOACT Group
Garmischer Straße 7, 80339 München, Deutschland

ARS - The Art of Software Engineering
Software Engineering, Technologieberatung, IBM Software, IBM Lizenzmanagement 
Services

Handelsregister München, HRB 101829, USt-ID: DE 155 068 909
Geschäftsführer: Joachim Gucker, Stefan Schäffer, Michael Arbesmeier
Datenschutzerklärung: https://www.ars.de/datenschutz/
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

RE: [SOGo] Help to setup autoconfig and autodiscover

[Kai-Uwe Rommel - ARS]

Hello Philippe,
what I posted here was just my setup except that I replaced my domain/server 
names
with your generic sample name. You will need to debug this now yourself in your 
environment.
Perhaps you overlooked something (such as necessary name change).
I had collected all this from various sources on the Internet a couple of years 
ago,
there was no single source. Therefore I thought I could post that all together 
here.
I can confirm that the setup still works fine for auto configuring Thunderbird 
from my server.

Kai-Uwe Rommel

From: users-requ...@sogo.nu  On Behalf Of HYVERNAT 
Philippe
Sent: Monday, January 10, 2022 10:12 AM
To: Kai-Uwe Rommel - ARS (kai-uwe.rom...@ars.de) 
Subject: Re: [SOGo] Help to setup autoconfig and autodiscover


Hello,

Thanks a lot for your details

so i try only with thunderbird,

i created an host autoconfig.domain.com and put the file 
www/mail/config-v1.1.xml

i can access with my browser to port 80  
http://autoconfig.domain.com/mail/config-v1.1.xml

When i try to create an account to thunderbird. in my firewall i can see the 
access, and everything is ok but Thunderbird say that config is not found ???

i have Apache24 php81.

Shall i activate xml on the server ? and how ?

Thanks a lot

ARS Computer und Consulting GmbH, www.ars.de
ein Unternehmen der TIMETOACT Group
Garmischer Straße 7, 80339 München, Deutschland

ARS - The Art of Software Engineering
Software Engineering, Technologieberatung, IBM Software, IBM Lizenzmanagement 
Services

Handelsregister München, HRB 101829, USt-ID: DE 155 068 909
Geschäftsführer: Joachim Gucker, Stefan Schäffer, Michael Arbesmeier
Datenschutzerklärung: https://web.ars.de/datenschutz/
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

RE: [SOGo] Help to setup autoconfig and autodiscover

[Kai-Uwe Rommel - ARS]

First, you need to set up DNS for your domain:

  *   CNAME of autoconfig for your web server
  *   CNAME of autodiscover for your web server
  *   SRV record of _autodiscover._tcp
So it should look like:
_autodiscover._tcp  SRV  10 0 443  webmail.domain.com.
autoconfig  CNAME webmail.domain.com.
autodiscoverCNAME webmail.domain.com.

On the web server you then need

  *   enable PHP
  *   a couple of aliases:
Alias /autodiscover/autodiscover.xml "/var/www/html/autodiscover.php"
Alias /Autodiscover/Autodiscover.xml "/var/www/html/autodiscover.php"
Alias /AutoDiscover/AutoDiscover.xml "/var/www/html/autodiscover.php"
Alias /ios "/var/www/html/mailsetup.php"

  *   then those autodiscover.php and mailsetup.php files
  *   and this mail/config-v1.1.xml:



domain.com
eMail @ domain.com 
domain.com

webmail.domain.com
993
SSL
password-cleartext
%EMAILLOCALPART%


webmail.domain.com
465
SSL
password-cleartext
%EMAILLOCALPART%

https://webmail.domain.com>
WebMail-Interface zu domain.com
WebMail interface for domain.com




The autodiscover.php is a bit lengthy:

http://technet.microsoft.com/en-us/library/cc511507.aspx

// Get contents of request made to Autodiscover.
$request = file_get_contents("php://input");
preg_match("/\(.*?)\<\/EMailAddress\>/", $request, 
$email_address);
preg_match("/\(.*?)@(.*?)\<\/EMailAddress\>/", $request, 
$email_name);

/*** Begin Configuration ***/

// ActiveSync URL.
$_CONFIG['MobileSync']['Url'] = 
https://webmail.domain.com/Microsoft-Server-ActiveSync;

// IMAP configuration settings.
$_CONFIG['IMAP']['Server'] = "webmail.domain.com";
$_CONFIG['IMAP']['Port'] = "993";
$_CONFIG['IMAP']['SSL'] = "on";
$_CONFIG['IMAP']['SPA'] = "off";
$_CONFIG['IMAP']['AuthRequired'] = "on";
$_CONFIG['IMAP']['DomainRequired'] = "off";
$_CONFIG['IMAP']['LoginName'] = $email_name[1];

// SMTP configuration settings.
$_CONFIG['SMTP']['Server'] = "webmail.domain.com";
$_CONFIG['SMTP']['Port'] = "465";
$_CONFIG['SMTP']['SSL'] = "on";
$_CONFIG['SMTP']['SPA'] = "off";
$_CONFIG['SMTP']['AuthRequired'] = "on";
$_CONFIG['SMTP']['DomainRequired'] = "off";
$_CONFIG['SMTP']['LoginName'] = $email_name[1];

/*** End Configuration ***/

// XML document heading.
header("Content-Type: text/xml");
echo "\n";

// Get the schema from the request.
preg_match("/\(.*?)\<\/AcceptableResponseSchema\>/", 
$request, $schema);

// Determine the type of device requesting Autodiscover.
if (preg_match("/\/mobilesync\//", $schema[1]))
{
// Mobile device.
?>
http://schemas.microsoft.com/exchange/autodiscover/responseschema/2006>

de:de







MobileSync








http://schemas.microsoft.com/exchange/autodiscover/responseschema/2006>


email
settings



$value\n";
}
?>






http://schemas.microsoft.com/exchange/autodiscover/responseschema/2006>


600
Invalid Request






And the mailsetup.php for iOS devices:







domain.com ActiveSync Configuration for Apple iOS





Benutzer-Name:











And the mailsetup.mobileconfig it references:


http://www.apple.com/DTDs/PropertyList-1.0.dtd>


PayloadUUID
8B9C9E2E-53E7-44EC-A361-74EC8136B4CF
PayloadDisplayName
%EMAIL%
  

RE: [SOGo] SOGo 2.4.0 - EAS does not support Reply-To?

[Kai-Uwe Rommel - ARS]

Hello Thomas,

thanks. That is for 5.4, right? I'm still on 2.4 but plan to rebuild the entire 
server during 1H22,
most probably based on a MailCow containerized setup, then with a current code 
stack.

Kai-Uwe Rommel

From: users-requ...@sogo.nu  On Behalf Of "T F"
Sent: Wednesday, January 5, 2022 9:17 AM
To: users@sogo.nu
Subject: AW: [SOGo] SOGo 2.4.0 - EAS does not support Reply-To?

Hi Kai-Uwe!
The pull request #307 has been merged.
Can you please test with the latest nightly build.
Regards
Thomas

Von: T F 
Gesendet: Donnerstag, 30. Dezember 2021 15:27
An: users@sogo.nu
Betreff: AW: [SOGo] SOGo 2.4.0 - EAS does not support Reply-To?

Hi Kai-Uwe!
FYI: I filed a pull request for this: 
https://github.com/inverse-inc/sogo/pull/307.
Regards
Thomas

Von: users-requ...@sogo.nu<mailto:users-requ...@sogo.nu> 
mailto:users-requ...@sogo.nu>> Im Auftrag von Kai-Uwe 
Rommel - ARS
Gesendet: Donnerstag, 23. Dezember 2021 21:33
An: users@sogo.nu<mailto:users@sogo.nu>
Betreff: RE: [SOGo] SOGo 2.4.0 - EAS does not support Reply-To?

So it's not implemented either in the current version (5.4)?
Is there a reason (some problem to be expected)?
It's kind of strange as this is a commonly used header field.

Kai-Uwe Rommel


From: users-requ...@sogo.nu<mailto:users-requ...@sogo.nu> 
mailto:users-requ...@sogo.nu>> On Behalf Of "Thomas 
Fuehrer"
Sent: Thursday, December 23, 2021 8:12 AM
To: users@sogo.nu<mailto:users@sogo.nu>
Subject: AW: [SOGo] SOGo 2.4.0 - EAS does not support Reply-To?

Hello,
this is not yet implemented.
There are some code-lines (commented) in SOGoMailObject+ActiveSync.m which 
gives a rough idea about what it takes to implement the "reply-to":

SOGoMailObject+ActiveSync.m:
  // Reply-To - FIXME
  //NSArray *replyTo = [[message objectForKey: @"envelope"] replyTo];
  //if ([replyTo count])
  //  [s appendFormat: @"%@", 
[addressFormatter stringForArray: replyTo]];

Regards
Thomas

Von: users-requ...@sogo.nu<mailto:users-requ...@sogo.nu> 
mailto:users-requ...@sogo.nu>> Im Auftrag von Kai-Uwe 
Rommel - ARS
Gesendet: Dienstag, 21. Dezember 2021 12:25
An: users@sogo.nu<mailto:users@sogo.nu>
Betreff: [SOGo] SOGo 2.4.0 - EAS does not support Reply-To?

Hello,

I'm still running an old SOGo 2.4.0 server for our family, on top of Dovecot 
and Postfix.
We are using EAS to connect a couple of mobile devices to it.

My son an I have now noticed that when we receive e-mail messages that contain 
Reply-To fields,
then these are shown and honored in the web client (and of course when using 
e.g. Thunderbird to
access the mailbox directly on Dovecot) but not on the mobile clients via EAS.
We are using the "Nine" and "BlueMail" apps on Android. In both the Reply-To 
fields do not show up.
Of course when we then reply to such a message, the reply goes to the original 
sender and not to the
address in Reply-To.

Is this a known limitation of the SOGo EAS implementation? Is it still present 
in SOGo 5.4?

Kai-Uwe Rommel

ARS Computer und Consulting GmbH, www.ars.de<http://www.ars.de>
ein Unternehmen der TIMETOACT Group
Garmischer Straße 7, 80339 München, Deutschland

ARS - The Art of Software Engineering
Software Engineering, Technologieberatung, IBM Software, IBM Lizenzmanagement 
Services

Handelsregister München, HRB 101829, USt-ID: DE 155 068 909
Geschäftsführer: Joachim Gucker, Stefan Schäffer, Michael Arbesmeier
Datenschutzerklärung: https://web.ars.de/datenschutz/
--
users@sogo.nu<mailto:users@sogo.nu>
https://inverse.ca/sogo/lists
--
users@sogo.nu
https://inverse.ca/sogo/lists

ARS Computer und Consulting GmbH, www.ars.de
ein Unternehmen der TIMETOACT Group
Garmischer Straße 7, 80339 München, Deutschland

ARS - The Art of Software Engineering
Software Engineering, Technologieberatung, IBM Software, IBM Lizenzmanagement 
Services

Handelsregister München, HRB 101829, USt-ID: DE 155 068 909
Geschäftsführer: Joachim Gucker, Stefan Schäffer, Michael Arbesmeier
Datenschutzerklärung: https://web.ars.de/datenschutz/
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

RE: [SOGo] SOGo 2.4.0 - EAS does not support Reply-To?

[Kai-Uwe Rommel - ARS]

So it's not implemented either in the current version (5.4)?
Is there a reason (some problem to be expected)?
It's kind of strange as this is a commonly used header field.

Kai-Uwe Rommel


From: users-requ...@sogo.nu  On Behalf Of "Thomas 
Fuehrer"
Sent: Thursday, December 23, 2021 8:12 AM
To: users@sogo.nu
Subject: AW: [SOGo] SOGo 2.4.0 - EAS does not support Reply-To?

Hello,
this is not yet implemented.
There are some code-lines (commented) in SOGoMailObject+ActiveSync.m which 
gives a rough idea about what it takes to implement the "reply-to":

SOGoMailObject+ActiveSync.m:
  // Reply-To - FIXME
  //NSArray *replyTo = [[message objectForKey: @"envelope"] replyTo];
  //if ([replyTo count])
  //  [s appendFormat: @"%@", 
[addressFormatter stringForArray: replyTo]];

Regards
Thomas

Von: users-requ...@sogo.nu  Im Auftrag von Kai-Uwe 
Rommel - ARS
Gesendet: Dienstag, 21. Dezember 2021 12:25
An: users@sogo.nu
Betreff: [SOGo] SOGo 2.4.0 - EAS does not support Reply-To?

Hello,

I'm still running an old SOGo 2.4.0 server for our family, on top of Dovecot 
and Postfix.
We are using EAS to connect a couple of mobile devices to it.

My son an I have now noticed that when we receive e-mail messages that contain 
Reply-To fields,
then these are shown and honored in the web client (and of course when using 
e.g. Thunderbird to
access the mailbox directly on Dovecot) but not on the mobile clients via EAS.
We are using the "Nine" and "BlueMail" apps on Android. In both the Reply-To 
fields do not show up.
Of course when we then reply to such a message, the reply goes to the original 
sender and not to the
address in Reply-To.

Is this a known limitation of the SOGo EAS implementation? Is it still present 
in SOGo 5.4?

Kai-Uwe Rommel


ARS Computer und Consulting GmbH, www.ars.de
ein Unternehmen der TIMETOACT Group
Garmischer Straße 7, 80339 München, Deutschland

ARS - The Art of Software Engineering
Software Engineering, Technologieberatung, IBM Software, IBM Lizenzmanagement 
Services

Handelsregister München, HRB 101829, USt-ID: DE 155 068 909
Geschäftsführer: Joachim Gucker, Stefan Schäffer, Michael Arbesmeier
Datenschutzerklärung: https://web.ars.de/datenschutz/
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] SOGo 2.4.0 - EAS does not support Reply-To?

[Kai-Uwe Rommel - ARS]

Hello,

I'm still running an old SOGo 2.4.0 server for our family, on top of Dovecot 
and Postfix.
We are using EAS to connect a couple of mobile devices to it.

My son an I have now noticed that when we receive e-mail messages that contain 
Reply-To fields,
then these are shown and honored in the web client (and of course when using 
e.g. Thunderbird to
access the mailbox directly on Dovecot) but not on the mobile clients via EAS.
We are using the "Nine" and "BlueMail" apps on Android. In both the Reply-To 
fields do not show up.
Of course when we then reply to such a message, the reply goes to the original 
sender and not to the
address in Reply-To.

Is this a known limitation of the SOGo EAS implementation? Is it still present 
in SOGo 5.4?

Kai-Uwe Rommel

kai-uwe.rom...@ars.de
Telefon+Mobil: +49 89 32468-120


ARS Computer und Consulting GmbH, www.ars.de
ein Unternehmen der TIMETOACT Group
Garmischer Straße 7, 80339 München, Deutschland

ARS - The Art of Software Engineering
Software Engineering, Technologieberatung, IBM Software, IBM Lizenzmanagement 
Services

Handelsregister München, HRB 101829, USt-ID: DE 155 068 909
Geschäftsführer: Joachim Gucker, Stefan Schäffer, Michael Arbesmeier
Datenschutzerklärung: https://web.ars.de/datenschutz/
-- 
users@sogo.nu
https://inverse.ca/sogo/lists