Killing a hanged Windows service

A hanged service looks like this (as you can see, all Start/Stop/Pause/Resume buttons are disabled):

To kill this service, first note the service name. On the screenshot above, it is ‘EntropySoftCFS’ (ie: the first thing displayed in the “General” tab).

Then, open a DOS shell and run the ‘sc queryex’ command to retrieve the service PID, then use the ‘taskkill’ command to… well, kill it !

C:\>sc queryex EntropySoftCFS

SERVICE_NAME: EntropySoftCFS
TYPE               : 10  WIN32_OWN_PROCESS
STATE              : 2  START_PENDING
(NOT_STOPPABLE, NOT_PAUSABLE, IGNORES_SHUTDOWN))

WIN32_EXIT_CODE    : 0  (0x0)
SERVICE_EXIT_CODE  : 0  (0x0)
CHECKPOINT         : 0x1
WAIT_HINT          : 0xbb8
PID                : 3756
FLAGS              :

C:\>taskkill /PID 3756 /F
SUCCESS: The process with PID 3756 has been terminated.

Laurent KUBASKI

Advertisements

Solving the mySQL “The security settings could not be applied” error

Yesterday I got this error message during the last step of the MySQL Windows installer: “The security settings could not be applied to the database because the connection has failed with the following error”.

The issue can be solved issue this procedure from the MySQL website.

First, cancel the wizard and make sure that the MySQL service is stopped.

Then, create a text file using a SQL query that will reset the root password.

UPDATE mysql.user SET Password=PASSWORD('admin') WHERE User='root';
FLUSH PRIVILEGES;

Then, launch mySQL using the following command line:

mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server 5.5\my.ini" --init-file="C:\mysql-init.txt" --console

Note: it’s better to use the ”–console” option so that error messages are correctly displayed.

Finally, open a new DOS shell and execute the following command line to shutdown mySQL:

mysqladmin -u root -p shutdown

You can now restart the mySQL installer and choose the “Repair” option:

 

Laurent KUBASKI

Retrieve mail location in Outlook 2010

OK, I spent 30 minutes looking for this: you use the Outlook 2010 search to find a mail and now you would like to know in which folder this mail is located… how do you do this ?

I tried googling for “retrieve mail location”, “retrieve mail parent folder” but couldn’t find any relevant answer.

The solution is rather easy: you just need to add the “in folder” column to the search result. To do this, right click on the search columns header and choose the “view settings” option:

Then, click on the “Columns…” button:

Then, add the “In Folder” column to the columns to display (it is part of the “All Mail fields” category”):

There you go:

Laurent KUBASKI