This shows you the differences between two versions of the page.
— |
lastfinger [2015/08/26 19:40] (current) dlicious Initial page |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ===== Copy files to server ===== | ||
+ | <code bash upload.sh> | ||
+ | rsync -avP bin *.sql.bz2 postfix www remote_host: | ||
+ | </code> | ||
+ | |||
+ | ===== Configure Apache ===== | ||
+ | |||
+ | * Write template to /etc/apache2/sites-available/lastfinger.com | ||
+ | * a2ensite lastfinger.com | ||
+ | |||
+ | ===== Configure MySQL ===== | ||
+ | |||
+ | * Run mysql_secure_installation | ||
+ | * Populate ~/.my.cnf with username/password | ||
+ | * Import backup dump | ||
+ | |||
+ | ===== Configure Postfix ===== | ||
+ | |||
+ | ===== Install mail handler script ===== | ||
+ | |||
+ | ===== TODO ===== | ||
+ | |||
+ | ==== Security updates ==== | ||
+ | |||
+ | * Sanitize all user inputs (from GET/POST data) | ||
+ | * Set up to use app-specific MySQL credentials | ||
+ | |||
+ | ==== Near-term features ==== | ||
+ | |||
+ | * Create and use UUIDs as message identifiers instead of MySQL row IDs | ||
+ | |||
+ | ==== Long-term features ==== | ||
+ | |||
+ | * Implement simple reply composer |