Forum Linux.général Webmail sogo connexion database avec socket

Posté par  . Licence CC By‑SA.
Étiquettes :
0
15
avr.
2025

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://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

  • # Je ne connaissais pas ce logiciel.

    Posté par  . Évalué à 3.

    C'est un webmail

    Les deux liens dans le message sont vieux de 14 ans, il y a peut être plus récent à trouver. Le projet est toujours maintenu mais, je pense qu'il vaut mieux chercher dans l'archive de leur mailing list (il ne semble pas y avoir de forum officiel):
    https://www.mail-archive.com/users%40sogo.nu/

    Sinon, vu le message d'erreur,

    sogod[100540:100540] could not open channel to sogo@/run/postgresql/.s.PGSQL.5432

    c'est peut être lié à la connexion à la BDD. Je regarderais donc du coté des logs de Postgresql voir s'il y a des connexions refusées.

    cette erreur est à creuser aussi

    'OCSAdminURL' is not set

    Un problème de config encore manifestement

    "Si tous les cons volaient, il ferait nuit" F. Dard

Suivre le flux des commentaires

Note : les commentaires appartiennent à celles et ceux qui les ont postés. Nous n’en sommes pas responsables.