Variables we will provide Email Address Incoming Mail Server Outgoing Mail Server Password You need to replace on the screens shown below with values we give you. This setup is for IMAP (where mail is retained on your web … Continued
Reverse Proxy to your lan – inc wordpress hack
1. Name server Create name server entry pointing to your wan address your.external-name.com A 1.2.3.4 2. Router Create a port forward (on a specific port if required to a specific port) WAN (1.2.3.4) -> forward http traffic to lan 192.168.0.12 … Continued
Securing your mail server POP3
SSL Configuration for your Email Account Get in touch to find out your mail server and mailbox username (essentially your email address). Use the screenshots below to help edit your email account settings: Screen 1) Screen 2) … Continued
Amazon EC2 – Snapshot Creation
#!/bin/bash export EC2_HOME=/opt/aws/apitools/ec2 export AWS_SECRET_KEY=**************** export AWS_ACCESS_KEY=***************** export JAVA_HOME=/usr/lib/jvm/jre /opt/aws/bin/ec2-create-snapshot vol-******* –description “Daily Data Snapshot” –region eu-west-1 /opt/aws/bin/ec2-create-snapshot vol-******* –description “Daily Root Snapshot” –region eu-west-1 —– ends file This might help someone looking to add a cron tab entry for … Continued
MySQL Triggers
If you have a table of GPS data ,that keeps getting written to, and starts to run to millions of records. It is a sensible idea to create a trigger under mysql to update a scratchpad summary table on an … Continued
MySQL Master Slave – Replication
If you need to run mysql replication, then we can help configue it for you, its a fantastic way of allowing you to run reporting against a large dataset, by running all your queries against the slave database, and this … Continued
Texting Solutions
If you’re looking for a text messaging / sms solution for your club or community, we are offering a full service, including allowing you to handle polls and contact your members. Join many other clubs in using a service, … Continued
Ritchie Hunter Website Live
Congrats to Ryan on completing the new ritchiehunter.com site, its a wordpress site that is using media queries to enable it to be viewed sensibly on various different display resolutions. Its using responsive design patterns and is built in … Continued
Using Sum and ABS statements in MySQL
MySQL / PHP Problem I need to sum the number of entries in a table where an id > 0 or an id = 23 Resolution Use a GROUP BY clause in conjunction with a SUM and an ABS SUM( … Continued
Setup PHP SSH2 Connection from php to remote box on pair networks
1. Download modules http://www.php.net/downloads.php Download Win32 binaries and extract php_ssh2.dll to the extensions directory Edit the php.ini file that is being used to include this extension extension=php_ssh2.dll Generate a pub / private key pair on the server you wish to … Continued