View Issue Details

IDProjectCategoryView StatusLast Update
0000638SOGoWeb Preferencespublic2010-05-29 19:03
Reporterwharf Assigned Toludovic  
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionno change required 
Product Versionnightly v2 
Summary0000638: [SOGO1.2.2 Nightly] recording preferences fails with proxy error
Description

When 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.

Activities

wharf

wharf

2010-05-29 12:18

reporter   ~0001067

Last edited: 2010-05-29 12: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.

ludovic

ludovic

2010-05-29 12:22

administrator   ~0001068

My guess is that you enabled Sieve and you don't have a managesieve daemon listening.

wharf

wharf

2010-05-29 12:28

reporter   ~0001069

Last edited: 2010-05-29 12: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.

ludovic

ludovic

2010-05-29 12:33

administrator   ~0001070

In any case, show your .GNUstepDefaults.

wharf

wharf

2010-05-29 12:48

reporter   ~0001072

Last edited: 2010-05-29 12: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&quot;;
WOMessageUseUTF8 = YES;
WOParsersUseUTF8 = YES;
WOPort = 20000;
WOSendMail = smtp;
SxVMemLimit = 512;

};

}

wharf

wharf

2010-05-29 18:43

reporter   ~0001073

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 11:12 wharf New Issue
2010-05-29 12:18 wharf Note Added: 0001067
2010-05-29 12:22 ludovic Note Added: 0001068
2010-05-29 12:23 wharf Note Edited: 0001067
2010-05-29 12:28 wharf Note Added: 0001069
2010-05-29 12:30 wharf Note Edited: 0001069
2010-05-29 12:33 ludovic Note Added: 0001070
2010-05-29 12:48 wharf Note Added: 0001072
2010-05-29 12:49 wharf Note Edited: 0001072
2010-05-29 12:50 wharf Note Edited: 0001072
2010-05-29 18:43 wharf Note Added: 0001073
2010-05-29 19:03 ludovic Status new => resolved
2010-05-29 19:03 ludovic Resolution open => no change required
2010-05-29 19:03 ludovic Assigned To => ludovic