Installation SOGO

Support Debian
#1

Bonjour j’aimerai installé sogo sur debian squeeze.
J’ai suvi ce tuto :http://wiki.debian.org/SOGo
En remplaçant juste md5 par sha1 et les noms de domaines ainsi que les mots de passe.
Mon problème est d’une part que il y a pas de lien entre le nom de domaine et l’ip du serveur en utilisant sa cfg:

<VirtualHost *:80>
   Servername sogo.debiantest.com
   DocumentRoot /usr/lib/GNUstep/SOGo/WebServerResources/
   ErrorLog /var/log/apache2/error.log
   Customlog /var/log/apache2/access.log combined
   ServerSignature Off

   Alias /SOGo.woa/WebServerResources/ /usr/lib/GNUstep/SOGo/WebServerResources/
   Alias /SOGo/WebServerResources/ /usr/lib/GNUstep/SOGo/WebServerResources/
   AliasMatch /SOGo/so/ControlPanel/Products/(.*)/Resources/(.*) /usr/lib/GNUstep/SOGo/$1.SOGo/Resources/$2

   <Directory /usr/lib/GNUstep/SOGo/>
      AllowOverride None
      Order deny,allow
      Allow from all
   </Directory>

   <LocationMatch "^/SOGo/so/ControlPanel/Products/.*UI/Resources/.*\.(jpg|png|gif|css|js)">
     SetHandler default-handler
   </LocationMatch>

   ProxyRequests Off
   SetEnv proxy-nokeepalive 1
   ProxyPreserveHost On
   ProxyPass /SOGo http://127.0.0.1:20000/SOGo retry=0

   <Proxy http://127.0.0.1:20000/SOGo>
     RequestHeader set "x-webobjects-server-port" "80"
     RequestHeader set "x-webobjects-server-name" "sogo.debiantest.com"
     RequestHeader set "x-webobjects-server-url" "http://sogo.debiantest.com"
     RequestHeader set "x-webobjects-server-protocol" "HTTP/1.0"
     RequestHeader set "x-webobjects-remote-host" %{REMOTE_HOST}e env=REMOTE_HOST
     AddDefaultCharset UTF-8
     Order allow,deny
     Allow from all
   </Proxy>
   ## We use mod_rewrite to pass remote address to the SOGo proxy.
   # The remote address will appear in SOGo's log files and in the X-Forward
   # header of emails.
   RewriteEngine On
   RewriteRule ^/SOGo/(.*)$ /SOGo/$1 [env=REMOTE_HOST:%{REMOTE_ADDR},PT]

   Redirect permanent /index.html http://sogo.debiantest.com/SOGo

</Virtualhost>[/code]

D'autre part quand j'arrive sur la page en utilisant l'ip et que j'entre le nom d'utilisateur et le mot de passe, il me met Mauvais nom d'utilisateur ou mot de passe.

[code]#!/bin/bash
su sogo
defaults write sogod SOGoTimeZone "Europe/Amsterdam"
defaults write sogod SOGoMailDomain "debiantest.com"
defaults write sogod SOGoLanguage "French"
# say "isAddressBook = NO" for a shared hosting situation
# this is a very long line:
defaults write sogod SOGoUserSources '({canAuthenticate = YES; displayName = "SOGo Users"; id = users; isAddressBook = YES; type = sql; userPasswordAlgorithm = sha1; viewURL ="mysql://sogo:mdp@127.0.0.1:3306/sogo/sogo_users";})'
defaults write sogod SOGoProfileURL 'mysql://sogo:mdp@127.0.0.1:3306/sogo/sogo_user_profile'
defaults write sogod OCSFolderInfoURL 'mysql://sogo:mdp@127.0.0.1:3306/sogo/sogo_folder_info'
defaults write sogod OCSSessionsFolderURL 'mysql://sogo:mdp@127.0.0.1:3306/sogo/sogo_sessions_folder'
defaults write sogod SOGoAppointmentSendEMailNotifications NO
defaults write sogod SOGoLoginModule Calendar
defaults write sogod SOGoSieveScriptsEnabled YES
defaults write sogod SOGoSieveServer sieve://localhost
defaults write sogod SOGoVacationEnabled YES
defaults write sogod SOGoMailMessageCheck every_5_minutes
defaults write sogod SOGoFirstDayOfWeek 1
# I am using Cyrus IMAP 2.2 in the default settings, I needed this 4 lines 
# for mailbox setting. I don't think you need them with other IMAP servers:
defaults write sogod SOGoDraftsFolderName "INBOX.Drafts"
defaults write sogod SOGoSentFolderName "INBOX.Sent"
defaults write sogod SOGoTrashFolderName "INBOX.Trash"
defaults write sogod NGImap4ConnectionStringSeparator "."
exit
/etc/init.d/sogo restart

Voici les logs:
errors.log:

sogo.log:

May 03 10:19:29 sogod [960]: version 1.3.6 (build @vizzini.inverse.ca 201104081810) -- starting May 03 10:19:29 sogod [960]: vmem size check enabled: shutting down app when vmem > 384 MB May 03 10:19:29 sogod [960]: <0x0x90d2950[SOGoProductLoader]> SOGo products loaded from '/usr/lib/GNUstep/SOGo': May 03 10:19:29 sogod [960]: <0x0x90d2950[SOGoProductLoader]> ContactsUI.SOGo, MainUI.SOGo, AdministrationUI.SOGo, Mailer.SOGo, CommonUI.SOGo, Contacts.SOGo, MailPartViewers.SOGo, PreferencesUI.SOGo, SchedulerUI.SOGo, Appointments.SOGo, MailerUI.SOGo May 03 10:19:30 sogod [960]: <0x0x91c0d78[WOWatchDog]> listening on *:20000 May 03 10:19:30 sogod [960]: <0x0x91c0d78[WOWatchDog]> watchdog process pid: 960 May 03 10:19:30 sogod [960]: <0x0xb75a1180[WOWatchDogChild]> watchdog request timeout set to 10 minutes May 03 10:19:30 sogod [960]: <0x0x91c0d78[WOWatchDog]> preparing 1 children May 03 10:19:30 sogod [960]: <0x0x91c0d78[WOWatchDog]> child spawned with pid 975 2011-05-03 10:19:31.214 sogod[975] ERROR: could not open MySQL4 connection to database 'sogo': Can't connect to MySQL server on '127.0.0.1' (111) May 03 10:19:31 sogod [975]: [ERROR] <0x0x916d5d8[GCSChannelManager]> could not open channel <MySQL4Channel[0x0x8fd7230] connection=0x(null)> for URL: mysql://sogo:mdp@127.0.0.1:3306/sogo/sogo_user_profile May 03 10:19:31 sogod [975]: [WARN] <0x0x916d5d8[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2011-05-03 10:19:30 +0200

Merci d’avance :slightly_smiling:

#2

Bonjour,

Sujet un peu vieux, mais ça peut toujours servir.
Le message d’erreur est assez clair: 2011-05-03 10:19:31.214 sogod[975] ERROR: could not open MySQL4 connection to database ‘sogo’: Can’t connect to MySQL server on ‘127.0.0.1’ (111).

Il faut donc que tu vérifies les différentes informations de connexion à la base MySQL.

  • Le serveur MySQL est-il bien lancé sur ta machine? Les connexions TCP sont-elles autorisées (normalement oui par défaut, mais il arrive que ce soit désactivé, la plupart des services se connectent par socket)?
  • La base MySQL “sogo” existe-t-elle?
  • L’utilisateur MySQL “sogo” est-il bien identifié par “mdp”?
  • L’utilisateur MySQL “sogo” a-t-il bien les droits sur la base “sogo”?

Tu peux vérifier tout ça d’un coup, en ligne de commande:

$ mysql --host=127.0.0.1 --port=3306 --user=sogo --database=sogo --password=mdp
mysql> select * from sogo_users;
+-------------------------+-------------------------+----------------------------------+------------------+-------------------------+
| c_uid                   | c_name                  | c_password                       | c_cn             | mail                    |
+-------------------------+-------------------------+----------------------------------+------------------+-------------------------+
| blablabla               | blablabla               | blablabla                        | blablabla        | blablabla               |
+-------------------------+-------------------------+----------------------------------+------------------+-------------------------+
1 row in set (0.00 sec)
#3

J’ai finallement opté pour Zarafa.
merci d’avoir rép, ça me sera utile :slightly_smiling: