Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How can I change user password directly by SQL

  1. #1
    Join Date
    Oct 2010
    Posts
    7

    Default How can I change user password directly by SQL

    I would like to provide my users with an way by which they can change
    their password themselves.

    To do it , I'm going to write some codes to update ,by SQL, the PASSWORD column of
    USERS table in HIBERNATE system database, but
    the value of the PASSWORD column should be encrypted by the method that pentaho uses.

    Is there anybody who knows How can I encrypt password value ?
    Last edited by replicax; 04-04-2011 at 06:35 AM.

  2. #2
    Join Date
    Oct 2010
    Posts
    7

    Default

    I have found the solution myself.

    The password encoding method can be changed by editing pentaho-solutions/system/applicationContext-spring-security-hibernate.xml.

    Default setting is :
    <bean id="passwordEncoder" class="passwordEncoder" class="org.pentaho.platform.engine.security.DefaultPentahoPasswordEncoder" />

    To change it to MD5 which is supported by every languages :
    <bean id="passwordEncoder" class="org.springframework.security.providers.encoding.Md5PasswordEncoder" />

    For example , doing like following in Perl get same result .

    use Digest::MD5 qw(md5_hex);
    print md5_hex("passwd");

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.