Re: [phpGroupWare-users] Trouble on sitemanager with an user...

[Marco Gaiarin]

Mandi! Benoit Hamet
  In chel di` si favelave...

> Sorry but can you put the same thing for another user for which is works
> ? (I guess not you since you are the "admin" of the sitemgr isn't it ?)

Sure!

address@hidden:~$ ldapsearch -x -h localhost -b dc=sv,dc=lnf,dc=it 
"(uid=walter)" | grep -i id 
# filter: (uid=walter)
dn: uid=walter,ou=People,dc=sv,dc=lnf,dc=it
uid: walter
uidNumber: 1001
phpgwAccountID: 1001
gidNumber: 1004
sambaSID: S-1-5-21-1458177777-355997386-270368766-1004
sambaPrimaryGroupSID: S-1-5-21-1458177777-355997386-270368766-1009

phpgroupwaresv=# select * from phpgw_acl where acl_account=1001;
acl_appname |  acl_location  | acl_account | acl_rights 
-------------+----------------+-------------+------------
 preferences | changepassword |        1001 |          1
 phpgw_group | 1102           |        1001 |          1
 phpgw_group | 100            |        1001 |          1
 phpgw_group | 666            |        1001 |          1
 phpgw_group | 1004           |        1001 |          1
 phpgw_group | 1026           |        1001 |          1
 phpgw_group | 1042           |        1001 |          1
 phpgw_group | 1043           |        1001 |          1
 phpgw_group | 1100           |        1001 |          1

phpgroupwaresv=# select * from phpgw_acl where acl_appname='sitemgr' and 
acl_account in (1001, 100, 666, 1004, 1026, 1042, 1043, 1100, 1102) and 
acl_location='L26';
 acl_appname | acl_location | acl_account | acl_rights 
-------------+--------------+-------------+------------
 sitemgr     | L26          |        1102 |          3
 sitemgr     | L26          |         100 |          1
 sitemgr     | L26          |        1100 |          1
 sitemgr     | L26          |        1043 |          3
 sitemgr     | L26          |         666 |          3
 sitemgr     | L26          |        1026 |          1
 sitemgr     | L26          |        1042 |          1
 sitemgr     | L26          |        1004 |          3


> > Yes, there's no user ACL, only group ACL.
> Just in case (if not already tested), can you add a specific right to
> this user ? and check it's working ?

Mmmhhhh... good idea, i think we are approaching the right point.


I can only set read access for that user, if i set write access they
are cleared on save.

I've done manually:

        update phpgw_acl set acl_rights=3 where acl_appname='sitemgr' and 
acl_account in (1002);

and now i can see the 'write' flag on sitemgr cathegory ACL.


User are just gone, i'll say you tomorrow.

-- 
dott. Marco Gaiarin                                 GNUPG Key ID: 240A3D66
  Associazione ``La Nostra Famiglia''                http://www.sv.lnf.it/
  Polo FVG  -  Via della Bontà, 7 - 33078  -  San Vito al Tagliamento (PN)
  marco.gaiarin(at)sv.lnf.it      tel +39-0434-842711  fax +39-0434-842797