Overview
On rare occasions a partner will forget their cluster admin's password. There is a way to update the cluster admin's password in the database to a "known" value because the password is always hashed with the same value on every CentreStack server. This document does not contain instructions for how you will execute the SQL queries. Use one of the various tools available depending on which DBMS is used.
Procedure
The syntax is slightly different between MySQL and Microsoft SQL Server. Each has it's now section below.
MySQL
Execute this query to view information about the cluster admin:
/*
Displays the cluster admin info
*/
SELECT u.UserId
, u.Email
, u.Password
, n.Name
/*
, n.Tag
, n.Value
, u.UserGuid
*/
FROM csmain.xaf_namedvalue AS n
INNER JOIN csmain.xaf_user AS u
ON u.UserGuid = n.Value
WHERE n.Name='default_admin_id' AND n.Tag='default_domain_auth';
Execute this query to set the password for the cluster admin to password:
/*
Updates the Cluster Admin password to: password
*/
UPDATE csmain.xaf_user as u
INNER JOIN csmain.xaf_namedvalue AS n
ON u.UserGuid = n.Value
SET Password='5F4DCC3B5AA765D61D8327DEB882CF99'
WHERE n.Name='default_admin_id' AND n.Tag='default_domain_auth';
Microsoft SQL Server
Execute this query to view information about the cluster admin:
/*
Displays the cluster admin info
*/
SELECT u.UserId
, u.Email
, u.Password
, n.Name
/*
, n.Tag
, n.Value
, u.UserGuid
*/
FROM [user].[dbo].[xaf_NamedValue] AS n
INNER JOIN [user].[dbo].[xaf_User] AS u
ON u.UserGuid = n.Value
WHERE n.Name='default_admin_id' AND n.Tag='default_domain_auth';
Execute this query to set the password for the cluster admin to password:
/*
Updates the Cluster Admin password to: password
*/
UPDATE [user].[dbo].[xaf_User]
SET Password='5F4DCC3B5AA765D61D8327DEB882CF99'
FROM [user].[dbo].[xaf_User] as u
INNER JOIN [user].[dbo].[xaf_NamedValue] AS n
ON u.UserGuid = n.Value
WHERE n.Name='default_admin_id' AND n.Tag='default_domain_auth';
Comments
0 comments
Please sign in to leave a comment.