Author: dp | 06 May 2010 | View Comments
Categories: Servers
Yesterday, I managed to delete the primary database that we use at work. I won’t go in to how this happened, other than to say: Fuck you MySQL Workbench. I was trying to get a map of the table relations within the database. Needless to say, it didn’t work. After the immediate pants-wiping, I restored [...]
Author: dp | 14 April 2010 | View Comments
Categories: Servers
At work, we have Nginx sitting in front of Apache, to take some of the load off. We’ve also decided that we should use our bandwidth sparingly, and compress/minify Javascript/CSS. To do that, we’re using the built in Embedded Perl Module functionality inherent within Nginx. But because we have several different sites running on a [...]
Author: dp | 12 April 2010 | View Comments
Categories: Servers
This is a great read about working with udev, specifically, getting things working after you’ve written your rules, and they still don’t work. Remember that udev has a different $PATH than everything else, so qualify your paths to mount, etc. udev debugging toolbox « Web 0.2.
Author: dp | 26 January 2010 | View Comments
Categories: Servers
I admit, I borrowed this from How to fix strange characters in MySQL database – Vinh Pham. But I also added a few more that were missing; update <table> set <field> = replace(<field>, ‘’’, ‘\”); update <table> set <field> = replace(<field>, ‘…’, ‘…’); update <table> set <field> = replace(<field>, ‘–’, ‘-’); update <table> set <field> [...]
Author: dp | 11 January 2010 | View Comments
Categories: Projects, Servers
I’ve recently been posting my benchmark scripts to github. You can find them here: gms8994′s benchmark at master – GitHub. I’ve also started posting the results within the wiki, each page with the same name as the script. For example: comparing MySQL inserts with one set of values, or multiple sets of values.
Author: dp | 09 October 2009 | View Comments
Categories: Servers
external is the box that, for the past 1836 days, hosted everything dp.cx related. This included mail, web, ftp, ssh, ntp, bittorrent, dns, irc, silc, svn, git, mysql, postgresql, and many others. Not too bad for a Celeron 2.0GHz. This last uptime beat the old record: # Uptime | System Boot up —————————-+————————————————— -> 1 [...]
Author: dp | 09 October 2009 | View Comments
Categories: Servers
ssh-server.example.com $ ssh-keygen -l -f /etc/ssh/ssh_host_rsa_key.pub 1024 98:2e:d7:e0:de:9f:ac:67:28:c2:42:2d:37:16:58:4d ssh_host_rsa_key.pub via SSH Host Key Protection.
Author: dp | 29 July 2009 | View Comments
Categories: Servers
Recently, I had to lease a new server. My old one was ok, but it was 5 years old, and showing it’s age. The most recent bout of problems was due to postfix, and a specific domain that I host mail for. I had previously set up Policyd in an attempt to stop the influx [...]
