User:MichaelWestwind/wordpress testbed

site press set up by vagrant

packages installed

ii  wordpress      2.5.1-11       weblog manager
ii  apache2        2.2.9-10+lenny Apache HTTP Server metapackage
ii  apache2-mpm-pr 2.2.9-10+lenny Apache HTTP Server - traditional non-threade
ii  apache2-utils  2.2.9-10+lenny utility programs for webservers
ii  apache2.2-comm 2.2.9-10+lenny Apache HTTP Server common files
ii  php5           5.2.6.dfsg.1-1 server-side, HTML-embedded scripting languag
ii  php5-common    5.2.6.dfsg.1-1 Common files for packages built from the php
ii  php5-gd        5.2.6.dfsg.1-1 GD module for php5
ii  php5-mysql     5.2.6.dfsg.1-1 MySQL module for php5
ii  mysql-client-5 5.0.51a-24+len MySQL database client binaries
ii  mysql-common   5.0.51a-24+len MySQL database common files

• 6-13 added mysql-server

• on oahu:
  • mysqldump -uroot -p wordpress >dump.sql
  • tar cvf wp-backup.tar /usr/share/wordpress/wp-content/ dump.sql
  • gzip wp-backup.tar

• copy to press (took two steps because oahu is in dmz)
  • untar (found I made mistake when I tarred it and had to be in / to untar properly)

• replace all instances of oahu.freegeek.org with press.fglan (using vim)
• now I need to create a wordpress database with a user wordpress and a password
• sudo mysql -p
• create database wordpress;
• create user wordpress identified by xxxxxx;
• grant all on wordpress.* to wordpress;

sudo dpkg -i tinymce_3.2.6-1_all.deb 
sudo dpkg -i wordpress_2.8.4-2_all.deb
sudo apt-get install libjs-jquery
sudo apt-get -f install

The following extra packages will be installed:
  libjs-cropper libjs-jquery php-gettext
The following NEW packages will be installed:
  libjs-cropper libjs-jquery php-gettext

Setting up libjs-jquery (1.2.6-2) ...
Setting up php-gettext (1.0.7-6) ...
Setting up libjs-cropper (1.2.0-1) ...
Setting up wordpress (2.8.4-2) ...
Installing new version of config file /etc/wordpress/wp-config.php ...
Created commit 3a841ed: committing changes in /etc after apt run
 1 files changed, 6 insertions(+), 0 deletions(-)


created git repository in /usr/share/wordpress/fg
copied wp-content to wp-content
copied wp-config.php to /etc/wordpress/wp-config.php
copied .htaccess to /etc/wordpress/htaccess

database dump email to me by aaron
changed url of site in database dump to press.fglan

imported db 

mysql -u wordpress -p wordpress < /home/earthworm/aryn82_fgeek.sql 
set up a wordpress file in sites-available

<VirtualHost *:80>
        ServerAdmin earthworm@freegeek.org
        ServerName press.fglan
        DocumentRoot /usr/share/wordpress/
        <Directory />
                Options FollowSymLinks
                AllowOverride None
        </Directory>
        <Directory /usr/share/wordpress/>
                Options Indexes FollowSymLinks MultiViews
                AllowOverride All
                Order allow,deny
                allow from all
                DirectoryIndex index.php
        </Directory>
</VirtualHost>



put rewrite.load in mods-enables
change sites-enabled/000-default to point to sites-available/wordpress