So you ran an upgrade, or got carried away tweaking things on your server, and now MySQL is acting like an island of its own. Your websites can’t connect, your phpmyadmin can’t connect, and you are miserable. You get errors like ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysqld.sock’ and, you … Read more
If you are running a Ubuntu server on a VPS, the latest upgrade may have brought dismay with warnings and errors and finally failure. Some of the sample output can look like: Processing triggers for man-db … locale: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.15′ not found (required by locale) locale: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.14′ not found (required by locale) … Read more
When I used a slideshow plugin on AamJanata, I got this error. WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘orderorder` INT(11) NOT NULL DEFAULT ‘0” at line 1] ALTER TABLE wp_gallery_slides CHANGE COLUMN order … Read more
W3 Total Cache is hands down the best speed solution I have ever found for WordPress. However, it can be a little intimidating to configure, and sometimes gets you stuck. Being a self-learned admin, I am more often the idiot, so I go back to what works and figure it out. Here’s my bombproof checklist … Read more
Uh… this could have been a tweet instead of a post. in your terminal, paste: apt-get install php5-tidy Answer “y” when asked. Done. Just to make this last longer… if this doesn’t do the trick, you aren’t logged in as root. try: sudo apt-get install php5-tidy Restart Apache service apache2 restart Now, really, I’m done. … Read more
I try and get all my installing done before I get into putting files on the server. So, if I wreck something and have to start over, I haven’t wasted a lot of upload and setting up time. This server I am describing runs Ubuntu Server and I am using it to run a few wordpress sites. … Read more
Oh, so you installed Varnish, what good will it do, if most of your content is not cached? I went for the “Preparing Varnish/Wordpress? for a Slashdotting in 60 seconds or less… ” code provided on the Varnish site. Its rather ruthless, but I’m not particularly attached to seeing the logged in version of my websites that … Read more
After Installing the default server and getting it trouble free and upgraded, its time to set things up as they are meant to be. And unless you have a very dynamic site, you should try Varnish Cache. Its far faster than others, because it sits on the front of the server and serves cache instantly … Read more
My intention is to whiz up the WordPress. The best of both worlds, so to say. WordPress is very cool, but needs some serious speed boost to lose that leisurely blog feel. So here’s how you do it. Please remember, this is code I use on Ubuntu. If that is not your server, you are … Read more
Your VPS offers you the possibility of a fresh installation, reinstall OS they call it. Do that. Use Ubuntu 10.10 Please note that I am no computer expert, I am telling you what worked for me. The default installation of Ubuntu doesn’t have locale set. You will get “locale failed” variety errors when you install … Read more