[horde] LDAP Groups

Juan Asensio Sánchez okelet at gmail.com
Sat Jul 26 17:17:35 UTC 2008


Hi

I have configured Horde to use the groups from a LDAP server, using
posixGroups. What i want is to manage the permissions of certain
objects based on groups. The first problem is that the list of groups
does not appear in the Groups sectionof the administration. Also, when
i want to add a contact to an address book i get this error: "Source
not found"; i don't get this error when I disable ldap groups. In the
log, i get these entries:

==============================

Jul 26 17:06:45 HORDE [error] [turba] MDB2 Error: unknown error:
_doQuery: [Error message: Could not execute statement]
[Last executed query: SELECT s.*  FROM turba_shares s  LEFT JOIN
turba_shares_users AS u ON u.share_id = s.share_id LEFT JOIN
turba_shares_groups AS g ON g.share_id = s.share_id WHERE
s.share_owner = 'usuario1' OR (s.perm_creator & 4) <> 0 OR
(s.perm_default & 4) <> 0 OR ( u.user_uid = 'usuario1' AND (u.perm &
4) <> 0) OR ( g.group_uid IN ("cn=Usuarios del
dominio,ou=Grupos,dc=nutum,dc=local","cn=tecnicos,ou=Grupos,dc=nutum,dc=local")
AND (g.perm & 4) <> 0) ORDER BY s.share_name ASC]
[Native message: ERROR:  no existe la columna «cn=Usuarios del
dominio,ou=Grupos,dc=nutum,dc=local» at character 321]
 [pid 19974 on line 422 of "/var/www/horde/lib/Horde/Share/sql.php"]
Jul 26 17:06:45 HORDE [error] [turba] MDB2 Error: unknown error:
_doQuery: [Error message: Could not execute statement]
[Last executed query: SELECT s.*  FROM turba_shares s  LEFT JOIN
turba_shares_users AS u ON u.share_id = s.share_id LEFT JOIN
turba_shares_groups AS g ON g.share_id = s.share_id WHERE
s.share_owner = 'usuario1' OR (s.perm_creator & 4) <> 0 OR
(s.perm_default & 4) <> 0 OR ( u.user_uid = 'usuario1' AND (u.perm &
4) <> 0) OR ( g.group_uid IN ("cn=Usuarios del
dominio,ou=Grupos,dc=nutum,dc=local","cn=tecnicos,ou=Grupos,dc=nutum,dc=local")
AND (g.perm & 4) <> 0) ORDER BY s.share_name ASC]
[Native message: ERROR:  no existe la columna «cn=Usuarios del
dominio,ou=Grupos,dc=nutum,dc=local» at character 321]

==============================

("no existe la columna" -> the column does not exist)

"cn=Usuarios del dominio,ou=Grupos,dc=nutum,dc=local" and
"cn=tecnicos,ou=Grupos,dc=nutum,dc=local" are the groups the user
"usuario1" belongs to. So Horde is getting fine the groups from the
LDAP directory, but they don't appear in the Groups page, and I get
error in Turba and some other modules.

Any idea? Thanks in advance.


More information about the horde mailing list