Installing wordpress using SSH

Most of my clients are on a WordPress platform. It is much easier to install new wordpresses through SSH, then through the traditional Cpanel/plesk and ftp. Here is how you install WordPress using SSH.

Step1: Login to your server via SSH. (I like using puTTY for this.)

Your will need your:
ip:
user:
pass:

Step2: Navigate to your current directory on the server

cd /var/www/vhosts/domain.com/httpdocs/

Step3: Download the latest version of wordpress to your server.

wget http://wordpress.org/latest.zip

Step4: Unzip the download

unzip wordpress-2.9.2.zip

Step5: Move contents from wordpress directory to current location on server.

cp -rf ./wordpress/* ./

Step6: Creating MySQL DB

-Login to MySQL

mysql -uusername -ppassword

-Create Database

create database dbname

-Grant user access to new db

grant usage on *.* to username@localhost identified by 'password'

-Set Privileges to this user on this db

grant all privileges on dbname.* to username@localhost

-Test conntection, change values below with the newly created info from above and user that was granted access.

mysql -uusername -ppassword dbname

Note: If all was successful with no errors, your db is installed.

Step7:  Your wordpress is ready for the final installation.  Go to your site with the new WordPress files are located and follow the steps.

Note: You can remove the zip file now as well.

rm wordpress-2.9.2.zip

Note: To remove an entire directory

rm -rf DirectoryName

That is it. Congrats on setting up your first WordPress through SSH.

Enable Soap with PHP5 On Media Temple (dv)

So here we go again with another Media Temple Update. I currently moved my development server to Media Temple (dv). Everything so far has been pretty smooth. I had a Magento Cart to set up and needed SOAP enabled. Low and behold, Soap was not enabled on the server.

Note: If you are uncertain if your server has SOAP enabled or not, create a phpinfo(); file. If you do not see Soap enabled, you will need to add it.

Step 1: Download PHP5 (I am using version 5.2.6, so replace to whatever version you have). List of previous PHP versions.

wget http://museum.php.net/php5/php-5.2.6.tar.gz

Step 2: Unpack the PHP file
tar -zxf php-5.2.6.tar.gz

Step 3: Configure PHP to enable SOAP.
cd php-5.2.6
./configure --enable-soap=shared

Step 4: Rebuild PHP (This takes some time).
make

Step 5: Now we just copy over the SOAP module to your existing PHP module directory.
cp modules/soap.so /usr/lib/php/modules/

Step 6: Add the new SOAP configuration to your existing configuration
echo "extension=soap.so" > /etc/php.d/soap.ini

Step 7: Restart Server
/etc/init.d/httpd restart

Step 8: Remove the PHP folder you just downloaded for this process.
rm -rf /home/php-5.2.6/

Check your PHPINFO file again. You should now see soap enabled.
Cheers!

Special Thanks to dotjay.co.uk for pointing this out.

Setting up Zend Optimizer on Media Temple (dv)

So I recently had an upgrade on a client server from Media Temple. They had a gs account and was upgraded to a dedicated server. Sounds great? Well the first thing I ran into was that their admin no longer worked since it used Zend Optimizer for some of the plugins. Media Temple (dv) uses ion cube. Oh shit…
So I decided to list my steps for getting zend optimizer on a dv sever in case anyone else needed it.

MediaTemple (gs) SQL Out of Memory?

So it appears MediaTemple has striked once again! I am so glad I am not hosted with them. I have been working on a client’s zencart, which is hosted on mediatemple (gs) server. Aside from all of the downtimes and really amazingly slow connections at other times, I have gotten a new error!

5 Out of memory (Needed 2091012 bytes)

I was a bit puzzled at first. I had not touched the site in a few days. The last time I had checked the site, everything was in working order. The error was on a sql statement. I couldnt figure this out. So I decided to ask google! (You got to love asking Google, they know everything). 

Anyways, I ran into this post, by mediatemple. It appears the sql server they are running has been moved to a limited container. No warning, just lets move this and maybe no one will notice. I had read this was to reduce abusive users, but I fail to see how running a out-of-the-box zencart consitutes as “abusive”.  Well a quick bandaid fix was to remove the banner calls on the tpl_main_page.php from the template folder. They are not using banners so it was a quick fix. It seems to find ways to reduce the sql calls being made at least allows the page to load.

Ah, I love AN Hosting.  I will sing their praises forever!