Ruby on rails

sudo netstat -lp | grep 3000

This should give an output like this: Note: if you started your WEBrick server under a different port just change the 3000 in this command to the port you used.

This output tell you that PID (in my instance) that’s running the WEBrick server is 22673, this will be different for you server so please note down the PID (its the number before /ruby). Now we just need to kill this process to do this we use the following command (substitute [PID] for the PID you noted in the previous step):

sudo kill -9 [PID]

Now the WEBrick server will stop and you didn’t have to restart the machine.

• Adding a new domain controller that runs a version of Windows Server that is later then the current domain controller
• Before you upgrade your existing domain controller to a later version of Windows Server

What does adprep do:

• Updates the Active Directory schema
• Updates security descriptors
• Modifies the  access control lists (ACLs) on Active Directory objects and on files in the SYSVOL shared folder
• Creates new objects, as needed
• Creates new containers, as needed

You can find Adprep on your Windows Server 2008 CD in the \support\adprep\ or \sources\adprep, however if your like and you ordered you server with no CD‘s or if you have lost your CD‘s you made find it hard to get this tool, as far as I can tell there are no direct download links for the files (other then this page) and the alternative is to download the trail CD‘s and copy the file from there. This is exactly what I had to do however I would of much preferred to simply download the files so I’m adding a link to them on this page, both these files were extracted from the trial CD on the 3rd September 2012 so they should be up to date.

Downloads:

adprep.exe

adprep32.exe

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: