6.0.0-beta1
7/6/25

[#7481] LDAP groups disappear inside perms
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

History
10/23/2008 09:18:54 PM Jan Schneider Comment #4 Reply to this comment
I do not think this is a duplicate of bug #6883.
Of course it is. But the fix for bug #6883 has been incomplete because 
no one who reported it bothered to test our fixes.
10/23/2008 05:56:59 PM horde_list (at) blomberg (dot) tk Comment #3 Reply to this comment
I have the same problem. With Horde 3.3 and group_uid field as varchar 
according to the

solution for bug #6883. The group id (cn=...) is correctly set in the 
table 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.


10/19/2008 04:56:50 PM Jan Schneider Comment #2
State ⇒ Duplicate
Reply to this comment
Duplicate of bug #6883.
10/12/2008 01:11:04 PM horde (at) jensthebrain (dot) de Comment #1
Priority ⇒ 2. Medium
Patch ⇒ No
Milestone ⇒
Queue ⇒ Horde Groupware Webmail Edition
Summary ⇒ LDAP groups disappear inside perms
Type ⇒ Bug
State ⇒ Unconfirmed
Reply to this comment
I've a fully working horde groupware webmail installation. User and 
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.

Saved Queries