Koozali.org: home of the SME Server

Obsolete Releases => SME 8.x Contribs => Topic started by: Arnaud on June 13, 2014, 07:59:20 PM

Title: SME8 32 bits: problem with SOGo and siebe
Post by: Arnaud on June 13, 2014, 07:59:20 PM
Hello,
I have following problem with SOGo installed according to the wiki http://wiki.contribs.org/Sogo (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.  :sad:

The only thing that I found in the www is https://wikit.firewall-services.com/doku.php/smedev/dovecot (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


Title: Re: SME8 32 bits: problem with SOGo and siebe
Post by: nicolatiana on June 13, 2014, 11:36:18 PM
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 (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 ?
Quote
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 (http://forums.contribs.org/index.php/topic,50693.0.html)

Nicola
Title: Re: SME8 32 bits: problem with SOGo and siebe
Post by: stephdl on June 14, 2014, 07:49:14 AM
Or jump to sme9
Title: Re: SME8 32 bits: problem with SOGo and siebe
Post by: Arnaud on June 14, 2014, 09:00:35 PM
Hi Nicola
and thank you for your informations.

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

Quote
1) Please confirm that http://smeserver.nethesis.it/releases/8/i386/smeserver-sogo-1.0.1-1.el5.nh.noarch.rpm (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

Quote
3) Can you log in to SOGo (and save settings) as admin ?
No, I can't. "Admin" or "user" have the same problem.

Quote
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


Quote
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



Title: Re: SME8 32 bits: problem with SOGo and siebe
Post by: nicolatiana on June 14, 2014, 09:51:45 PM
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 (https://lists.inverse.ca/sogo/arc/users/2013-11/msg00084.html)

I suspect sieve is not the cause but a victim too:
Quote
No child available to handle incoming request!
seems more relevant.

Nicola

Addendum: give a look to httpd logs too
Title: Re: SME8 32 bits: problem with SOGo and siebe
Post by: Arnaud on June 15, 2014, 09:14:47 PM
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  :sad: 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
Title: Re: SME8 32 bits: problem with SOGo and siebe
Post by: nicolatiana on June 15, 2014, 10:11:47 PM
Quote
WOWorkersCount = 3;
+
Quote
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 ?
Title: Re: SME8 32 bits: problem with SOGo and siebe
Post by: Daniel B. on June 16, 2014, 06:45:43 PM
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.
Title: Re: SME8 32 bits: problem with SOGo and siebe
Post by: nicolatiana on June 16, 2014, 07:31:39 PM
Quote
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
Title: Re: SME8 32 bits: problem with SOGo and siebe
Post by: Arnaud on June 17, 2014, 07:12:36 PM
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
Title: Re: SME8 32 bits: problem with SOGo and siebe
Post by: Arnaud on June 20, 2014, 11:51:39 AM
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"  :shock: (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



Title: Re: SME8 32 bits: problem with SOGo and siebe
Post by: nicolatiana on June 20, 2014, 11:56:12 AM
Quote
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
Title: Re: SME8 32 bits: problem with SOGo and siebe
Post by: Arnaud on June 20, 2014, 04:01:30 PM
Quote
These colors are only displayed in the agenda if the week don't start with "Monday"  :shock: (setting in the preferences too)
Unfortunately, I get the same phenomenon with sme8 64 bits too.......

Arnaud
Title: Re: SME8 32 bits: problem with SOGo and siebe
Post by: Arnaud on June 22, 2014, 09:58:22 PM
 :lol: :lol:
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