Redmine Alert on New Admin or Public Project

Steve Stonebraker posted this in MYSQL, Scripts, Software, Windows on September 24th, 2010

Problem: How can I receive an email when the Redmine admin list changes or a project is changed to publicly viewable? You will need to run some mysql commands / queries in windows batch mode.

Solution:

Download blat and place in c:\windows\system32 Create directory c:\1admin and place these files in it:

These are the queries . . . → Read More: Redmine Alert on New Admin or Public Project

Leave a comment   MYSQL, Scripts, Software, Windows

HowTo: Harden Bitnami WampStack WordPress Install

Steve Stonebraker posted this in Security, Windows on July 7th, 2010

Hardening your Windows Bitnami WampStack WordPress Install: By default apache runs under an account with read/write to your entire machine, let’s fix that!

CREATING USERS 1. Create two new local users named apache and filezilla. 2. Add filezilla to the group administrators 3. Click Start -> Run 4. Type services.msc & hit enter 5. Find . . . → Read More: HowTo: Harden Bitnami WampStack WordPress Install

Leave a comment   Security, Windows

Howto: Fix WP Super Cache Manager Cache Directory Writable Error

Steve Stonebraker posted this in Windows on July 7th, 2010

Receiving an error like this?

WP Super Cache Manager Error: Your cache directory (C:\Program Files\BitNami WAMPStack\apps\wordpress\htdocs/wp-content/cache/) or C:\Program Files\BitNami WAMPStack\apps\wordpress\htdocs/wp-content need to be writable for this plugin to work. Double-check it. Cannot continue… fix previous problems

To Fix:

1. Click Start -> Run 2. Type services.msc & hit enter 3. Find the service running apache . . . → Read More: Howto: Fix WP Super Cache Manager Cache Directory Writable Error

Leave a comment   Windows

Howto: Backup your Bitnami Stack’s MySQL DB

Steve Stonebraker posted this in MYSQL, Scripts, Windows on June 26th, 2010

Below I will explain how to take nightly backups of your MySQL database Download and Install: MYSQL GUI Tools 7zip Windows Server 2003 Resource Kit Tools to obtain robocopy

After you install the tools bring up a command prompt and run these commands to copy robocopy to our working folder (1BACKUP_MYSQL):

cd \ cd .. . . . → Read More: Howto: Backup your Bitnami Stack’s MySQL DB

Leave a comment   MYSQL, Scripts, Windows

Howto: Fix a Slow Bitnami Redmine Stack

Steve Stonebraker posted this in MSSQL, Windows on June 25th, 2010

Problem: Redmine is running super slow. Version: Bitnami Redmine Stack on Windows The Fix 1. Run MySQL System Tray Monitor (accessible from either of these methods):

Start menu – MySql – MySQL System Tray Monitor “C:\Program Files\MySQL\MySQL Tools for 5.0\MySQLSystemTrayMonitor.exe”

2. Right click on system tray icon and from the popup menu select Actions -> . . . → Read More: Howto: Fix a Slow Bitnami Redmine Stack

Leave a comment   MSSQL, Windows