SOGo | BTS

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000638SOGoWeb Preferencespublic2010-05-29 07:122010-05-29 15:03
Reporterwharf 
Assigned Toludovic 
PrioritynormalSeverityminorReproducibilityalways
StatusresolvedResolutionno change required 
PlatformOSOS Version
Product Versionnightly v2 
Target VersionFixed in Version 
Summary0000638: [SOGO1.2.2 Nightly] recording preferences fails with proxy error
DescriptionWhen attempting record of preferences in SOGo i get this message in sogo logs
 
sogod[6708] ERROR: MySQL4 field is marked unsigned (unsupported): {columnName = c_folder_id; name = c_folder_id; }


In same time a window shows with proxy error 502

Proxy Error

The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request POST /SOGo/SOGo/my_username/preferences.

Reason: Error reading from remote server

Apache/2.2.3 (CentOS) Server at 127.0.0.1 Port 443
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0001067)
wharf (reporter)
2010-05-29 08:18
edited on: 2010-05-29 08:23

I changed the faulty column to SIGNED attribute but now that error does not appear anymore i have something else

"GET /SOGo/SOGo/so/user_name/preferences HTTP/1.1" 200 14051/0 0.245 55082 74% 564K
EXCEPTION: <NGCouldNotConnectException: 0x975d078> NAME:NGCouldNotConnectException REASON:Could not connect to address <0x0x97230b0[NGInternetSocketAddress]: host=localhost port=2000>: connection refused INFO:(nil)

Yes i noticed that the port which sould be 20000 is 2000 but my httpd.conf is ok with the right values in it and the sogo.conf as well.
I have no idea on what is the origin of this message in the log. Still have the proxy error 502 in despite of changing and restarting apache and sogod.

User avatar (0001068)
ludovic (administrator)
2010-05-29 08:22

My guess is that you enabled Sieve and you don't have a managesieve daemon listening.
(0001069)
wharf (reporter)
2010-05-29 08:28
edited on: 2010-05-29 08:30

For now i added nothing like sieve or something else, the machine where sogo is installed is a kind of sandbox, a standalone server dedicated to sogo. Perhaps it is installed out of the box with CentOS ?
I will check what you suggested.

The postfix production server is remote.
I didn't yet installed IMAP on the remote server.
I will try to exclude IMAP from sogo.conf if it happens that sieve is not installed on the sogo server.

Thank you for your kind help.

User avatar (0001070)
ludovic (administrator)
2010-05-29 08:33

In any case, show your .GNUstepDefaults.
(0001072)
wharf (reporter)
2010-05-29 08:48
edited on: 2010-05-29 08:50

Of course, here it is :

{
    NSGlobalDomain = {
    };
    sogod = {
        OCSFolderInfoURL = "mysql://sogo:pss@localhost:3306/sogo/sogo_folder_info";
        SOGoACLsSendEMailNotifications = YES;
        SOGoAppointmentSendEMailNotifications = YES;
        SOGoAuthenticationMethod = LDAP;
        SOGoDraftsFolderName = Drafts;
        SOGoFirstDayOfWeek = 1;
        SOGoFoldersSendEMailNotifications = YES;
        SOGoForceIMAPLoginWithEmail = NO;
        SOGoForwardEnabled = YES;
        SOGoImapServer = mail.toto.eu;
        SOGoLanguage = French;
        SOGoMailDomain = "toto.eu";
        SOGoMailingMechanism = smtp;
        SOGoOtherUsersFolderName = "Other Users";
        SOGoProfileURL "mysql://sogo:pss@localhost:3306/sogo/sogo_user_profile";
        SOGoSMTPServer = smtp.toto.eu;
        SOGoSentFolderName = Sent;
        SOGoSharedFolderName = "Fichiers partages";
        SOGoSuperUsernames = (
            mouarf
        );
        SOGoTimeZone = Europe/Paris;
        SOGoTrashFolderName = Trash;
        SOGoUserSources = (
            {
                CNFieldName = cn;
                IDFieldName = uid;
                UIDFieldName = uid;
                baseDN = "dc=toto,dc=net";
                bindDN = "cn=manager,dc=toto,dc=net";
                bindFields = uid;
                bindPassword = "xxxxxxx";
                canAuthenticate = YES;
                displayName = "Addresses Partages";
                hostname = 192.168.7.250;
                id = public;
                isAddressBook = YES;
                port = 389;
                type = ldap;
                }
        );
        SOGoVacationEnabled = YES;
        WOApplicationRedirectURL = "https://127.0.0.1/SOGo"; [^]
        WOMessageUseUTF8 = YES;
        WOParsersUseUTF8 = YES;
        WOPort = 20000;
        WOSendMail = smtp;
        SxVMemLimit = 512;

    };
}

(0001073)
wharf (reporter)
2010-05-29 14:43

Seems that you guessed right, i modified the file and it shows more verbose message in the logs, the fact is that it can't reach the smtp server.
So i think this bug can be closed, i'm sure it has something in relation with some locked ports on the remote mail server.

Thank you very much for your help.

- Issue History
Date Modified Username Field Change
2010-05-29 07:12 wharf New Issue
2010-05-29 08:18 wharf Note Added: 0001067
2010-05-29 08:22 ludovic Note Added: 0001068
2010-05-29 08:23 wharf Note Edited: 0001067
2010-05-29 08:28 wharf Note Added: 0001069
2010-05-29 08:30 wharf Note Edited: 0001069
2010-05-29 08:33 ludovic Note Added: 0001070
2010-05-29 08:48 wharf Note Added: 0001072
2010-05-29 08:49 wharf Note Edited: 0001072
2010-05-29 08:50 wharf Note Edited: 0001072
2010-05-29 14:43 wharf Note Added: 0001073
2010-05-29 15:03 ludovic Status new => resolved
2010-05-29 15:03 ludovic Resolution open => no change required
2010-05-29 15:03 ludovic Assigned To => ludovic


Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker