[SOGo] BTS activities for Friday, January 07 2022

2022-01-07 Thread SOGo reporter
Title: BTS activities for Friday, January 07 2022





  
BTS Activities

  Home page: https://sogo.nu/bugs
  Project: SOGo
  For the period covering: Friday, January 07 2022

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
5449
	2022-01-07 03:31:30
	updated (open)
	Backend General
	can't upgrade from 5.0.1 to anything newer due to "the called object returned no result" error
	
	  
	
4930
	2022-01-07 16:28:12
	updated (open)
	Web General
	SOGO and search engine robots
	
	  
	
5388
	2022-01-07 16:04:56
	resolved (fixed)
	Web Mail
	Loading bar when opening emails with winmail.dat
	
	  
	
4931
	2022-01-07 16:20:38
	closed (fixed)
	Backend Calendar
	Sogo doesn't create table in db
	
	  
	
5430
	2022-01-07 18:11:31
	closed (not a bug)
	Web Mail
	Out of office: disable notification doesn't disable
	
	  
	
  
  


-- users@sogo.nuhttps://inverse.ca/sogo/lists

Re: [SOGo] Help to setup autoconfig and autodiscover

2022-01-07 Thread Kees van Vloten



Hello,

Thank you for your answer, i try this.

Best regards

Le 06/01/2022 à 22:14, Kai-Uwe Rommel - ARS (kai-uwe.rom...@ars.de) a 
écrit :


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.

autodiscover CNAME 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.

    ?>

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




de:de









  





MobileSync

   





   







    

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






   email

settings

    





   $value\n";

}

?>











    

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







600

  Invalid Request









    

And the mailsetup.php for iOS devices:



$cmdline = "/usr/bin/openssl smime -sign -in 
/var/www/html/apple/$timestamp -out 
/var/www/html/apple/$timestamp.signed -signer 
/etc/pki/dovecot/dovecot.cer -inkey 
/etc/pki/dovecot/private/dovecot.pem -certfile 
/etc/pki/dovecot/intermediate.cer -nodetach -outform der";


$output = exec($cmdline);

header('Content-type: application/x-apple-aspen-config; charset=utf-8');

header('Content-Disposition: attachment; 
filename="domain.mobileconfig"');


header('Content-Transfer-Encoding: binary');

ob_clean();

flush();

readfile("/var/www/html/apple/$timestamp.signed");

flush();

unlink("/var/www/html/apple/$timestamp");

unlink("/var/www/html/apple/$timestamp.signed");

?>







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%

PayloadIdentifier

domain.profile

PayloadDescription

Configures the device for use with ActiveSync for 
domain.com


PayloadOrganization

DOMAIN

PayloadVersion

1

PayloadType

 Configuration

PayloadContent

    



PayloadUUID

837AF5F3-1380-4234-BAD0-8246A644AC2E

PayloadDisplayName

%USERNAME%

PayloadDescription

Configures the device for use with ActiveSync for 
DOMAIN.


PayloadOrganization

DOMAIN

PayloadVersion

1

PayloadIdentifier

domain.email

PayloadType

com.apple.eas.account


Re: [SOGo] Sogo adress book at Gigaset

2022-01-07 Thread Paul van der Vlis
Op 06-01-2022 om 17:48 schreef "t.b.mailingli...@igeno-fat.de" 
(t.b.mailingli...@igeno-fat.de):

Hello,

I can't talk about the Gigaset Go-Box 100, but the GIGASET IP DECT 
Multicell system N720-DM-PRO  has following options - has anyone an idea 
if this could be connected to SoGo adressbook? Christian? Anyone?:



 1. *Phone book via Lightweight Directory Access Protocol (LDAP)*
 2.


Phone book via XML-Protocol

 3. *Public online phone books*

You can select the online phonebooks of several providers for
display in the handset.

Provider:

  * kT Phonebook
  * Telefoongids
  * Phone cat.
  * DGS Navne
  * [tel.search.ch]
  * Settings for a custom provider  ...



Maybe that custom provider can do it?

Modern Fritzboxes can do it, for example the 7490. But it's not perfect, 
I have problems with some special characters like the é in names, then 
the contact is not visable. But in general it works.


With regards,
Paul



--
Paul van der Vlis Linux systeembeheer Groningen
https://vandervlis.nl/
--
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Help to setup autoconfig and autodiscover

2022-01-07 Thread HYVERNAT Philippe

Hello,

Thank you for your answer, i try this.

Best regards

Le 06/01/2022 à 22:14, Kai-Uwe Rommel - ARS (kai-uwe.rom...@ars.de) a 
écrit :


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.

autodiscover CNAME 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.

    ?>

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


    

de:de

    





    

    





MobileSync

   





   

    

    

    

    

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


    

    

   email

settings

        // Loop through each 
configured protocol.


while(list($protocol, $settings) = each($_CONFIG))

    {

// Skip ActiveSync protocol.

  if ($protocol == "MobileSync") continue;

    ?>





   $value\n";

}

    ?>







    

    

    

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


    

    


600

  Invalid Request



    

    

    

    

And the mailsetup.php for iOS devices:



$cmdline = "/usr/bin/openssl smime -sign -in 
/var/www/html/apple/$timestamp -out 
/var/www/html/apple/$timestamp.signed -signer 
/etc/pki/dovecot/dovecot.cer -inkey 
/etc/pki/dovecot/private/dovecot.pem -certfile 
/etc/pki/dovecot/intermediate.cer -nodetach -outform der";


$output = exec($cmdline);

header('Content-type: application/x-apple-aspen-config; charset=utf-8');

header('Content-Disposition: attachment; filename="domain.mobileconfig"');

header('Content-Transfer-Encoding: binary');

ob_clean();

flush();

readfile("/var/www/html/apple/$timestamp.signed");

flush();

unlink("/var/www/html/apple/$timestamp");

unlink("/var/www/html/apple/$timestamp.signed");

?>







domain.com ActiveSync Configuration for Apple iOS













[SOGo] CarDav CalDav SOGO5 and SOGO2

2022-01-07 Thread "giova...@neweden.uk.to"

Hello,

I have trouble using CarDAV SOGo5 with macOS and Android. I have my own 
installation of SOGo2 and SOGo5 on debian.


Scenario SOGo2:
carDav and calDav work fine with macOS, iOS and Android 10 (with DAVx5 
www.davx5.com)


Scenario SOGo5

CalDav works fine with macOS, iOS and Android 10 (with DAVx5 www.davx5.com).
CarDav doens't work with Android 10 and macOS. No contacts appear and no 
errors are reported on both server and client side,
Could you please let me know if someone was able to sync carDav with 
Android or macOS?

thank you in advance

Giovanni






--
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Sogo adress book at Gigaset

2022-01-07 Thread Christian Mack
Hello

Am 06.01.22 um 17:48 schrieb "t.b.mailingli...@igeno-fat.de"
(t.b.mailingli...@igeno-fat.de):
> Hello,
> 
> I can't talk about the Gigaset Go-Box 100, but the GIGASET IP DECT
> Multicell system N720-DM-PRO  has following options - has anyone an idea
> if this could be connected to SoGo adressbook? Christian? Anyone?:
> 
> 
> 1. *Phone book via Lightweight Directory Access Protocol (LDAP)*
> 2.  Phone book via XML-Protocol
> 3. *Public online phone books*
> 
>    You can select the online phonebooks of several providers for
>    display in the handset.
> 
>    Provider:
> 
>  * kT Phonebook
>  * Telefoongids
>  * Phone cat.
>  * DGS Navne
>  * [tel.search.ch]
>  * Settings for a custom provider  ...
> [cut]

1 You could set up an LDAP Server and feed it with exported address book
data from SOGo.
That would not be live access to SOGo, but you could do those exports on
a regular basis.

2 or 3 use XML formatted Data only.
I could not find any definition for that format (just some quick search,
probably missed it).
SOGo does not provide that anyway.
You currently only have cardDAV access to address books on SOGo side.
If you know the XML format definition, you could write a converter
Application, or open an enhancement request at https://sogo.nu/bugs


Kind regards,
Christian Mack

-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung IT-Dienste Forschung und Lehre
78457 Konstanz
+49 7531 88-4416



smime.p7s
Description: S/MIME Cryptographic Signature