Forums

Resolved
2 votes
I am now in the process of evaluating different groupware server and I will do my best at sharing my findings. This
groupware server is not meant to work in parallel with Zarafa.

This is the installation procedure that I have used:

This is mostly an amalgamation of information and credit is due to the following sources:
- The ClearOS wiki: SOGo Groupware with Thunderbird Sync
- Contributors to this forum post: Installing SOGo on COS63
- Plus many more on this forum.
- Oviously the SOGo contributors: SOGo installation guide

Note: Even if I have include some information on how to install the 32-bit version, I have only installed and tested the 64-bit version.

Installation requirements:
Graphical Console or Putty
Mail (Cyrus-IMAP)
PHP
Web
MySQL
OpenLDAP (ClearOS app, usefull)

Create the “sogo” service user (no password required)
groupadd -r sogo
useradd -mr -g sogo sogo -d /var/lib/sogo


RepoForge required:
for 32-bit installation:
yum localinstall http://apt.sw.be/redhat/el6/en/i386/rpmforge/RPMS/rpmforge-release-0.5.3-1.el6.rf.i686.rpm

for 64-bit installation:
yum localinstall http://apt.sw.be/redhat/el6/en/x86_64/rpmforge/RPMS/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm


I have seen on this forum a few having difficulty with rpm's conflict issues from the epel repo.
I am going to attempt to reduce such risk by immediately limiting the access to the RPMforge repo.
nano /etc/yum.repos.d/rpmforge.repo
entry for repo rpmforge change enabled = 1 to enabled = 0 and make sure all the rest of the repo's are set to enabled = 0


Create the yum SOGo configuration:
nano /etc/yum.repos.d/sogo.repo
[sogo-rhel6]
name=Inverse SOGo Repository
baseurl=http://inverse.ca/downloads/SOGo/RHEL6/$basearch
enabled = 0
gpgcheck=0


Modify the clearos-epel configuration file to exclude all gnustep-* rpm`s
Note: you may want at the end of this install return the clearos-epel to its original state by removing the exclusion: gnustep-*, your choice.
nano /etc/yum.repos.d/clearos-epel.repo
[clearos-epel]
...
exclude=amavisd-new-* zarafa* ...
...

with

[clearos-epel]
...
exclude=amavisd-new-* zarafa* ... gnustep-*
...


Finally the big install
yum install --enablerepo=sogo-rhel6 --enablerepo=clearos-epel --enablerepo=rpmforge-extras --enablerepo=clearos-core sogo sope49-gdl1-mysql sogo-tool


For some unknown reason the .pid folder container was not created during the above install? Lets fix that:
install -d -m 755 -o root -g root /var/run/memcached

memcached was not installed to automatically start, we are going to fix that also.
chkconfig memcached on

Start the memcached service
service memcached start


MySQL, at the password prompt enter you DB password
mysql --user=root -p 
<yourmysqlpassword>

CREATE DATABASE sogo;
CREATE USER 'sogo'@'localhost' IDENTIFIED BY '<yourdbsogopassword>';
GRANT ALL PRIVILEGES ON sogo.* TO 'sogo'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit


Backup the configuration folder:
cp -rp /etc/sogo/sogo.conf /etc/sogo/sogo.conf.default


A new feature of the SOGo 2.0.5, you can now use a configuration file,
replace the content of the configuration with the following and fix to your liking:
nano /etc/sogo/sogo.conf
{
/* ********************* Main SOGo configuration file **********************
* *
* Since the content of this file is a dictionary in OpenStep plist format, *
* the curly braces enclosing the body of the configuration are mandatory. *
* See the Installation Guide for details on the format. *
* *
* C and C++ style comments are supported. *
* *
* This example configuration contains only a subset of all available *
* configuration parameters. Please see the installation guide more details. *
* *
* ~sogo/GNUstep/Defaults/.GNUstepDefaults has precedence over this file, *
* make sure to move it away to avoid unwanted parameter overrides. *
* *
* **************************************************************************/

/* Web Interface */
SOGoPageTitle = "WebMail";
SOGoLoginModule = Mail;
SOGoVacationEnabled = YES;
SOGoForwardEnabled = YES;
SOGoSieveScriptsEnabled = YES;
SOGoMailMessageCheck = every_minute;
// SOGoMailMessageCheck = every_10_minutes;
SOGoMailReplyPlacement = above;
SOGoMailSignaturePlacement = below;
SOGoMailComposeMessageType = html;
SOGoEnableEMailAlarms = NO;
SOGoTimeFormat = "%H:%M";
SOGoDayStartTime = 9;
SOGoDayEndTime = 19;
SOGoFirstDayOfWeek = 1;
SOGoFirstWeekOfYear = January1;

/* General */
SOGoLanguage = English;
SOGoTimeZone = <yourtimezone>; // i.e. America/Montreal
SOGoMailDomain = <yourdomain.com>;
SOGoAppointmentSendEMailNotifications = YES;
SOGoFoldersSendEMailNotifications = YES;
SOGoACLsSendEMailNotifications = YES;
SOGoCalendarDefaultRoles = (PublicViewer, ConfidentialDandTViewer);
SOGoSuperUsernames = (<sogouser>;);
SOGoEnablePublicAccess = YES;

/* LDAP authentication */
SOGoUserSources = (
{
type = ldap;
baseDN = "ou=Users,ou=Accounts,<yourdc=system,dc=lan>";
bindDN = "cn=manager,ou=Internal,<yourdc=system,dc=lan>";
bindPassword = <yourldapbindpassword>;
CNFieldName = cn;
IDFieldName = cn;
UIDFieldName = uid;
bindFields = (uid);
filter = "(objectClass = clearMailAccount)";
canAuthenticate = YES;
displayName = "Local Addresses";
hostname = "localhost";
id = public;
isAddressBook = NO;
port = 389;
MailFieldNames = (clearMailAliases,mail);
}
);

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

/* Mail */
SOGoDraftsFolderName = INBOX/Drafts;
SOGoSentFolderName = "INBOX/Sent Items";
SOGoTrashFolderName = INBOX/Trash;

/* SMTP Server configuration */
SOGoMailingMechanism = smtp;
SOGoSMTPServer = localhost;

/* IMAP Server configuration */
SOGoIMAPServer = "imaps://localhost:993";
SOGoMailShowSubscribedFoldersOnly = NO;

}


Restart the SOGo service to enable the above configuration:
service sogod restart


Modify the Web Apache Server configuration file:
nano /etc/httpd/conf.d/SOGo.conf
## adjust the following to your configuration
RequestHeader set "x-webobjects-server-port" "443"
RequestHeader set "x-webobjects-server-name" "<yourhostname>"
RequestHeader set "x-webobjects-server-url" "https://<yourhostname>;"


Restart the Web Apache Server service to enable the above configuration:
service httpd restart


There is a couple of features that you may want to enable in cron jobs:
nano /etc/cron.d/sogo
- Vacation messages expiration
- Session cleanup
- Email alarms
- Daily backups


And finally see if it runs:
https://yourhostname>/SOGo


Enjoy, P.
Monday, April 15 2013, 08:04 PM
Share this post:
Responses (17)
  • Accepted Answer

    Tuesday, March 01 2016, 12:39 AM - #Permalink
    Resolved
    0 votes
    Sorry, unable to comment.
    Don't use Zarafa, Outlook or a frontend. See http://sogo.nu/download.html#/frontends
    The reply is currently minimized Show
  • Accepted Answer

    Monday, February 29 2016, 02:37 PM - #Permalink
    Resolved
    0 votes
    Hi Tony,
    Thanks for posting.
    I will be trying this soon, I do not like what is going on with Zarafa and support for Outlook.
    Did anyone try getting z-push to work with sogo on clear?
    I understand that support for mobiles is not as good.

    What front end do you use and do you feel that this is enterprise ready?
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, February 24 2016, 08:45 AM - #Permalink
    Resolved
    0 votes
    Philippe - thank-you for this how-to - some things you might be interested in :-

    Trying out NethServer and found it installs SOGo, completely integrated with ldap etc - and free:-) Liked it very much, especially the ability to access mail on other email servers in addition to the one SOGo is running on. So the project was to install on ClearOS 6.7 - integrated with ldap etc. Wanted to install SOGO Version 2.8 first, then tried the new Version 3. Liked Version 2 more, so this is what I now run :-)

    SOGo has their own repository so I created a file called sogo.repo in /etc/yum.repos.d
     
    [sogo]
    name=SOGo v2 Repository
    baseurl=http://sogo.nu/files/downloads/SOGo/RHEL6/$basearch
    gpgcheck=0
    enabled = 0

    Then used a similar command to yours to install the required rpms, enabling the "sogo" repository. Everything is there - no need to mess with epel or rpmforge, and yum will add all the dependencies.

    Using this method I found the sogo user was automatically created and all changes/additions to the httpd configurations made - just restarted httpd.

    # php /var/clearos/openldap/config.php
    was useful for the ldap configuration in /etc/sogo/sogo.conf - configured somewhat similar to yours.

    Enabled SOGo to use mail servers other than one one it is running on.


    # su - sogo -s /bin/bash
    # defaults write sogod SOGoMailAuxiliaryUserAccountsEnabled YES
    # exit

    and restarted sogod

    Then when you are logged into SOGo webmail you can select Preferences => IMAP Accounts ; and the bottom of the left hand pane at the bottom you will now have a "+" and "-" allowing you to add/delete mail-user accounts on other email servers.

    So far, all good ;-)

    Oh! finally a message like

    2016-02-24 19:38:37.880 sogod[23410] File NSDictionary.m: 626. In -[NSDictionary initWithContentsOfFile:] Contents of file '/etc/sogo/sogo.conf' does not contain a dictionary
    <0x0xb569787c[SOGoStartupLogger]> Cannot read configuration from '/etc/sogo/sogo.conf'. Aborting

    when restarting sogod is usually just a syntax error, missing ";" and the end of a line or misplaced/additional "{" or "}"
    /var/log/sogo/sogo.log is also useful

    EDIT: After playing with Version 3 again I have changed my mind and like it better :-)
    Like
    1
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, September 23 2015, 02:51 PM - #Permalink
    Resolved
    0 votes
    @Rob

    I have not changes that particular setting but my wife uses SOGO configured for a different language and that setting seems to hold. Have you looked at your SOGO log? My instructions are fairly old, have you made any changes to the installation procedure?
    The reply is currently minimized Show
  • Accepted Answer

    Rob Bosma
    Rob Bosma
    Offline
    Tuesday, September 22 2015, 07:11 PM - #Permalink
    Resolved
    0 votes
    I like the features of SOGo, that is why I have done everything on this page. But what I have noticed is that the setting will not be saved when I have changed for example the country/location. I have searched everywhere also at SOGo but nothing usefull. Please help.......
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, June 15 2013, 02:19 PM - #Permalink
    Resolved
    0 votes
    Philippe Eveleigh wrote:
    augustynr

    As we at it has anyone been able to run iphone and android ?

    I have not but this might be of interest: How to: Install Funambol - with SOGo connector


    I've been using SOGo with iPhone for about two years and Android for about 4 months, iPhone works fine with the CalDAV and CardDav, android you need to install some Cal/CardDAV sync modules but it's ok after that. You certainly don't need Funambol for either, that's just a massive pest.
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, June 15 2013, 02:15 PM - #Permalink
    Resolved
    0 votes
    YAR wrote:
    I found a workaround:

    If you add:

    SOGoMailCustomFromEnabled = YES;

    to the sogo.conf

    the user can It set the email address themselves in "preferences" and than the "IMAP Accounts" tab that is normally locked.


    That will than be used as the default. If you select an other in the from dropdownbox it stil does not work (dah!)

    I did notice that it then uses the displayname followd by @unspecified-domain as from address. At the receiving side this is than shown as fistname@correctdomainname and lastname@correctdomainname.


    I had this issue, thanks for the note, I just changed all the aliases to use hyphens instead.
    The reply is currently minimized Show
  • Accepted Answer

    YAR
    YAR
    Offline
    Friday, May 03 2013, 10:34 AM - #Permalink
    Resolved
    0 votes
    I found a workaround:

    If you add:

    SOGoMailCustomFromEnabled = YES;

    to the sogo.conf

    the user can It set the email address themselves in "preferences" and than the "IMAP Accounts" tab that is normally locked.


    That will than be used as the default. If you select an other in the from dropdownbox it stil does not work (dah!)

    I did notice that it then uses the displayname followd by @unspecified-domain as from address. At the receiving side this is than shown as fistname@correctdomainname and lastname@correctdomainname.
    The reply is currently minimized Show
  • Accepted Answer

    YAR
    YAR
    Offline
    Wednesday, May 01 2013, 10:03 PM - #Permalink
    Resolved
    0 votes
    Hoping I would be able to fix the email name issue. I just tried the next step: Configure SOGo to use my Owncloud calendar and address book.....


    But I can't get it to work, the calendar part might work but I have serious doubts about the address book.

    All the info I can find is about using the "SOGo Connector Thunderbird extension" which I'll need to configure Thunderbird but nothing to sync SOGo with Owncloud and vice versa.

    However If this can't work, then I think I have to look for a different webmail client because I don't know of a Owncloud replacement.

    I have tried Roundcube, it even integrates with the Owncloud webpage however it has no calendar.

    Does Zarafa integrate with Owncloud that anyone knows? Just the address book and calendar would be nice, anything else a bonus.


    Pfffffff decisions decisions
    The reply is currently minimized Show
  • Accepted Answer

    YAR
    YAR
    Offline
    Wednesday, May 01 2013, 05:47 PM - #Permalink
    Resolved
    0 votes
    Hi Philippe

    Thanks!, had a look at syntaxIllegal address syntax unfortunately it's not the same. I have put my domain name at the mail settings and I don't see the @ sign behind my alias.

    Mine looks exactly like this: Firstname Lastname <firstname.lastname>

    That's including the capitalisation. It looks to me that it correctly picks-up the display name and the alias but just forgets to put the domain name behind it.

    In the from dropbox I can also select the username and that one is complete ie: Fistname Lastname <username@domainame> and works as expected.

    I tried to cheat and put the @domainname in the sogo.conf but that did not work... bummer!

    I did notice that the order of the aliases is the same as in my ClearOS server which is good because that means I don't need access to the locked part in the preferences box.

    Any more tips?
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, April 30 2013, 04:40 PM - #Permalink
    Resolved
    0 votes
    augustynr

    As we at it has anyone been able to run iphone and android ?

    I have not but this might be of interest: How to: Install Funambol - with SOGo connector
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, April 30 2013, 04:32 PM - #Permalink
    Resolved
    0 votes
    YAR I can try and help, all this is still pretty new to me.

    If I compose a mail it displays firstname.lastname (no domain name) if I then send the mail it displays firstname.lastname@unspecified-domain in the sent items folder.

    Sounds similar to this problem: Illegal address syntax

    It would be enough for me if I was able to change it at the "preferences" and than the "IMAP Accounts" tab but that is locked. How do I unlock that?
    That also looks the place were I can change the preferred sender address/alias, am I correct?

    If I do understand the question correctly, regrettably I do not think this is possible. This part of the SOGo configuration is forgone since we are using the ClearOS Cyrus setup. For the User/Alias configuration I have made the configuration use the CLearOS User LDAP configuration.

    SOGoMailMessageCheck = every_minute;
    Thanks ... fixed in the original post.
    The reply is currently minimized Show
  • Accepted Answer

    YAR
    YAR
    Offline
    Tuesday, April 30 2013, 01:17 PM - #Permalink
    Resolved
    0 votes
    Thanks for this

    But I would like some help: I can't get the aliases to work

    My aliases are firsname.lastname for all but one.


    If I compose a mail it displays firstname.lastname (no domain name) if I then send the mail it displays firstname.lastname@unspecified-domain in the sent items folder.

    It arrives at the recipient as fistname@domainname, lastname@domainname

    I have put in the domainname in sogo.conf

    It would be enough for me if I was able to change it at the "preferences" and than the "IMAP Accounts" tab but that is locked. How do I unlock that?
    That also looks the place were I can change the preferred sender address/alias, am I correct?


    PS: there is a typo in the posted sogo.conf

    SOGoMailMessageCheck = every_minutes;
    should be
    SOGoMailMessageCheck = every_minute;
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, April 28 2013, 04:09 AM - #Permalink
    Resolved
    0 votes
    After I rebooted the system things seems to be ok.
    How do I add open change to it?
    As we at it has anyone been able to run iphone and android ?
    how about the other tools?
    Thanks for the great work.
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, April 28 2013, 03:31 AM - #Permalink
    Resolved
    0 votes
    Hi it was a problem with the configuration file I left <> characters.
    Once I removed them I was able to login with a clearos user.
    I was able to bring up the page but when I try to open any of the emails or preferences tab I get the:
    Error 12 (net::ERR_INSUFFICIENT_RESOURCES): Unknown error.
    At the same time sogod takes 100% of one cpu

    Any help?
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, April 28 2013, 02:25 AM - #Permalink
    Resolved
    0 votes
    Thanks, I have tried it and after I try to restart sogo I get following error:
    Restarting SOGo:
    2013-04-27 22:12:41.142 sogod[5551] File NSDictionary.m: 626. In -[NSDictionary initWithContentsOfFile:] Contents of file '/etc/sogo/sogo.conf' does not contain aionary
    <0x0x7fe9302f8828[SOGoStartupLogger]> Cannot read configuration from '/etc/sogo/sogo.conf'. Aborting

    Any idea what would be the reason and how to fix it?
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, April 16 2013, 12:26 PM - #Permalink
    Resolved
    0 votes
    Thanks for posting!

    I used to provide a build of SOGo for ClearOS 5.2, I could revisit for 6.x if I found the time :)
    The reply is currently minimized Show
Your Reply