[SOGo] Help configuring SOGo to interface with OpenLDAP on eBox
Hello everyone. I am very much a SOGo beginner. Actually still
struggling to get my first install up and working nicely. I am also
very new to LDAP in general and OpenLDAP specifically. I believe I
have most of the various pieces playing nicely together (Apache,
Postgresql, SOGo) as I can get to a login screen. However the
integration with OpenLDAP is non-functional and therefore I cannot
login to actually play with the software! HELP!
I have looked high and low on the internet and found a LOT of
different write-ups on installing and configuring SOGo. However, most
of them are either talking about previous versions OR assume a lot of
knowledge/experience that I just don't have. What I want to do (I
think) is create some SOGo specific accounts to add to the OpenLDAP
directory. However I cannot seem to authenticate to it even via the
command line using ldapadd.
Some examples of links I have been looking at follow:
http://forum.ebox-platform.com/index.php?topic=3453.0utm_source=twitterutm_medium=smutm_campaign=howto.sogo.ebox
http://article.gmane.org/gmane.comp.cms.opengroupware.sogo/378/match=sogo+ldap+configuration
Oh, by the way, my final setup is two VMs. One running eBox
(OpenLDAP) and the other with SOGo (SOGo, Apache, postgresql).
Below is a bunch of my current configuration files. If you have some
suggestions please give me somewhat detailed instructions at least in
regards to OpenLDAP as the subject is still quite new and I am a
little hazy on it all. Thanks.
Jeremy
ps: Sorry for the very long email.
= = = = = my simple SOGo configuration script from SOGo VM = = = = =
#!/bin/sh
Basic Settings
defaults write sogod WOPort 2
defaults write sogod SOGoTimeZone
America/Vancouver
defaults write sogod SOGoLanguage English
defaults write sogod WOApplicationRedirectURL
http://sogo.mjacksongroup.ca/SOGo/;
defaults write sogod WOHtppAllowHostlocalhost
defaults write sogod SOGoFirstDayOfWeek 1
defaults write sogod SOGoSuperUsernames mjgadmin
Simplified PostgreSQL
defaults write sogod SOGoProfileURL
postgresql://sogo:s...@localhost:5432/sogo
defaults write sogod OCSFolderInfoURL
postgresql://sogo:s...@localhost:5432/sogo/sogo_folder_info
Email Settings
#defaults write sogod SOGoMailDomain
sogo.mjacksongroup.ca
SMTP Server Configuration
#defaults write sogod SOGoMailingMechanism sendmail
#defaults write sogod SOGoSMTPServer localhost
#defaults write sogod WOSendMail
/usr/sbin/sendmail
#defaults write sogod WOMessageUseUTF8 YES
#defaults write sogod WOParsersUseUTF8 YES
IMAP Server Configuration
#defaults write sogod SOGoIMAPServer localhost
#defaults write sogod SOGoFoldersSendEMailNotifications YES
#defaults write sogod SOGoForceIMAPLoginWithEmailYES
#defaults write sogod SOGoForwardEnabled YES
#defaults write sogod SOGoACLsSendEMailNotifications YES
#defaults write sogod SOGoAppointmentSendEMailNotifications YES
#defaults write sogod SOGoVacationEnabledYES
#defaults write sogod SOGoSentFolderName Sent
#defaults write sogod SOGoDraftsFolderName Drafts
#defaults write sogod SOGoOtherUsersFolderName Other Users
#defaults write sogod SOGoSharedFolderName
Shared Folders
#defaults write sogod SOGoTrashFolderNameTrash
LDAP Settings
defaults write sogod SOGoAuthenticationMethod LDAP
defaults write sogod SOGoUserSources
'({CNFieldName = cn;
type= ldap;
CNFieldName = cn;
IDFieldName = cn;
UIDFieldName= sAMAccountName;
baseDN =
cn=Users,dc=ebox,dc=mjacksongroup,dc=ca;
bindDN =
cn=sogo,cn=Users,dc=ebox,dc=mjacksongroup,dc=ca;
bindFields = (sAMAccountName);
bindPassword= BC+nOhckViYh+eBn;
canAuthenticate = YES;
displayName = Shared Addresses;
hostname=
ebox.mjacksongroup.ca;
id = public;
isAddressBook = YES;
port= 389})'
Web Interface Configuration
defaults write sogod SOGoLoginModuleCalendar
defaults write sogod SOGoZipPath
[SOGo] unable to change calendar entries on sogo server with thunderbird
Hallo Currently (since I have installed the SOGo Connector) I can no longer change entries in my calendar on the sogo server with thunderbird. I can create and delete them, but not change. Entries in my local calender can be changed without a problem. SOGo Server Version 1.2.2 lightning (inverse edition) 0.10 inverse sogo connector 0.100 Martin -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Migration from SOGo 1.2.0 to 1.2.2 whit PostgreSQL
Hi, we have SOGo 1.2.0 running good on Debian Lenny with PostgreSQL. We are trying SOGo 1.2.2 but Calendars Tasks aren't show. SOGo logs show: 0x086210F0[SOGoAppointmentFolder]:297-4B9F9880-1-65B9D600 (-[SOGoAppointmentFolder fetchFields:from:to:title:component:additionalFilters:in cludeProtectedInformation:]): fetch failed! 127.0.0.1 - - [19/Jul/2010:11:10:06 GMT] POST /SOGo/so/pruebascomparex/Calendar/eventslist?asc=truesort=startday=filterpopup=view_today H TTP/1.1 200 2/0 0.060 - - 0 0x0x856cee8[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,b.c_cont ent,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification ,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a. c_uid,a.c_startdate,a.c_enddate FROM sogopruebasc0012f17844c_quick a, sogopruebasc0012f17844c b WHERE (c_component = 'vtodo') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': PostgreSQL72Exception: 0x9de7680 NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=0x0x8a99c38[PostgreSQL72Channel]: connection=0x0x8980518[PGConnection]: connection=0x0x8c801f0): ERROR: no existe la columna a .c_category LINE 1: ...ent,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_catego... ^ 0x08C9BC98[SOGoAppointmentFolder]:personal (-[SOGoAppointmentFolder fetchFields:from:to:title:component:additionalFilters:includeProtectedI nformation:]): fetch failed! 0x0x8537718[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_uid,a.c_startdate,a.c_enddate FROM sogopruebasc00551cbd7c8_quick a, sogopruebasc00551cbd7c8 b WHERE (c_component = 'vtodo') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': PostgreSQL72Exception: 0x9e5c510 NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=0x0x8a99c38[PostgreSQL72Channel]: connection=0x0x8980518[PGConnection]: connection=0x0x8c801f0): ERROR: no existe la columna a.c_category LINE 1: ...ent,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_catego... ^ 0x0887BE28[SOGoWebAppointmentFolder]:7A8E-4B754B80-43-3B51A0C0 (-[SOGoAppointmentFolder fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): fetch failed! 0x0x8a21dd8[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_uid,a.c_startdate,a.c_enddate FROM sogopruebasc00155c55a94_quick a, sogopruebasc00155c55a94 b WHERE (c_component = 'vtodo') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': PostgreSQL72Exception: 0x90a1340 NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=0x0x8a99c38[PostgreSQL72Channel]: connection=0x0x8980518[PGConnection]: connection=0x0x8c801f0): ERROR: no existe la columna a.c_category LINE 1: ...ent,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_catego... We had to create that columns manually or apply some kind of change into our database? Regards Joaquín Manuel Llano Montero COMPAREX PC-WARE Group Ingeniero de Sistemas C/ Severo Ochoa 20 06800 Mérida (Badajoz) España phone: +34 924 37 35 73 / +34 924 38 36 00 mobile: +34 615 84 80 19 fax: +34 924 37 45 18 email: joaquin.ll...@comparex.es mailto:fernando.po...@comparex.es web:www.comparex.es http://www.comparex.es COMPAREX PC-WARE Group | c/Severo Ochoa 20 06800 Mérida , Badajoz | España phone: +34 924 37 35 73 | mobile: +34 615 84 80 19 | fax: +34 924 37 45 18 email: joaquin.ll...@comparex.es mailto:fernando.po...@comparex.es | web: www.comparex.es http://www.comparex.es -- De conformidad con lo establecido en la L.O.P.D., COMPAREX garantiza la adopción de las medidas necesarias para asegurar el tratamiento confidencial de los datos de carácter personal. Así mismo le informamos de la posibilidad de ejercer los derechos de acceso, rectificación, cancelación y oposición. According to the established in the Spanish law of data protection (L.O.P.D.),
RE: [SOGo] Migration from SOGo 1.2.0 to 1.2.2 whit PostgreSQL
Thanks, We are using inverse.ca repository deb http://inverse.ca/debian lenny lenny. Had we to use sql-update-20070822.sh or sql-update-1.2.2_to_1.3.0.sh directly? If we migrate database, our SOGo 1.2.0 continue working or we had to migrate the production system? We use same database for test and production. We have translated some messages that wasn't translated into Spanish. If you want we can send that translation for include in future versions. Thanks again. De: Ludovic Marcotte [mailto:lmarco...@inverse.ca] Enviado el: lunes, 19 de julio de 2010 13:43 Para: users@sogo.nu Asunto: Re: [SOGo] Migration from SOGo 1.2.0 to 1.2.2 whit PostgreSQL Joaquin Llano wrote: Hi, we have SOGo 1.2.0 running good on Debian Lenny with PostgreSQL. We are trying SOGo 1.2.2 but Calendars Tasks aren't show. See the update scripts: http://mtn.inverse.ca/revision/browse/1d776c3766bf2049490ce720a4ffc09f3e 604e5c/Scripts If you're updating to a nightly build, you have to run the sql-update-1.2.2_to_1.3.0.sh script. Regards, -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Multiple calendars after conversion in Tbird
I've converted a couple of my users to SOGo and I am getting multiple calendars in Thunderbird after I install the SOGo extensions. For example, both users have 3 Personal calendars. But only one appears to be the real one. The other two don't do anything and I can't delete them. The extra calendars do not show up in the users' web client. Any ideas what is causing this? -- *Bob Wooldridge**/ /* -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] BTS activities for Monday, July 19 2010
Title: BTS activities for Monday, July 19 2010 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Monday, July 19 2010 idlast updatestatus (resolution)categorysummary 640 2010-07-19 03:29:57 new (open) Web Calendar Visualize event's Owner -- users@sogo.nu https://inverse.ca/sogo/lists
