Difference between revisions of "User:MichaelWestwind/wordpress testbed"

From FreekiWiki
Jump to navigation Jump to search
 
(4 intermediate revisions by the same user not shown)
Line 15: Line 15:
  
 
*6-13 added mysql-server
 
*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;
 +
<pre>
 +
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
 +
 +
</pre>

Latest revision as of 14:40, 9 September 2009

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
Retrieved from "http://wiki.freegeek.org/index.php?title=User:MichaelWestwind/wordpress_testbed&oldid=42426"