Summary | LDAP groups disappear inside perms |
Queue | Horde Groupware Webmail Edition |
Queue Version | 1.2 |
Type | Bug |
State | Duplicate |
Priority | 2. Medium |
Owners | |
Requester | horde (at) jensthebrain (dot) de |
Created | 10/12/2008 (6111 days ago) |
Due | |
Updated | 10/23/2008 (6100 days ago) |
Assigned | |
Resolved | 10/19/2008 (6104 days ago) |
Github Issue Link | |
Github Pull Request | |
Milestone | |
Patch | No |
bug #6883.bug #6883has been incomplete becauseno one who reported it bothered to test our fixes.
according to the
solution for
bug #6883. The group id (cn=...) is correctly set in thetable nag_shares_groups
(this requires that the datatype is changed from integer to varchar).
It seems that the group_uid is casted to int in _getShareCriteria at
line 673 in
framework/Share/Share/sql.php rev. 1.1.2.47. I don't understand how an LDAP
group id (cn=...) should be casted to int.
This is a typical error-log:
Oct 23 19:12:56 HORDE [error] [nag] MDB2 Error: unknown error:
_doQuery: [Error
message: Could not execute statement]
[Last executed query: SELECT DISTINCT s.* FROM nag_shares s LEFT
JOIN nag_shares_users
AS u ON u.share_id = s.share_id LEFT JOIN nag_shares_groups AS g ON
g.share_id = s.share_id
WHERE s.share_owner = 'jbl' OR (s.perm_creator & 4) != 0 OR
(s.perm_default & 4) != 0 OR
( u.user_uid = 'jbl' AND (u.perm & 4) != 0) OR (g.group_uid IN
(0,0,0,0,0) AND (g.perm & 4) != 0)
ORDER BY s.attribute_name ASC]
[Native message: ERROR: IN types character varying and integer cannot
be matched]
[pid 25224 on line 457 of "/usr/local/www/horde/lib/Horde/Share/sql.php"]
I do not think this is a duplicate of
bug #6883.State ⇒ Duplicate
bug #6883.Priority ⇒ 2. Medium
Patch ⇒ No
Milestone ⇒
Queue ⇒ Horde Groupware Webmail Edition
Summary ⇒ LDAP groups disappear inside perms
Type ⇒ Bug
State ⇒ Unconfirmed
groups are pulled from LDAP and all users/groups are found.
I can add a group to the calendar perms of my personal calendar. But
after logout/login the group disappears from the permissions list. The
same works with ldap users.
A little debugging revealed that the gorup id gets somewhere changed
to "0". Inside the data table kronolith_shares_groups it's correctly
recorded with cn=...
It happens with DataTree and SQL as Permission drivers.