The GroundWork Monitor is a simple way to deploy Nagios monitoring to networks. It does a great job of monitoring Linux servers, and anything that speaks SNMP.
I recently needed to make some updates to a GroundWork Community Edition VM, and found myself in a situation where the admin user’s dashboard (web browser interface) password had been changed to an unknown value. I was able to SSH into the GroundWork VM though (it’s CentOS Linux based). There’s info floating around the net on how to reset the admin password, but it was written for older versions of GroundWork, so some of the default password, and MySQL schema details have changed.
Here’s what I did to reset the admin user’s password on GroundWork Monitor 6.0 Community Edition:
- SSH into the GroundWork VM. If you haven’t changed the root user’s default password, then it’s going to be “opensource”
- Login to MySQL, and run a query to reset the “admin” user’s password to “admin”. The admin password entered below uses a hash:
/usr/local/groundwork/mysql/bin/mysql -u root monarch
update users set password='21232f297a57a5a743894a0e4a801fc3' where user_name='admin';
That query won’t work for a couple of reasons, the least of which being that credentials are stored in the jbossportal database, not in monarch.
The following command will work to reset the admin password on a default system where the database user passwords haven’t been updated:
/usr/local/groundwork/mysql/bin/mysql -ujboss -pjboss jbossportal -e ‘UPDATE jbp_users SET jbp_password = “21232f297a57a5a743894a0e4a801fc3” WHERE jbp_uname = “admin”;’
For more cool tips and updates checkout http://kb.groundworkopensource.com/
Comment by Mark Carey — June 4, 2010 @ 4:23 pm