How to reset MySQL root password

To reset the MySQL root password, do the following:

SET PASSWORD FOR root@localhost=PASSWORD(‘yournewpassword’);

And voila! You have changed your password.

PS: If you have a “problem” with beeing able to login to MySQL without using password (even when it is set in MySQL), try to edit or delete ~/my.cnf, since that holds information used to avoid the login promt.


(scam?) ” OpenSSH

Aparantly, somebody is willing to release a OpenSSH exploit in less than 48 hours. I hope (and guess) that it is a joke, but if not, the results can become “interesting”.



Clear the Postfix mail queue

If you for some reasont want to clear the Postfix mail queue, you could do a:

postsuper -d ALL

Or if you just want to remove deferred mail:

postsuper -d ALL deferred

Software Ubuntu

Getting Groupwise to work on Ubuntu 64bit (9.04)

Just a quick post on what i did to get Groupwise up and running on Ubuntu 64bit:

1) Installed a 32bit virtual Ubuntu machine, and converted the Groupwise installer to a .deb package with “alien -c filename”.

2) Moved the .deb package back to the host machine.

3) Installed 32bit java libraries “sudo apt-get install ia32-sun-java6-bin”

4) Forced installation of the Groupwise client “sudo dpkg -i –force-architecture novell-groupwise-gwclient_8.0.0-84911_i386.deb”

5) And it works 🙂


Cron commands not working when outputting to stderr(2>&1)

The error:

username@host:/home/foo> fetchmail -f /opt/rt-fetchmail/fetchmail 2>&1 /dev/null
Enter password for username@/dev/null:

Solution: Change the cron entry / command to the following:

fetchmail -f /opt/rt-fetchmail/fetchmail > /dev/null 2>&1

This will stop -all- output from appearing.


Fix for the “Out of memory! Callback called exit.” error in Request Tracker (RT)

When RT is upgraded, users can experience WSOD(White Screen Of Death), all the log will say is:
“Out of memory! Callback called exit.”. Not so informative eh?

The solution is pretty simple, run this query in the database:

“ALTER TABLE sessions CHANGE a_session a_session LONGBLOB;”

Then clear the table with:

TRUNCATE TABLE `sessions`;

Any logged in users will be logged out, but the problem should disappear.

Java Linux

One possible solution for Glassfish cluster node-agent startup problems

Just a quick hint for those of you who are experiencing problem with getting node-agents up and running in a Glassfish cluster.

If the problem is that the asadmin start-agent command simply times out/uses a long time to start, and even possibly returning a filenotfoundexception. The problem could be as simple as a firewall blocking traffic to/from the master-node. A quick way to check it is to simply disable the FW.

Note that if the master-node does not see the node-agent status, it is also caused by FW-issues, fix the FW and then restart the node-agent(s), then it all should work like a charm!


SysRq-reboot macro for Blackbox KVM software

A nice way of rebooting a frozen Linux-based server when you do not have a power switch available is to use the SysRq-abilities. (Ubuntu Example.) Blackbox does not have a default macro installed for just that, but you can create a new macro and insert the following:

“<Alt-PRESS><Print Screen><Alt-RELEASE>RSEIUB”

This will create a working macro for writing any data in cache to disk, kill all processes (Sigkill), remount mounted disks and perform a reboot.

SLES Software

How to fix that stupid backspace in Vim on SLES

Sometimes the backspace button can be a real pain on SLES-systems, but the fix is simple!

Add this to ~/.vimrc:
set backspace=indent,eol,start

Linux SLES

Installation of GPFS on SLES10

I have been playing around with GPFS on SLES for some days now and have compiled a quick HOWO for installation of the system.

Important notes:

  1. You must have root-access for the servers you are installing on
  2. You must compile GPFS kernel modules
  3. You must have access to the GPFS-packages from IBM

Install guide:

  1. Install all 4 rpm files
  2. Install needed packages for compilation: zypper in gcc xorg-x11-devel gcc-c++ kernel-source
  3. Download the latest patch from IBM*
  4. Compile it: cd /usr/lpp/mmfs/;make Autoconfig;make World;make InstallImages

Now you should have GPFS up and running without too much hazzle.
(* Patches are not always needed to make it work, but in case you encounter compilation errors, the latest patch should fix them)