#---------- SOGo installation ----------#

echo "deb http://http.debian.net/debian jessie-backports main" > /etc/apt/sources.list.d/backports.list

echo -e "deb http://inverse.ca/debian-v3 jessie jessie\n\
deb-src http://inverse.ca/debian-v3 jessie jessie" > /etc/apt/sources.list.d/SOGo.list

apt-key adv --keyserver keys.gnupg.net --recv-key 0x810273C4

apt-get update
apt-get install mysql-server sogo sope4.9-gdl1-mysql apache2 libapache2-mod-wsgi memcached

mysqladmin -u root -pazerty create sogo;
mysql -u root -pazerty -e "CREATE USER 'sogo'@'localhost' IDENTIFIED BY 'sogo';"
mysql -u root -pazerty -e "GRANT ALL PRIVILEGES ON sogo.* TO 'sogo'@'localhost';"
mysqladmin -u root -pazerty flush-privileges

a2enmod headers
a2enmod proxy
a2enmod proxy_http
a2enmod ssl
a2enmod rewrite
a2dismod reqtimeout

a2ensite default-ssl.conf

/etc/init.d/apache2 restart; /etc/init.d/sogo restart

{
  /* Database configuration (mysql:// or mysql://) */
  SOGoProfileURL = "mysql://sogo:sogo@localhost:3306/sogo/sogo_user_profile";
  OCSFolderInfoURL = "mysql://sogo:sogo@localhost:3306/sogo/sogo_folder_info";
  OCSSessionsFolderURL = "mysql://sogo:sogo@localhost:3306/sogo/sogo_sessions_folder";

  /* Mail */
  SOGoIMAPServer = "imaps://mail.example.fr:993";
  SOGoSieveServer = "sieve://mail.example.fr:4190";
  SOGoSMTPServer = mx.example.fr;
  SOGoMailDomain = example.fr;
  SOGoMailingMechanism = smtp;

  /* Notifications */
  SOGoAppointmentSendEMailNotifications = YES;
  SOGoFoldersSendEMailNotifications = NO;

  /* Authentication */
  SOGoPasswordChangeEnabled = NO;

  /* LDAP authentication example */
  SOGoUserSources = (
    {
      type = ldap;
      CNFieldName = cn;
      UIDFieldName = uid;
      IDFieldName =mail; // first field of the DN for direct binds
      bindFields = (uid, mail, cn); // array of fields to use for indirect binds
      baseDN = "dc=example,dc=fr";
      bindAsCurrentUser= YES;
      filter = "(o='example' OR ou='example' OR ou='sogo')";
      MultipleBookingsFieldName = "MultipleBookings";
      KindFieldName = "Kind";
      canAuthenticate = YES;
      displayName = "Shared Addresses";
      hostname = ldap://ldap.example.fr:389;
      id = public;
      isAddressBook = YES;
      IMAPLoginFieldName = mail;
    }
  );

  /* Web Interface */
  SOGoVacationEnabled = YES;
  SOGoSieveScriptsEnabled = YES;
  SOGoLoginModule = Calendar;
  SOGoCalendarDefaultRoles = (PublicViewer,ConfidentialDAndTViewer,PrivateDAndTViewer);

  /* General */
  SOGoLanguage = French;
  SOGoTimeZone = Europe/Paris;
  SOGoSuperUsernames = (serdar); // This is an array - keep the parens!
  WOPidFile = "/var/run/sogo/sogo.pid";
  
  /* Debug */
  SOGoDebugRequests = YES;
  SoDebugBaseURL = YES;
  ImapDebugEnabled = YES;
  LDAPDebugEnabled = YES;
  PGDebugEnabled = YES;
  MySQL4DebugEnabled = YES;
  SOGoUIxDebugEnabled = YES;
  WODontZipResponse = YES;
  WOLogFile = /var/log/sogo/sogo.log;
}

Alias /SOGo.woa/WebServerResources/ \
      /usr/lib/GNUstep/SOGo/WebServerResources/
Alias /SOGo/WebServerResources/ \
      /usr/lib/GNUstep/SOGo/WebServerResources/

<Directory /usr/lib/GNUstep/SOGo/>
    AllowOverride None

    <IfVersion < 2.4>      
        Order deny,allow
        Allow from all
    </IfVersion>
    <IfVersion >= 2.4>
        Require all granted
    </IfVersion>

    # Explicitly allow caching of static content to avoid browser specific behavior.
    # A resource's URL MUST change in order to have the client load the new version.
    <IfModule expires_module>
      ExpiresActive On
      ExpiresDefault "access plus 1 year"
    </IfModule>
</Directory>

## Uncomment the following to enable proxy-side authentication, you will then
## need to set the "SOGoTrustProxyAuthentication" SOGo user default to YES and
## adjust the "x-webobjects-remote-user" proxy header in the "Proxy" section
## below.
#
## For full proxy-side authentication:
#<Location /SOGo>
#  AuthType XXX
#  Require valid-user
#  SetEnv proxy-nokeepalive 1
#  Allow from all
#</Location>
#
## For proxy-side authentication only for CardDAV and GroupDAV from external
## clients:
#<Location /SOGo/dav>
#  AuthType XXX
#  Require valid-user
#  SetEnv proxy-nokeepalive 1
#  Allow from all
#</Location>

ProxyRequests Off
SetEnv proxy-nokeepalive 1
ProxyPreserveHost On

# When using CAS, you should uncomment this and install cas-proxy-validate.py
# in /usr/lib/cgi-bin to reduce server overloading
#
# ProxyPass /SOGo/casProxy http://localhost/cgi-bin/cas-proxy-validate.py
# <Proxy http://localhost/app/cas-proxy-validate.py>
#   Order deny,allow
#   Allow from your-cas-host-addr
# </Proxy>

# Enable to use Microsoft ActiveSync support
# Note that you MUST have many sogod workers to use ActiveSync.
# See the SOGo Installation and Configuration guide for more details.
#
#ProxyPass /Microsoft-Server-ActiveSync \
# http://127.0.0.1:20000/SOGo/Microsoft-Server-ActiveSync \
# retry=60 connectiontimeout=5 timeout=360

ProxyPass /SOGo http://127.0.0.1:20000/SOGo retry=0

<Proxy http://127.0.0.1:20000/SOGo>
## adjust the following to your configuration
  RequestHeader set "x-webobjects-server-port" "443"
  RequestHeader set "x-webobjects-server-name" "192.168.123.115"
  RequestHeader set "x-webobjects-server-url" "https://192.168.123.115"

## When using proxy-side autentication, you need to uncomment and
## adjust the following line:
  RequestHeader unset "x-webobjects-remote-user"
#  RequestHeader set "x-webobjects-remote-user" "%{REMOTE_USER}e" env=REMOTE_USER

  RequestHeader set "x-webobjects-server-protocol" "HTTP/1.0"

  AddDefaultCharset UTF-8

  Order allow,deny
  Allow from all
</Proxy>

# For Apple autoconfiguration
<IfModule rewrite_module>
  RewriteEngine On
  RewriteRule ^/.well-known/caldav/?$ /SOGo/dav [R=301]
  RewriteRule ^/.well-known/carddav/?$ /SOGo/dav [R=301]
</IfModule>

sogo@sogo:~$ ps -ef |grep sogo
root       2243   1480  0 14:48 pts/0    00:00:00 su -s /bin/bash - sogo
sogo       2244   2243  0 14:48 pts/0    00:00:00 -su
sogo       2326   2244  0 14:57 pts/0    00:00:00 ps -ef
sogo       2327   2244  0 14:57 pts/0    00:00:00 grep sogo
sogo@sogo:~$
sogo@sogo:~$ gdb --args /usr/sbin/sogod -WOUseWatchDog NO -WONoDetach YES -WOPort 20000 -WOWorkersCount 1 -WOLogFile - -WOPidFile /tmp/sogo.pid
GNU gdb (Debian 7.7.1+dfsg-5) 7.7.1
Copyright (C) 2014 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-linux-gnu".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>.
Find the GDB manual and other documentation resources online at:
<http://www.gnu.org/software/gdb/documentation/>.
For help, type "help".
Type "apropos word" to search for commands related to "word"...
Reading symbols from /usr/sbin/sogod...Reading symbols from /usr/lib/debug//usr/sbin/sogod...done.
done.
(gdb)
(gdb) run
Starting program: /usr/sbin/sogod -WOUseWatchDog NO -WONoDetach YES -WOPort 20000 -WOWorkersCount 1 -WOLogFile - -WOPidFile /tmp/sogo.pid
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
Apr 25 14:57:59 sogod [2356]: version 3.0.2 (build @shiva.inverse 201603051728) -- starting
Apr 25 14:57:59 sogod [2356]: vmem size check enabled: shutting down app when vmem > 384 MB
Apr 25 14:57:59 sogod [2356]: <0x0x555555a681e0[SOGoProductLoader]> SOGo products loaded from '/usr/lib/GNUstep/SOGo':
Apr 25 14:57:59 sogod [2356]: <0x0x555555a681e0[SOGoProductLoader]>   SchedulerUI.SOGo, AdministrationUI.SOGo, MainUI.SOGo, MailPartViewers.SOGo, ContactsUI.SOGo, CommonUI.SOGo, Mailer.SOGo                                                , PreferencesUI.SOGo, Contacts.SOGo, Appointments.SOGo, MailerUI.SOGo
[New Thread 0x7fffe8eec700 (LWP 2360)]
[Thread 0x7fffe8eec700 (LWP 2360) exited]
2016-04-25 14:57:59.487 sogod[2356] MySQL4 connection established 0x0x555555c59d60
2016-04-25 14:57:59.487 sogod[2356] MySQL4 channel 0x0x555555b11d20 opened (connection=0x0x555555c59d60,sogo)
2016-04-25 14:57:59.487 sogod[2356] <MySQL4Channel[0x0x555555b11d20] connection=0x0x555555c59d60> SQL: SELECT count(*) FROM sogo_user_profile;
2016-04-25 14:57:59.488 sogod[2356] <MySQL4Channel[0x0x555555b11d20] connection=0x0x555555c59d60>   query has results, entering fetch-mode.
2016-04-25 14:57:59.488 sogod[2356] <MySQL4Channel[0x0x555555b11d20] connection=0x0x555555c59d60> SQL: SELECT count(*) FROM sogo_folder_info;
2016-04-25 14:57:59.489 sogod[2356] <MySQL4Channel[0x0x555555b11d20] connection=0x0x555555c59d60>   query has results, entering fetch-mode.
2016-04-25 14:57:59.490 sogod[2356] <MySQL4Channel[0x0x555555b11d20] connection=0x0x555555c59d60> SQL: SELECT count(*) FROM sogo_sessions_folder;
2016-04-25 14:57:59.491 sogod[2356] <MySQL4Channel[0x0x555555b11d20] connection=0x0x555555c59d60>   query has results, entering fetch-mode.
Apr 25 14:57:59 sogod [2356]: |SOGo| WOHttpAdaptor listening on address *:20000

^C
Program received signal SIGINT, Interrupt.
0x00007ffff45b6d3d in poll () at ../sysdeps/unix/syscall-template.S:81
81      ../sysdeps/unix/syscall-template.S: Aucun fichier ou dossier de ce type.
(gdb) b
Breakpoint 1 at 0x7ffff45b6d3d: file ../sysdeps/unix/syscall-template.S, line 81.
(gdb) b abort
Breakpoint 2 at 0x7ffff450d300: abort. (2 locations)
(gdb) c
Continuing.

Breakpoint 1, 0x00007ffff45b6d3d in poll () at ../sysdeps/unix/syscall-template.S:81
81      in ../sysdeps/unix/syscall-template.S
(gdb)bt
#0  0x00007ffff45b6d3d in poll () at ../sysdeps/unix/syscall-template.S:81
#1  0x00007ffff555411e in poll (__timeout=29955, __nfds=<optimized out>, __fds=<optimized out>) at /usr/include/x86_64-linux-gnu/bits/poll2.h:46
#2  -[GSRunLoopCtxt pollUntil:within:] (self=<optimized out>, _cmd=0x7ffff5939900 <_OBJC_SELECTOR_TABLE+1216>, milliseconds=29955, contexts=<optimized out>) at GSRunLoopCtxt.m:430
#3  0x00007ffff5492840 in -[NSRunLoop acceptInputForMode:beforeDate:] (self=0x555555b6aa00, _cmd=0x2, mode=0x7ffff593a770 <_OBJC_INSTANCE_2>, limit_date=0x555555b50fb0) at NSRunLoop.m:1217
#4  0x00007ffff5492cf2 in -[NSRunLoop runMode:beforeDate:] (self=0x555555b6aa00, _cmd=0x555555b5a3b0, mode=0x7ffff593a770 <_OBJC_INSTANCE_2>, date=0x555555b34cd0) at NSRunLoop.m:1288
#5  0x00007ffff6c4a71e in -[WOCoreApplication run] (self=0x555555b6b120, _cmd=<optimized out>) at WOCoreApplication.m:584
#6  0x000055555555afc1 in -[SOGo run] (self=0x555555b6b120, _cmd=0x7ffff6f823d0 <_OBJC_SELECTOR_TABLE+208>) at SOGo.m:268
#7  0x00007ffff6c6ef54 in WOApplicationMain (_appClassName=_appClassName@entry=0x555555760940 <_OBJC_INSTANCE_0>, argc=argc@entry=13, argv=argv@entry=0x7fffffffec18)
    at WOApplicationMain.m:42
#8  0x00007ffff6c8ac8f in WOWatchDogApplicationMain (appName=0x555555760940 <_OBJC_INSTANCE_0>, argc=13, argv=0x7fffffffec18) at WOWatchDogApplicationMain.m:1043
#9  0x000055555555a279 in main (argc=13, argv=0x7fffffffec18, env=0x7fffffffec88) at sogod.m:51
(gdb)