Lieu de stockage des mots de passe NTML

[rjarry]

Bonjour,
Je ne peux pas modifier le mot de passe d'un utilisateur car lorsque je le recherche par la console d'administration, ça plante (juste pour cet utilisateur) :

javax.faces.FacesException: javax.faces.FacesException: Could not retrieve value of component with path : {Component-Path : [Class: javax.faces.component.UIViewRoot,ViewId: /jsp/dialog/container.jsp][Class: javax.faces.component.html.HtmlForm,Id: dialog][Class: javax.faces.component.UINamingContainer,Id: dialog-body][Class: org.alfresco.web.ui.common.component.UIPanel,Id: users-panel][Class: org.alfresco.web.ui.common.component.data.UIRichList,Id: users-list][Class: org.alfresco.web.ui.common.component.data.UIColumn,Id: _idJsp33][Class: javax.faces.component.html.HtmlOutputText,Id: _idJsp35]}
caused by:
org.apache.jasper.JasperException: javax.faces.FacesException: Could not retrieve value of component with path : {Component-Path : [Class: javax.faces.component.UIViewRoot,ViewId: /jsp/dialog/container.jsp][Class: javax.faces.component.html.HtmlForm,Id: dialog][Class: javax.faces.component.UINamingContainer,Id: dialog-body][Class: org.alfresco.web.ui.common.component.UIPanel,Id: users-panel][Class: org.alfresco.web.ui.common.component.data.UIRichList,Id: users-list][Class: org.alfresco.web.ui.common.component.data.UIColumn,Id: _idJsp33][Class: javax.faces.component.html.HtmlOutputText,Id: _idJsp35]}
caused by:
javax.faces.FacesException: Could not retrieve value of component with path : {Component-Path : [Class: javax.faces.component.UIViewRoot,ViewId: /jsp/dialog/container.jsp][Class: javax.faces.component.html.HtmlForm,Id: dialog][Class: javax.faces.component.UINamingContainer,Id: dialog-body][Class: org.alfresco.web.ui.common.component.UIPanel,Id: users-panel][Class: org.alfresco.web.ui.common.component.data.UIRichList,Id: users-list][Class: org.alfresco.web.ui.common.component.data.UIColumn,Id: _idJsp33][Class: javax.faces.component.html.HtmlOutputText,Id: _idJsp35]}
caused by:
javax.faces.el.EvaluationException: Cannot get value for expression '#{r.sizeLatest}'
caused by:
javax.faces.el.EvaluationException: Exception getting value of property sizeLatest of base of type : org.alfresco.web.bean.repository.MapNode
caused by:
java.lang.IllegalStateException: Non-unique path: found : /app:company_home/app:user_homes 0
‍‍‍‍‍‍‍‍‍‍‍‍

Pouvez-vous me dire où est stocké le mot de passe pour le modifier à la main ?

Je suis en Community version Alfresco Lab 3.

Cordialement.

[rjarry]

Je me répond :

Alfresco Version 3.1sp1

For an Alfresco 3.1sp1 system, use the following instructions:

1) Run the following commands and check you have only one row in the output:

SELECT anp1.node_id,
  anp1.qname_id,      
  anp1.string_value      
  FROM alf_node_properties anp1 
  INNER JOIN alf_qname aq1 ON aq1.id = anp1.qname_id                         
  INNER JOIN alf_node_properties anp2 ON anp2.node_id = anp1.node_id      
  INNER JOIN alf_qname aq2 ON aq2.id = anp2.qname_id                         
  WHERE aq1.local_name = 'password'   
  AND aq2.local_name = 'username'      
  AND anp2.string_value = 'admin'  


It should output the current md4 hashed password for the 'admin' user. An example output is:

+———+———-+———————————-+
| node_id | qname_id | string_value |                    
+———+———-+———————————-+
| 4 | 10 | 209c6174da490caeb422f3fa5a7ae634 |               
+———+———-+———————————-+
1 row in set (0.00 sec)


2) If you get only one row, then update the table:

UPDATE alf_node_properties 
SET string_value='209c6174da490caeb422f3fa5a7ae634'
WHERE 
node_id=THENODEIDABOVE
and
qname_id=THEQNAMEVALUEABOVE


Where you need to replace THENODEIDABOVE and THEQNAMEVALUEABOVE with the results from step 1), in this example 4 and 10 respectively.

Note: Please use caution when running this SQL, and ensure that you have the appropriate AND conditions in the UPDATE query.

Par contre, j'ai du redémarrer Tomcat.

[rguinot]

Non-unique path: found : /app:company_home/app:user_homes 0‍

Vous avez supprimé le répertoire 'user homes', et vous utilisez le home folder provider se basant dessus.
D'autre part, la version que vous utilisez est très ancienne.