Just a quick warning before we start this method is pretty brutal, it is not a spam filter and these methods will delete all your comments weaver they are spam or not, so I only recommend using it when you have let your comments get out of hand and really don’t have time to go through manually, otherwise you might as well just disable comments in your WordPress settings.

I said at the beginning this tutorial is for those who don’t have phpMyAdmin, well as I’m nice I’ve included a quick video for the phpMyAdmin method at the bottom of the page. However if you don’t have phpMyAdmin installed there are a few other way you can delete all your unapproved comments. The easiest way is to have shell access to your box, if you don’t know just skip to the next step. All you need to do is access the box and run one MySQL statement, this can be done as follows:

mysql -u [USERNAME] -p -e "DELETE FROM wordpress.wp_comments WHERE comment_approved=0;" wordpress

And thats it all your unappoved comments will be delted saving your many hours of manualy deleting comments.

NEXT STEP: If you don’t have access to your shell and you don’t have phpMyAdmin installed there is another way to do this, you create a simple PHP page that deletes all comments and access it form your web browser. This should only really be used as a last resort as it will create a page that anyone can access that once opened will delete all your unread comments. This is fine to-do so long as your delete/restrict the page after you’ve finished. So let’s get started first open Notepad or some other html editor and create a page with the following code while adding your own username, password, and database name:

<?php

//Warning this page will delete all your WordPress comments once opened and can accessed by anyone so you should delete or restrict once used!

//Please replace the following with your details

$usrName="[REPLACE WITH YOUR USERNAME]";
$usrPass="[REPLACE WITH YOUR PASSWORD]";
$usrDB="[REPLACE WITH YOUR DATABASE NAME]";

$con = mysql_connect("localhost",$usrName,$usrPass);
if (!$con)
{
	die('Could not connect: Please check your usrName & usrPass settings');
}

mysql_select_db($usrDB, $con);

$result = mysql_query("DELETE FROM wp_comments WHERE comment_approved=0;");
if (!$result)
{
	die('Could not delete: Please check your usrDB setting');
}
else
{
	echo 'All unapproved comments now deleted';
}

?>

Now you’ll need to save this page to something like wp-coment-remove.php then upload it to your site via your normal file transfer method (either ftp or via a http file uploader) once you have done this all you’ll need to do is access the page, so for this site I would go to the page http://www.the-tech-tutorial.com/wp-coment-remove.php , just substitute the-tech-tutorial for your sites address. Now that you have run this page, all your unapproved comments will be gone, hooray. Just remember that this page is a security risk because anyone can access it so either restrict is access once you’re done or delete the page.

As I promised here is the YouTube video showing how to do this with phpMyAdmin:

//tcpCase.h
#include <iostream>
#include <stdio.h>
#include <stdlib.h>
#include <unistd.h>
#include <errno.h>
#include <string.h>
#include <sys/types.h>
#include <sys/socket.h>
#include <netinet/in.h>
#include <netdb.h>
#include <arpa/inet.h>
#include <sys/wait.h>
#include <signal.h>
#include <time.h>

#ifndef TCPCASE_H_
#define TCPCASE_H_

class tcpCase
{
public:
	tcpCase(char * _port, char * _addr);
	virtual ~tcpCase();

	void startConnection();
	bool charSearch(char *toSearch, char *searchFor);

private:
	addrinfo hints, *servinfo;
	char *addr;
	char *port;
	int s; //the socket descriptor

	bool sendData(char *msg);

	void manageRecv(int numbytes, char * buf);
};

#endif /* TCPCASE_H_ */

Class

//tcpCase.cpp
#include "tcpCase.h"

using namespace std;

#define MAXDATASIZE 100

tcpCase::tcpCase(char * _port, char * _addr)
{
	port = _port;
	addr = _addr;

	//Ensure that servinfo is clear
	memset(&hints, 0, sizeof hints); // make sure the struct is empty

	//setup hints
	hints.ai_family = AF_UNSPEC; // don't care IPv4 or IPv6
	hints.ai_socktype = SOCK_STREAM; // TCP stream sockets

	//Setup the structs if error print why
	int res;
	if ((res = getaddrinfo(addr,port,&hints,&servinfo)) != 0)
	{
		fprintf(stderr,"getaddrinfo: %s\n", gai_strerror(res));
	}

	//setup the socket
	if ((s = socket(servinfo->ai_family,servinfo->ai_socktype,servinfo->ai_protocol)) == -1)
	{
		perror("client: socket");
	}

}

tcpCase::~tcpCase()
{
	// TODO Auto-generated destructor stub
}

void tcpCase::startConnection()
{//This goes into the send/rcv loop
	//Connect
	if (connect(s,servinfo->ai_addr, servinfo->ai_addrlen) == -1)
	{
		close (s);
		perror("Client Connect");
	}

	//We dont need this anymore
	freeaddrinfo(servinfo);

	int numbytes;
	char buf[MAXDATASIZE];
	while (1)
	{
		//Recv & print Data
		numbytes = recv(s,buf,MAXDATASIZE-1,0);
		buf[numbytes]='\0';
		cout << buf;

		//What do I do with the recived data
		manageRecv(numbytes,buf);

		//break if connection closed
		if (numbytes==0)
		{
			cout << "----------------------CONNECTION CLOSED---------------------------"<< endl;

			break;
		}
	}

}

bool tcpCase::charSearch(char *toSearch, char *searchFor)
{
	int len = strlen(toSearch);
	int forLen = strlen(searchFor); // The length of the searchfor field

	//Search through each char in toSearch
	for (int i = 0; i < len;i++)
	{
		//If the active char is equil to the first search item then search toSearch
		if (searchFor[0] == toSearch[i])
		{
			bool found = true;
			//search the char array for search field
			for (int x = 1; x < forLen; x++)
			{
				if (toSearch[i+x]!=searchFor[x])
				{
					found = false;
				}
			}

			//if found return true;
			if (found == true)
				return true;
		}
	}

	return 0;
}

bool tcpCase::sendData(char *msg)
{//Send some data
	//Send some data
	int len = strlen(msg);
	int bytes_sent = send(s,msg,len,0);

	if (bytes_sent == 0)
		return false;
	else
		return true;
}

void tcpCase::manageRecv(int numbytes, char * buf)
{
	/*
	*	TODO: Add your code here!
	*	int numbytes: this is the number of bytes in the recived msg
	*	char * buf: this is the message recieved
	*/
}

• int numbytes : the number of bytes in the recived message
• char * buf : the message recived

from this you should be able to program your protocol.

Calling this class is also pretty simple, all you need to do is give the parameters:

• port: the port you want to connect to
• addr: the server you want to connect to

then call the startConnection() function to get the client to connect, here is a quick example:

  tcpCase test = tcpCase("6667","irc.ubuntu.com");
  test.startConnection();

If you want more information on c++ socket programming I recommend you read Beej’s Guide to Network Programming. As socket programming is a complicated thing i recommend you read the whole of this great guide, rather then just skipping to the the examples (learn from my mistake there)

Sudo apt-get install cpulimit

Once cpulimit is installed all you need to do is run the program you want to limit then type the following substituting [program] to the program you want to run, i.e gpg:

sudo cpulimit -e "[program]" -l 30

When I first installed 11.04 my installer crashed (due to a faulty cd) so I decided to boot into windows to finish the work I needed to get done, sadly the installer had crashed before installing grub so I couldn’t boot into windows. To fix this I quickly loaded a live CD and installed grub on my windows partition, this worked fine for the time being. After I finished my work I burned another cd (at a slower speed) and re-installed Ubuntu 11.04 successfully. Now when I rebooted grub didn’t see the windows partitions. So first it tried:

sudo update-grub

this still Couldn’t find the windows partition, so I then tried

sudo os-prober

this also would not find windows. I had a look at my windows partition and realised that the grub files were still installed, I deleted these (c:\boot (lowercase only)) and re-run update-grub<.span> witch finaly found windows.

Now if you dont want to read my story here are the most common ways of getting grub to find your windows partition:

sudo update-grub

sudo os-prober

Remove any grub files from your windows drive

# disable the raid setup
dmraid -an
dmraid -si

# remove the metadata
dmraid -E -r

Install StartUP – Manager 
Open it and go to display and set the  Resolution as 640 X 480 and colour depth as 8 bits

I hope this helped fix your problems, if not please feel free to leave a comment and I’ll try to answer your questions.

To do this first you must understand what a CSV file is, it stands for Comma Separated File, as the name suggests it consists of data separated by a comma. When you create a new CSV file you enter each Column followed by a comma, then you’re ready to move to the next row you enter a line terminator (usually \n). This simple way of formatting data is vary us full because nearly all database and spreadsheet programs are compatible with it. This enables you to layout the data you want in excel then export it to a CSV then import this CSV into your MySQL database.

To do this all you need to do is issue a SQL command in the same way you would any SQL command, either by PHP, the MySQL console or using some tool such as MySQL Workbench. The command you should execute is:

LOAD DATA LOCAL INFILE '[File Name]'
INTO  [Table]
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
([field], [field], [field]);

Now you may need to change this command depending on your database, the filds you’ll need to change are:

• [File Name] Substitute [File Name] for location of your CSV file
• INTO TABLE [Table]: Substitute [Table] for the table name your are trying to populate
• ([field], [field], [field]); Here substitute the field names you want to populate, remember that the order of these fields represent the order of columns in your CSV file.
• TERMINATED BY & ENCLOSED BY This is the general convention used by excel when you export as CSV, however if you know different you may need to change these

• Don’t Include Column Names In The CSV, This will always end as tears as I bet you don’t want the field names stored in your database, and they are often the wrong data type.
• Be Careful of Empty Rows, Its very easy to insert blank rows, either before your data or after your data when working in excel, its worth checking your CSV in notepad to ensure there are no empty rows, they will look like a line of comer’s and will nearly always cause the import to error.

Please leave any Comments or feedback, Thanks.

cd /usr/local/src
sudo wget http://prdownloads.sourceforge.net/sourceforge/nagios/nagios-3.2.2.tar.gz
sudo tar xvzf nagios-3.2.2.tar.gz
cd nagios-3.2.2
sudo ./configure --prefix=/usr/local/nagios --with-nagios-user=nagios --with-nagios-group=nagios --with-command-group=nagcmd --enable-nanosleep --enable-event-broker
sudo make all
sudo make install
sudo make install-init
sudo make install-commandmode
sudo make install-config
sudo update-rc.d -f nagios defaults
cd ..

ENHANCEMENTS

* Patch to new_mini_epn to allow any command line length without breaking on extra trailing or leading whitespace (Ray Bengen)
* Patch to mini_epn to allow any command line length (Thomas Guyot-Sionnest)
* Patch to speed up loading of state retention data (Matthieu Kermagoret)
* Custom notifications are now suppressed during scheduled downtime (Sven Nierlein)
* Added code to warn user about exit code of 126 meaning plugin is not executable (bug #153)
* Scheduled downtime can now start on SOFT error states (bug #47)
* Main window frame URL can now be specify with a “corewindow=” parameter
* Improved config CGI shows commands, command args in an easier to use manner (Jochen Bern)
* Added ability for NEB modules to override execution of event handlers (Sven Nierlein)
* Custom macros are no longer cleaned/stripped as they are user-defined and should be trusted (Peter Morch)

FIXES

* Fix for choosing next valid time on day of DST change when clocks go one hour backwards
* Fix for nagios now erroring when “Error: Could not find any contactgroup matching…” displayed
* Fix tap tests for Solaris 10 and newer versions of Test::Harness
* Fix for notifications not being sent out when scheduled downtime is cancelled (Daniel Pouzzner)
* Fix for first notification delay being calculated incorrectly, and notifications potentially going out early (Pawel Malachowski)
* Fix for text of scheduling downtime of all services on a host (Holger Weiss)
* Fix for services inheriting notification period from hosts if not defined (Gordon Messmer)
* Fix for incorrect service states on host failures (bug #130 Petya Kohts)
* Fix for incorrect service state attributes being set on host failures (bug #128 Petya Kohts)
* Fix for non-scheduled hosts and services not being updated in NDOUtils
* Fix for typos in TAC, CMD CGIs (bugs #150, #144, #148)
* Fix for types in documentation (bugs #145, #105, #106)
* Fix for incorrect host state counts in status CGI when viewing servicegroups (bug #72)
* Fix for new Splunk integration query parameters (bug #136)
* Fix for extra field header in availability CSV export (bug #113)
* Fix for macro processing code modifying input string (Jochen Bern)
* Fix for update check API
* Fix for CGI speedup when persistent=0 for comments
* Fix for event execution loop re-scheduling host checks instead of executing them if service checks are disabled (bug #152)
* Fix for segfaults on Solaris (Torsten Huebler)
* Fix for incorrect comment expiration times being passed to event broker (Mattieu Kermagot)
* Doc updates related to cleaning of custom macros (Peter Valdemar Morch)
* Fix to sample notify-service-by-email command (bug #62)
* Fix for retaining host display name and alias, as well as service display name (Folkert van Heusden)

To backup:

mysqldump -u [USERNAME] -p  [DATABASE] > backup.sql

[USERNAME]: Replace this with your MySQL Username
[DATABASE]: Replace this with the name of the database you wish to backup

mysql -u [USERNAME] -p [DATABASE] < backup.sql 

[USERNAME]: Replace this with your MySQL Username
[DATABASE]: Replace this with the name of the database you wish to backup

However if we store the passwords using the MD5 Hash Function then it’s impossible to see the password, however all we can do is encrypt the users password and see if it matched the stored MD5 Function, so how do we do this:

Well we enter these commands when adding new users, and checking to see if a user’s password is correct:

Insert new User

INSERT INTO `user` (`Username`, `Pass`) VALUES ('bob.jhonny', MD5('mypassword'));

SELECT * FROM `user` WHERE username='bob.jhonny' AND pass=MD5('mypassword');

If returns null then the user password is incorrect

Reset Password

UPDATE `dlp_contatcs`.`user` SET `Pass`=MD5('NewPassword') WHERE `Username`='bob.jhonny';

They are commonly used to fix corrupt data when downloading from newsgroups, however they can be used to make recovery files for pretty much any file. These recovery files are often much smaller than the original so they can easily be transmitted with the original file. However they normally only repair 5% of the original file, you can make parity files that repair more by scarifying the size of the parity file, so how do we do this:
Create Par2 File with 5% redundancy

par2 create -r5 test.mpg

Create Par2 File with 10% redundancy

par2 create -r10 test.mpg

Create Par2 File with 25% redundancy

par2 create -r25 test.mpg

par2 create -r5 test.mpg.part*.rar

Verify the original file with the Par2 File

par2 verify test.mpg.par2

If this fails then you will need to repair the file

To Repair the File

par2 repair test.mpg.par2

For more info goto the Par2 Man Page