Installing WordPress on 8-Coral: Difference between revisions

From The Uniform Server Wiki
Jump to navigation Jump to search
(Created page with "<span id="top"></span> {| cellpadding="2" |__TOC__||'''Installing WordPress on 8-Coral''' |} This guide shows you how to install WordPress on The Uniform Server 8-Coral Series. ...")
 
(→‎Moving Servers: removed erroneous semicolon)
 
(4 intermediate revisions by the same user not shown)
Line 13: Line 13:
This creates a new folder named ''' wordpress''' that has all the application files.
This creates a new folder named ''' wordpress''' that has all the application files.


== Create the MySQL database ==
== Create the MySQL database and user ==


Before installing MediaWiki you must create a new MySQL database and user.
Before installing WordPress you should create a new MySQL user, which works best if you also create the associated database.


#From the control menu select: Server configuration > MySQL > Create delete Database
#From the Unicontroller, select: Server Configuration > MySQL > Create delete Database .
#Enter the database name to create; for example "wordpress" (without the quotes)
#Enter the database name to create; for example '''wordpress'''.
#Click the "Create Database" button. You can now close this menu.
#Click the "Create Database" button. You can now close this menu.
#From the Server Configuration, select: MySQL > Create Restricted MySQL User .
# Enter the user name (example: Wprdbu).
# Enter password (example: WpYusr359).
# Enter the database '''wordpress''' (as created above).
# Leave all permissions marked and click the "Create User" button. Close this menu.


== Installation ==
== Installation ==
Line 33: Line 38:
Fill in the fields as below:
Fill in the fields as below:
* '''''Database name:''''' '''wordpress''' (The name of the database you created.)
* '''''Database name:''''' '''wordpress''' (The name of the database you created.)
* '''''User name:''''' '''root'''
* '''''User name:''''' '''Wprdbu'''
* '''''Password:''''' '''root''', or the password you set for MySQL root account)
* '''''Password:''''' '''WpYusr359'''
* '''''Database host:''''' localhost (or 127.0.0.1 for Windows 7)
* '''''Database host:''''' '''localhost''' (or '''127.0.0.1''' for Windows 7)
* '''''Database table prefix:''''' wp_
* '''''Database table prefix:''''' wp_
Now click "Submit" for the next step.
Now click "Submit" for the next step.
Line 63: Line 68:
content to your USB memory stick. That’s it. Don’t expect fantastic speeds, however it is usable.
content to your USB memory stick. That’s it. Don’t expect fantastic speeds, however it is usable.


== Move Servers ==
== Moving Servers ==
One of The Uniform Server’s unique features is the capability to run more than one complete  
One of The Uniform Server’s unique features is the capability to easily run more than one complete  
server on the same PC. When running a server from a USB memory stick, you can use this to  
server system on the same PC. When running a server from a USB memory stick, you can use this advantage to prevent server collisions.  
great advantage and prevent server collisions.  
 
You will have noticed that Unicontroller's icon displays a one (meaning standard ports).  
You will have noticed that Unicontroller's icon displays a one (meaning standard ports).  
Moving The Uniform Server increments this digit for each server move. In reality it’s not  
Moving The Uniform Server increments this digit for each server move. In reality it’s not  
Line 74: Line 79:
This works just fine for the servers, but WordPress is unaware of the change and will fail to run properly. Note that the port numbers you use must match the ones for this particular server stack.  For the examples below, the servers have been moved to ports 83 (Apache) and 3309 (MySQL).  
This works just fine for the servers, but WordPress is unaware of the change and will fail to run properly. Note that the port numbers you use must match the ones for this particular server stack.  For the examples below, the servers have been moved to ports 83 (Apache) and 3309 (MySQL).  


You must make two different changes.
The '''''best''''' option is to install WordPress '''after''' moving The Uniform Server.
 
If you installed WordPress and then moved the servers, the following changes will get you operational again.  If the WordPress content is extensive, meaning you have many posts or changes, we suggest that you export the data and edit the file with a text editor to do the changes of step 2.  Then reload the database from the edited file.


1. Edit the wp-config.php file and change the DB_HOST entry to have the following:
1. Edit the wp-config.php file and change the DB_HOST entry to have the following:
<pre>
<pre>
define('DB_HOST', ';localhost:3309');
define('DB_HOST', 'localhost:3309');
  or
  or
define('DB_HOST', '127.0.0.1:3309');
define('DB_HOST', '127.0.0.1:3309');
</pre>
</pre>
2. Using phpMyAdmin, update the siteurl and home entries in the wp_options table as follows.
2. This is the tricky part. Using phpMyAdmin, update the siteurl, home, theme_mods_twentyeleven and dashboard_widget_options entries in the wp_options table and the guids in the wp_posts table as follows.
#Select the WordPress database for this installation.
#Select the WordPress database for this installation.
#Select the '''wp_options''' table for browse.
#Select the '''wp_options''' table for browse.
#Edit the entry for '''siteurl''' (normally the first location) and change "localhost" to "localhost:83"
#Edit the entry for '''siteurl''' and change "localhost" to "localhost:83"
#Edit the entry for '''home''' (normally about 30-40 entries down) and change "localhost" to "localhost:83"
#Edit the entry for '''home''' and change "localhost" to "localhost:83"
#Edit the entry for '''dashboard_widget_options''' and change "localhost" to "localhost:83" in ''three places''.
#Edit the entry for '''theme_mods_twentyeleven''' and change "localhost" to "localhost:83"
#Select the '''wp_posts''' table for browse.
#For each post entry, edit the '''guid''' and change "localhost" to "localhost:83"


Your WordPress should now work properly.
Your WordPress should now work properly.
Line 93: Line 104:
This installation guide is intended to get the application up and running purely for testing.   
This installation guide is intended to get the application up and running purely for testing.   
The configuration options should be reviewed if you are intending to put the application online.  
The configuration options should be reviewed if you are intending to put the application online.  
Be sure to read any security advice from MediaWiki and check their web site.
Be sure to read any security advice from WordPress and check their [http://wordpress.org web site]. You may also find their information on [http://codex.wordpress.org/Hardening_WordPress Hardening WordPress] very useful.


More importantly, the above installation is an extreme security risk if put online as is.   
More importantly, the above installation is an extreme security risk if put online as is.   
Line 100: Line 111:
for any user who has connection access to your server.
for any user who has connection access to your server.


Among other things, you should create a restricted MySQL user limited only to the WordPress database and substitute that user and password for "root" in the wp-config.php file.   
Among other things, be sure you created a restricted MySQL user limited only to the WordPress database.  If you used "root" to do the installation, be sure to substitute the restricted user and password for "root" in the wp-config.php file.   
----
----


[[Category: Applications]]
[[Category: Applications]]
[[Category: Installation]]
[[Category: Installation]]

Latest revision as of 13:15, 9 February 2012

Installing WordPress on 8-Coral

This guide shows you how to install WordPress on The Uniform Server 8-Coral Series.

Preparation

Download WordPress

  1. Download WordPress 3.3 (or newer version) from here to a known location.
  2. Extract this file to The Uniform Server's root folder *\UniServer\www.

This creates a new folder named wordpress that has all the application files.

Create the MySQL database and user

Before installing WordPress you should create a new MySQL user, which works best if you also create the associated database.

  1. From the Unicontroller, select: Server Configuration > MySQL > Create delete Database .
  2. Enter the database name to create; for example wordpress.
  3. Click the "Create Database" button. You can now close this menu.
  4. From the Server Configuration, select: MySQL > Create Restricted MySQL User .
  5. Enter the user name (example: Wprdbu).
  6. Enter password (example: WpYusr359).
  7. Enter the database wordpress (as created above).
  8. Leave all permissions marked and click the "Create User" button. Close this menu.

Installation

Type http://localhost/wordpress into your browser to start the installation sequence.

The first page shows that there isn't a wp-config.php file available, and we will proceed to Create a Configuration File.

The next page is the "gather your info" page. Continue by clicking "Let's go!"

Database connection page Fill in the fields as below:

  • Database name: wordpress (The name of the database you created.)
  • User name: Wprdbu
  • Password: WpYusr359
  • Database host: localhost (or 127.0.0.1 for Windows 7)
  • Database table prefix: wp_

Now click "Submit" for the next step.

This next page shows whether you have a valid connection to the database, and when you click "Run the install" it continues the rest of the process.

The Welcome page requires the following information:

  • Site title: WordPress on Coral -- (Choose whatever you like; you can change this later in WordPress)
  • Username: admin (or a more obscure and secure name)
  • Password: (Make this reasonably secure, but memorable)
  • Your e-mail: admin@localhost.org -- (Any email will do; you can change this later in WordPress)
  • Uncheck, "Allow my site to appear in search engines ..." -- (Not required for localhost)

Click on Install WordPress

You should see the Success! page.

When you click on Log in, it goes to the administration login page.

Put in the username and password you specified for the installation and click on Log In. If you remembered correctly, you should now see the WordPress Dashboard page.

Portability

If you want a portable version of WordPress, copy the folder UniServer and all its content to your USB memory stick. That’s it. Don’t expect fantastic speeds, however it is usable.

Moving Servers

One of The Uniform Server’s unique features is the capability to easily run more than one complete server system on the same PC. When running a server from a USB memory stick, you can use this advantage to prevent server collisions.

You will have noticed that Unicontroller's icon displays a one (meaning standard ports). Moving The Uniform Server increments this digit for each server move. In reality it’s not just a port change but a complete server update. Running server status displays the server characteristics.

This works just fine for the servers, but WordPress is unaware of the change and will fail to run properly. Note that the port numbers you use must match the ones for this particular server stack. For the examples below, the servers have been moved to ports 83 (Apache) and 3309 (MySQL).

The best option is to install WordPress after moving The Uniform Server.

If you installed WordPress and then moved the servers, the following changes will get you operational again. If the WordPress content is extensive, meaning you have many posts or changes, we suggest that you export the data and edit the file with a text editor to do the changes of step 2. Then reload the database from the edited file.

1. Edit the wp-config.php file and change the DB_HOST entry to have the following:

define('DB_HOST', 'localhost:3309');
 or
define('DB_HOST', '127.0.0.1:3309');

2. This is the tricky part. Using phpMyAdmin, update the siteurl, home, theme_mods_twentyeleven and dashboard_widget_options entries in the wp_options table and the guids in the wp_posts table as follows.

  1. Select the WordPress database for this installation.
  2. Select the wp_options table for browse.
  3. Edit the entry for siteurl and change "localhost" to "localhost:83"
  4. Edit the entry for home and change "localhost" to "localhost:83"
  5. Edit the entry for dashboard_widget_options and change "localhost" to "localhost:83" in three places.
  6. Edit the entry for theme_mods_twentyeleven and change "localhost" to "localhost:83"
  7. Select the wp_posts table for browse.
  8. For each post entry, edit the guid and change "localhost" to "localhost:83"

Your WordPress should now work properly.

Security

This installation guide is intended to get the application up and running purely for testing. The configuration options should be reviewed if you are intending to put the application online. Be sure to read any security advice from WordPress and check their web site. You may also find their information on Hardening WordPress very useful.

More importantly, the above installation is an extreme security risk if put online as is. It is imperative that you secure the MySQL server before putting your servers online. Please read MySQL Security and restrict the privileges for any user who has connection access to your server.

Among other things, be sure you created a restricted MySQL user limited only to the WordPress database. If you used "root" to do the installation, be sure to substitute the restricted user and password for "root" in the wp-config.php file.