Articles in the system_administration category

  1. MySQL: Query caused different errors on master and slave

    Posted on in System Administration

    We ran across the following error on a MySQL slave server recent:

    mysql> SHOW SLAVE STATUS \G
    <snip>
    Last_Error: Query caused different errors on master and slave. Error on master: 'Deadlock found when trying to get lock; try restarting transaction' (1213), Error on slave: 'no error' (0). Default database: '<database_name …
  2. NTP and Your Xen-based Linux VM

    Posted on in System Administration

    As every system administrator is aware, keeping precise time on your servers can be critical. For example, if you use QueueMetrics for your Asterisk-based call center and the QM and MySQL servers are running with different times, users will notice confusing behavior as calls seem to arrive in the future …

  3. WordPress 3.0.1 Fixes Category Base Bug

    Posted on in System Administration

    Official WordPress LogoOn one of the WordPress-based websites I maintain, I have removed the category base so that, when browsing a category the url doesn't end with /category/category-slug/. I accomplished that by putting a single '.' in the "Category base" text box of the Permalinks admin page. This worked fine until I …

  4. WordPress Permalinks Not Working

    Posted on in System Administration

    Official WordPress LogoWhile setting up a new blog for an old site the other day, I ran into a situation where the main page would work, but individual posts would result in a 404 (page not found) error. Checking the error log revealed that Apache could not find the file it was …

  5. Configuring Syslog for Your Cisco Routers and Switches

    Posted on in System Administration

    Configuring your syslog server to accept logging output from your Cisco routers and switches requires a few basic steps. We'll assume that you are using a new server and haven't made any previous changes to the syslog configuration. I use <acronym title="Red Hat Enterprise Linux">RHEL</acronym> 5 most …

  6. tshark Fails: Interface is Not Up

    Posted on in System Administration

    This problem happened on a Mac Mini running OS X 10.4 (Tiger) not too long ago. The user was trying to run tshark against interface en2 — a USB <acronym title="Network Interface Card">NIC</acronym>. The tshark command produced the following output.

    # tshark -w /tmp/slap -i en2
    Capturing …
  7. Rate-limiting SSH connections with iptables

    Posted on in System Administration

    If you have SSH open toward the Internet, you are surely aware of the number of brute force password attempts your server sees everyday. Although a good password policy may make these attempts nothing more than an annoyance, each connection to your SSH daemon takes up valuable server resources. I …

Slaptijack's Koding Kraken