LinuxWorld interviewed me recently concerning OpenGroupware.org. The interview is part of their "Spotlight on Open Source in business" series.

The getAuditEntries method was added to the zOGI API as of r920, and added to the ZideStore trunk in r2095. getAuditEntries provides the ability to retrieve the audit entries from the server's database that have occurred since a specified entry. Using this feature a service can page through server changes and synchronize some repository; this allows functionality equivalent to that provided by MOGIMon but without a back-door database connection. Since audit records are serialized with integer ids in the OpenGroupware database this acts very much like the uSNChanged attribute provided by Microsoft Active Directory.

HordOGo provides integration between the OpenGroupware groupware server and the Horde application suite; HordOGo is a consumer of the zOGI API. Currently the HordOGo is hosted in the zOGI repository as an incubator; see the "Bindings/PHP/HordOGo" folder. Status of the HordOGo project is tracked on the zOGI wiki page for HordOGo.

In October 2006 I wrote a simple Turba driver that used POGI to provide an OpenGroupware address source to the Horde application suite. I'm now working on HordOGo which will provide real integration with Horde. Hopefully HordOGo will eventually be accepted into the Horde trunk and bring OpenGroupware support on equal footing with Kolab.

Ext.ogo is a project to develope a Javascript wrapper around the zOGI to make it easier to use OpenGroupware from within the Ext JS framework. Ext JS is an impressive platform for developing highly interactive web applications with a high degree of browser independence. The intention of Ext.ogo is to build JSON support into the zOGI PHP wrapper and a simple Javascript object.

• 2007-02-21 - Currently the project is only in the planning stages but some basic testing has been performed and it seems possible to accomplish this goal in the fairly near term.

cd gnustep-make-1.13.0
./configure --prefix=/usr/local/OGo-GNUstep \
--with-library-combo=gnu-fd-nil \
--with-system-root=/usr/local/OGo-GNUstep \
--disable-importing-config-file \
--with-config-file=/usr/local/OGo-GNUstep/GNUstep.conf
make
make install

source /usr/local/OGo-GNUstep/Library/Makefiles/GNUstep.sh
cd ../sope/libFoundation
export CFLAGS=-Wno-import
./configure
make
sudo make -j1 INSTALL_ROOT_DIR=/ \
GNUSTEP_INSTALLATION_DIR=/usr/local \
FHS_INSTALL_ROOT=/usr/local install

cd ..
export CFLAGS=
./configure --prefix=/usr/local \

PostgreSQL 8.3 not longer performs automatic casting of INT to TEXT when INTs are compared to character types. This change is documented in the release notes. This change causes a database exception to occur in OpenGroupare's ACL processing. The specific error is:

ERROR: IN types character varying and integer cannot be matched


ACL queries like the following cause the exception because they contain a condition that compares string value to an array of integers: auth_id IN ( 9981, 9991,... where auth_id is a VARCHAR(255) value.

Do you have lots of errors like:

Feb 17 20:39:28 ogo-zidestore-1.5 [14569]: ERROR(+[NSCalendarDate(PostgreSQL72Values) valueFromCString:length:postgreSQLType:attribute:adaptorChannel:]): unexpected string '2007-03-13 15:38:41.420456+00' for date type 'DATE', returning now (expected format: '2001-07-26 14:00:00+02')

in your ZideStore error log? This is because the time & date parser in SOPE's PostreSQL adaptor didn't understand the milliseconds portion of the value. As of SOPE r1601 this should be corrected. SOPE now just ignores the millisecond value. See the diff for details.

Consonance now has a calendar UI for the scheduler tab of the main window. This is a significant milestone; up until now that feature has been very conspicuously absent. I had hoped to be be able to port some code from some other projects but ended up writing the entire widget from scratch. Consonance displayed a calendar event for the first time on 2007-12-30 at 16:33 (GMT). A screenshot is here and also attached to this post. This code is included as of r470.