Re: [Phpgroupware-users] My strange things with LDAP...

[Marco Gaiarin]

Again:

> I've posted this some day ago:

> > First user creation went well. The second popup an insert/update error
> > because a duplicate key, and now this group (web) exist in ldap setup
> > but not in phpgw admin group page.

> > Before resetting ldap account i've cleaned up phpgw_acl and 
> > phpgw_preferences
> > tables, could be that some other table have to be cleaned up?!

> > Please, say me some sql instruction i can use to debug this, thanks.

Trying to explain better: i'm using last stable branch, cvs updated,
with LDAP for account.

I've created some account, but for a unknown cause the creation of
``web'' group go bad: the group was created in LDAP but phpgw does not
``see'' it.

I've tried to fiddle with the phpgw table, but i've not found what i've
to add. The LDAP record are:

dn: cn=web,ou=Group,dc=ac,dc=concordia-pordenone,dc=it
userPassword:: <ops!>
phpgwAccountType: g
phpgwAccountExpires: -1
objectClass: top
objectClass: posixGroup
objectClass: phpgwAccount
cn: web
creatorsName: cn=admin,dc=ac,dc=concordia-pordenone,dc=it
createTimestamp: 20031001154304Z
gidNumber: 1002
description: Webmaster
memberUid: gaio
memberUid: petrunet
memberUid: guidolo
modifiersName: cn=admin,dc=ac,dc=concordia-pordenone,dc=it
modifyTimestamp: 20031022104041Z


and (for me) relevant table are:

phpgwacpn=# select * from phpgw_acl where acl_location=1002 or
acl_account=1002;                                                               
                 
 acl_appname | acl_location | acl_account | acl_rights
-------------+--------------+-------------+------------
 phpgw_group | 1002         |        1000 |          1
 sitemgr     | run          |        1002 |          1
(2 rows)
 
phpgwacpn=# select * from phpgw_preferences where preference_owner=1002;
 preference_owner | preference_value                                            
                                                                                
                                      
------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 1002             | 
a:1:{s:6:"common";a:11:{s:9:"maxmatchs";s:2:"50";s:12:"template_set";s:7:"justweb";s:5:"theme";s:6:"heaven";s:13:"navbar_format";s:5:"icons";s:9:"tz_offset";s:1:"1";s:10:"dateformat";s:5:"d/m/Y";s:10:"timeformat";s:2:"24";s:7:"country";s:2:"IT";s:4:"lang";s:2:"it";s:17:"show_currentusers";s:4:"True";s:8:"currency";s:1:"";}}
(1 row)
 

(1000 is the UID of user gaio, mine).



Please, help me, i cannot simply delete and recreate the web group. ;(

-- 
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)
  gaio(at)sv.lnf.it             tel +39-0434-842711    fax +39-0434-842797

         Proteggiamo l'innovazione in Europa: no ai brevetti software
                           http://swpat.xsec.it/