The script is attempting to insert or update a row with the integer entry taking on either the default value (e.g., of 0 or NULL) or the next AUTO_INCREMENT value.

MySQL is not interpreting this action as valid due to its SQL_MODE being in STRICT mode.

To fix:

/etc/mysql/mysql.conf.d/mysqld.cnf

Change
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

To:
sql_mode=””

Restart MYSQL.

*In my case I had so sql_mode entry so I just appended to the end of the file.

Credit – http://www.devside.net/wamp-server/mysql-error-incorrect-integer-value-for-column-name-at-row-1

For me it was as simple as enabling the CGI module for apache2:

a2enmod cgi
service apache2 reload

Simple steps to ensure Pure-FTPd works on an EC2 instance:

1. Enable passive mode

sudo echo "50000 50100" > /etc/pure-ftpd/conf/PassivePortRange

2. Allow access to Public IP

sudo echo "public_ip" > /etc/pure-ftpd/conf/ForcePassiveIP

3. AWS Security Groups

Allow ports 50000 – 50100 to be open to anywhere

4. Restart Pure FTPd

sudo /etc/init.d/pure-ftpd restart

5. Test FTP access

Simple bash script using the AWS Cli to backup EBS Volumes.

I used a free tier micro EC2 Amazon AMI to act as the backup generator.

AWS Interface

1. Create new policy with permission to create snapshots:

– Security, Identity & Compliance > IAM

– Policy > Create policy

– Create Your Own Policy

– Give a relevant name and insert the following into the Policy Document:

CloudFlare

1. SignUp for CloudFlare and follow the instruction to switch DNS to them

2. Within your CloudFlare account select Crypto

3. The first Option will be SSL

4. Select Flexible SSL

WordPress HTTPS Plugin

1. Search and install

2. Settings > Proxy: Yes

3. Save