Where has all the groupware gone.....

Paul Pathiakis pathiaki2 at yahoo.com
Mon May 6 20:10:31 UTC 2013


Lukasz,

Yes, I agree with that.  I'm just finding some really strange things with this port attempt.

Also, the online documentation at the SOGo site is very sparse and hardly intuitive.

This install is going to need a documented procedure.

At the present time, I've gone down multiple roads with many issues. 

I'm trying to figure out how SOGo creates the table(s) for user info in the PostGreSQL database.  I can't seem to find a script or sql command to create the tables.  Does it do it automatically according to the configuration in the sogo.conf?

Another issue that seems related is this:

[SOGoUserManager]> No authentication sources defined - nobody will be able to login. Check your defaults.  So I have to assume (ack!) that it's not reading the sogo.conf file.... however, the SOGo Debug directives that I have turned on in that file are being activated (

2013-05-06 14:13:34.197 sogod[38913] Note(SoObject): SoDebugKeyLookup is enabled!
2013-05-06 14:13:34.197 sogod[38913] Note(SoObject): SoDebugBaseURL is enabled!
2013-05-06 14:13:34.197 sogod[38913] Note(SoObject): relative base URLs are enabled.

)

The error I'm seeing seems to indicate that it's not seeing the declaration for the pgsql database.  Yet, I've created the user sogo with a database sogo with the passwd sogo  (as an initial attempt)

SOGoProfileURL = "postgresql://sogo:sogo@172.24.0.19:5432/sogo/sogo_user_profile";    <-----There it is!!!!

OCSFolderInfoURL = "postgresql://sogo:sogo@localhost:5432/sogo/sogo_folder_info";
OCSSessionsFolderURL = "postgresql://sogo:sogo@localhost:5432/sogo/sogo_sessions_folder";

SOGoDraftsFolderName = Drafts;
SOGoSentFolderName = Sent;
SOGoTrashFolderName = Trash;
SOGoIMAPServer = 172.24.0.25;
SOGoSMTPServer = 172.24.0.25;
SOGoMailDomain = atlantisservices.net;
SOGoMailingMechanism = smtp;
SOGoForceExternalLoginWithEmail = NO;
SOGoMailSpoolPath = /var/spool/mail;
SOGoAppointmentSendEMailNotifications = YES;
  //NGImap4ConnectionStringSeparator = "/";
  //SOGoACLsSendEMailNotifications = NO;
  //SOGoSieveServer = sieve://127.0.0.1:4190;

  /* Authentication */
SOGoPasswordChangeEnabled = YES;

  /* LDAP authentication example */
SOGoUserSources = (
  {
    type = ldap;
    CNFieldName = cn;
    IDFieldName = uid;
    UIDFieldName = uid;
    baseDN = "ou=people,dc=example,dc=net";
    bindDN = "uid=sogo,ou=people,dc=example,dc=net";
    bindPassword = thisisfun;
    canAuthenticate = YES;
    displayName = "Shared Addresses";
    hostname = ldap://<ldap server>:389;  <-- I have a real address here.
    id = public;
    isAddressBook = YES;
  }
);

SOGoPageTitle = SOGo;
SOGoVacationEnabled = YES;
SOGoForwardEnabled = YES;
  //SOGoSieveScriptsEnabled = YES;

  /* General */
SOGoLanguage = English;
SOGoTimeZone = America/New_York;
SOGoCalendarDefaultRoles = (
  PublicDAndTViewer,
  ConfidentialDAndTViewer
  );

  //SOGoSuperUsernames = (sogo1, sogo2); //This is an array - keep the parens!
  
  /* Debug */
SoDebugBaseURL = YES;
ImapDebugEnabled = YES;
LDAPDebugEnabled = YES;
SOGoDebugRequests = YES;
PGDebugEnabled = YES;
SOGoUIxDebugEnabled = YES;
WODontZipResponse = YES;
WOLogFile = /var/log/sogo/sogo.log;

}



________________________________
 From: Łukasz Wąsikowski <lukasz at wasikowski.net>
To: Paul Pathiakis <pathiaki2 at yahoo.com> 
Cc: Jim Riggs <ports at christianserving.org>; Joe Malcolm <jmalcolm at uraeus.com>; Marco Steinbach <coco at executive-computing.de>; "ports at freebsd.org" <ports at freebsd.org> 
Sent: Monday, May 6, 2013 11:46 AM
Subject: Re: Where has all the groupware gone.....
 

W dniu 2013-05-06 16:30, Paul Pathiakis pisze:

> Also, where is the sogo.conf file supposed to be located?  That is, what directory?  /var/lib doesn't exist on a BSD machine.

All third party software should have configuration in $PREFIX/etc/,
which in most cases is /usr/local/etc/ - please don't put any
configuration files in places like /var/lib or
/usr/local/GNUstep/Local/Library/SOGo mentioned before.

-- 
best regards,
Lukasz Wasikowski


More information about the freebsd-ports mailing list