1 Topic by ketan.aagja

  • ketan.aagja
  • Member
  • Offline
  • From: UK
  • Registered: 2012-05-15
  • Posts: 252

Topic: Updated SOGo and Prefrences in SOGo webmail stopped working

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.5-1
- Linux/BSD distribution name and version: CentOS Linux release 7.2.1511 (Core)
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? : Yes
- Related log if you're reporting an issue: Dovecot, Sogo
====

I am facing strange issue where I updated SOGo to new 3.2.0 version from 3.1.5. Now Preferences tab on SOGo webmail is not working. Neither any check boxes are being clicked nor any values we modify is being set.

------------- SOGO LOG -------------

Oct 12 04:11:02 sogod [4947]: <0x0x7fdd9af19b80[WOHttpAdaptor]> notified the watchdog that we are ready
Oct 12 04:11:11 sogod [4947]: |SOGo| starting method 'POST' on uri '/SOGo/so/postmaster@mydomain.co.uk/Preferences/save'
Oct 12 04:11:11 sogod [4947]: <0x0x7fdd9aec4ba0[SOGoCache]> Cache cleanup interval set every 300.000000 seconds
Oct 12 04:11:11 sogod [4947]: <0x0x7fdd9aec4ba0[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
Oct 12 04:11:11 sogod [4947]: |SOGo| request took 0.372338 seconds to execute
Oct 12 04:11:11 sogod [4947]: localhost "POST /SOGo/so/postmaster@mydomain.co.uk/Preferences/save HTTP/1.0" 200 0/4093 0.378 - - 5M
Oct 12 04:11:23 sogod [4947]: |SOGo| starting method 'GET' on uri '/SOGo/so/postmaster@mydomain.co.uk/logoff'
Oct 12 04:11:23 sogod [4947]: SOGoUserHomePage user 'postmaster@mydomain.co.uk' logged off
Oct 12 04:11:23 sogod [4947]: |SOGo| request took 0.007243 seconds to execute
Oct 12 04:11:23 sogod [4947]: localhost "GET /SOGo/so/postmaster@mydomain.co.uk/logoff HTTP/1.0" 302 0/0 0.009 - - 8K
Oct 12 04:11:24 sogod [4947]: |SOGo| starting method 'GET' on uri '/SOGo/so/'
Oct 12 04:11:24 sogod [4947]: |SOGo| request took 0.053087 seconds to execute
Oct 12 04:11:24 sogod [4947]: localhost "GET /SOGo/so/ HTTP/1.0" 200 6767/0 0.055 25336 73% 580K
Oct 12 04:11:40 sogod [4947]: |SOGo| starting method 'POST' on uri '/SOGo/connect'
Oct 12 04:11:40 sogod [4947]: SOGoRootPage successful login from 'localhost' for user 'postmaster@mydomain.co.uk' - expire = -1  grace = -1
Oct 12 04:11:40 sogod [4947]: [WARN] <0x0x7fdd9b1e8710[SOGoWebDAVAclManager]> entry '{DAV:}write' already exists in DAV permissions table
Oct 12 04:11:40 sogod [4947]: [WARN] <0x0x7fdd9b1e8710[SOGoWebDAVAclManager]> entry '{DAV:}write-properties' already exists in DAV permissions table
Oct 12 04:11:40 sogod [4947]: [WARN] <0x0x7fdd9b1e8710[SOGoWebDAVAclManager]> entry '{DAV:}write-content' already exists in DAV permissions table
Oct 12 04:11:40 sogod [4947]: |SOGo| request took 0.011428 seconds to execute
Oct 12 04:11:40 sogod [4947]: localhost "POST /SOGo/connect HTTP/1.0" 200 48/87 0.013 - - 144K
Oct 12 04:11:41 sogod [4947]: |SOGo| starting method 'GET' on uri '/SOGo/so/SOGo/postmaster%40mydomain.co.uk'
Oct 12 04:11:41 sogod [4947]: |SOGo| request took 0.002736 seconds to execute
Oct 12 04:11:41 sogod [4947]: localhost "GET /SOGo/so/SOGo/postmaster%40mydomain.co.uk HTTP/1.0" 302 0/0 0.004 - - 0
Oct 12 04:11:41 sogod [4947]: |SOGo| starting method 'GET' on uri '/SOGo/so/SOGo/postmaster%40mydomain.co.uk/view'
Oct 12 04:11:41 sogod [4947]: |SOGo| request took 0.003919 seconds to execute
Oct 12 04:11:41 sogod [4947]: localhost "GET /SOGo/so/SOGo/postmaster%40mydomain.co.uk/view HTTP/1.0" 302 0/0 0.005 - - 0
Oct 12 04:11:41 sogod [4947]: |SOGo| starting method 'GET' on uri '/SOGo/so/postmaster@mydomain.co.uk/Mail'
Oct 12 04:11:41 sogod [4947]: |SOGo| request took 0.002983 seconds to execute
Oct 12 04:11:41 sogod [4947]: localhost "GET /SOGo/so/postmaster@mydomain.co.uk/Mail HTTP/1.0" 302 0/0 0.004 - - 0
Oct 12 04:11:41 sogod [4947]: |SOGo| starting method 'GET' on uri '/SOGo/so/postmaster@mydomain.co.uk/Mail/view'
Oct 12 04:11:41 sogod [4947]: |SOGo| request took 0.091178 seconds to execute
Oct 12 04:11:41 sogod [4947]: localhost "GET /SOGo/so/postmaster@mydomain.co.uk/Mail/view HTTP/1.0" 200 15872/0 0.094 70643 77% 1M
Oct 12 04:11:42 sogod [4947]: |SOGo| starting method 'GET' on uri '/SOGo/so/postmaster@mydomain.co.uk/Calendar/alarmslist?browserTime=1476259893'
Oct 12 04:11:42 sogod [4947]: |SOGo| request took 0.010219 seconds to execute
Oct 12 04:11:42 sogod [4947]: localhost "GET /SOGo/so/postmaster@mydomain.co.uk/Calendar/alarmslist?browserTime=1476259893 HTTP/1.0" 200 63/0 0.012 - - 28K
Oct 12 04:11:42 sogod [4947]: |SOGo| starting method 'GET' on uri '/SOGo/so/postmaster@mydomain.co.uk/jsonDefaults'
Oct 12 04:11:42 sogod [4945]: |SOGo| starting method 'GET' on uri '/SOGo/so/postmaster@mydomain.co.uk/jsonSettings'
Oct 12 04:11:42 sogod [4945]: <0x0x7fdd9aacf250[SOGoCache]> Cache cleanup interval set every 300.000000 seconds
Oct 12 04:11:42 sogod [4945]: <0x0x7fdd9aacf250[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
Oct 12 04:11:42 sogod [4945]: |SOGo| request took 0.007575 seconds to execute
Oct 12 04:11:42 sogod [4945]: localhost "GET /SOGo/so/postmaster@mydomain.co.uk/jsonSettings HTTP/1.0" 200 338/0 0.011 - - 1M
Oct 12 04:11:42 sogod [4947]: |SOGo| request took 0.022905 seconds to execute
Oct 12 04:11:42 sogod [4947]: localhost "GET /SOGo/so/postmaster@mydomain.co.uk/jsonDefaults HTTP/1.0" 200 4022/0 0.024 - - 0
Oct 12 04:11:43 sogod [4947]: |SOGo| starting method 'GET' on uri '/SOGo/so/postmaster@mydomain.co.uk/Mail/0/view'
Oct 12 04:11:43 sogod [4947]: |SOGo| request took 0.258087 seconds to execute
Oct 12 04:11:43 sogod [4947]: localhost "GET /SOGo/so/postmaster@mydomain.co.uk/Mail/0/view HTTP/1.0" 200 802/0 0.259 - - 0
Oct 12 04:11:43 sogod [4947]: |SOGo| starting method 'POST' on uri '/SOGo/so/postmaster@mydomain.co.uk/Mail/unseenCount'
Oct 12 04:11:43 sogod [4945]: |SOGo| starting method 'POST' on uri '/SOGo/so/postmaster@mydomain.co.uk/Mail/0/folderINBOX/view'
S[0x7fdd9b2bd1d0]: "IMPLEMENTATION" "Dovecot Pigeonhole"
S[0x7fdd9b2bd1d0]: "SIEVE" "fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date ihave"
S[0x7fdd9b2bd1d0]: "NOTIFY" "mailto"
S[0x7fdd9b2bd1d0]: "SASL" "PLAIN LOGIN"
S[0x7fdd9b2bd1d0]: "STARTTLS"
S[0x7fdd9b2bd1d0]: "VERSION" "1.0"
S[0x7fdd9b2bd1d0]: OK "Dovecot ready."
C: AUTHENTICATE "PLAIN" {%d+}
LOGIN:PASSWORD

S[0x7fdd9b2bd1d0]: OK "Logged in."
S[0x7fdd9b2c7fa0]: "IMPLEMENTATION" "Dovecot Pigeonhole"
S[0x7fdd9b2c7fa0]: "SIEVE" "fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date ihave"
S[0x7fdd9b2c7fa0]: "NOTIFY" "mailto"
S[0x7fdd9b2c7fa0]: "SASL" "PLAIN LOGIN"
S[0x7fdd9b2c7fa0]: "STARTTLS"
S[0x7fdd9b2c7fa0]: "VERSION" "1.0"
S[0x7fdd9b2c7fa0]: OK "Dovecot ready."
C: AUTHENTICATE "PLAIN" {%d+}
LOGIN:PASSWORD


------------- Dovecot LOG -------------

Dovecot log shows only below entries about sieve which seems fine:

Oct 12 09:25:10 managesieve(postmaster@mydomain.co.uk): Debug: shared: root=/var/run/dovecot, index=, indexpvt=, control=, inbox=, alt=
Oct 12 09:25:10 managesieve(postmaster@mydomain.co.uk): Debug: acl: initializing backend with data: vfile
Oct 12 09:25:10 managesieve(postmaster@mydomain.co.uk): Debug: acl: acl username = postmaster@mydomain.co.uk
Oct 12 09:25:10 managesieve(postmaster@mydomain.co.uk): Debug: acl: owner = 0
Oct 12 09:25:10 managesieve(postmaster@mydomain.co.uk): Debug: acl vfile: Global ACL directory: (none)
Oct 12 09:25:10 managesieve(postmaster@mydomain.co.uk): Debug: sieve: Pigeonhole version 0.4.2 initializing
Oct 12 09:25:10 managesieve(postmaster@mydomain.co.uk): Debug: sieve-storage: using active sieve script path: /var/vmail/vmail1/mydomain.co.uk/p/o/s/postmaster-2014.01.03.19.05.33//sieve/dovecot.sieve
Oct 12 09:25:10 managesieve(postmaster@mydomain.co.uk): Debug: sieve-storage: using sieve script storage directory: /var/vmail/vmail1/mydomain.co.uk/p/o/s/postmaster-2014.01.03.19.05.33//sieve
Oct 12 09:25:10 managesieve(postmaster@mydomain.co.uk): Debug: sieve-storage: using permissions from /var/vmail/vmail1/mydomain.co.uk/p/o/s/postmaster-2014.01.03.19.05.33//sieve: mode=0700 gid=-1
Oct 12 09:25:10 managesieve(postmaster@mydomain.co.uk): Debug: sieve-storage: relative path to sieve storage in active link:
Oct 12 09:25:10 managesieve(postmaster@mydomain.co.uk): Debug: sieve-storage: nothing to rescue /var/vmail/vmail1/mydomain.co.uk/p/o/s/postmaster-2014.01.03.19.05.33//sieve/dovecot.sieve.
Oct 12 09:25:10 managesieve(postmaster@mydomain.co.uk): Info: Connection closed bytes=35/87
Oct 12 09:25:10 managesieve(postmaster@mydomain.co.uk): Info: Connection closed bytes=0/17

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ketan.aagja

  • ketan.aagja
  • Member
  • Offline
  • From: UK
  • Registered: 2012-05-15
  • Posts: 252

Re: Updated SOGo and Prefrences in SOGo webmail stopped working

I just saw new update for SOGo and thought the issue might have raised and resolved due to which they have initiated new update just in 24 hours. I updated the same but I think issue is still same.

Sogo log shows:
Oct 12 05:17:31 sogod [25797]: <0x0x7f8d441f0f30[SOGoSieveManager]> WARNING: Could not delete Sieve script - continuing...: {RawResponse = "{ok = 0; }"; result = 0; }
Oct 12 05:17:31 sogod [25797]: |SOGo| request took 0.179090 seconds to execute

3 Reply by ketan.aagja (edited by ketan.aagja 2016-10-12 19:01:38)

  • ketan.aagja
  • Member
  • Offline
  • From: UK
  • Registered: 2012-05-15
  • Posts: 252

Re: Updated SOGo and Prefrences in SOGo webmail stopped working

I think I have got it working now. I had to disable each and every options stated below and restart sogod service.

    SOGoSieveServer = sieve://127.0.0.1:4190;
    SOGoSieveScriptsEnabled = YES;
    SOGoVacationEnabled = YES;
    SOGoForwardEnabled = YES;
    SOGoSieveFolderEncoding = UTF-8;

Enabling each option one by one sorted the issue, restarting sogod and memcached services. Hope this helps anyone facing the same issue.

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Updated SOGo and Prefrences in SOGo webmail stopped working

ketan.aagja wrote:

    SOGoSieveServer = sieve://127.0.0.1:4190;
    SOGoSieveScriptsEnabled = YES;
    SOGoVacationEnabled = YES;
    SOGoForwardEnabled = YES;
    SOGoSieveFolderEncoding = UTF-8;

These parameters are used to enable sieve service (mail filter) in SOGo. IMO, it doesn't seem related to your issue - or i misunderstood your issue.

5 Reply by ketan.aagja

  • ketan.aagja
  • Member
  • Offline
  • From: UK
  • Registered: 2012-05-15
  • Posts: 252

Re: Updated SOGo and Prefrences in SOGo webmail stopped working

Hi Zhang,

Yes all below options were enabled earlier :

    SOGoSieveServer = sieve://127.0.0.1:4190;
    SOGoSieveScriptsEnabled = YES;
    SOGoVacationEnabled = YES;
    SOGoForwardEnabled = YES;
    SOGoSieveFolderEncoding = UTF-8;

When I updated SOGo it was enabled by default due to earlier config in sogo.conf. However after update, preferences tab and filters, vacation all stopped working. It did now allow any check box to be clicked and anything to set. If we change anything and save and later come back on same page it gets reset automatically.

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Updated SOGo and Prefrences in SOGo webmail stopped working

This is weird. i have no idea yet. sad Maybe you should ask for support from SOGo team:
https://sogo.nu/support/index_new.html#/community

7 Reply by dsp3

  • dsp3
  • Member
  • Offline
  • Registered: 2015-12-23
  • Posts: 104

Re: Updated SOGo and Prefrences in SOGo webmail stopped working

ketan.aagja wrote:

Hi Zhang,

Yes all below options were enabled earlier :

    SOGoSieveServer = sieve://127.0.0.1:4190;
    SOGoSieveScriptsEnabled = YES;
    SOGoVacationEnabled = YES;
    SOGoForwardEnabled = YES;
    SOGoSieveFolderEncoding = UTF-8;

When I updated SOGo it was enabled by default due to earlier config in sogo.conf. However after update, preferences tab and filters, vacation all stopped working. It did now allow any check box to be clicked and anything to set. If we change anything and save and later come back on same page it gets reset automatically.

I can confirm this. I have exact same issue. Will try to disable options as described above.

8 Reply by ketan.aagja (edited by ketan.aagja 2016-10-13 17:08:22)

  • ketan.aagja
  • Member
  • Offline
  • From: UK
  • Registered: 2012-05-15
  • Posts: 252

Re: Updated SOGo and Prefrences in SOGo webmail stopped working

More on helping side... no default version of SOGo allows paste layouts/data from excel files/sheets. If you try it, it will only paste text data not tables and it's layout. You will have to install addon of Paste From Excel to achieve copy pasting from excel files.

download and extract / copy pastefromexcel folder in below location (x64bit):
/usr/lib64/GNUstep/SOGo/WebServerResources/js/vendor/ckeditor/plugins

Edit below file:
/usr/lib64/GNUstep/SOGo/WebServerResources/js/vendor/ckeditor/build-config.js

look for pasterfromwork under     plugins : {  and paste below line

'pastefromexcel' : 1,

Now edit below file:
/usr/lib64/GNUstep/SOGo/WebServerResources/js/vendor/ckeditor/config.js

and add below line before ending of file ==>>

};

  config.extraPlugins = 'pastefromexcel';


again edit below file:
/usr/lib64/GNUstep/SOGo/WebServerResources/js/vendor/ckeditor/ckeditor.js

Look for:

CKEDITOR.config.plugins =

and add ,pastefromexcel, after pasterfromword

SOGo service restart not required, just refresh SOGo webmail and try copy pasting table from excel file. If you do not see table layout try clearing your browser history, it should work.


However one strange issue and solutions in SOGo compose box:
If you copy and paste from word or excel file into compose box and send email directly, receiver will receive blank email at their end.

Just hit one SPACE at the end of your email or write down anything in email if you have to then send email, receiver will receive full email with all copied contents. (I have raised this issue with sogo already)

9 Reply by ketan.aagja

  • ketan.aagja
  • Member
  • Offline
  • From: UK
  • Registered: 2012-05-15
  • Posts: 252

Re: Updated SOGo and Prefrences in SOGo webmail stopped working

However one strange issue and solutions in SOGo compose box:
If you copy and paste from word or excel file into compose box and send email directly, receiver will receive blank email at their end.

Just hit one SPACE at the end of your email or write down anything in email if you have to then send email, receiver will receive full email with all copied contents. (I have raised this issue with sogo already)


Sogo has rectified the issue now