Creating SSL keys, CSRs, self-signed certificates, and .pem files.

Programming 14 July 2009 | Comments

SSL, that oh so incredibly confusing and distorted system for encryption between servers… oh how I loath thee. I’ve found myself setting up another server, and with that server comes a new set of SSL certificates for the various daemons – SMTP, IMAP, POP, Apache… You name it, I’ve probably had to set it up at one point or another. The hard part, though, is every time I have to do it again – I end up searching the internet, trying haphazardly everything I can get my hands on to do it right. Boy is it exhausting to not have anything succeed while you’re trying to get something done, so for me – and all of your enjoyment – I have documented my SSL-ventures herein.

Tagged in , , , , , , , , ,

Socialism Doesn’t Work, But We Need Something

Philanthropy 12 July 2009 | Comments

Just recently I was discussing with a good friend of mine, Tyler Lozano, about a variety of topics ranging from personal dissatisfaction with personal social lives to the greater dissatisfaction with what is defined as a normal life. About how he refuses to accept standards of life, like a house with a white-picket fence, and [...]

Tagged in , , , , ,

Homelessness

Philanthropy 22 June 2009 | Comments

For a photojournalism project, I (with the help of a fellow student) went against the suggestion of my teacher and did a project on homelessness in Orlando, Florida. She was concerned about the sensitivity of the topic, and was afraid of disturbing, offending, or being assaulted by, the homeless.
When we went, we were both rather [...]

Tagged in , , , , , , , , , , , ,

Listing Users with Database Access

Programming 24 May 2009 | Comments

As a part of my server migration, I’ve begun noting which databases to transfer, which I can trash, and who owns them. This is pretty eye-opening, as it lets me know which users I had forgotten to purge as they left my services.

SELECT User
FROM mysql.db
WHERE Db = ‘databasename’;

That will retrieve all [...]

Tagged in , , , , ,

The Smithy on the Hill

Personal 24 May 2009 | Comments

For the past year, I’ve been planning and implementing a final project for high school: the Senior Project. A project intended to take roughly twenty-plus hours to complete, and about sixty-plus hours to actually plan.
The project that I had chosen with the help of some friends while making snow-angels in the carpet was “Learning the [...]

Tagged in , , , , , , , , ,