Topic: SME8 32 bits: problem with SOGo and siebe

[Arnaud]

Hello,
I have following problem with SOGo installed according to the wiki http://wiki.contribs.org/Sogo on a SME8 32 bits: in webmail, I can't save any preference. I get a popup that means: "this service is no available right now".

The logs give:

Code: [Select]

192.168.2.103 - - [13/Jun/2014:19:43:22 GMT] "GET /SOGo/so/arnaud/preferences HTTP/1.1" 200 16803/0 0.153 71077 76% 0
2014-06-13 19:43:24.762 sogod[4065] Sieve connection failed on sieve://localhost:4190
192.168.2.103 - - [13/Jun/2014:19:43:24 GMT] "POST /SOGo/so/arnaud/preferences HTTP/1.1" 503 49/2084 0.054 - - 0

The second line shows that there is a problem with sieve. 

The only thing that I found in the www is https://wikit.firewall-services.com/doku.php/smedev/dovecot. 

On my test machine with SME8 64 bits, I installed SOGo too (according to the wiki too) for test purposes and I don't have this probleme.

Who can give me some indications to get it running with 32 bits?

Thanks.
Regards
Arnaud

[nicolatiana]

0) I suppose You log-in but You are not able to save preferences; right ?
1) Please confirm that http://smeserver.nethesis.it/releases/8/i386/smeserver-sogo-1.0.1-1.el5.nh.noarch.rpm has been installed and not another (older) release.
2) I see that Sogo 2.2.5 has been released; I suppose that if You installed in past days this release has been installed. Maybe some incompatibility between this relase and the current contrib (at least in 32 bit) ? Or the incompatibility with Dovecot 1.0 is increasing ?
3) Can you log in to SOGo (and save settings) as admin ?
4) Any other relevant error in log (post some more lines, starting from login to logout) ?
5) Did You play with these settings in template ?

SOGoSieveServer = "sieve://localhost:4190";
SOGoVacationEnabled = YES;
SOGoForwardEnabled = YES;
SOGoSieveScriptsEnabled = YES;

I suppose You're testing: consider, as next step after the above checks, to follow FWS wiki to install Dovecot 2.x

http://forums.contribs.org/index.php/topic,50693.0.html

Nicola

[stephdl]

Or jump to sme9

[Arnaud]

Hi Nicola
and thank you for your informations.

0) I suppose You log-in but You are not able to save preferences; right ?

yes!

1) Please confirm that http://smeserver.nethesis.it/releases/8/i386/smeserver-sogo-1.0.1-1.el5.nh.noarch.rpm has been installed and not another (older) release.

I confirm.
I installed Sogo a cup of weeks ago according to the wiki and I have:

Code: [Select]

smeserver-sogo.noarch                   1.0.1-1.el5.nh                       installed
sogo.i386                               2.2.4-1.el5                          installed
sogo-tool.i386                          2.2.4-1.el5                          installed


3) Can you log in to SOGo (and save settings) as admin ?

No, I can't. "Admin" or "user" have the same problem.

4) Any other relevant error in log (post some more lines, starting from login to logout) ?

This is the journal of following:
- login
- open "preferences"
- try to save the preferences without any modification
- get the error popup
- close the popup
- close the window of "preferences"
- logout

Code: [Select]

192.168.2.103 - - [14/Jun/2014:20:42:41 GMT] "POST /SOGo/connect HTTP/1.1" 200 27/45 0.077 - - 0
192.168.2.103 - - [14/Jun/2014:20:42:42 GMT] "GET /SOGo/so/arnaud HTTP/1.1" 302 0/0 0.006 - - 0192.168.2.103 - - [14/Jun/2014:20:42:42 GMT] "GET /SOGo/so/arnaud/view HTTP/1.1" 302 0/0 0.011 - - 0192.168.2.103 - - [14/Jun/2014:20:42:42 GMT] "GET /SOGo/so/arnaud/Mail HTTP/1.1" 302 0/0 0.007 - - 0Jun 14 20:42:42 sogod [3897]: [ERROR] <0x0x8661ad4[WOWatchDog]> No child available to handle incoming request!
2014-06-14 20:42:42.645 sogod[4065] parseTimeZone: cannot parse time notation 'GMT'
2014-06-14 20:42:42.647 sogod[4065] parseTimeZone: cannot parse time notation 'GMT'
2014-06-14 20:42:42.651 sogod[4065] parseTimeZone: cannot parse time notation 'GMT'
2014-06-14 20:42:42.721 sogod[4065] parseTimeZone: cannot parse time notation 'GMT'
2014-06-14 20:42:43.013 sogod[4065] parseTimeZone: cannot parse time notation 'GMT'
192.168.2.103 - - [14/Jun/2014:20:42:43 GMT] "GET /SOGo/so/arnaud/Mail/view HTTP/1.1" 200 17264/0 1.236 86401 80% 0
192.168.2.103 - - [14/Jun/2014:20:42:44 GMT] "POST /SOGo/so/arnaud/Calendar/alarmslist?browserTime=1402771363 HTTP/1.1" 200 380/0 0.018 - - 0
192.168.2.103 - - [14/Jun/2014:20:42:44 GMT] "POST /SOGo/so/arnaud/Mail/0/mailboxes HTTP/1.1" 200 30387/0 0.391 - - 0
192.168.2.103 - - [14/Jun/2014:20:42:45 GMT] "POST /SOGo/so/arnaud/Mail/foldersState HTTP/1.1" 200 0/0 0.009 - - 0
192.168.2.103 - - [14/Jun/2014:20:42:45 GMT] "POST /SOGo/so/arnaud/Mail/0/folderINBOX/unseenCount HTTP/1.1" 200 13/0 0.190 - - 0
192.168.2.103 - - [14/Jun/2014:20:42:50 GMT] "GET /SOGo/so/arnaud/preferences HTTP/1.1" 200 16795/0 0.271 71073 76% 0
2014-06-14 20:42:54.517 sogod[4065] Sieve connection failed on sieve://localhost:4190
192.168.2.103 - - [14/Jun/2014:20:42:54 GMT] "POST /SOGo/so/arnaud/preferences HTTP/1.1" 503 49/2084 0.053 - - 0
192.168.2.103 - - [14/Jun/2014:20:43:01 GMT] "GET /SOGo/so/arnaud/Mail/0/folderINBOX/expunge HTTP/1.1" 200 2/0 0.190 - - 0
Jun 14 20:43:01 sogod [4065]: SOGoUserHomePage user 'arnaud' logged off
192.168.2.103 - - [14/Jun/2014:20:43:01 GMT] "GET /SOGo/so/arnaud/logoff HTTP/1.1" 302 0/0 0.009 - - 0
192.168.2.103 - - [14/Jun/2014:20:43:02 GMT] "GET /SOGo/so/ HTTP/1.1" 200 4512/0 0.125 13175 65% 0

5) Did You play with these settings in template ?

No I don't. I only run the procedure of the wiki.
Where are these templates exactly placed? I could have a look and see the parameters.

At the next, I will try the same installing procedure on a virtual machine 32 bits and see if the problem occurs again.


@Stephdl: its too early for me to switch the prod server on sme9. And I don't have the time to reinstall and reconfigure by hand, set all the parameters I have set during the last years...........


Regards,
Arnaud

[nicolatiana]

Please quote the popup error too.
Attach your /etc/sogo/sogo.conf
Your server is a fresh one or have some "history" ?

Take a look here: https://lists.inverse.ca/sogo/arc/users/2013-11/msg00084.html

I suspect sieve is not the cause but a victim too:

No child available to handle incoming request!

seems more relevant.

Nicola

Addendum: give a look to httpd logs too

[Arnaud]

Hi Nicola,

the /etc/sogo/sogo.conf is as follow:

Code: [Select]

*
 * ------------------------------------------------------------
 *        !!DO NOT MODIFY THIS FILE!!
 * 
 *  Manual changes will be lost when this file is regenerated.
 *
 *  Please read the developer's guide, which is available
 *  at http://www.contribs.org/development/
 *
 *  Copyright (C) 1999-2006 Mitel Networks Corporation
 * ------------------------------------------------------------
 */
{
        NGUseUTF8AsURLEncoding = YES;
        OCSFolderInfoURL = "mysql://sogo:42rqgeUy8muPJaaxVUzmnrRy1DH5ELQS5p4PnUYLR0LQDyP7rcTPfAKM6P6oXbtbPuMFMJhVIecF@localhost/sogo/sogo_folder_info";
        OCSSessionsFolderURL = "mysql://sogo:42rqgeUy8muPJaaxVUzmnrRy1DH5ELQS5p4PnUYLR0LQDyP7rcTPfAKM6P6oXbtbPuMFMJhVIecF@localhost/sogo/sogo_sessions_folder";
        SOGoACLsSendEMailNotifications = NO;
        SOGoAppointmentSendEMailNotifications = YES;
        SOGoAppointmentSendEMailReceipts = YES;
        SOGoAuthenticationMethod = LDAP;
        SOGoDraftsFolderName = Drafts;
        SOGoEnablePublicAccess = YES;
        SOGoFoldersSendEMailNotifications = NO;
        SOGoIMAPServer = localhost;
        SOGoMailDomain = guedel.eu;
        SOGoMailingMechanism = smtp;
        SOGoProfileURL = "mysql://sogo:42rqgeUy8muPJaaxVUzmnrRy1DH5ELQS5p4PnUYLR0LQDyP7rcTPfAKM6P6oXbtbPuMFMJhVIecF@localhost/sogo/sogo_user_profile";
        SOGoSMTPServer = localhost;
        SOGoSentFolderName = Sent;
        SOGoSuperUsernames = (
            admin
        );
        SOGoTimeZone = Europe/Berlin;
        SOGoTrashFolderName = Trash;
        WOWorkersCount = 3;
        SOGoMailAuxiliaryUserAccountsEnabled = YES;
SOGoMailCustomFromEnabled = YES;

        SOGoSieveServer = sieve://localhost:4190;
        SOGoSieveScriptsEnabled = YES;
        SOGoVacationEnabled = YES;
        SOGoForwardEnabled = YES;
        NGImap4ConnectionStringSeparator = ".";

        SOGoUserSources = (

            {
                CNFieldName = cn;
                IDFieldName = uid;
                UIDFieldName = uid;
                baseDN = "ou=Users,dc=guedel,dc=eu";
                canAuthenticate = YES;
                displayName = "Users";
                hostname = localhost;
                id = users;
                isAddressBook = YES;
                port = ;
                type = ldap;
            },
            { 
                CNFieldName = cn;
                IDFieldName = cn;
                UIDFieldName = cn;
                baseDN = "ou=Groups,dc=guedel,dc=eu";
                canAuthenticate = YES;
                displayName = "Groups";
                hostname = localhost;
                id = groups;
                isAddressBook = YES;
                port = ;
                type = ldap;
            }
        );
        WOMessageUseUTF8 = YES;
        WOParsersUseUTF8 = YES;
        WOPort = 127.0.0.1:20000;
        WOUseRelativeURLs = YES;
}
The server has of course already some history, but nothing exotic.
I tried on the virtual machine (that is an old clone of the prod server): exactly the same reaction  The popup only says that the service is not available right now.

I'm thinking about installing sme8 64 bits on the prod server and restore datas and parameter with affa --full-restore. If it woks (= if all the parameters of the 32 bits are compatible with the 64 bits - I think they are) it could be the easier and faster solution (even if it's not the solution of this problem).

But before I'll have a look on the sogo.conf of my 64bits tests machine and compare with the 32 bits.

Regards

Arnaud

[nicolatiana]

WOWorkersCount = 3;

+

https://lists.inverse.ca/sogo/arc/users/2013-11/msg00084.html

According to this post try to modify the above parameter, at first directly (to see if give You some benefit), then modifying a custom template.

Nicola

P.S.: maybe your 64 bit is a fresh install ?

[Daniel B.]

The problem is not the number of workers, but the fact that you have:

Code: [Select]

SOGoSieveServer = "sieve://localhost:4190";
SOGoVacationEnabled = YES;
SOGoForwardEnabled = YES;
SOGoSieveScriptsEnabled = YES;

In sogo.conf

SME doesn't run a sieve service on a default install (unless you use this: https://wikit.firewall-services.com/doku.php/smedev/dovecot, but it's not a default install anymore in this case ). Those directives should be set to NO instead of YES, so SOGo won't try to reach a sieve server, and won't fail anymore when saving preferences.

If you're running the contrib from http://smeserver.nethesis.it/releases/8/i386/smeserver-sogo-1.0.1-1.el5.nh.noarch.rpm the responsible template is /etc/e-smith/templates/etc/sogo/sogod.conf/10defaults, arround line 29:

Code: [Select]

    # check nethservice version for disable sieve filter   
    if ($sysconfig{'ReleaseVersion'} =~ m/^8\.[123456789]$/) {
my $SievePort= ($sogod{'SievePort'} || "4190");
        [...]

Which means sieve is enabled only if you have a ReleaseVersion prop of the sysconfig entry is 8.something. This is a bug in the contrib, as this release version doesn't guarantee you'll have sieve enabled (Nethesis guys probably install a custom IMAP service with sieve enabled). You can override this 10defaults template with a custom-template to disable sieve support.

[nicolatiana]

SOGoSieveServer = "sieve://localhost:4190";
SOGoVacationEnabled = YES;
SOGoForwardEnabled = YES;
SOGoSieveScriptsEnabled = YES;

I did not considered it, sorry; after my recent issues I've upgraded all of my Sogo servers to Dovecot 2.x so for me the above setting are usual. 

More or less Nethesis do something like FWS to run Dovecot 2.x, I suppose

Not clear why in Arnaud's 64 bit is working.

Nicola

[Arnaud]

Hello Daniel
and many thanks for your information: I will try this direction asap and give a (I hope positiv!) report.

For info: the sogo.conf of the 64 bit = sogo.conf of the 32 bits. The 64bits machine is a clone (via affa-restore) of the 32bits machine.

Bye.
Arnaud

[Arnaud]

The problem is not the number of workers, but the fact that you have:

Code: [Select]

SOGoSieveServer = "sieve://localhost:4190";
SOGoVacationEnabled = YES;
SOGoForwardEnabled = YES;
SOGoSieveScriptsEnabled = YES;

In sogo.conf

Bingo! That's it!
As you proposed, I have created and modified the template-custom (sogo.conf and not sogod.conf) by commenting these 4 lines:

Code: [Select]

# my $SievePort= ($sogod{'SievePort'} || "4190");
# $OUT .= "        SOGoSieveServer = sieve://localhost:" . $SievePort . ";\n";
# $OUT .= "        SOGoSieveScriptsEnabled = YES;\n";
# $OUT .= "        SOGoVacationEnabled = YES;\n";
# $OUT .= "        SOGoForwardEnabled = YES;\n";
If I only comment the 2 firsts, I get the problem further (but sieve is searched on an other port).

Now I can save the preferences and of course I don't have the "vacation" and "forward" functions anymore.

One thing is still mysterious: in the preferences, I can set a color for each "category" of date in the agenda. These colors are only displayed in the agenda if the week don't start with "Monday"  (setting in the preferences too) It is not really a problem but it is a pity. I will test with the 64 bits version.

Thanks a lot!
Bye
Arnaud

[nicolatiana]

These colors are only displayed in the agenda if the week don't start with "Monday"

I'll test it too; if you confirm in 64 bit too consider to open a Bug in Sogo's mantis Bug-tracker.

Nicola

[Arnaud]

These colors are only displayed in the agenda if the week don't start with "Monday"  (setting in the preferences too)

Unfortunately, I get the same phenomenon with sme8 64 bits too.......

Arnaud

[Arnaud]

 
I didn't do anything and the colours of the categories are now displayed with the SME8 32 bits!!
The only thing is: when not immediately displayed, switch the agenda to the next month and back to the current month and ......  the categories are coloured...............

Bye
Arnaud