URL: https://linuxfr.org/forums/linux-general/posts/webmail-sogo-connexion-database-avec-socket Title: Webmail sogo connexion database avec socket Authors: electro575 Date: 2025年04月15日T10:23:53+02:00 License: CC By-SA Tags: webmail, sogo et postgresql Score: 0 Bonjour à tous, Je suis sous debian sid. J'aimerais que sogo puisse se connecter à sa database postgresql via un socket unix. Je n'ai rien trouvé dans la doc officiel donc j'ai suivi deux liens faisant référence à une connexion par socket. [https://users.sogo.narkive.com/VMCKWiPY/sogo-connect-sogo-to-memcached-and-pgsql-with-unix-socket](https://users.sogo.narkive.com/VMCKWiPY/sogo-connect-sogo-to-memcached-and-pgsql-with-unix-socket) [https://www.tumfatig.net/2011/configure-sogo-to-use-mysql-socket/](https://www.tumfatig.net/2011/configure-sogo-to-use-mysql-socket/) J'ai essayé plusieurs syntaxes. ``` viewURL = "postgresql://%2Frun%2Fpostgresql/sogo/sogo_users"; viewURL = "postgresql://user:mdp@%2Frun%2Fpostgresql/sogo/sogo_users"; viewURL = "postgresql://user:mdp@%2Frun%2Fpostgresql%2F.s.PGSQL.5432/sogo/sogo_users"; ``` Voici ma configuration sogo.conf ``` { SOGoUserSources = ( { type = sql; id = directory; viewURL = "postgresql://%2Frun%2Fpostgresql/sogo/sogo_users"; canAuthenticate = NO; isAddressBook = YES; userPasswordAlgorithm = md5; displayName = "Global Address Book"; } ); SOGoProfileURL = "postgresql://%2Frun%2Fpostgresql/sogo/sogo_user_profile"; OCSFolderInfoURL = "postgresql://%2Frun%2Fpostgresql/sogo/sogo_folder_info"; OCSSessionsFolderURL = "postgresql://%2Frun%2Fpostgresql/sogo/sogo_sessions_folder"; OCSEMailAlarmsFolderURL = "postgresql://%2Frun%2Fpostgresql/sogo/sogo_alarms_folder"; SOGoLanguage = French; SOGoAppointmentSendEMailNotifications = YES; SOGoMailingMechanism = smtp; SOGoSMTPServer = 127.0.0.1; SOGoTimeZone = Europe/Paris; SOGoSentFolderName = Sent; SOGoTrashFolderName = Trash; SOGoDraftsFolderName = Drafts; SOGoIMAPAclConformsToIMAPExt = YES; SOGoVacationEnabled = NO; SOGoSieveScriptsEnabled = NO; SOGoFirstDayOfWeek = 0; SOGoMailMessageCheck = manually; SOGoMailAuxiliaryUserAccountsEnabled = NO; SOGoMemcachedHost = /run/memcached/memcached.sock; SOGoMailingMechanism = smtp; SOGoSMTPServer = 127.0.0.1; SOGoForceExternalLoginWithEmail = NO; SOGoDraftsFolderName = Drafts; SOGoSentFolderName = Sent; SOGoTrashFolderName = Trash; SOGoJunkFolderName = Junk; SOGoSieveFolderEncoding = UTF-8; SOGoMailShowSubscribedFoldersOnly = NO; SOGoIMAPAclStyle = rfc4314; SOGoIMAPAclConformsToIMAPExt = NO; SOGoForceExternalLoginWithEmail = NO; SOGoMailSpoolPath = /var/spool/sogo; NGMimeBuildMimeTempDirectory = /tmp; SOGoVacationEnabled = NO; SOGoForwardEnabled = NO; SOGoSieveScriptsEnabled = NO; SOGoMailAuxiliaryUserAccountsEnabled = NO; SOGoFirstDayOfWeek = 0; /* Common IMAP and SMTP Configuration*/ SOGoMailMessageCheck = every_5_minutes; SOGoForceExternalLoginWithEmail = NO; /* IMAP Configuration */ SOGoIMAPServer = "imap://localhost:XXXX/"; SOGoSieveServer = "sieve://127.0.0.1:XXXX"; /* Debug */ GCSFolderDebugEnabled = YES; GCSFolderStoreDebugEnabled = YES; LDAPDebugEnabled = YES; MySQL4DebugEnabled = YES; NGImap4DisableIMAP4Pooling = YES; OCSFolderManagerSQLDebugEnabled = YES; PGDebugEnabled = YES; SOGoDebugRequests = YES; SOGoMailKeepDraftsAfterSend = YES; SOGoUIxDebugEnabled = YES; SoDebugObjectTraversal = YES; SoSecurityManagerDebugEnabled = YES; WODontZipResponse = YES; WODebugZipResponse = YES; /* IMAP Server configuration */ SOGoMailDomain = mydomain.org; } ``` Rien n'y fait, je suis toujours bloqué. Voici les logs ``` Apr 15 10:18:31 sogod [100537]: version 5.12.0 -- starting Apr 15 10:18:31 sogod [100537]: vmem size check enabled: shutting down app when vmem> 384 MB. Currently at 100 MB Apr 15 10:18:31 sogod [100537]: <0x0xaaaaf5237780[sogoproductloader]> SOGo products loaded from '/usr/lib/aarch64-linux-gnu/GNUstep/SOGo': Apr 15 10:18:31 sogod [100537]: <0x0xaaaaf5237780[sogoproductloader]> Contacts.SOGo, ContactsUI.SOGo, Appointments.SOGo, MainUI.SOGo, AdministrationUI.SOGo, Mailer.SOGo, SchedulerUI.SOGo, PreferencesUI.SOGo, MailerUI.SOGo, MailPartViewers.SOGo, CommonUI.SOGo Apr 15 10:18:31 sogod [100537]: All products loaded - current memory usage at 107 MB Apr 15 10:18:31 sogod [100537]: <0x0xaaaaf525b7e0[wowatchdog]> listening on 127.0.0.1:20000 Apr 15 10:18:31 sogod [100537]: <0x0xaaaaf525b7e0[wowatchdog]> watchdog process pid: 100537 Apr 15 10:18:31 sogod [100537]: <0x0xffff91feb8d0[wowatchdogchild]> watchdog request timeout set to 10 minutes Apr 15 10:18:31 sogod [100537]: <0x0xaaaaf525b7e0[wowatchdog]> preparing 3 children Apr 15 10:18:31 sogod [100537]: <0x0xaaaaf525b7e0[wowatchdog]> child spawned with pid 100538 Apr 15 10:18:31 sogod [100537]: <0x0xaaaaf525b7e0[wowatchdog]> child spawned with pid 100539 Apr 15 10:18:31 sogod [100537]: <0x0xaaaaf525b7e0[wowatchdog]> child spawned with pid 100540 2025年04月15日 10:18:32.054 sogod[100538:100538] could not open channel to sogo@/run/postgresql/.s.PGSQL.5432 Apr 15 10:18:32 sogod [100538]: [ERROR] <0x0xaaaaf53c2f30[gcschannelmanager]> could not open channel <0x0xaaaaf539c650[postgresql72channel]: not-connected> for postgresql:///run/postgresql/.s.PGSQL.5432/sogo/sogo_user_profile Apr 15 10:18:32 sogod [100538]: [WARN] <0x0xaaaaf53c2f30[gcschannelmanager]> will prevent opening of this channel 5 seconds after 2025年04月15日 10:18:31 +0200 2025年04月15日 10:18:32.058 sogod[100539:100539] could not open channel to sogo@/run/postgresql/.s.PGSQL.5432 Apr 15 10:18:32 sogod [100539]: [ERROR] <0x0xaaaaf53c2f30[gcschannelmanager]> could not open channel <0x0xaaaaf539c650[postgresql72channel]: not-connected> for postgresql:///run/postgresql/.s.PGSQL.5432/sogo/sogo_user_profile Apr 15 10:18:32 sogod [100539]: [WARN] <0x0xaaaaf53c2f30[gcschannelmanager]> will prevent opening of this channel 5 seconds after 2025年04月15日 10:18:31 +0200 Apr 15 10:18:32 sogod [100538]: [ERROR] <0x0xffff923929b0[gcsadminfolder]> 'OCSAdminURL' is not set Apr 15 10:18:32 sogod [100538]: <0x0xaaaaf551c460[wohttpadaptor]> notified the watchdog that we are ready 2025年04月15日 10:18:32.062 sogod[100540:100540] could not open channel to sogo@/run/postgresql/.s.PGSQL.5432 Apr 15 10:18:32 sogod [100540]: [ERROR] <0x0xaaaaf53c2f30[gcschannelmanager]> could not open channel <0x0xaaaaf539c650[postgresql72channel]: not-connected> for postgresql:///run/postgresql/.s.PGSQL.5432/sogo/sogo_user_profile Apr 15 10:18:32 sogod [100540]: [WARN] <0x0xaaaaf53c2f30[gcschannelmanager]> will prevent opening of this channel 5 seconds after 2025年04月15日 10:18:31 +0200 Apr 15 10:18:32 sogod [100539]: [ERROR] <0x0xffff923929b0[gcsadminfolder]> 'OCSAdminURL' is not set Apr 15 10:18:32 sogod [100539]: <0x0xaaaaf551c460[wohttpadaptor]> notified the watchdog that we are ready Apr 15 10:18:32 sogod [100540]: [ERROR] <0x0xffff923929b0[gcsadminfolder]> 'OCSAdminURL' is not set Apr 15 10:18:32 sogod [100540]: <0x0xaaaaf551c480[wohttpadaptor]> notified the watchdog that we are ready ``` Merci pour vos conseils

AltStyle によって変換されたページ (->オリジナル) /