Author Topic: Quick Howto: SOGo  (Read 50561 times)

satyris

  • Zen Monk
  • **
  • Posts: 94
  • Karma: +0/-0
    • View Profile
Re: Quick Howto: SOGo
« Reply #45 on: October 29, 2010, 09:21:45 am »
Hi Björn,
thanks for your help, but this peace of sh... needs to much of my spare time.
I dont have the time to read a manual completely and i could not find the needed information as you mentioned before.

binary-two

  • Zen Monk
  • **
  • Posts: 61
  • Karma: +3/-0
    • View Profile
Re: Quick Howto: SOGo
« Reply #46 on: October 29, 2010, 10:39:45 am »
but this peace of sh...

Well, swearing usually does not help. If you don't like it, leave it :-P.

I am always happy to help, but if you waste other people's time time instead of yours, it could be considered inconsiderate if not rude ;-). The SOGo manual is not that big, straight forward and very well written; it helps to understand what is happening in the background (GnuStep, Apache, etc.).

Just my 2 cents.

Björn
« Last Edit: October 29, 2010, 12:56:12 pm by binary-two »

satyris

  • Zen Monk
  • **
  • Posts: 94
  • Karma: +0/-0
    • View Profile
Re: Quick Howto: SOGo
« Reply #47 on: October 29, 2010, 07:19:10 pm »
Quote
The SOGo manual is not that big, straight forward and very well written

Mhm, then i got the wrong one, cause mine was not very helpful. So many sides about the explanation of Parameters and a half side about apache configuration ????

Beside that, there was NO example about SOGo.conf in it.
Very well written?
I know better ones.

I stumbled from one problem to the next one, not very funny and straight forward...

Last word: sorry, that you think i wasted your time. Thought that i could bring it to a good ending and to more knowledge for everyone reading that.


obimichael

  • Zen Monk
  • **
  • Posts: 60
  • Karma: +3/-0
    • View Profile
Re: Quick Howto: SOGo
« Reply #48 on: November 17, 2010, 10:47:24 pm »
Hi!
I was trying to get SOGo working with EBox on Ubuntu 10.04 for about 1 month, but now I got it working!

The problems I found and my solutions:
Apache wasn't starting after installation of SOGo,
* I had to add some symbolic links to /etc/apache2/mods-enabled
* goto directory: cd /etc/apache2/mods-enabled
* add symbolic link: ln -s /etc/apache2/mods-available/modulename modulename
The modulnames: proxy.load, proxy.conf, proxy_ajp.load, proxy_balancer.load, proxy_connect.load, proxy_ftp.load, proxy_http.load, proxy_scgi.load, headers.load
* restart apache: /etc/init.d/apache2 restart

/etc/apache2/conf.d/SOGo.conf
Code: [Select]
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>

## 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.
#<Location /SOGo>
#  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>

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.0.119"
  RequestHeader set "x-webobjects-server-url" "https://192.168.0.119"

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

  RequestHeader set "x-webobjects-server-protocol" "HTTP/1.0"
  RequestHeader set "x-webobjects-remote-host" "127.0.0.1"

  AddDefaultCharset UTF-8

  Order allow,deny
  Allow from all
</Proxy>

Configuration of SOGo
* stop sogo, before config: sudo /etc/init.d/sogo stop
* change user: sudo su sogo
* add config line by line: defaults write sogod VARIABLE VALUE (Return)

Code: [Select]
defaults write sogod SOGoProfileURL  "mysql://{username}:{password}@localhost:3306/{databasename}/sogo_user_profile"
defaults write sogod SOGoTimeZone "Europe/Berlin"
defaults write sogod SOGoMailDomain "{virtual maildomain of ebox}"
defaults write sogod SOGoLanguage German
defaults write sogod SOGoAppointmentSendEmailNotifications YES
defaults write sogod SOGoFoldersSenEmailNotifications YES
defaults write sogod SOGoFoldersSendEmailNotifications YES
defaults write sogod SOGoACLsSendEMailNotifications YES
defaults write sogod SOGoDraftsFolderName Drafts
defaults write sogod SOGoSharedFolderName "Shared Folders"
defaults write sogod SOGoTrashFolderName Trash
defaults write sogod SOGoSentFolderName Sent
defaults write sogod SOGoIMAPServer localhost
defaults write sogod SOGoForceIMAPLoginWithEmail YES
defaults write sogod SOGoSuperUsernames '("{superusername}")'
defaults write sogod SOGoCalendarDefaultRoles '("PublicViewer", "ConfidentialDAndTViewer")'
defaults write sogod OCSFolderInfoURL "mysql://{username}:{password}@localhost:3306/{databasename}/sogo_folder_info"

defaults write sogod SOGoUserSources '({CNFieldName = cn;
IDFieldName = uid; UIDFieldName = uid; IMAPHostFieldName = mailHost;
baseDN = "ou=Users,dc={computername}";
bindDN = "cn=ebox,dc={computername}";
bindPassword = "{password}"; canAuthenticate = YES; displayName =
"Shared Addresses"; hostname = "localhost"; id = public;
isAddressBook = YES; port=389})'


Some additional Informations
* About LDAP Settings, take a look at Ebox > Users and Groups > LDAP Settings
* 502 Proxy Error: Something wrong with your configuration
* Service Temporarily Unavailable: Start sogo! sudo /etc/init.d/sogo start
* Do not add WOApplicationRedirectURL
* You cannot add a calender, or addressbook: Variable OCSFolderInfoURL is missing or wrong configured
* No emails or folders visible: SOGoIMAPServer correct? SOGoForceIMAPLoginWithEmail set to YES?
* IPAddress of my server: 192.168.0.119

I'm not finished testing all aspects, so I a lot of work is still missing ...

Regards from Austria
Michael
« Last Edit: November 17, 2010, 10:58:42 pm by obimichael »

smithkevinc

  • Zen Apprentice
  • *
  • Posts: 13
  • Karma: +0/-0
    • View Profile
Re: Quick Howto: SOGo
« Reply #49 on: February 16, 2011, 04:39:26 am »
I seem to have a good working setup now, except the SOGo quota indicator is missing. Thunderbird sees the quota information just fine. Did I miss something or is this an issue with how Zentryal does quotas?

Would like to know if anyone else is getting the quota indicator I guess.

smithkevinc

  • Zen Apprentice
  • *
  • Posts: 13
  • Karma: +0/-0
    • View Profile
Re: Quick Howto: SOGo
« Reply #50 on: February 23, 2011, 03:46:02 am »
I seem to have a good working setup now, except the SOGo quota indicator is missing. Thunderbird sees the quota information just fine. Did I miss something or is this an issue with how Zentryal does quotas?

Would like to know if anyone else is getting the quota indicator I guess.


In dovecot.conf changing
Code: [Select]
quota = maildir:User quotato
Code: [Select]
quota = maildir
Gets me my quota indicator in SOGo, but I'm wondering if making this change will cause some ill effects. Anyone know?

chymian

  • Zen Apprentice
  • *
  • Posts: 12
  • Karma: +1/-0
    • View Profile
Re: Quick Howto: SOGo
« Reply #51 on: June 01, 2011, 05:24:46 pm »
hi,
first of all, thx for everybody's contribution on this howto setting up sogo on zentyal.

I've sogo 1.3.7a up und running on ubuntu 10.04.2, lucid, with zentyal 2.0.20. looks good so far.

a solution I found to not being able to edit cal-entries on thundebird
(for everybody, who runs into the same pbl.):
if I use only the connector & lightning plugins from sogo (no integrator) and configure the path's by myself, I couldn't edit the calender-entries in TB, which where created from sogo-web.
SOLUTION-> after setting some ACL's on the Cal. & AB., via the SOGo-web, this behavior went away.


I do have pbls. with the TB3 and sogo-integrator-3.105 (on debian wheezy).
when using the integrator, the dav-urls within TB for Calendar & Addressbooks are setup with email adr., instead of the plain username:
i.e. /SOGo/dav/user@domain/Calendar instead of /SOGo/dav/user/Calendar
and TB uses email-adr. to authenticate, with the effect, that no authentication works, Cal. & AB. are not accessible, since on the host, they are with usernames only.

I started on a fresh-initialized database and (IDFieldName, UIDFieldName, bindFields) = uid
which uses i.e. the superusernames = uid.

on the current setup (-> config), I also started over with a clean database and I used (IDFieldName, UIDFieldName) = mail (due to dovecot acls), but it has no effect on neither the path of the dav-urls, nor the logins. but it does have an effect on the superusernames, they have to be email then.

does anybody has an idea, how to get either the TB integrator to use plain username only, or to convince sogo to use the email in the dav-url & login's?

TIA
günter


config (xml to txt-style, with defaults read sogod)
Code: [Select]
sogod SOGoDraftsFolderName Drafts
sogod SOGoTrashFolderName Trash
sogod SOGoSieveServer sieve://localhost:4190
sogod WOParsersUseUTF8 YES
sogod SOGoOtherUsersFolderName 'Other Users'
sogod WOWorkersCount 1
sogod SOGoIMAPAclConformsToIMAPExt YES
sogod SOGoVacationEnabled YES
sogod SOGoTimeZone Europe/Berlin
sogod WOMessageUseUTF8 YES
sogod SOGoSieveScriptsEnabled YES
sogod SOGoSentFolderName Sent
sogod SOGoMailingMechanism sendmail
sogod SOGoForceIMAPLoginWithEmail yes
sogod SOGoSMTPServer smtp://localhost:25
sogod OCSSessionsFolderURL postgresql://sogo:<password>@localhost:5432/sogo/public/sogo_sessions_folder
sogod SOGoSharedFolderName 'Shared Folders'
sogod SOGoIMAPServer imap://localhost:143
sogod SOGoMailAuxiliaryUserAccountsEnabled yes
sogod WOSendMail /usr/sbin/sendmail
sogod SOGoACLsSendEMailNotifications YES
sogod SOGoProfileURL postgresql://sogo:<password>@localhost:5432/sogo/public/sogo_user_profile
sogod OCSEMailAlarmsFolderURL postgresql://sogo:<password>@localhost:5432/sogo/public/sogo_alarm_folder
sogod SOGoEnableEMailAlarms YES
sogod SOGoFoldersSendEMailNotifications YES
sogod SOGoSuperUsernames '(
    user@example.org
)'
sogod SOGoMemcachedHost localhost
sogod WOPort 20000
sogod domains '{
    sogo.local = {
        SOGoMailDomain = example.org;
        SOGoUserSources = (
            {
                CNFieldName = cn;
                IDFieldName = mail;
                IMAPLoginFieldName = mail;
                MailFieldNames = (
                    mail
                );
                SOGoLDAPContactInfoAttribute = uid;
                UIDFieldName = mail;
                baseDN = "ou=Users,dc=<hostname>,dc=example,dc=org";
                bindDN = "cn=ebox,dc=<hostname>,dc=example,dc=org";
                bindFields = (
                    uid
                    mail
                );
                bindPassword = <password>;
                canAuthenticate = YES;
                displayName = "Users Addresses";
                filter = "(objectClass=inetOrgPerson)";
                hostname = 127.0.0.1;
                id = users;
                isAddressBook = YES;
                port = 389;
                type = ldap;
            }
        );
    };
}'
sogod SOGoCacheCleanupInterval 300
sogod SOGoLanguage German
sogod OCSFolderInfoURL postgresql://sogo:<password>@localhost:5432/sogo/public/sogo_folder_info
sogod SOGoForwardEnabled YES
sogod SOGoFirstDayOfWeek 1
sogod SOGoAppointmentSendEMailNotifications YES
   

CONFIG MODIFIED
according to smithkevinc next post
« Last Edit: June 16, 2011, 02:07:04 pm by chymian »

smithkevinc

  • Zen Apprentice
  • *
  • Posts: 13
  • Karma: +0/-0
    • View Profile
Re: Quick Howto: SOGo
« Reply #52 on: June 15, 2011, 08:36:13 pm »
bindFields = (uid, mail)

Setting above worked for me. Dav urls use email address. You can still log into the web interface with just username as
well as email address. I think, "untested", if you drop uid it will force email for web logins as well.

chymian

  • Zen Apprentice
  • *
  • Posts: 12
  • Karma: +1/-0
    • View Profile
Re: Quick Howto: SOGo
« Reply #53 on: June 16, 2011, 01:41:24 pm »
bindFields = (uid, mail)

Setting above worked for me. Dav urls use email address. You can still log into the web interface with just username as
well as email address. I think, "untested", if you drop uid it will force email for web logins as well.

thx a lot, worked for me too, after restarting with a fresh database.
I corrected the config above - for easy copy & paste

cheers
günter

nontrivial

  • Zen Warrior
  • ***
  • Posts: 173
  • Karma: +14/-0
    • View Profile
Re: Quick Howto: SOGo
« Reply #54 on: July 05, 2012, 03:50:57 pm »
With the help of this post I have this working as well, more or less. Since postgresql is already installed fro Zentyal, I am using that instead of MySQL. The only issue I have now is the ACL thing. How exactly does one start with a clean database?

James

chymian

  • Zen Apprentice
  • *
  • Posts: 12
  • Karma: +1/-0
    • View Profile
Re: Quick Howto: SOGo
« Reply #55 on: July 06, 2012, 12:44:03 pm »
a clean database is like a new created one. it does not have any tables & data in it - a prisitine one.
you can drop your sogo database with the command dropdb an create a new, fresh one.
these are the postgres-cmd's  which I use to create user & db:

Code: [Select]
su – postgres
dropdb sogo

createuser --no-superuser --no-createdb –-no-createrole –-encrypted --pwprompt sogo
(specify a password for sogo)
createdb -O sogo sogo


nontrivial

  • Zen Warrior
  • ***
  • Posts: 173
  • Karma: +14/-0
    • View Profile
Re: Quick Howto: SOGo
« Reply #56 on: July 06, 2012, 08:22:57 pm »
OK, thanks, I didn't realize that sogo would just recreate it's database if it needed to.

James

chymian

  • Zen Apprentice
  • *
  • Posts: 12
  • Karma: +1/-0
    • View Profile
Re: Quick Howto: SOGo
« Reply #57 on: July 06, 2012, 09:39:46 pm »
OK, thanks, I didn't realize that sogo would just recreate it's database if it needed to.


it doesn't. you have to create the database! see "createdb cmd" in my last post.
it create's it's tables within the database.
have a nice one
günter

Laurent Dinclaux

  • Zen Monk
  • **
  • Posts: 80
  • Karma: +3/-0
    • View Profile
    • Gecka
Re: Quick Howto: SOGo
« Reply #58 on: March 19, 2014, 07:32:24 am »
[removed - wrong thread]
Laurent

CPUdon

  • Zen Apprentice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Re: Quick Howto: SOGo
« Reply #59 on: April 06, 2014, 06:52:57 am »
Great  :)