Search Results

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.

Creating custom Spamassassin rules

example: body            Job_Scam_Rule  /craftmediadepartment|LOUWILLE ENGINEERING|ABLE TEXTILE DEPARTMENT/ describe        Job_Scam_Rule  “Spam is not allowed” score           Job_Scam_Rule  2000 2000 2000 2000 or header LOCAL_ED_SUBJECT      Subject =~ /\bED\b/ score LOCAL_ED_SUBJECT       40 needs to go in the users user_prefs file if allow_user_rules is enabled in local.cf. Otherwise can be done on a serverwide basis in /etc/mail/spamassassin/local.cf or similar manual: […]

openssl unable to write random state

openssl genrsa -out test.pem 1024 -rand $HOME/httpdocs/cert/.rnd Generating RSA private key, 1024 bit long modulus …………………….++++++ …………………..++++++ unable to write ‘random state’ e is 65537 (0x10001) Causing non-random keys to be generated This is because openssl tries to create a .rnd file in the users home directory by default to create the random file.  The […]

MySQL Replication over SSL

##Tutorial for MySQL Replication over SSL (one-way)## ##################################################### ##Check that SSL has been compiled in SSL on both the master and the client: SHOW VARIABLES LIKE ‘have_openssl'; or mysql –ssl –help If it says disabled or yes then its fine.  If it says no then an SSL enabled version of MySQL needs to be installed. […]

MySQL Dump database to Email

To backup a database and send it to email, add a cron job like: mysqldump -ce –user=user –password=pass dbname | gzip |uuencode dbbackup.gz| mail -s “xxxx Database Backup” me@mydomain.com

Horde Plesk enforce signature

To enforce a signature/footer on all users: Edit /usr/share/psa-horde/imp/config/trailer.txt

RedHat Enabled Passive FTP

// List the modules installed lsmod // Load the ip_conntrack_ftp module modprobe ip_conntrack_ftp Edit /etc/sysconfig/iptables-config to include: IPTABLES_MODULES=”ip_nat_ftp ip_conntrack_ftp”

Linux at command

A useful utility for scheduling one-off tasks. atq = view scheduled jobs at -c 7 = show command to be run in job number 7 atrm 7 = delete job number 7 at -m 08:50 2009-10-15 < updatejob = schedule a job to run the contents of updatejob or type: at -m 08:50 2009-10-15 then […]

Apache MySQL Authentication

mod_auth_mysql will need to be loaded. in vhost.conf add: AuthType Basic AuthName “Auth required” AuthMySQLHost localhost AuthMySQLUser auth_user AuthMySQLPassword mypassword AuthMySQLDB mysqlauth AuthMysqlUserTable clients AuthMySQLNameField username AuthMySQLPasswordField passwd AuthMySQLPwEncryption none AuthMySQLEnable on require valid-user Then in MySQL: create database mysqlauth; use mysqlauth; CREATE TABLE `clients` ( `username` varchar(25) NOT NULL default ”, `passwd` varchar(25) NOT […]

Apache server status

Add the following to httpd.conf for resource troubleshooting: ExtendedStatus On SetHandler server-status Order deny,allow Deny from all Allow from myipaddress