The Empirical Manifesto

Because I seem to buy, build, and lose/destroy/rebuild/re-purpose a stupid number of VPS, I need a placeholder for a quick and dirty checklist. Well, that and every single postfix HOWTO is seemingly either written by a mail engineer, or a 10 year-old. It took me far too long to get only the pieces I needed (have the sever send only, and send through gmail) filtered from all the other fancy-schmancy mail minutia and the not-really-working-after-all HOWTOs.

---

new_vps:~#

USER ACCCOUNTS

new_vps:~#useradd ehowton
new_vps:~#passwd ehowton
new_vps:~#visudo
%wheel ALL=(ALL) ALL

new_vps:~#vi /etc/ssh/sshd_config
PermitRootLogin no

new_vps:~#service sshd restart

O/S UPDATE

new_vps:~#zypper up

DATABASE

new_vps:~#zypper install mariadb
new_vps:~#service mysql start
new_vps:~#mysql -u root
mysql> UPDATE mysql.user SET Password = PASSWORD('newpwd')
-> WHERE User = 'root';
mysql> FLUSH PRIVILEGES;
quit

MAIL

new_vps:~#zypper install postfix
new_vps:~#zypper install ca-certificates
new_vps:~#vi /etc/postfix/main.cf
relayhost = [smtp.gmail.com]:587
smtp_sasl_auth_enable = yes
smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd
smtp_sasl_security_options = noanonymous
smtp_tls_CAfile = /etc/ssl/certs/Equifax_Secure_CA.pem
smtp_use_tls = yes

new_vps:~#vi /etc/postfix/saslpasswd
[smtp.gmail.com]:587 USERNAME@gmail.com:PASSWORD

new_vps:~#chmod 400 /etc/postfix/sasl_passwd
new_vps:~#postmap /etc/postfix/sasl_passwd

new_vps:~#service postfix restart

https://www.google.com/accounts/DisplayUnlockCaptcha

new_vps:~#echo "postfix test" | mail -s "postfix test" USERNAME@gmail.com

CHECK IN SPAM FOLDER

For a veritable laundry list of reasons, I'm migrating my documentation server at work from one VM farm to another, and in doing so, moving from Ubuntu 10.04 LTS (uptime 370 days) to openSUSE 13.1. Sadly, I'm also wading hip-deep into the bane of my professional preference, the database. Yes, I prefer flat files. Its a shortcoming of which I'm painfully aware.

How my mind works fascinates even me. I've often wondered if I'm just dumber than my co-workers (most probable given I work amongst geniuses), or if I have some elusive, yet-to-be-discovered gift (less likely given my age) which offsets the fact that I have to re-learn the same highly-technical things (As opposed to, say simple physics) over and over and over when I don't utilize them. There is one affably-hyper-super-smart coworker who can remember detailed, nuanced configurations he worked on once, years ago. I remind him often not all of us have the mind of an engineer. Then there is the architect who is visibly aghast when I don't recall building a specific server from the countless servers I've built over the many, many years I've been building servers. Personally I like to think its because I reserve that area of my brain for having things like, "a personality." That said, it takes a diverse group of skills and personalities to do what we, as a group, succeed at day in and day out. Nothing at all would ever get done if everyone was exactly like me.

So each time I have to delve into mysql (now MariahDB) its like a brand-new experience. Granted, that's a little tongue-in-cheek. I remember how to log in, and to create databases. But that's usually about it...until I start working with them again, then I seem to remember more commands. A little more is retained each time, and the learning curve less steep. Databases look like they'd be a lot of fun actually, were it not for the forlorn DBAs wearing pickled faces they keep in jars on the shelves of their respective homes each day.

Migrating smf (my documentation platform) is as easy as upgrading the application, upgrading the database, manually backing up the database, moving it and the application to an upgraded system, restoring the database, and changing all the absolute paths within the tablespaces. What could go wrong?