• Home
• dp
• dp’s Social Graph
• RSS

Archive for the 'Servers' Category

Databases and backups

Yazan: dp | 06 May 2010 | No 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 [...]

Using Nginx’s Embedded Perl Module

Yazan: dp | 14 April 2010 | 1 Comment
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 [...]

udev debugging toolbox « Web 0.2

Yazan: dp | 12 April 2010 | 1 Comment
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.

How to fix strange characters in MySQL database – Vinh Pham

Yazan: dp | 26 January 2010 | 4 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>, ‘…’, ‘&hellip;’); update <table> set <field> = replace(<field>, ‘–’, ‘-’); update <table> set <field> [...]

gms8994′s benchmark at master – GitHub

Yazan: dp | 11 January 2010 | No 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.

The end of external

Yazan: dp | 09 October 2009 | 1 Comment
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 [...]

Get the SSH server fingerprint

Yazan: dp | 09 October 2009 | No 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.

Postfix + fail2ban = win

Yazan: dp | 29 July 2009 | 5 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 [...]