[SOGo] help sogo error

2019-04-24 Thread Rafael Aviles 
I need help

I have sogo version 4.0.2 on a zentyal 6.0, I'm failing login sogo. in the
log I have the following error
Apr 24 18:44:03 sogod [10865]: SOGoRootPage Login from '192.168.165.4' for
user 'ebe' might not have worked - password policy: 65535
grace: -1 expire: -1 bound: 0
Apr 24 18:44:03 sogod [10865]: 192.168.165.4 'POST / SOGo / connect HTTP /
1.1' 403 34/67 0.167 - - 0
2019-04-24 18: 44: 12.313 sogod [10865: 10865] ERROR (-
[NGLdapSearchResultEnumerator nextObject]): does not support result
references yet.

I thank their help
Thank you
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Issue with SOGo CalDAV event REPLY handling

2019-04-24 Thread Christian Mack 
Hello

Sorry for the late response.

That change is intentional.
Organizer is always also an Attendee, so that is an unnecessary
duplication, which caused problems.
Therefore the unnecessary ATTENDEE entry for the ORGANIZER was removed.


Kind regards,
Christian Mack

Am 29.03.19 um 17:55 schrieb Alessio Cecchi (ales...@skye.it):
> 
> we are working on integration betwen Sogo and our CRM, but we have a
> problem related to the CalDAV SOGo engine.
> 
> We want to update the event in organizer calendar processing an external
> ics, sent by mail with method REPLY with only one attendee inside.
> 
> We noticed that sending the ics attached in mail directly to caldav
> engine causes an override of all attendees with only the one that
> answered the email.
> 
> Can you provide us some hints on how to proceed the right way ?
> 
> 
> This is an example of a request:
> 
> BEGIN:VCALENDAR
> PRODID:-//Google Inc//Google Calendar 70.9054//EN
> VERSION:2.0
> CALSCALE:GREGORIAN
> METHOD:REQUEST
> BEGIN:VEVENT
> DTSTART:20190329T143000Z
> DTEND:20190329T153000Z
> DTSTAMP:20190325T135647Z
> ORGANIZER;CN=G:mailto:g...@gmail.com
> UID:1ppgvkr2958songgv529v89bvt
> ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;
>  RSVP=TRUE;CN=a...@gmail.com;X-NUM-GUESTS=0:mailto:a...@gmail.com
> ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=ACCEPTED;CN=G;
>  X-NUM-GUESTS=0:mailto:g...@gmail.com
> CREATED:20190325T135645Z
> DESCRIPTION:test
> LAST-MODIFIED:20190325T135645Z
> LOCATION:
> SEQUENCE:0
> STATUS:CONFIRMED
> SUMMARY:test gmail
> TRANSP:OPAQUE
> END:VEVENT
> END:VCALENDAR
> 
> This is an example of a reply:
> 
> BEGIN:VCALENDAR
> PRODID:-//Google Inc//Google Calendar 70.9054//EN
> VERSION:2.0
> CALSCALE:GREGORIAN
> METHOD:REPLY
> BEGIN:VEVENT
> DTSTART:20190329T143000Z
> DTEND:20190329T153000Z
> DTSTAMP:20190325T135647Z
> ORGANIZER;CN=G:mailto:g...@gmail.com
> UID:1ppgvkr2958songgv529v89bvt
> ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=ACCEPTED;
>  CN=a...@gmail.com;X-NUM-GUESTS=0:mailto:a...@gmail.com
> CREATED:20190325T135645Z
> DESCRIPTION:test
> LAST-MODIFIED:20190325T135645Z
> LOCATION:
> SEQUENCE:0
> SUMMARY:test gmail
> TRANSP:OPAQUE
> END:VEVENT
> END:VCALENDAR
> 
> Thanks
> 


-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416



smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] Application Permissions?

2019-04-24 Thread Christian Mack 
Hello

Sorry for the late answer.

Am 28.03.19 um 16:44 schrieb Jurgis Pralgauskis
(jurgis.pralgaus...@gmail.com):
> 
> my company provides booking service and our client asked is it possible to
> integrate with Sogo.
> We have integration with msgraph, and it works nicely using "Application
> Permissions" (with  X509Certificate credentials).
> https://docs.microsoft.com/en-us/azure/active-directory/develop/v2-permissions-and-consent#permission-types
> 
> We can rw events with users' calendars without explicit users' consent (we
> have the only adminconsent).   Is it possible with Sogo?
> Or shoud each user give consent (delegate permissions) separately?
> 

SOGo does not use authorization via Active Directory.
It only can use authentication via LDAP access to Active Directory.

That said, you could use a so called SOGoSuperUser account.
That has to be configured on the SOGo server in its /etc/sogo/sogo.conf
configuration and be created in the authentication source (e.g. Active
Directory).
Every SOGoSuperUser has full access to every calendar and  addressbook
within SOGo.

If you can change/add/delete events in a foreign calendar without
consent of the owner, depends on the laws of the clients country.
Here in Europe because of GDPR (=General Data Protection Regulation)
that needs to be checked with a lawyer first.


Kind regards,
Christian Mack

-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416



smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] Why does EAS(exchange active sync) use wrong account name?

2019-04-24 Thread "Christian M. Jensen" 

Hi.

It sounds like your SOGo config is not matching your user backend, take 
a look at the values of MailFieldNames & SOGoForceExternalLoginWithEmail


See: 
https://sogo.nu/files/docs/SOGoInstallationGuide.html#Authentication-using-SQL


If you can login to SOGo web, then maybe it's the mail client that is 
sending user the user part of the e-mail and not the full email.


That's just my 2 cents.

On 24-04-2019 12:02, luckydog xf (luckydo...@gmail.com) wrote:

Bring this up, hope I could find out a solution.

On Thu, Apr 11, 2019 at 10:23 AM luckydog xf > wrote:


---
Does anyone have any idea or clue? Thanks.

On Tue, Apr 9, 2019 at 9:54 AM luckydog xf mailto:luckydo...@gmail.com>> wrote:

Here is MySQL query logs
# the 1st statement does return my password.  My c_uid is
'hongquan' and mail is 'hongq...@ad.pthl.hk
' in table *views*.
#  the 2nd statement return the entire fied of this record.

2019-04-09 09:51:25.255 sogod[5853:5853]

SQL:*SELECT c_password FROM views WHERE (c_uid = 'hongquan')
OR (mail = 'hongquan');*
2019-04-09 09:51:25.256 sogod[5853:5853]
 
 query has results, entering fetch-mode.
2019-04-09 09:51:25.261 sogod[5853:5853] MySQL4 connection
established 0x0x560c3311ff08
2019-04-09 09:51:25.261 sogod[5853:5853] MySQL4 channel
0x0x560c311f0ad0 opened (connection=0x0x560c3311ff08,sogo)
2019-04-09 09:51:25.261 sogod[5853:5853]

*SQL: SELECT * FROM views WHERE (c_uid = 'hongquan') OR (mail
= 'hongquan') OR (mail = 'hongquan');*
2019-04-09 09:51:25.262 sogod[5853:5853]
 
 query has results, entering fetch-mode.
Apr 09 09:51:25 sogod [5853]: |SOGo| request took 0.008609
seconds to execute
Apr 09 09:51:25 sogod [5853]: 172.16.234.223 "OPTIONS
/SOGo/Microsoft-Server-ActiveSync HTTP/1.1" 200 0/0 0.009 - - 4K



On Tue, Apr 9, 2019 at 9:51 AM luckydog xf
mailto:luckydo...@gmail.com>> wrote:

Here is my settings.

-

 Desktop,  open Outlook2016,   New account, --->manual
setup or addtional server types --->Outlook.com or
Exchange ActiveSync compatible service.

  # user information
   Your Name: hongquan
   Email Address: hongq...@ad.pthl.hk

  # server information
  mail Server: mail.ad.pthl.hk 
  # logon information
   Username: hongquan
  Password: 


# sogo.log

Apr 09 09:47:10 sogod [5853]: 172.16.234.223 "OPTIONS
/SOGo/Microsoft-Server-ActiveSync HTTP/1.1" 200 0/0 0.007
- - 32K

Seeing from above log, authentication is OK.

Test account settings takes a while and raises an error
that "Log onto Exchange ActiveSync mail server(EAS): the
server cannot be found"

--- IMAP seting is fine and I can receive and send email
--


I visit
http://mail.ad.pthl.hk//Microsoft-Server-ActiveSync is a
bland page and access log is 200, so I assume ActiveSync
is correct.


 What's wrong ?   Thanks.


On Mon, Apr 8, 2019 at 5:37 PM luckydog xf
mailto:luckydo...@gmail.com>> wrote:

Here is logs:


Apr 08 17:25:18 sogod [16322]: |SOGo| starting method
'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync'
Apr 08 17:25:18 sogod [16322]: |SOGo| request took
0.001262 seconds to execute
Apr 08 17:25:18 sogod [16322]: 172.16.234.223 "OPTIONS
/SOGo/Microsoft-Server-ActiveSync HTTP/1.1" 200 0/0
0.002 - - 0
Apr 08 17:26:36 sogod [16322]: |SOGo| starting method
'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync'
Apr 08 17:26:36 sogod [16322]: |SOGo| request took
0.001592 seconds to execute
Apr 08 17:26:36 sogod [16322]: 172.16.234.223 "OPTIONS
/SOGo/Microsoft-Server-ActiveSync HTTP/1.1" 200 0/0
0.003 - - 0
Apr 08 17:27:40 sogod [16322]: |SOGo| starting method
'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync'
Apr 08 17:27:40 sogod [16322]: |SOGo| request took
0.000844 seconds to execute
Apr 08 17:27:40 sogod [16322]: 172.16.234.223 "OPTIONS
/SOGo/Microsoft-Server-ActiveSync HTTP/1.1" 200 0/0
0.001 - - 0

Anything wrong?


On Mon, Apr 8, 2019 at 3:15 PM luckydog xf
mailto:luckydo...@gmail.com>>

Re: [SOGo] Why does EAS(exchange active sync) use wrong account name?

2019-04-24 Thread luckydog xf 
Bring this up, hope I could find out a solution.

On Thu, Apr 11, 2019 at 10:23 AM luckydog xf  wrote:

> ---
> Does anyone have any idea or clue? Thanks.
>
> On Tue, Apr 9, 2019 at 9:54 AM luckydog xf  wrote:
>
>> Here is MySQL query logs
>> # the 1st statement does return my password.  My c_uid is 'hongquan' and
>> mail is 'hongq...@ad.pthl.hk' in table *views*.
>> #  the 2nd statement return the entire fied of this record.
>>
>> 2019-04-09 09:51:25.255 sogod[5853:5853] > connection=0x0x560c33120f68> SQL:* SELECT c_password FROM views WHERE
>> (c_uid = 'hongquan') OR (mail = 'hongquan');*
>> 2019-04-09 09:51:25.256 sogod[5853:5853] > connection=0x0x560c33120f68>   query has results, entering fetch-mode.
>> 2019-04-09 09:51:25.261 sogod[5853:5853] MySQL4 connection established
>> 0x0x560c3311ff08
>> 2019-04-09 09:51:25.261 sogod[5853:5853] MySQL4 channel 0x0x560c311f0ad0
>> opened (connection=0x0x560c3311ff08,sogo)
>> 2019-04-09 09:51:25.261 sogod[5853:5853] > connection=0x0x560c3311ff08> *SQL: SELECT * FROM views WHERE (c_uid =
>> 'hongquan') OR (mail = 'hongquan') OR (mail = 'hongquan');*
>> 2019-04-09 09:51:25.262 sogod[5853:5853] > connection=0x0x560c3311ff08>   query has results, entering fetch-mode.
>> Apr 09 09:51:25 sogod [5853]: |SOGo| request took 0.008609 seconds to
>> execute
>> Apr 09 09:51:25 sogod [5853]: 172.16.234.223 "OPTIONS
>> /SOGo/Microsoft-Server-ActiveSync HTTP/1.1" 200 0/0 0.009 - - 4K
>>
>>
>>
>> On Tue, Apr 9, 2019 at 9:51 AM luckydog xf  wrote:
>>
>>> Here is my settings.
>>>
>>> -
>>>
>>>  Desktop,  open Outlook2016,   New account, --->manual setup or
>>> addtional server types --->Outlook.com or Exchange ActiveSync compatible
>>> service.
>>>
>>>   # user information
>>>Your Name: hongquan
>>>Email Address: hongq...@ad.pthl.hk
>>>
>>>   # server information
>>>   mail Server: mail.ad.pthl.hk
>>>
>>>   # logon information
>>>Username: hongquan
>>>   Password: 
>>>
>>>
>>> # sogo.log
>>>
>>> Apr 09 09:47:10 sogod [5853]: 172.16.234.223 "OPTIONS
>>> /SOGo/Microsoft-Server-ActiveSync HTTP/1.1" 200 0/0 0.007 - - 32K
>>>
>>> Seeing from above log, authentication is OK.
>>>
>>> Test account settings takes a while and raises an error that "Log onto
>>> Exchange ActiveSync mail server(EAS): the server cannot be found"
>>>
>>> --- IMAP seting is fine and I can receive and send email --
>>>
>>>
>>> I visit http://mail.ad.pthl.hk//Microsoft-Server-ActiveSync is a bland
>>> page and access log is 200, so I assume ActiveSync is correct.
>>>
>>>
>>>  What's wrong ?   Thanks.
>>>
>>>
>>> On Mon, Apr 8, 2019 at 5:37 PM luckydog xf  wrote:
>>>
 Here is logs:


 Apr 08 17:25:18 sogod [16322]: |SOGo| starting method 'OPTIONS' on uri
 '/SOGo/Microsoft-Server-ActiveSync'
 Apr 08 17:25:18 sogod [16322]: |SOGo| request took 0.001262 seconds to
 execute
 Apr 08 17:25:18 sogod [16322]: 172.16.234.223 "OPTIONS
 /SOGo/Microsoft-Server-ActiveSync HTTP/1.1" 200 0/0 0.002 - - 0
 Apr 08 17:26:36 sogod [16322]: |SOGo| starting method 'OPTIONS' on uri
 '/SOGo/Microsoft-Server-ActiveSync'
 Apr 08 17:26:36 sogod [16322]: |SOGo| request took 0.001592 seconds to
 execute
 Apr 08 17:26:36 sogod [16322]: 172.16.234.223 "OPTIONS
 /SOGo/Microsoft-Server-ActiveSync HTTP/1.1" 200 0/0 0.003 - - 0
 Apr 08 17:27:40 sogod [16322]: |SOGo| starting method 'OPTIONS' on uri
 '/SOGo/Microsoft-Server-ActiveSync'
 Apr 08 17:27:40 sogod [16322]: |SOGo| request took 0.000844 seconds to
 execute
 Apr 08 17:27:40 sogod [16322]: 172.16.234.223 "OPTIONS
 /SOGo/Microsoft-Server-ActiveSync HTTP/1.1" 200 0/0 0.001 - - 0

 Anything wrong?


 On Mon, Apr 8, 2019 at 3:15 PM luckydog xf 
 wrote:

> LoginFieldNames = (c_uid, mail);
>
> Add this optionals, so that either hongquan or hongq...@ad.pthl.hk
> works. But http access log is
> 172.16.81.56 - - [08/Apr/2019:14:14:47 +0800] "OPTIONS
> /Microsoft-Server-ActiveSync HTTP/1.1" 200 - "-" "Android/5.1-EAS-1.3"
> while it's probably due to App version, it still cannot sync email.etc.
>
> On Mon, Apr 8, 2019 at 12:49 PM luckydog xf 
> wrote:
>
>> # logs
>>
>> Apr 08 12:30:52 sogod [15247]: |SOGo| starting method 'OPTIONS' on
>> uri '/SOGo/Microsoft-Server-ActiveSync'
>> 2019-04-08 12:30:52.697 sogod[15247:15247]
>>  SQL: 
>> *SELECT
>> c_password FROM view WHERE c_uid = 'hongquan';*
>> 2019-04-08 12:30:52.698 sogod[15247:15247]
>>query has
>> results, entering fetch-mode.
>> Apr 08 12:30:52 sogod [15247]:
>> <0x0x557eeeafec40[SOGoDAVAuthenticator]> tried wrong password for user
>> 'hongquan'!
>> Apr 08 12:30:52 sogod [15247]: |SOGo| request took 0.001318 seconds
>> to execute
>>
>> # exchange client setup
>> email addr： hongq...@ad.pthl.hk
>> username: hongq...@ad.pthl.hk  ### I check that sogo reads account
>> name