gmane.comp.cms.opengroupware.user

Invitation to connect on LinkedIn

Tafadzwa Kashora — 2010-07-13T10:06:34

LinkedIn
------------

   
I'd like to add you to my professional network on LinkedIn.

- Tafadzwa

Tafadzwa Kashora
Graduate Trainee at POSB 
Zimbabwe

Confirm that you know Tafadzwa Kashora
https://www.linkedin.com/e/-j4e7rk-gbkkv0l5-68/isd/1461969590/Sz4N_OI1/


 
------
(c) 2010, LinkedIn Corporation

Good news for Evolution users with GroupDAV servers.

Adam Tauno Williams — 2010-05-07T17:32:50

The bug to support Location headers in PUT responses has just been
closed.  This brings Evolutions WebDAV address book into compliance with
GroupDAV as specified in section 5.4.

"Handle server's resource rename on WebDAV PUT response"
<https://bugzilla.gnome.org/show_bug.cgi?id=566354>

And for more efficient synchronization support for ctags has also been
committed.

"WebDAV Addressbook backend should use ctags"
<https://bugzilla.gnome.org/show_bug.cgi?id=617168>

Announcing the OpenGroupware Coils project...

Adam Tauno Williams — 2010-05-03T17:58:55

This message is the official public announcement of the OpenGroupware
Coils project.

**** ANNOUNCEMENT ****
OpenGroupware Coils <http://sourceforge.net/projects/coils/> is a port
of the OpenGroupware collaboration platform from SOPE & Objective-C to
Python 2.6. It is intended to be backwards compatible and can be
installed in parallel with your existing OpenGroupware Obj-C services
stack. OpenGroupware Coils will read you OpenGroupware Obj-C
configuration files, connect to your OpenGroupware Obj-C database, and
perform updates in a manner compatible with OpenGroupware Obj-C.
OpenGroupware Coils will maintain parallel compatibility until such time
as it reaches operational feature parity. This is an *alpha* release of
OpenGroupware Coils and is (a) not feature complete and (b) under heavy
development. However to commitment to parallel compatibility until
feature-parity ensures that moving between development versions will the
painless; and you can continue to use your existing OpenGroupware
application stack.

What works today?
1.) Reading and management of NextStep/OpenStep configuration files.
Coils can both read an write the same plist files for user defaults and
the NSGlobalDomain plist for configuration information. So installing
OpenGroupware Coils is a zero-config process. Although there very well
may be items you want to tweak. Every effort is made to re-use existing
OpenGroupware defaults - which are documented in WMOGAG
<http://docs.opengroupware.org/Members/whitemice/wmogag/file_view>
2.) The XML-RPC proxy will intercept XML-RPC calls to OpenGroupware
Obj-C's ZideStore service. It provides retry, so if the call to
ZideStore fails [due to process restart, etc...] the call is
automatically retried. It can also process specific API calls in Coils
while relaying others to ZideStore's zOGI bundle. This allows a gradual
migration from ZideStore's zOGI implementation to Coil's implementation
transparent to applications. By default the Coil's zOGI only processes
zogi.getLoginAccount calls. This offloads most of the authentication
related calls from ZideStore to Coils.
3.) The GroupDAV/WebDAV presentation of the contacts available to a
client has been tested in Novell Evolution successfully. Coils has been
architected to make the presentation of large collections as efficient
as possible. Testing is performed using an addressbook containing
22,000 contacts. Write support is in the early stages of development.
Coils uses the Python module vobject
<http://vobject.skyhouseconsulting.com/> to process vCard data.
3.1.) Contacts can be retrieved from the server as vCards or presented
in XML, JSON, or YAML. Whatever is easiest for your client application
to process.
3.2.) A special URL provides a JSON feed of contacts or users
(accounts) with upcoming birthdays.
4.) Read support should for for CalDAV clients. Collects are presented
that provide either the user's personal calendar or a user's Overview
calendar as determined by their panel.
5.) Most zOGI getObject(...) operations are functional.
6.) A large portion of the require Logic (commands) have been
implemented. Access control has also been implemented. Access control
in Coils offers features in addition to the OpenGroupware Obj-C services
including proxy user and negative ACLs.
7.) The OpenGroupware Integration Engine (OIE), which not complete, is
operational and has reached a useful level of utility. OIE provides a
workflow and Business Process Modeling engine that tightly integrates
with OpenGroupware's more traditional groupware facilities. OIE
currently manages workflows described using BPML 1.1.
7.1.) Routes can be created and modified, and processes initiated and
monitored via the WebDAV presentation; the entire workflow system can
be controlled via GNOME's Nautilus file manager and possibly other
WebDAV clients [only Nautilus/GVFS have currently been tested].
7.2.) OIE can perform operations with external SQL databases [tested
with IBM Informix/DB2], search LDAP DSAs [search results are
XML/DSMLv1], manipulate XML (perform XPath assignments and XSLT
transformations), convert JSON data into XML, retrieve OpenGroupware
objects as XML (such as Contacts, Enterprises, etc...), send SMTP mail
(including attachemnts), and perform various string operations and
regular expression matches.
7.3.) OIE contains an extensible method for dealing with file formats
such as fixed record length text files, XLS, and DIF files. File
formats can be create and defined [as YAML text] via the WebDAV layer
using a text editor such as GNOME's gedit. File format definitions
allow OIE to read or create formatted files, such as XLS documents.
7.4.) OIE processes can "park". Allowing processing to stop (actually
shutting down the worker on the server) awaiting additional data or user
response, for example, from an e-mail produced by the OIE workflow. In
future versions OIE's processing will be integrated further with
groupware functions allowing workflows to be initiated via task
creation/completion, entity modification, etc...
8.) OpenGroupware Coils provides the concept of "Content Plugins".
This implements the functionality intended for the ZideStore zOGI bundle
(pluginData entity is defined for the zOGI specification:
<http://code.google.com/p/zogi/wiki/PluginData>) but deemed unrealistic
to implement in the existing Objective-C environment. Content Plugins
allow additional information from external services (such as an ERP
system) to be gathered by OpenGroupware Coils and delivered to clients
with related entities. For example, when an Enterprise entity is
retrieved by a zOGI call sales and related information can be added by a
custom ContentPlugin to the data that is returned to the client.
Unwitting clients can simply ignore the additional information, but
custom interfaces such as a CRM system can present the information to
use user without themselves having to contain logic to gather the
information from ERP or requiring permissions to access the ERP. Data
made available to OpenGroupware via Content Plugins is also
automatically available to OpenGroupware Integration Engine workflows.
So you can code your connectors once and use that data from everywhere
that you can access your OpenGroupware server via HTTP. A developer
only needs to inherit the ContentPlugin class and their content plugin
will automatically be loaded and used by OpenGroupware Coils. An
example ContentPlugin that provides integration with Twitter has already
been implemented; this plugin automatically includes a contact's
Twitter timeline with the contact's data.
<http://coils.hg.sourceforge.net/hgweb/coils/coils/file/db62d0ee9f9b/src/coils/logic/twitter/content_plugin.py>

Architecure:
OpenGroupware Coils is similair in many respects to OpenGroupware
Obj-C architecturally. Both use a Logic layer where operations are
performed using Command pattern objects. Both divide the presentation,
operational (Logic), and model into discrete layers.
However OpenGroupware Coils is implemented as a component oriented
service as it is intended to provide services in addition to web
services and to really less of external OS components [such as cron].
OpenGroupware is comprised of a collection of services - one of which
provides the HTTP services - that communicate via AMQ
<http://www.amqp.org/confluence/display/AMQP/> using an AMQ server such
as RabbitMQ <http://www.rabbitmq.com/>. AMQ provides flexible, fast,
and *reliable* messaging between components. [This design decision was
made only after it was clearly demonstrated that RabbitMQ is readily
available for all mainstream LINUX distributions and is *VERY* simple to
install and configure - in fact, you can get Coils up and running with
RabbitMQ with *zero* MQ configuration]. One exciting possibility AMQ
provides is for future versions of OpenGroupware Coils to distribute
services across multiple hosts or multiple networks.
Component services include HTTP services, the OpenGroupware
Integration Engine, maintenance of the Contact vCard cache, and
appointment notification. Implementing addition services is very simple
as all the AMQ plumbing is abstracted into the Service class. All the
developer needs to do is inherit the coils.core.Service class and
implement a few methods and the service will automatically be started
with OpenGroupware Coils and connected to the messaging service. For an
example of how, almost trivial, it is to implement an OpenGroupware
Coils service take a look at Coils "clock" service
<http://coils.hg.sourceforge.net/hgweb/coils/coils/file/db62d0ee9f9b/src/coils/logic/pubsub/clock.py> which provides a clock service to which other services can subscribe to.

How can I contribute?
All contributions and comments are welcome.
Non-developers can help with testing or helping to maintain the wiki.
The project also needs web-desginers and artists.
For developers source code is managed in a Mercurial
<http://mercurial.selenic.com/> repository on SourceForge. Mercurial is
a modern distributed source code management system, which unlike CVS and
subversion, makes managing branches and commit access a very open and
natural process. To check out the source code go to
<http://sourceforge.net/projects/coils/develop>. <Monodevelop
http://monodevelop.com/> solution and project files are included in the
source; so if you have that excellent, free, and multiplatform IDE
available browsing the OpenGroupware Coils source is a snap. But use of
Monodevelop, or any IDE, is not required to contribute code to the
OpenGroupware Coils <http://sourceforge.net/projects/coils/> project.
The excellent TortoiseHg <http://tortoisehg.bitbucket.org/> tools for
working with Mercurial are also recommended - but you can do everything
via the Mercurial hg command line utility. Every kind of work is
available within the OpenGroupware Coils project: if you want to work
with OIE to process XML and implement workflows, if you want to work on
HTTP protocols like WebDAV/GroupDAV/CalDAV/RSS there are jobs for you,
if you want to do database oriented work via the amazing SQLalchemy ORM
<http://www.sqlalchemy.org/>, or get into the nut-n-bolts of AMQP...
just check out the code and dig in.

For communication the OpenGroupware Coils project has two mailing lists:

coils-devel for discussion of the development of the OpenGroupware Coils
project; technical stuff.
<https://lists.sourceforge.net/lists/listinfo/coils-devel>

coils-project for discussion of the project itself including website,
coordination, promotion, etc..
<https://lists.sourceforge.net/lists/listinfo/coils-project>

OpenGroupware Coils does not *yet* have a "coils-users" yet! This is an
*alpha* release. A "coils-user" list will be created with the project
deliverys a 1.0 download. The project is currently looking for
developers and other contributors. Not that OpenGroupware Coils isn't
already very usefule - it is! - but the project wants to be very clear
about its current state and not over-sell.

Links:
* Provisioning a CentOS5 host for OpenGroupware Coils
<https://sourceforge.net/apps/trac/coils/wiki/ProvisioningCentOS5>
* Installing OpenGroupware Coils
<https://sourceforge.net/apps/trac/coils/wiki/Installation>

Re: tasks access control

Adam Tauno Williams — 2010-01-15T16:10:18

Quoting Renzo Vettori <r.vettori< at >pistoiaindustria.it>:

Correct.


Correct.  Think of the project as a container and when an object is  
placed in the container it inherits the permissions of the container.


In what way?

Via zOGI, or other methods, it is possible to search tasks, but in the  
WebUI there is only tasks-in-projects and the user's relevent task  
lists (to-do, delegated, assigned, and archived).

tasks access control

Renzo Vettori — 2010-01-15T14:51:20

I think that tasks don't support acls in opengroupware, anyway, tasks 
not linked to a project are only shown in owner's (and executor's) 
webui, so that these are the only users who can view and change 
everything. This is not the case when a task is linked to a project as 
task list is shown in projects and anyone who has read access to the 
project can change everything.

Is this right? Maybe this can be changed in jobUI templates?

Many Thanks

Renzo Vettori

Re: Documentation and files on opensuse

Adam Tauno Williams — 2009-12-07T02:13:07

Pull the source RPMs from the OBS and they should build just fine;  they
only fail to build *binary* packages on OBS because of standards
compliance issues I haven't had the time to hack around.

<http://download.opensuse.org/repositories/server://OpenGroupware/SLE_10/src/>

Re: Documentation and files on opensuse

Vincent-- — 2009-12-06T23:22:51

I've been busy with some other things, mainly because I got a new job. Now I 
am focusing on OGo again and am still a little stuck and in doubt. I run 
opensuse 11.0 on my server. Do you recommend that I use the SLES_10 packages 
and try to get it to work by hacking? Or do you have some sort of guide on how 
to build my own packages for this version? /Or/ should I try to do something 
without the packages and start working with the sources?

Thanks and happy holidays,

Vincent
On Monday 05 October 2009 18:09:14 adam< at >morrison-ind.com wrote:

Re: Renaming a resource?

Adam Tauno WIlliams — 2009-11-13T01:34:51

Excellent.


Right it is stored in your user defaults, in the
schedular_panel_resourceNames attribute.


User defaults are stored in OpenSTEP style PList (property list) files
in the OpenGroupware documents root.  So, for example, if your account's
objectId is 10,100 then there is
a /var/lib/opengroupware.org/documents/10100.defaults file.  If you have
just a couple to edit you can do it by hand if your careful (just use a
text editor).

Otherwise I just the other day implemented an OpenSTEP PList writer
OpenGroupware Coils so you can script mass changes with Python.  Coils
will soon have an RPC for reading / writing user defaults as an admin
since that is a feature we need.  Source for the OpenSTEP PList reader /
writer is at
<http://coils.hg.sourceforge.net/hgweb/coils/coils/file/4ed140ab0c93/src/coils/model/plist>

I probably should just have an admin RPC to rename a resource?

Re: Renaming a resource?

Jeff — 2009-11-12T17:21:29

Finally got around to renaming the resource, and these database queries did
the trick, thanks!

However, the old resource name is still showing up in the calendar view in
the dropdown (where it defaults to my account - but we have the Resources
listed there too).

What table is that stored in so I can update that without having the users
change it manually?   And wherever that table is, does it need an
object_version increment as well?

Thanks!
Jeff

On Tue, Aug 18, 2009 at 12:11 PM, Adam Tauno Williams <
awilliam< at >whitemice.org> wrote:

Re: OGO-WebUI Error column t1.birthname does not exist

Ken Smith — 2009-10-07T15:17:43

Running the update script worked. The WebUI is working now. Thanks

But it did give an error like this

psql:pg-update-1.x-to-5.5.psql:45: ERROR:  column "owner_id" of relation 
"job" already exists

I looked for birthname in pg-build-schema.psql, at least not in the 
version arrived from the yum repository today.....


Thanks

Ken

Re: OGO-WebUI Error column t1.birthname does not exist

Adam Tauno Williams — 2009-10-07T13:55:45

Did you try running the update script?  Possibly the dbsetup package
isn't using the correct [current] script.

Looking at the script it does look like the default creation script is
missing that attribute, among others.
<http://svn.opengroupware.org/OpenGroupware.org/trunk/Database/PostgreSQL/pg-build-schema.psql>
Try running the update script.
<http://svn.opengroupware.org/OpenGroupware.org/trunk/Database/PostgreSQL/pg-update-1.x-to-5.5.psql>


More likely that I did.

OGO-WebUI Error column t1.birthname does not exist

Ken Smith — 2009-10-07T13:29:14

Hi,

Just setup OGO 5.5 from the repository at 
http://download.opensuse.org/repositories/server://OpenGroupware/CentOS_5/ 
on a Centos system to do some testing with Zideone and I get this error 
in the browser when I first try to log in.


Application Server caught exception:

  session: 54FD54FD014ACC7724
  element: 
  context: <0x0xa464034[WOContext]: 0014acc77240a464034 app=ogo-webui-5.5 sn=54FD54FD014ACC7724 eid= rqeid=>
  request: <WORequest[0x0xa4607d4]: method=GET uri=/OpenGroupware app=OpenGroupware rqKey= rqPath=>

  class:   PostgreSQL72Exception
  name:    PostgreSQL72FatalError
  reason:  fatal pgsql error (channel=<0x0xa68b574[PostgreSQL72Channel]: connection=<0x0xa68b75c[PGConnection]:  \
connection=0x0xa68bfb0>>): ERROR:  column t1.birthname does not exist

  info:


The same error message is in the WebUI error log.

Postgres has the OGo database installed by the .rpm. I can't see a table 
with a t1.birthname column.

I recall seeing some discussion about schema alterations but not 
involving t1.birthname as far as I recall

I noticed that the file pg-update-1.x-to-5.5.psql includes the stanza


ALTER TABLE company ADD COLUMN birthname     VARCHAR(255) NULL;


:-(

Any ideas. I've probably missed something obvious.

Thanks

Ken

Re: Documentation and files on opensuse

Vincent-- — 2009-10-05T20:27:58

Thanks for the fast reply, I will read the manual, I see it contains quite a 
lot of information. If you could send me the source-rpms, just to be sure, it 
would be very nice.
I use opensuse because I started using it long long time ago for my desktop 
and it seemed a logical choice for my server. Now I notice it might not be the 
optimal choice and I consider freebsd for a next server, but that is a whole 
different discussion.

Thanks!

Vincent

Re: Documentation and files on opensuse

2009-10-05T16:09:14

See WMOGAG,  it has a whole section on Installation and explains the  
architecture.  I'd guess your mod_ngobjweb Apache module is not  
loaded, or the OGo service daemon is not started.
<http://docs.opengroupware.org/Members/whitemice/wmogag/file_view>


I run it on openSUSE 11.1 and  I do all my development on openSUSE  
11.1 [11.1 GNOME is the best desktop ever]. But there are no packages  
on OBS because OBS *demands* perfect packages and as of 11.1 the  
standard is terribly specific - I haven't had time to create  
satisfactory packages for 11.1.  The source packages should build  
locally on 11.1 if you can do an rpmbuild...  I have to focus my  
[limited] time on CentOS since that is what "real" servers run.

Otherwise possibly I can just send you openSUSE 11.1 packages.

Documentation and files on opensuse

Vincent-- — 2009-10-05T15:53:24

Dear readers,

Recently I found opengroupware as  a very suitable program for me, in order to 
be able to access my mail, agenda and contacts everywhere with web access and 
clients.
On my server I use opensuse, but I found that there are (almost) no rpms 
available in the repositories for version 11.0 and 11.1 
(http://download.opensuse.org/repositories/server:/OpenGroupware/) I've worked 
around this by installing the SLE_10 rpms and they appear to work. At least, I 
get a response at localhost/OpenGroupware,  but I get a error 500. I wanted to 
check some logs, but in apache error and access logs I found nothing useful. 
From the installed files, I noticed a lot of files are installed in /usr/bin, 
/usr/lib and /usr/share/opengroupware-5.5 and 1.1 But I could not find any 
clear man pages or manual documents. The manuals on opengroupware.org are 
about a running server, but I can not find a manual on how to get a server 
running.
I hope someone can help me get ogo working on opensuse 11.x!

Thanks and with kind regards,

Vincent

Re: Quick Version Question

Ken Smith — 2009-10-01T18:24:57

I agree, any new installations I'm doing are Centos

Re: Quick Version Question

Adam Tauno Williams — 2009-10-01T15:03:32

There are no packages there.

There are FC9 packages < at >
<http://download.opensuse.org/repositories/server://OpenGroupware/Fedora_9/>  Nothing older than that is supported by OBS.  

FC6 was released on October 24, 2006 and is no longer maintained.  I
believe FC9 is even unmaintained at this point.

CentOS5 is the platform I would recommend.

Re: Quick Version Question

Ken Smith — 2009-10-01T13:28:40

There used to be a yum repository here ->

http://download.opengroupware.org/nightly/packages/fedora-core7/trunk

I will just have done the install from there.


My guess is that this FC6 system is approx between 5.4 and 5.5

Thanks

Ken

Re: Quick Version Question

Adam Tauno Williams — 2009-10-01T11:57:59

Where did you get the packages?


5.4 is pretty much the end of 1.1 development
5.5 is the current trunk

There was a difference between the internal versions (which was 5.3,
5.4, 5.5) and the "released" version (1.0, 1.1) which was resolved by
bumping the numbers when 1.1 development ended [creating 5.4 (stable)
and 5.5(development).  Also the odd difference between OGo & ZideStore
version numbers was resolved;  ZideStore 1.5 = OGo 1.1, where ZideStore
5.4 = OGo 5.4 and ZideStore 5.5 = OGo 5.5! :)

Quick Version Question

Ken Smith — 2009-10-01T10:58:58

Hi,

I'd like to test the ZideOne connector on OGo. I have an OGo 
installation done via RPM on an FC6 system.

The ZideOne connector says it prefers to work with V5.4 or 5.5

The test FC6 system claims to be have ogo-webui 1.1, xmlrpc 1.1, 
zidestore 1.5.

I'm sure the FC6 install isn't really ancient, what's the mapping 
between these version numbers

Thanks

Ken

Re: Quick Version Question

Ken Smith — 2009-10-01T18:24:57

I agree, any new installations I'm doing are Centos