After setting the server time with the following command:

dpkg-reconfigure tzdata

The syslog service now needs restarted:

service syslog restart

Tail the mail.log to check the entries are stamped with the correct time:

tail -f /var/log/mail/log

If you are trying to packet capture on a remote server as a non root user carry out the following as root:

Add a capture group and add yourself to it:

groupadd pcap
usermod -a -G pcap nonrootuser

Next, change the group of tcpdump and set permissions:

chgrp pcap /usr/sbin/tcpdump
chmod 750 /usr/sbin/tcpdump

Finally, use setcap to give tcpdump the necessary permissions:

setcap cap_net_raw,cap_net_admin=eip /usr/sbin/tcpdump

Credit goes to askubuntu.com: http://askubuntu.com/questions/530920/tcpdump-permissions-problem

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