Jeff Folk a écrit , Le 25.03.2011 20:58:
On Mar 25, 2011, at 2:46 PM, DBM wrote:
Hello,
this is my first post on the list.
I was convinced to try SOGo and it seems very powerful but of course not
everything works perfectly out of the box ... !
I spent some time checking the archive and even if some topic were
closed to my question none of the idea posted could solve the following
problem.
On a fresh debian installation (dpkg -l sogo > 1.3.5a) used with
postgresql instead of mysql,
no matter if you have activity, after 5 minutes you are disconnected !
lots of posts spoke about the following parameter which I did set
without any visible change :
OCSSessionsFolderURL
="postgresql://sogo:myDBpassword@localhost:5432/sogo/sogo_sessions_folder";
I cheked into the database and the table sogo_sessions_folder is not
created but I read in a post that SOGo should create it by itself if it
does not exists.
Also I noticed that with or whithout this set into the GNUstepDefaults
file, I always have the following ERROR in the log file :
Mar 24 16:41:44 sogod [398]: [ERROR] <0x0xb7f38a20[GCSSessionsFolder]>
'OCSSessionsFolderURL' is not set
I also did set SOGoLoginModule = "Calendar"; but it has also no effect ...
I wonder if, being in 1.3.5a, the conf file should now be XML ans is not
understood ?
I tried to increase the log verbosity but it didn't give more idea
except another evidence of a strange behaviour described below :
I guess this is not related but I have also a strange message and I
don't know where it comes from as it appears each time I move or create
an event (french text but without french characters) :
"...
2011-03-24 16:43:21.380 sogod[398] <0x0x9c8c480[PostgreSQL72Channel]:
connection=<0x0x9d6e5e0[PGConnection]: connection=0x0x9d6e6f8>>:
message: ATTENTION: utilisation non standard de \\ dans une chaîne
littérale
LINE 1: UPDATE sogo_user_profile SET c_settings = '{"Calendar": ...
^
HINT: Utilisez la syntaxe de chaîne d'échappement pour les antislashs,
c'est-à-dire E'\\'.
..."
thanks for any hint or help,
Regard,
Franck
Did you also restart memcached and sogod after writing the entry to the
defaults file?
Jeff
Hello Jeff,
you're are fast on the draw ;-)
I did restart the sogo daemon but not the memcached !
I try that and keep you informed,
thanks,
I've just tried to restart the two of them but still the 5 minutes
logout and the ERROR in the log ...
by the way here is the full conf as Ludovic asks (some elements seem to
appear on a new line, they are, not it's just because of 72 char
wrapping in the mail):
{
NSGlobalDomain = {
};
sogod = {
SOGoUIxDebugEnabled = YES;
GCSFolderDebugEnabled = YES;
GCSFolderStoreDebugEnabled = YES;
SOGoDebugRequests = YES;
WOApplicationRedirectURL = YES;
NGUseUTF8AsURLEncoding = YES;
OCSSessionsFolderURL
="postgresql://sogo:******@localhost:5432/sogo/sogo_sessions_folder";
OCSFolderInfoURL =
"postgresql://sogo:******@localhost:5432/sogo/sogo_folder_info";
SOGoACLsSendEMailNotifications = NO;
SOGoAppointmentSendEMailNotifications = NO;
SOGoAuthenticationMethod = SQL;
SOGoDraftsFolderName = INBOX.Drafts;
SOGoFoldersSendEMailNotifications = NO;
SOGoIMAPServer = localhost;
SOGoLanguage = French;
SOGoMailDomain = jm-secours.com;
SOGoMailingMechanism = smtp;
SOGoOtherUsersFolderName = "Other Users";
SOGoProfileURL =
"postgresql://sogo:******@localhost:5432/sogo/sogo_user_profile";
SOGoSMTPServer = smtp-out.dbm.lan;
SOGoSentFolderName = INBOX.Sent;
SOGoSharedFolderName = "Shared Folders";
SOGoTimeZone = Europe/Paris;
SOGoTrashFolderName = INBOX.Trash;
SOGoEnableEMailAlarms = NO;
SOGoMailAuxiliaryUserAccountsEnabled = YES;
SOGoUserSources = (
{
canAuthenticate = YES;
id = Interne;
isAddressBook = YES;
type = sql;
userPasswordAlgorithm = md5;
viewURL =
"postgresql://sogo:******@localhost:5432/sogo/sogo_view";
}
);
WOMessageUseUTF8 = YES;
WOParsersUseUTF8 = YES;
WOPort = "20000";
WOUseRelativeURLs = NO;
WOWorkersCount = "5";
SOGoLoginModule = "Calendar";
};
}
Regards,
Franck
--
[email protected]
https://inverse.ca/sogo/lists
