Horde calendar sharing for groups

horde

#1

Hello,
we are running UCS 4.2 with the latest Horde container. Authentication works fine with username or primary E-Mail address. Sharing calendars works with single users works fine, but the user must be addressed with the full mail address.

Sharing calendars with Posix Groups (from LDAP) does not work. Horde does not show the appropriate field to enter the group name or search for groups in the Settings for the calendar under the “Sharing” tab.

Thanks,
Robert


#2

To answer this question:
Horde does not use ldap but IMAP for authentication. In this case the groups are not visible to horde and setting group permissions does not work.

We solved this now by replicating selected LDAP groups into the horde group configuration tables horde_groups and horde_groups_members, using a simple python script. Sharing calendars and Resources to those groups is now possible. If anybody is interested, I can clean that up and share it.


#3

Hi,
great to hear. I would be interested. I would really appreciate it!

Thank you


#4

Hey,
you find the script attached to this post.

Several assumptions are made:

We sync mailinglists to horde groups, so all users of the mailinglist department1@test.local are synced to the horde group department1 . See line 35 for the command for getting the list (basically udm mail/lists list ).

The script runs against the local PostgreSQL database on the host, if you run any special configuration you have to take this into account.

Every group contains the CALENDARUSER, as this user shares the corresponding calendars to the horde groups. This has to be configured in the horde calendar sharing for this user.

You need to define the lists that will be considered on line 20.

The target groups must be created from the Horde GUI, the script only alters the users in each group.

Sync is one-way only from LDAP to horde, so changes (adding/removing user) via the horde GUI will not be synced back.

Nested groups are not supported.

The script runs in testmode at first and shows the SQL commands that will be executed. run the script with -c to commit changes.

Adding the script to a hook in univention that will be called after changes to the mailinglist configuration could be nice.

I am not a database GUI, so if this script deletes all of your data I AM NOT RESPONSIBLE FOR ANY DAMAGES DONE WITH THIS.

Best regards,
Robert

importUsersHorde.py (4.4 KB)