Here are the steps of what you need to do in order to install and setup MySQL on a new server.

We’ll prepare a fresh CentOS 6 system (64 bit) for use as a database server. All you need is access to an SSH client and your server root credentials.

Off we go!

{ 0 comments }

We’re all excited about the new features in Automattic’s P2 Theme v1.4.0 – however many of us have setup custom tweaks around Post Categories. In the latest version these have been replaced with Post Formats.

Post Formats are great, but they are limited to values defined in the WordPress core. If you wanted to create a new post menu like “critical” or “alarm” this wouldn’t work. We could use Custom Post Types to add to those formats, however it’s way too big an operation for I wanted to achieve: which is bringing back the “posting into categories” feature we’ve come to love from the previous version.

In this article I’ll show you how to back-port categories so posts will appear as they did in P2 v1.3.3 while retaining all functions of the latest update.

[read full article…]

{ 4 comments }

Today P2 Version 1.4.0 has been released – hurra! Thanks for everyone’s hard work on this amazing theme.

P2 now boasts a couple of extra options and plenty of changes under the hood, but like many other great features those are not immediately obvious. Let me show you how the new changes work and how they can make your P2 experience even better.

Excellent – let’s have a look

{ 24 comments }

Sometimes you’re working on a system and you’re not entirely sure which Linux distribution it is. There are several ways to find out what you’re working with and I keep forgetting what they commands are to get there – so here’s a quick list for all of us.

Release and Distribution

Most systems (but not all) have a file called something-release in the /etc directory. On CentOS and Redhat this is /etc/redhat-release. Display the contents of that file and you’ll find out:

cat /etc/redhat-release

This is not going to work on an Ubuntu system for example where the file is called something different. The best approach hence is to call

cat /etc/*release

which will give you the output no matter which distribution you’re on. You may also try

lsb_release -a

however this does not work on all systems. When it does it will typically show you a more detailed output.

Linux Kernel

If you want to dig even deeper and find out which Kernel you’re using, or if you’re working on a 32/64 bit system, try issuing

uname -mrs

which will show you those. Try -a instead for a more detailed output.

Hubert is running CentOS 5.8 in 64bit. Looks like he needs an upgrade.

Hope this helps ;-)

{ 0 comments }

How to use vi to edit files in Linux

Here’s a brief reminder on how you can edit files with vi directly from the command line. Text is all you get, no other visual clues or menus are included, and best of all you need to know each keyboard shortcut once you’ve entered it. vi is an old editor going back all the way [...]

Read the full article →

How to use SFTP with Plesk 10.4.4

We had a discussion recently about using SFTP under Plesk 10. It’s possible, however the feature is not called SFTP explicitly so I thought it’s best to describe how it works here. Note that SFTP is only possible for the main domain owner, not for additional FTP Users that you may create under Web Users… [...]

Read the full article →

How to tweak P2: adding and replacing categories

Today I’m going to tweak the marvellous P2 Theme by Automattic. P2 is one of my all time favourite themes – not only because it transforms WordPress into something completely different, but also because it’s an innovative way we communicate internally here at WP Hosting. If you don’t know P2 yet, do check it out [...]

Read the full article →

Snapshot Backup 2.1

After over 20.000 downloads and one day before “the new iPad” hits the shelves, I give you an update on Snapshot Backup. I have finally found the time this week to work again on this project. It’s been too long, (8 months since my last update) but better late than never. It’s like a good [...]

Read the full article →

How to install CentOS on your laptop with Parallels Desktop

You can never have enough servers flying around, be that for testing, playing or developing. Today I decided that I wanted my local copy of CentOS on my Mac Book Pro – and thanks to Parallels Desktop I can run this in a virtual container alongside Mac OS X. Nice! It’s a bit complex so [...]

Read the full article →

How to remove Customer and Business Manager in Plesk

One of the questions that came up at Parallels Summit recently was how to uninstall Customer and Business manager. Plesk doesn’t offer a solution to uninstall things – even though you can add modules, once they’re installed they’re installed. Luckily I remember a good forum thread that’s a bit long so I’ll give you a [...]

Read the full article →

FIXED: The Problem with running PHP as FastCGI Application (WordPress and Plesk)

We’re currently on our way to Kissimmee, FL to join Parallels Summmit, an annual conference from the people who make Plesk. We’re also taking exams in Plesk 10.4.4 so we’re studying it in-depth – I’ve been using the software for over two years now but never had formal training in it. Well here goes! In [...]

Read the full article →

How to deploy HyperDB

Ever since I’ve started experimenting with HyperDB I thought that once I’ve got enough servers at my disposal, and if I ever figure out how to setup MySQL replication I’d bring the two together. I believe that day has finally come: HyperDB is now deployed across over 60 sites I’m taking care of. I want [...]

Read the full article →

Calling all Forum Beta Testers

Great News: I’ve been meaning to add a general WordPress forum to this site for a while, but none of the options seemed to work well for what I wanted to do. All I needed was a simple discussion forum, integrated into WordPress – I really didn’t want to mess around with phpBB or the [...]

Read the full article →

How to prevent direct file access in your wp-content directory

I was working on a secure site with sensitive video material that we needed strict members access to. Even though many plugins can make sure your direct permalinks can only be seen by logged in members, direct links to files in your wp-content directory are still accessible to others. They can even be hotlinked from [...]

Read the full article →