your SQL querie has also answered at my next question: if I use LDAP authentication, a copy of user ldap password is apparently NOT stored in the database.
________________________________ De : Clemens Klein-Robbenhaar <[email protected]> À : [email protected] Envoyé le : Mercredi 30 juillet 2014 13h57 Objet : Re: [xwiki-users] about password and LDAP ... > - I wondered where is stored local users password? More precisely in which > table? I see that users are in xwikidoc table: > http://platform.xwiki.org/xwiki/bin/view/DevGuide/DatabaseSchema (but not the > password) > Note, I don't want reinitialize password (I know how to do it with superuser) > The password is a (string-valued) attribute of an object of class "XWikiUsers", which is attached to the profile page. you can see this if you look at any user profile in the object editor. In mySQLyou can see the stored passwords might look like: select * from xwikiobjects join xwikistrings on xwikiobjects.XWO_ID = xwikistrings.XWS_ID where XWO_CLASSNAME='XWiki.XWikiUsers' and xwikistrings.XWS_NAME='password'; ... > > - With ldap authentication, I filter members by ldap statics groups > > #-# Only members of the following group can authenticate. > xwiki.authentication.ldap.user_group=dn=_agents_,xxxx,dc=fr > _agents_ contain a static list of memberUID with name.surname > > I active log for ldap and I saw that for the first connexion by a ldap user, > cache creation take 1mn > Apparently xwiki try to retrieve the dn for each member of the static group > for generate his cache (~5 queries by member) > Of course, I increased xwiki.authentication.ldap.groupcache_expiration value > > Are there a way to refresh the ldap cache by cron or scheduled script? > > Thxs. > > Pascal B > _______________________________________________ > users mailing list > [email protected] > http://lists.xwiki.org/mailman/listinfo/users > _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
