Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: nomster123 on September 04, 2015, 08:52:34 AM

Title: Change Default config manager password
Post by: nomster123 on September 04, 2015, 08:52:34 AM
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
Title: Re: Change Default config manager password
Post by: cavagnaro on September 04, 2015, 10:33:48 AM
You will have to delete password on sql table and restart CfgServer after that.

Enviado de meu C6602 usando Tapatalk

Title: Re: Change Default config manager password
Post by: nomster123 on September 04, 2015, 01:47:01 PM
Deleted password and restarted DB server and CFG server but no use. its not accepting blank password
Title: Re: Change Default config manager password
Post by: cavagnaro on September 04, 2015, 02: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

Title: Re: Change Default config manager password
Post by: nomster123 on September 04, 2015, 02:09:57 PM
Problem is that there is only one account in the DB right now that is default. Havant added any agent yet :/
Title: Re: Change Default config manager password
Post by: Adam G on September 04, 2015, 02:54:22 PM
Re-install?
Title: Re: Change Default config manager password
Post by: Kubig on September 04, 2015, 03:22:50 PM
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).
Title: Re: Change Default config manager password
Post by: nomster123 on September 04, 2015, 03:34:00 PM
dont want to reinstall, have already installed alot of things in it

@kubig: ill try this and get back to you on this
Title: Re: Change Default config manager password
Post by: nomster123 on September 04, 2015, 03:51:54 PM
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
Title: Re: Change Default config manager password
Post by: raza990 on September 07, 2015, 07:35:00 AM
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'.
Title: Re: Change Default config manager password
Post by: Adam G on September 08, 2015, 12:36:10 PM
Good post.

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


[quote author=raza990 link=topic=9084.msg40723#msg40723 date=1441611300]
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'.
[/quote]
Title: Re: Change Default config manager password
Post by: orel on September 02, 2022, 05:02:00 PM
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.