Grokbase › Groups › Hadoop › scm-users › June 2012
FAQ
Hello.
I have test hadoop installation and Cloudera Manager Free Edition.
I didn't use it for a while and forgot admin password.

How can i reset/set a new from shell ?

Regards
razor

Search Discussions

  • Philip Zeyliger at Jun 14, 2012 at 4:16 pm ⇧
    You'll have to edit the database directly. The database credentials are in
    /etc/cloudera-scm-server/db.properties. You'll need to use "psql -h
    localhost -U scm" (or something similar) to access the database. On a test
    system of mine, the password "admin" is encoded as follows. (I believe
    deleting all entries from the USERS table will also do the trick, leading
    you into the default state, but it's best to make a backup of your database
    first using pgdump.) I haven't had the opportunity to try this out at the
    moment; please do report back on how it works out.

    -- Philip

    mysql> select * from USERS;
    +---------+---------------------------------------------------+------------------------------------------------------------------+----------------------+
    USER_ID | USER_NAME |
    PASSWORD_HASH |
    PASSWORD_SALT |
    +---------+---------------------------------------------------+------------------------------------------------------------------+----------------------+
    1 | admin |
    ffa2eb4251b38e069e968890cb2bcdb6229982322f5ed2470bf96231fe4c39c8 |
    -4382599614486590865 |


    On Thu, Jun 14, 2012 at 8:01 AM, razor wrote:

    Hello.
    I have test hadoop installation and Cloudera Manager Free Edition.
    I didn't use it for a while and forgot admin password.

    How can i reset/set a new from shell ?

    Regards
    razor
  • Ricky Saltzer at Jun 14, 2012 at 4:24 pm ⇧
    Hey Phillip -

    I've tested and this does work.

    Ricky
    On Thu, Jun 14, 2012 at 12:15 PM, Philip Zeyliger wrote:

    You'll have to edit the database directly. The database credentials are
    in /etc/cloudera-scm-server/db.properties. You'll need to use "psql -h
    localhost -U scm" (or something similar) to access the database. On a test
    system of mine, the password "admin" is encoded as follows. (I believe
    deleting all entries from the USERS table will also do the trick, leading
    you into the default state, but it's best to make a backup of your database
    first using pgdump.) I haven't had the opportunity to try this out at the
    moment; please do report back on how it works out.

    -- Philip

    mysql> select * from USERS;

    +---------+---------------------------------------------------+------------------------------------------------------------------+----------------------+
    USER_ID | USER_NAME |
    PASSWORD_HASH |
    PASSWORD_SALT |

    +---------+---------------------------------------------------+------------------------------------------------------------------+----------------------+
    1 | admin |
    ffa2eb4251b38e069e968890cb2bcdb6229982322f5ed2470bf96231fe4c39c8 |
    -4382599614486590865 |


    On Thu, Jun 14, 2012 at 8:01 AM, razor wrote:

    Hello.
    I have test hadoop installation and Cloudera Manager Free Edition.
    I didn't use it for a while and forgot admin password.

    How can i reset/set a new from shell ?

    Regards
    razor
  • Kevin O'dell at Jun 14, 2012 at 4:32 pm ⇧
    Razor,

       The working testing that we have done is changing the hash and salt to
    the below so that it sets the password to admin, NOT removing all entries
    to return to a default state. Just wanted to clarify that.
    On Thu, Jun 14, 2012 at 12:23 PM, Ricky Saltzer wrote:

    Hey Phillip -

    I've tested and this does work.

    Ricky

    On Thu, Jun 14, 2012 at 12:15 PM, Philip Zeyliger wrote:

    You'll have to edit the database directly. The database credentials are
    in /etc/cloudera-scm-server/db.properties. You'll need to use "psql -h
    localhost -U scm" (or something similar) to access the database. On a test
    system of mine, the password "admin" is encoded as follows. (I believe
    deleting all entries from the USERS table will also do the trick, leading
    you into the default state, but it's best to make a backup of your database
    first using pgdump.) I haven't had the opportunity to try this out at the
    moment; please do report back on how it works out.

    -- Philip

    mysql> select * from USERS;

    +---------+---------------------------------------------------+------------------------------------------------------------------+----------------------+
    USER_ID | USER_NAME |
    PASSWORD_HASH |
    PASSWORD_SALT |

    +---------+---------------------------------------------------+------------------------------------------------------------------+----------------------+
    1 | admin |
    ffa2eb4251b38e069e968890cb2bcdb6229982322f5ed2470bf96231fe4c39c8 |
    -4382599614486590865 |


    On Thu, Jun 14, 2012 at 8:01 AM, razor wrote:

    Hello.
    I have test hadoop installation and Cloudera Manager Free Edition.
    I didn't use it for a while and forgot admin password.

    How can i reset/set a new from shell ?

    Regards
    razor

    --
    Kevin O'Dell
    Customer Operations Engineer, Cloudera
  • Razor at Jun 15, 2012 at 7:37 am ⇧
    Hi,
    thanks for fast replies.

    I tried to login using password from /etc/cloudera-scm-server/
    db.properties (cloudera.cmf.db.password=U0Lm85G41T)
    psql -h localhost -p 7432 -U scm
    and the entering the password, but it says:
    psql: FATAL: password authentication failed for user "scm"

    Is this a correct password? (in this file? or maybe somehow hashed?)

    Regards
    razor
  • Vikas Singh at Jun 15, 2012 at 4:23 pm ⇧
    Hi razor,

    Try adding the database to the command line. So the command line may look like:

    psql -h localhost -p 7432 -U scm -d scm -W

    Vikas
    On Fri, Jun 15, 2012 at 12:36 AM, razor wrote:
    Hi,
    thanks for fast replies.

    I tried to login using password from /etc/cloudera-scm-server/
    db.properties (cloudera.cmf.db.password=U0Lm85G41T)
    psql -h localhost -p 7432 -U scm
    and the entering the password, but it says:
    psql: FATAL:  password authentication failed for user "scm"

    Is this a correct password? (in this file? or maybe somehow hashed?)

    Regards
    razor
  • Casey Ching at Jun 15, 2012 at 7:51 pm ⇧
    You might also try

    psql -U cloudera-scm -p 7432 -h localhost -d scm

    using the password found in
    /var/lib/cloudera-scm-server-db/data/generated_password.txt

    Casey
    On Fri 15 Jun 2012 09:23:28 AM PDT, Vikas Singh wrote:

    Hi razor,

    Try adding the database to the command line. So the command line may
    look like:

    psql -h localhost -p 7432 -U scm -d scm -W

    Vikas
    On Fri, Jun 15, 2012 at 12:36 AM, razor wrote:

    Hi,
    thanks for fast replies.

    I tried to login using password from /etc/cloudera-scm-server/
    db.properties (cloudera.cmf.db.password=U0Lm85G41T)
    psql -h localhost -p 7432 -U scm
    and the entering the password, but it says:
    psql: FATAL: password authentication failed for user "scm"

    Is this a correct password? (in this file? or maybe somehow hashed?)

    Regards
    razor
  • Razor at Jun 17, 2012 at 9:38 pm ⇧
    Hi!

    It works perfectly.
    i had a problem to log in to scm database, because i mistaken l for a 1 in
    a password (db.properties)

    Thanks for help :)



    W dniu czwartek, 14 czerwca 2012 18:23:56 UTC+2 użytkownik Ricky Saltzer
    napisał:
    Hey Phillip -

    I've tested and this does work.

    Ricky
    On Thu, Jun 14, 2012 at 12:15 PM, Philip Zeyliger wrote:

    You'll have to edit the database directly. The database credentials are
    in /etc/cloudera-scm-server/db.properties. You'll need to use "psql -h
    localhost -U scm" (or something similar) to access the database. On a test
    system of mine, the password "admin" is encoded as follows. (I believe
    deleting all entries from the USERS table will also do the trick, leading
    you into the default state, but it's best to make a backup of your database
    first using pgdump.) I haven't had the opportunity to try this out at the
    moment; please do report back on how it works out.

    -- Philip

    mysql> select * from USERS;

    +---------+---------------------------------------------------+------------------------------------------------------------------+----------------------+
    USER_ID | USER_NAME |
    PASSWORD_HASH |
    PASSWORD_SALT |

    +---------+---------------------------------------------------+------------------------------------------------------------------+----------------------+
    1 | admin |
    ffa2eb4251b38e069e968890cb2bcdb6229982322f5ed2470bf96231fe4c39c8 |
    -4382599614486590865 |


    On Thu, Jun 14, 2012 at 8:01 AM, razor wrote:

    Hello.
    I have test hadoop installation and Cloudera Manager Free Edition.
    I didn't use it for a while and forgot admin password.

    How can i reset/set a new from shell ?

    Regards
    razor
  • KIRAN bhakre at Feb 26, 2013 at 11:07 am ⇧
    I am using the cloudera manager 4
    and hadoop cdh4.2

    this table is having more column how can we set it

    please give me the encryption for admin

    On Monday, 18 June 2012 03:07:55 UTC+5:30, razor wrote:

    Hi!

    It works perfectly.
    i had a problem to log in to scm database, because i mistaken l for a 1 in
    a password (db.properties)

    Thanks for help :)



    W dniu czwartek, 14 czerwca 2012 18:23:56 UTC+2 użytkownik Ricky Saltzer
    napisał:
    Hey Phillip -

    I've tested and this does work.

    Ricky

    On Thu, Jun 14, 2012 at 12:15 PM, Philip Zeyliger <phi...@cloudera.com<javascript:>
    wrote:
    You'll have to edit the database directly. The database credentials are
    in /etc/cloudera-scm-server/db.properties. You'll need to use "psql -h
    localhost -U scm" (or something similar) to access the database. On a test
    system of mine, the password "admin" is encoded as follows. (I believe
    deleting all entries from the USERS table will also do the trick, leading
    you into the default state, but it's best to make a backup of your database
    first using pgdump.) I haven't had the opportunity to try this out at the
    moment; please do report back on how it works out.

    -- Philip

    mysql> select * from USERS;

    +---------+---------------------------------------------------+------------------------------------------------------------------+----------------------+
    USER_ID | USER_NAME |
    PASSWORD_HASH |
    PASSWORD_SALT |

    +---------+---------------------------------------------------+------------------------------------------------------------------+----------------------+
    1 | admin |
    ffa2eb4251b38e069e968890cb2bcdb6229982322f5ed2470bf96231fe4c39c8 |
    -4382599614486590865 |



    On Thu, Jun 14, 2012 at 8:01 AM, razor <razor...@gmail.com <javascript:>
    wrote:
    Hello.
    I have test hadoop installation and Cloudera Manager Free Edition.
    I didn't use it for a while and forgot admin password.

    How can i reset/set a new from shell ?

    Regards
    razor
  • KIRAN bhakre at Mar 1, 2013 at 1:40 pm ⇧
    I have checked the ablove content but it is not working.
    it also showing the some other columns ....
    On Tuesday, 26 February 2013 16:31:17 UTC+5:30, KIRAN bhakre wrote:

    I am using the cloudera manager 4
    and hadoop cdh4.2

    this table is having more column how can we set it

    please give me the encryption for admin

    On Monday, 18 June 2012 03:07:55 UTC+5:30, razor wrote:

    Hi!

    It works perfectly.
    i had a problem to log in to scm database, because i mistaken l for a 1
    in a password (db.properties)

    Thanks for help :)



    W dniu czwartek, 14 czerwca 2012 18:23:56 UTC+2 użytkownik Ricky Saltzer
    napisał:
    Hey Phillip -

    I've tested and this does work.

    Ricky
    On Thu, Jun 14, 2012 at 12:15 PM, Philip Zeyliger wrote:

    You'll have to edit the database directly. The database credentials
    are in /etc/cloudera-scm-server/db.properties. You'll need to use "psql -h
    localhost -U scm" (or something similar) to access the database. On a test
    system of mine, the password "admin" is encoded as follows. (I believe
    deleting all entries from the USERS table will also do the trick, leading
    you into the default state, but it's best to make a backup of your database
    first using pgdump.) I haven't had the opportunity to try this out at the
    moment; please do report back on how it works out.

    -- Philip

    mysql> select * from USERS;

    +---------+---------------------------------------------------+------------------------------------------------------------------+----------------------+
    USER_ID | USER_NAME |
    PASSWORD_HASH |
    PASSWORD_SALT |

    +---------+---------------------------------------------------+------------------------------------------------------------------+----------------------+
    1 | admin |
    ffa2eb4251b38e069e968890cb2bcdb6229982322f5ed2470bf96231fe4c39c8 |
    -4382599614486590865 |


    On Thu, Jun 14, 2012 at 8:01 AM, razor wrote:

    Hello.
    I have test hadoop installation and Cloudera Manager Free Edition.
    I didn't use it for a while and forgot admin password.

    How can i reset/set a new from shell ?

    Regards
    razor
  • Dylan Hogg at Sep 24, 2013 at 1:54 am ⇧
    Thanks Philip, using your supplied password hash and salt reset the admin
    user password to admin also with the following SQL statement:

    scm=> update USERS set
    password_hash='ffa2eb4251b38e069e968890cb2bcdb6229982322f5ed2470bf96231fe4c39c8',
    password_salt=-4382599614486590865 WHERE user_name = 'admin';

    On Friday, 15 June 2012 02:15:51 UTC+10, Philip Zeyliger wrote:

    You'll have to edit the database directly. The database credentials are
    in /etc/cloudera-scm-server/db.properties. You'll need to use "psql -h
    localhost -U scm" (or something similar) to access the database. On a test
    system of mine, the password "admin" is encoded as follows. (I believe
    deleting all entries from the USERS table will also do the trick, leading
    you into the default state, but it's best to make a backup of your database
    first using pgdump.) I haven't had the opportunity to try this out at the
    moment; please do report back on how it works out.

    -- Philip

    mysql> select * from USERS;

    +---------+---------------------------------------------------+------------------------------------------------------------------+----------------------+
    USER_ID | USER_NAME |
    PASSWORD_HASH |
    PASSWORD_SALT |

    +---------+---------------------------------------------------+------------------------------------------------------------------+----------------------+
    1 | admin |
    ffa2eb4251b38e069e968890cb2bcdb6229982322f5ed2470bf96231fe4c39c8 |
    -4382599614486590865 |



    On Thu, Jun 14, 2012 at 8:01 AM, razor <razor...@gmail.com <javascript:>>wrote:
    Hello.
    I have test hadoop installation and Cloudera Manager Free Edition.
    I didn't use it for a while and forgot admin password.

    How can i reset/set a new from shell ?

    Regards
    razor
    To unsubscribe from this group and stop receiving emails from it, send an email to scm-users+unsubscribe@cloudera.org.
  • KIRAN bhakre at Feb 26, 2013 at 11:01 am ⇧
    On Thursday, 14 June 2012 20:31:15 UTC+5:30, razor wrote:
    Hello.
    I have test hadoop installation and Cloudera Manager Free Edition.
    I didn't use it for a while and forgot admin password.

    How can i reset/set a new from shell ?

    Regards
    razor

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupscm-users @
categorieshadoop
postedJun 14, '12 at 3:01p
activeSep 24, '13 at 1:54a
posts12
users8
websitecloudera.com
irc#hadoop

8 users in discussion

KIRAN bhakre: 3 posts Razor: 3 posts Dylan Hogg: 1 post Ricky Saltzer: 1 post Vikas Singh: 1 post Kevin O'dell: 1 post Philip Zeyliger: 1 post Casey Ching: 1 post

Content

People

Support

Translate

site design / logo © 2022 Grokbase