[SOGo] BTS activities for Wednesday, April 10 2019

2019-04-10 Thread SOGo reporter
Title: BTS activities for Wednesday, April 10 2019





  
BTS Activities

  Home page: http://www.sogo.nu/bugs
  Project: SOGo
  For the period covering: Wednesday, April 10 2019

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
4728
	2019-04-10 06:09:09
	updated (open)
	Backend Calendar
	METHOD:REPLY overwrites the entire event
	
	  
	
4729
	2019-04-10 06:27:27
	updated (open)
	Backend Calendar
	Cannot reply to external event change with the same PARTSTAT
	
	  
	
4730
	2019-04-10 06:53:15
	updated (open)
	Backend Calendar
	METHOD:REPLY sends old event data on event change
	
	  
	
4731
	2019-04-10 23:26:36
	updated (open)
	Web Mail
	Cannot reply to any email
	
	  
	
  
  


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

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

2019-04-10 Thread luckydog xf
---
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 specified here ###
> domain name: ad.pthl.hk
> password: 
> server: mail.ad.pthl.hk
> ..
>
> Actually in MariadDB c_uid is *hongq...@ad.pthl.hk
> *, NOT hongquan. But EAS use hongquan as query
> string of SQL statement.

[SOGo] Too much resource usage

2019-04-10 Thread Odhiambo Washington
SOGo-4.0.7 on FreeBSD-12 (amd64) with Apache/2.4.38:

With only one user accessing the web UI, I see the following resource usage:


last pid: 40485;  load averages:  3.13,  3.15,  3.13 up 20+06:16:29
18:58:16
148 processes: 4 running, 144 sleeping
CPU: 72.8% user,  0.0% nice,  2.6% system,  0.0% interrupt, 24.5% idle
Mem: 634M Active, 1948M Inact, 382M Laundry, 921M Wired, 382M Buf, 107M Free
Swap: 3852M Total, 1803M Used, 2049M Free, 46% Inuse

  PID USERNAMETHR PRI NICE   SIZERES STATEC   TIMEWCPU
COMMAND
 5211 sogod 1 1030   142M41M CPU3 3 413:03 103.76% sogod
 5876 sogod 1 1030   106M24M CPU2 2 416:28 101.33% sogod
 5888 sogod 1 1030   106M24M CPU1 1 416:31 100.39% sogod


-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", grep ^[^#] :-)
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Error on sogo.log

2019-04-10 Thread Odhiambo Washington
I am seeing this on sogo.log for v4.0.7 when a user is accessing their mail:

Apr 10 17:35:45 sogod [3631]: 41.90.4.204 "POST /SOGo/connect HTTP/1.1" 200
66/86 0.329 - - -
Apr 10 17:35:47 sogod [3631]: 41.90.4.204 "GET /SOGo/so/lm...@domain.name
HTTP/1.1" 302 0/0 0.023 - - -
Apr 10 17:35:47 sogod [3631]: 41.90.4.204 "GET /SOGo/so/
lm...@domain.name/view HTTP/1.1" 302 0/0 0.040 - - -
Apr 10 17:35:47 sogod [3631]: 41.90.4.204 "GET /SOGo/so/
lm...@domain.name/Mail HTTP/1.1" 302 0/0 0.003 - - -
Apr 10 17:35:47 sogod [3631]: 41.90.4.204 "GET /SOGo/so/
lm...@domain.name/Mail/view HTTP/1.1" 200 19085/0 0.095 82184 76% -
Apr 10 17:35:48 sogod [3631]: 41.90.4.204 "GET /SOGo/so/
lm...@domain.name/Calendar/alarmslist?browserTime=1554906941 HTTP/1.1" 200
63/0 0.088 - - -
Apr 10 17:35:49 sogod [5211]: 41.90.4.204 "GET /SOGo/so/
lm...@domain.name/Mail/0/view HTTP/1.1" 200 1135/0 0.690 - - -
*2019-04-10 17:35:50.534 sogod[5211:101429] parseTimeZone: cannot parse
time notation 'GMT'*


Where could that be coming from? That time format is not consistent with
the ones above it!
Then why is it talking about GMT when in my sogo.conf I have SOGoTimeZone =
Africa/Nairobi;  ???

-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", grep ^[^#] :-)
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] iPhone EAS Sent and Trash

2019-04-10 Thread Marc Patermann

Hi,

it is working now.

I changed

SOGoTrashFolderName = INBOX.Trash;
SOGoSentFolderName = INBOX.Sent;

to

SOGoTrashFolderName = INBOX/Trash;
SOGoSentFolderName = INBOX/Sent;

Although Cyrus IMAPd uses the dot separator.

Thanks to everyone who helped solving my iussue!


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


Re: [SOGo] BTS activities for Tuesday, April 09 2019

2019-04-10 Thread Keith Howard
All,

OK, I Googled the error and it is related to memcahed.
I changed the default SOGoMemcachedHost from a file (named pipe?) to
127.0.0.1
"localhost" is not valid either as it can return an IPv6 IP (which is not
yet implemented).
I no longer get the error, but I still go from 'Welcome' splash screen
right back to login screen.

I haven't configured Dovecot yet, so, perhaps that is why.

Thanks, everyone!

Keith

On Wed, Apr 10, 2019 at 12:01 AM SOGo reporter  wrote:

> BTS Activities
>
> Home page: *http://www.sogo.nu/bugs *
> Project: *SOGo*
> For the period covering: *Tuesday, April 09 2019*
> idlast updatestatus (resolution)categorysummary
> 4726  2019-04-09 08:56:37 updated
> (open) i18n Catalan language: a lot of missing translations
> 4723  2019-04-09 23:22:16 updated
> (open) sogo-tool sogo-tool users unknown - backup not working
> 768  2019-04-09 10:45:04 updated
> (open) Web Mail Add multiple Identity to Imap Account
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Authentication Problem Using Samba4

2019-04-10 Thread Keith Howard
Aleksey,

Thank you for your response!

While modifying the sogo.conf per your instructions, I noticed an extra
space between dc=lan in the base DN.  I corrected that, and with your
changes, it works!  Well, sort of.

Now, I login and the web page welcomes me by my full name, but logs me
right back out.

I cleaned up the sogo.conf and enabled degugging.
Here is more information from the log:

Apr 10 07:27:28 sogod [29367]: |SOGo| request took 0.114224 seconds to
execute
Apr 10 07:27:28 sogod [29367]: 172.16.42.253 "POST /SOGo/connect HTTP/1.1"
200 49/67 0.116 - - 32K
Apr 10 07:27:29 sogod [29367]: |SOGo| starting method 'GET' on uri
'/SOGo/so/khoward'
2019-04-10 07:27:29.934 sogod[29367:29367] Creating NGLdapConnection
instance for bindDN 'CN=Administrator,CN=Users,DC=medinaco,DC=lan'
Apr 10 07:27:29 sogod [29367]: <0x0x7f7728702d40[NGLdapConnection]> Using
ldap_initialize for LDAP URL: ldap://localhost
2019-04-10 07:27:29.972 sogod[29367:29367] -[NGLdapConnection
_searchAtBaseDN:qualifier:attributes:scope:]: search at base
'cn=users,dc=medinaco,dc=lan' filter
'(|(samaccountname=khoward)(mail=khoward))' for attrs '*'
Apr 10 07:27:29 sogod [29367]: <0x0x7f77282de330[SOGoCache]> an error
occurred when caching value for key 'khoward+attributes': "SERVER HAS
FAILED AND IS DISABLED UNTIL TIMED RETRY"
Apr 10 07:27:29 sogod [29367]: <0x0x7f77282de330[SOGoCache]> an error
occurred when caching value for key 'khow...@medinaco.lan+attributes':
"SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
Apr 10 07:27:29 sogod [29367]: |SOGo| request took 0.056453 seconds to
execute
Apr 10 07:27:29 sogod [29367]: 172.16.42.253 "GET /SOGo/so/khoward
HTTP/1.1" 200 27413/0 0.058 - - 0
***END LOG

I will try Google for this error, but if anyone has suggestions/corrections
for this, I very much appreciate your input!

Thanks.

Keith

On Tue, Apr 9, 2019 at 3:36 PM Aleksey V  wrote:

> Hallo! I had same problem some times ago. Try change according fields in
> your config in SOGoUserSources section:
>
>  CNFieldName = cn;
>  IDFieldName = cn;
>  UIDFieldName = sAMAccountName;
>  bindFields = (sAMAccountName);
>  id = directory;
>
> And add in there, in SOGoUserSources, passwordPolicy = NO;
>
> After this changes my problem was solved. This is from Sogo Installation
> and Configuration Guide
> (https://sogo.nu/files/docs/v3/SOGoInstallationGuide.pdf)
>
> 09.04.2019 18:16, Keith Howard (kbhoward1...@gmail.com) пишет:
> > SOGoUserSources = (
> > {
> >   type = ldap;
> >   CNFieldName = cn;
> >   IDFieldName = sAMAccountName;
> >   UIDFieldName = sAMAccountName;
> >   baseDN = "CN=Users,DC=medinaco,DC=lan";
> >   bindDN = "CN=Administrator,CN=Users,DC=medinaco,DC=lan";
> >   bindFields = (sAMAccountName,mail,userPrincipalName);
> >   bindPassword =  ;
> >   canAuthenticate = YES;
> >   displayName = "Public";
> >   hostname = "ldap://localhost";;
> >   id = public;
> >   isAddressBook = YES;
> >   scope = SUB;
> >
> > }
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>
-- 
users@sogo.nu
https://inverse.ca/sogo/lists