6.0.0-RC7
6/30/26

[#6150] Permission sql driver
Summary Permission sql driver
Queue Horde Framework Packages
Queue Version HEAD
Type Enhancement
State Resolved
Priority 1. Low
Owners chuck (at) horde (dot) org
Requester duck (at) obala (dot) net
Created 1/25/08 (6731 days ago)
Due
Updated 4/10/08 (6655 days ago)
Assigned 4/10/08 (6655 days ago)
Resolved 4/10/08 (6655 days ago)
Milestone
Patch Yes

History
475 Chuck Hagenbuch Comment #10
State ⇒ Resolved
Reply to this comment
Just needed to run horde-merge.php on this commit:

http://lists.horde.org/archives/cvs/Week-of-Mon-20080407/077159.html
154 Ben Klang Comment #9
State ⇒ Assigned
Reply to this comment
It looks like the SQL schema to create tables was omitted from the 
3.1_to_3.2 upgrade script.  The schema also does not appear in the 
scripts/sql directory.  This is in a FRAMEWORK_3 checkout from tonight.
134 Chuck Hagenbuch Comment #8 Reply to this comment
Fixed, thanks
528 Duck Comment #7 Reply to this comment
Committed, with a bunch of work on Perms and Share to get datatree
dependencies/references out and make this work without them. Thanks!
There is still a reference to DataTree::encodeName in the 
horde/admin/perms/add_child.php.
256 Chuck Hagenbuch Comment #6
Assigned to Chuck Hagenbuch
State ⇒ Resolved
Reply to this comment
Committed, with a bunch of work on Perms and Share to get datatree 
dependencies/references out and make this work without them. Thanks!
5212 Chuck Hagenbuch Comment #5 Reply to this comment
Added the SQL scripts and upgrade instructions.
536 Chuck Hagenbuch Comment #4 Reply to this comment
I've committed the UI.php and datatree.php changes as they make sense 
even without the rest of this (though I'm working on the full patch 
too). Thanks again.
506 Chuck Hagenbuch State ⇒ Accepted
 
01 Jan Schneider Patch ⇒ Yes
 
501 Jan Schneider Deleted Original Message
 
2811 Duck Comment #3
New Attachment: sql[1].php Download
Reply to this comment
Cache key fix.

Works on all my installations.
811 Duck Comment #2
New Attachment: sql.php
Reply to this comment
Fix adding permissions to the top level.



Finished.
134 Duck Comment #1
Priority ⇒ 1. Low
State ⇒ New
New Attachment: perms.tgz Download
Queue ⇒ Horde Framework Packages
Summary ⇒ Permission sql driver
Type ⇒ Enhancement
Reply to this comment
Another attempt minimize my DB load is moving permissions outside DT. 
Permission actually uses only id, name, parents and data colum for 
serialize its attributes. So with this driver you get a very small and 
fast table loading only the data needed when needed. And even loads 
and connect the db objeject only when need, as the comon calls are 
only hasPermission and exists and if you use cache you will never 
build anoter DB conenction to check a premission.



You also need the apply the perms.diff to the permissions UI as one 
datatree call is harcoded. As the permission driver, but this you must 
change it by your own.



Files:

- perms.sql, horde_perms table structure

- migrate.php: moves your current permissons to a flat table

- perms.diff current UI fix

- sql.php driver to out in Horde/Perms/sql.php

- test.php, runs all driver methods for result coparations

Saved Queries