Ubuntu Server WordPress with W3 Total Cache install

servers 225x300

Initial installation Ubuntu Server

Last time I configured my web server with Ubuntu Server, I had problems finding all the instructions on what and how to install everything needed to get a WordPress blog with W3 Total Cache, CDN, Apache2 MPM Worker and fcgi working. So this is my attempt to write down the steps needed to get the server going. You might find it of interest if your needs are similar to mine. Here’s the requirements for my WordPress blog.

  • Apache MPM Worker threaded version
  • APC PHP Opcode optimizer
  • All the required modules for W3 Total Cache
  • Graphics libraries for Mint statistics

[Read more…]

Hosting server at blueHost vs. self hosted

Bluehost

When setting up my old blog again that’s been down for about six months, I decided to host it, instead of having my linux machine here at home. So I started looking for hosting company. And what better place than to check out the WordPress page. I’ve tried a while with another hosting company, and that was a disaster, but it seemed BlueHost had a good reputation. With WordPress themselves recommending it, I signed up for a year. I did the normal optimizations to it, like installing W3 Total Cache, installed APC and got an Amazon Cloud account for pictures and other larger stuff. I did a lot of testing to get the maximum speed out of the server slot I had. The server was located in the US, But every time I did a check from the States, the initial byte took like 1 second. That doesn’t sound very long, but that’s waiting time before the page even start rendering. I tried everything, but couldn’t lower that. So back to hosting it myself.

[Read more…]

MAMP WordPress Error establishing a database connection

I’ve installed MAMP on my Mac to do some changes to my blog. I tried to set the WordPress wp-config.php file to connect to localhost:8889, but got an error that It could not connect to the database. After replacing localhost:8889 to 127.0.0.1:8889 it works. My quick guess is that permissions for the root user is set to allow connections 127.0.0.1, but not localhost. Anyway, it works now.

My wp-config.php file looks like this:

define('DB_NAME', 'wordpress');
/** MySQL database username */
define('DB_USER', 'root');
/** MySQL database password */
define('DB_PASSWORD', 'root');
/** MySQL hostname */
define('DB_HOST', '127.0.0.1:8889');