date:20220110

[SOGo] BTS activities for Monday, January 10 2022

2022-01-10 Thread SOGo reporter

Title: BTS activities for Monday, January 10 2022





  
BTS Activities

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

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
5454
	2022-01-10 13:32:42
	updated (open)
	Documentation
	bug tracker security
	
	  
	
5430
	2022-01-10 03:49:08
	feedback (reopened)
	Web Mail
	Out of office: disable notification doesn't disable
	
	  
	
  
  


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

Re: [SOGo] Database-error with Activesync

2022-01-10 Thread Hanns Mattes

Hi,

Am 09.01.22 um 11:14 schrieb Hanns Mattes (hannsmat...@googlemail.com):
> Hello,
> 
> I've setup sogo 5.4.0 on a server running FreeBSD 13.0 und PSQL, web access,
> caldav and carddav are working fine. But trying to access an account via
> activesync is failing:
> [...]

(I forgot to mention, that I'm using LDAP-Authentication.)

similar results with mysql:

Jan 10 17:45:24 sogod [66817]:
<0x805167a88[SOGoCacheGCSObject]:4E696E65413341374535423136363832> an
exception occurred when executing query 'SELECT * FROM
sogo_cache_folder_hanns_A_hanauix_D_de WHERE c_path =
'/4E696E65413341374535423136363832' AND c_uid = 'ha...@hanauix.de''
Jan 10 17:45:24 sogod [66817]:
<0x805167a88[SOGoCacheGCSObject]:4E696E65413341374535423136363832>
exception is ' NAME:ExecutionFailed
REASON:Unknown column 'c_uid' in 'where clause''
Jan 10 17:45:24 sogod [66817]: [ERROR]
<0x805167a88[SOGoCacheGCSObject]:4E696E65413341374535423136363832> could
not insert/update record for record '/4E696E65413341374535423136363832'
in sogo_cache_folder_hanns_A_hanauix_D_de:  NAME:ExecutionFailed REASON:Unknown column 'c_uid' in
'field list'

Any idea?

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

[SOGo] Carddav Server Response UTF8

2022-01-10 Thread feuerwelt...@gmail.com

Hi all ,  i have several issue with a strict VCARD implementations using SOGo as CardDav Server.  The from SOGo surfed VCard must be UTF-8 but was Latin-1. https://datatracker.ietf.org/doc/html/rfc6350#section-3.1  Any suggestion to solve this issue.  Reproduce with an curl to the CardDav Server :  curl --user "carddavtestuser@SOGo.Domain:SecretPWD" -s -X PROPFIND -H "Content-Type: application/xml"  -sD /dev/stderr https://SOGo.Domain/SOGo/dav/carddavtestuser@SOGo.Domain/Contacts/personal/  Return looks like UTF-8 but is Latin-1Example : a german 'ü' is encoded as 252 but must be c3bc (50108). Meißner ÜösülämiIsMeiner slmi HTTP/1.1 207 Multi-StatusDate: Mon, 10 Jan 2022 16:30:27 GMTServer: SOPE 4.9.37/WebDAVReferrer-Policy: same-originContent-Type: text/xml; charset="utf-8"X-Dav-Error: 200 No errorMs-Author-Via: DAVPragma: no-cacheContent-Length: 3548Cache-Control: no-cache /SOGo/dav/carddavt...@kundenservice.biz/Contacts/personal/183358-6133BB80-3-7158B900.vcfHTTP/1.1 200 OKSat, 04 Sep 2021 20:32:42 +0100168Sat, 04 Sep 2021 21:34:07 +0100gcs0001text/x-vcardMeiner slmi/SOGo/dav/carddavt...@kundenservice.biz/Contacts/personal/183358-6133BB80-3-7158B900.vcf0 Cheers Frank
-- users@sogo.nuhttps://inverse.ca/sogo/lists

RE: [SOGo] Help to setup autoconfig and autodiscover

2022-01-10 Thread 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

2022-01-10 Thread HYVERNAT Philippe


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


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);

[SOGo] BTS activities for Monday, January 10 2022

Re: [SOGo] Database-error with Activesync

[SOGo] Carddav Server Response UTF8

RE: [SOGo] Help to setup autoconfig and autodiscover

Re: [SOGo] Help to setup autoconfig and autodiscover

5 matches

Site Navigation

Mail list logo

Footer information