View Source

h4. If you forget the web interface password for the user "admin", you can reset it as follows:

h5.


h5. In 7.0.2 :
To reset or change the password for users authenticated against the GroundWork jboss-idm database, run the following command:
{code:title=run as nagios user}
/etc/init.d/groundwork stop gwservices
psql -U jboss -h localhost -d jboss-idm -c "
UPDATE jbid_io_creden
SET text = md5('password')
WHERE identity_object_id = (SELECT identity_object_id
FROM jbid_io u, jbid_io_creden c
WHERE u.id = c.identity_object_id
AND name = 'username');
"
/etc/init.d/groundwork start gwservices
{code}
Where:
* 'password' is replaced with the password
* 'username' is replaced with the user name
* 'localhost' is replaced with the database server name (the {{\-h localhost}} part is optional if you are on the host where the database exists; it is necessary to identify the server if that is on a different server)

Example: Resetting admin's password to: admin
{code:title=run as nagios user}
/etc/init.d/groundwork stop gwservices
psql -U jboss -h localhost -d jboss-idm -c "
UPDATE jbid_io_creden
SET text = md5('admin')
WHERE identity_object_id = (SELECT identity_object_id
FROM jbid_io u, jbid_io_creden c
WHERE u.id = c.identity_object_id
AND name = 'admin');
"
/etc/init.d/groundwork start gwservices
{code}

This will not affect the password for other users. It will however log out all users.

h5. In GroundWork Monitor >=6.6.x:

To reset or change the password for users authenticated against the GroundWork jbossportal database, run the following command:

{code:title=run as nagios user}
/etc/init.d/groundwork stop gwservices
psql -U jboss -h localhost -d jbossportal -c "
UPDATE jbp_users
SET jbp_password=md5('password')
WHERE jbp_uname='username'
"
/etc/init.d/groundwork start gwservices
{code}
Where:
* 'password' is replaced with the password
* 'username' is replaced with the user name
* 'localhost' is replaced with the database server name (the {{\-h localhost}} part is optional if you are on the host where the database exists; it is necessary to identify the server if that is on a different server)

Example: Resetting admin's password to: admin
{code:title=run as nagios user}
source /usr/local/groundwork/scripts/setenv.sh
/etc/init.d/groundwork stop gwservices
psql -U jboss -d jbossportal -c "
UPDATE jbp_users
SET jbp_password=md5('admin')
WHERE jbp_uname='admin'
"
/etc/init.d/groundwork start gwservices
{code}

This will not affect the password for other users. It will however log out all users.

h5. In GroundWork Monitor 6.0-6.5:

To reset or change the password for users authenticated against the GroundWork jbossportal database, run the following command:

{code}
source /usr/local/groundwork/scripts/setenv.sh
/etc/init.d/groundwork stop gwservices
mysql -ujboss -pjboss jbossportal -e "
UPDATE jbp_users
SET jbp_password=md5('password')
WHERE jbp_uname='username'
"
/etc/init.d/groundwork start gwservices
{code}
Where:
* 'password' is replaced with the password
* 'username' is replaced with the user name

Example: Resetting admin's password to: admin
{code}
source /usr/local/groundwork/scripts/setenv.sh
/etc/init.d/groundwork stop gwservices
mysql -ujboss -pjboss jbossportal -e "
UPDATE jbp_users
SET jbp_password=md5('admin')
WHERE jbp_uname='admin'
"
/etc/init.d/groundwork start gwservices
{code}

h5. In GroundWork Monitor 5.x:

To reset or change the password for users authenticated against the GroundWork guava database, run the following command:

{code}
mysql -uguava -pgwrk guava -e "
UPDATE guava_users
SET password = md5('password'), password_expire = '0000-00-00', password_change = '0'
WHERE username = 'username'
"
{code}
Where:
* 'password' is replaced with the password
* 'username' is replaced with the user name

Example: Resetting admin's password to: admin
{code}
mysql -uguava -pgwrk guava -e "
UPDATE guava_users
SET password = md5('admin'), password_expire = '0000-00-00', password_change = '0'
WHERE username = 'admin'
"
{code}