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 | ||