Posts Tagged ‘Windows’

Disable Data Execution Prevention (DEP) in Windows 2003

In Windows, right click on My Computer -> Properties -> Advanced -> Startup and recovery -> Setting -> Edit and change /NoExecute=…  to  /NoExecute=AlwaysOff You will need to reboot for changes to take effect.

Plesk for Windows MySQL Access

Plesk uses two Mysql servers. One for clients databases (port 3306) and second server for Plesk databases (8306). You can connect to Plesk DB using the following command: %plesk_dir%\mysql\bin\mysql.exe -uadmin -pPlesk_admin_passwd -P8306 “C:\Program Files\Parallels\Plesk\Databases\MySQL\bin\mysql.exe” -uadmin -pPlesk-admin_passwd -P8306 Plesk-admin_passwd = “C:\Program Files\Parallels\Plesk\admin\bin\plesksrvclient.exe” -get However if you want to connect to Clients’ Mysql Server you should use […]

Convert SSL from pem to pfx

Convert an SSL certificate from Apache pem to IIS pfx format. Copy the private key and certificate parts, from the PEM to their own files. Then: openssl pkcs12 -export -out ssl.pfx -in ssl.crt -inkey ssl.key This gave me a .pfx file i could import into IIS. If it’s an EV SSL, you can add the […]

Plesk Admin Password

Linux: cat /etc/psa/.psa.shadow Windows: Open a command prompt and type: “C:\Program Files\Parallels\Plesk\admin\bin\plesksrvclient.exe” -get

MSSQL Express Scheduled Backups

The Express edition of SQL server lacks automated scheduled backup functionality.  The following script will back up your databases.  It retains them for 7 days but can be easily edited: Create a directory called c:\SQLBackup and go into it Create a backup.sql file: DECLARE @name VARCHAR(50) — database name DECLARE @path VARCHAR(256) — path for […]

Identifying Rogue Processes in IIS

Bring up a command prompt and execute: iisapp.vbs This gives you a mapping of process id to application pool.  Next bring up the task manager and identify the process that you are interested in.  If process ids are not currently shown, go to the view menu, select Choose Columns and tick PID. You should now […]

RDP keep console session

To get the console session by remote desktop on a server remotely to guarantee you get the same session every time: mstsc /v: 192.168.0.111:3390 /console Some RDP managers also have a console flag built in.

Exchange mailstore full

Why does every Exchange admin have to find out the hard way that there is a limit to the database size (16GB for 2000, 75GB for 2003 I think). The chances are that it isn’t actually full of data, just very very fragmented.  I’ve reduced a 75GB file to around 20GB.  To defrag it: Dismount […]

Apache case insensitive URL’s

If your moving a site from a Windows host to Linux and all of the cases are messed up (Yes Windows is case-insensitive ), you could try to substitute through all the code to make sure the links are the correct case. If your lucky though, enable mod_speling and this should work: # Add the […]

Plesk for Windows – PCI Compliance

This is somewhat of a work in progress. The only thing flagged by PCI compliance scans so far is the use of SSLv2. This can be disabled in Windows 2003 by adding the following registry entry in: HKey_Local_Machine\System\CurrentControlSet\Control\SecurityProviders \SCHANNEL\Protocols\SSL 2.0\Server create a new DWORD named Enabled with the default value Also disable weak ciphers: HKey_Local_Machine\System\CurrentControlSet\Control\SecurityProviders […]