Author Topic: Change Default config manager password  (Read 5053 times)

Offline nomster123

  • Jr. Member
  • **
  • Posts: 58
  • Karma: 0
Change Default config manager password
« on: September 04, 2015, 05:52:34 PM »
due to a stupid mistake i changed password of default by mistake and unable to login to my config manager, im using SQL server 2008 with Conf server 8.1, tried to delete the password from cfg_person but it still doesnt log in as it is uding its own encryption. If i even delete the password entry it still doesnt log in. Suppose there is exncrypted for empty string too.

Please help its very important

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7538
  • Karma: 56330
Re: Change Default config manager password
« Reply #1 on: September 04, 2015, 07:33:48 PM »
You will have to delete password on sql table and restart CfgServer after that.

Enviado de meu C6602 usando Tapatalk


Offline nomster123

  • Jr. Member
  • **
  • Posts: 58
  • Karma: 0
Re: Change Default config manager password
« Reply #2 on: September 04, 2015, 10:47:01 PM »
Deleted password and restarted DB server and CFG server but no use. its not accepting blank password

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7538
  • Karma: 56330
Re: Change Default config manager password
« Reply #3 on: September 04, 2015, 11:03:19 PM »
Then create a password on another account you know. Copy the encrypted value to the default account and done. Easy as that...

Enviado de meu C6602 usando Tapatalk


Offline nomster123

  • Jr. Member
  • **
  • Posts: 58
  • Karma: 0
Re: Change Default config manager password
« Reply #4 on: September 04, 2015, 11:09:57 PM »
Problem is that there is only one account in the DB right now that is default. Havant added any agent yet :/

Adam G

  • Guest
Re: Change Default config manager password
« Reply #5 on: September 04, 2015, 11:54:22 PM »
Re-install?

Offline Kubig

  • Hero Member
  • *****
  • Posts: 2709
  • Karma: 41
Re: Change Default config manager password
« Reply #6 on: September 05, 2015, 12:22:50 AM »
Just idea : Try to extract just the SQL script for cfg_person table from the SQL scripts for the CFG databse and recreate this table (the default user should be create with default password).
Genesys certified professional consultant (GVP, SIP, GIR and Troubleshooting)

Offline nomster123

  • Jr. Member
  • **
  • Posts: 58
  • Karma: 0
Re: Change Default config manager password
« Reply #7 on: September 05, 2015, 12:34:00 AM »
dont want to reinstall, have already installed alot of things in it

@kubig: ill try this and get back to you on this

Offline nomster123

  • Jr. Member
  • **
  • Posts: 58
  • Karma: 0
Re: Change Default config manager password
« Reply #8 on: September 05, 2015, 12:51:54 AM »
Kubig , I am having trouble finding exact SQL statement which will insert  into persons table, There were two scripts i used , one was init other was CFG locals but both contain a lot of commands, it might just affect the whole Table.

Can you please specify which commands from these two scipts. Forgive me knowledge of SQL. Using SQL Server

Offline raza990

  • Full Member
  • ***
  • Posts: 214
  • Karma: 5
Re: Change Default config manager password
« Reply #9 on: September 07, 2015, 04:35:00 PM »
Please follow below steps if you forget the password of configuration server.

1.   Make a backup of your CME database
2.   Stop Configuration Server
3.   Run this SQL query against the database:
a.   Pre 8.0.3 configuration server/db:
UPDATE cfg_person SET password='5F4DCC3B5AA765D61D8327DEB882CF99' WHERE dbid=100;
b.   8.0.3 config server or highter:
UPDATE cfg_person SET password='5F4DCC3B5AA765D61D8327DEB882CF99' , salted_string=NULL WHERE dbid=100;
4.   Start Configuration Server.

This will change the password to 'password'.

NOTE:
Donít put the password of your own instead of '5F4DCC3B5AA765D61D8327DEB882CF99'.

Adam G

  • Guest
Re: Change Default config manager password
« Reply #10 on: September 08, 2015, 09:36:10 PM »
Good post.

Wonder if there is a way on SMF to flag it, as "useful"?


Please follow below steps if you forget the password of configuration server.

1.   Make a backup of your CME database
2.   Stop Configuration Server
3.   Run this SQL query against the database:
a.   Pre 8.0.3 configuration server/db:
UPDATE cfg_person SET password='5F4DCC3B5AA765D61D8327DEB882CF99' WHERE dbid=100;
b.   8.0.3 config server or highter:
UPDATE cfg_person SET password='5F4DCC3B5AA765D61D8327DEB882CF99' , salted_string=NULL WHERE dbid=100;
4.   Start Configuration Server.

This will change the password to 'password'.

NOTE:
Donít put the password of your own instead of '5F4DCC3B5AA765D61D8327DEB882CF99'.

Offline orel

  • Newbie
  • *
  • Posts: 2
  • Karma: 0
Re: Change Default config manager password
« Reply #11 on: September 03, 2022, 02:02:00 AM »
Hello,

I am trying to to compute the correct hash with a given password and salt.
The documentation states that this should be sha256(clear_text_password || salt) or sha256(salt || clear_text_password) but this doesn't seem to work.