I had a situation where we had an old Bugzilla server that hadn’t been used for several years. As these things often happen, the “powers that be” suddenly decided we need that server to be back up and running NOW. Of course, nobody could remember their passwords any more and the email password mechanism had stopped working.
A Google search could only seem to turn up suggestions that started with “login to an admin user…”. Yeah, if I could do that I wouldn’t really have problem would I?
Anyway the solution was fairly easy actually.
NOTE: this is a dangerous solution that leaves the admin user exposed for a little while. Take reasonable precautions to prevent access until finished. Either with firewall rules or via an Apache .htaccess rule.
- Sign on to Mysql via the command line on the server in question
USE bugs; (the bugzilla database)
UPDATE profiles SET cryptpassword=null WHERE userid=1;
userid is the id of an admin user
- You can now login as that user with no password (see I told you it was dangerous).
- As admin you can change the password of another user to a password you can rememeber, so do that.
- Now if you go back into the database and list everything you will see the encrypted passwords.
- Now just set the password for your admin user and use the encrypted string in place of null in the above SQL statement.
Once you have set the encrypted password you should be able to login as the admin user using the password you set and you can even change the password at this point.
Looking into RAID ADMIN TOOLS
Please Come Back.
Okay its seems that the Virtualmin downgrade has settled down now.
I’m still working out exactly how much functionality I have lost by going to the free GPL version but this is what I did:
- I downloaded the repo rpm and installed it with:
rpm -Uvh –oldpackage virtualmin-release-latest.rpm
yum clean all
This will clean up the repo settings left over from the downgrade and reset to the gpl version.
I then went into the webmin control panel:
WEBMIN>SYSTEM>Scheduled Cron Jobs
and disabled the following cron jobs (these are apparently not valid in the gpl version of Virtualmin):
That last one is a clean up program for fastcgi but , I haven’t found out what the other 2 jobs do.
I just know that they give me errors in my logs if left enabled.
I have since discovered that it might be possible to change the username and password to “GPL” and the re-run the install script. I have not tested this and don’t know what that would do to the existing servers, mailpacks , etc.
Okay so it turns out the upgrade (downgrade..sidegrade???) to Virtualmin didn’t work as well as I had hoped.
I did the steps outlined previously but some problems cropped up.
- Some hourly cron jobs started to act up (most notably one which cleans up Fastcgi scripts …fcgiclean.pl)
- The Virtualmin Control Panel announced a new update which , when applied, actually reverted back to the Pro version and then proceeded to warn me that the license was out of date …again…sigh
I will troll the support forums and see if I can fix this.
Also unfortunately Virtualmin seems to be updating their website so their support documentation is full of stale links…double sigh.
I will keep posting here.
I recently had to downgrade our Virtualmin package from PRO to GPL because our license expired and we didn’t seem to need the features of the PRO version any more.
Time will tell if this turns out to be a foolish move but this is what I did.
Basically you just install the GPL version over top of the PRO version, how you downgrade depends on your OS. For an RPM-based Distro like Centos 5, you’ll have to use the “–old-package” option to RPM to install the GPL version. Because upgrading is the far more common scenario, PRO has a higher Epoch than GPL, which means it always looks like a newer version to rpm/yum, even if it actually isn’t.
The GPL repository will have the same URL as the Professional one, except it
has “/gpl/” in the path.
Steps I took:
First install the GPL version over the PRO version;
rpm -Uvh –oldpackage wbm-virtual-server-“VERS#”.noarch.rpm
Obviously, with GPL, you won’t need a serial number to download it.
Then upgrade the repo with:
rpm -Uvh –oldpackage http://software.virtualmin.com/gpl/
Then do a
…and finally REBOOT if a new kernel was installed.
The TAR command is one of those built-in utilities that makes Linux (and of course UNIX) so great. It allows you to make an archive of a directory (or a series of files).
You would use it like so…
- cd to root folder
- tar -cvzf name.tgz dir
This makes a tar archive of dir.
- tar -xvf name.tgz
This will extract the archive name.tgz wherever you are.
tar -xvf file.tar.gz -C /some/dir/
This will change to /some/dir/ and extract file.tar.gz there.