Installing Drupal on 8-Coral

DRAFT

Installing Drupal on 8-Coral Series

Introduction

This step-by-step guide shows how to install Drupal on The Uniform Server 8-Coral and how to resolve common issues such as PHP mail and cron.

Preparation - 1

Install The Uniform Server A) Create a new folder named drupal_b (Can be any name) Extract a new copy of The Uniform Server 8-Coral to this folder  --- Database user name root - No need to change this  --- Database password root - Before installing Drupal, change the MySQL password. Start The Uniform Server. Download Drupal B) Create a new folder drupal_a (Can be any name its only a temporary folder) Download Drupal 7.8 (or newer version) from here save to a convenient folder for example drupal_a Unzip the downloaded file (drupal-6.15.tar.gz) Windows cannot do this. Use something like 7-Zip Portable  --- Download site: PortableApps.com  --- File name: 7-Zip Portable - Multilingual file archiver and compressor B) Extract drupal-7.8.tar.gz to current path; creates a new folder drupal-7.8.tar. Open this folder C) C) Extract drupal-7.8.tar to current path; creates a new folder drupal-6.15 (D). Inside this is a second folder drupal-7.8 containing all the drupal files E). Copy files to The Uniform Server F) Copy folder drupal-7.8 (E) to server root folder www (G) H) Rename folder drupal-7.8 to drupal I) Navigate to folder UniServer\www\drupal\sites\default  --- Make a copy of file: default.settings.php  --- Rename this copy to: settings.php

Switch to production, start servers

UniServer’s default is to use the production PHP configuration file. However, you may have switched configuration files during development.

Before installing any applications, ensure that the production configuration is selected.

Check configuration file:

1. Start UniTray, in folder UniServer double click on Start.exe, which creates the tray icon.
2. Check configuration: Left click tray icon > Server Status – Top of page, php.ini displays either Production or development.
3. If Production displayed, no action required; you can start servers.
4. If development displayed, left click tray icon > Advanced > click php.ini to switch to Production.

Start Servers:

• Start The Uniform Server. Left click tray icon > click Start UniServer

Preparation - 2

Create Drupal database

Creating the Drupal database is straight forward. Note that tables are automatically inserted during installation.

Left click tray icon > click phpMyAdmin - This opens phpMyAdmin in your browser A) We want to create a new database. Name it drupal (or something easy to remember if you change name make sure you use this name during installation.) B) Click on Create to create the database

Note:

• You can start phpMyAdmin from Apanel. Start Apanel by typing http://localhost/apanel/ into your browser address bar.
• From Apanel click on the phpMyAdmin link. (left menu under tools)

Optionally configure PHP email

After you complete the final step in Install and set-up Drupal, see below. You will receive the following warning message:

warning: mail() [function.mail]: Failed to connect to mailserver at "localhost" port 25,
verify your "SMTP" and "smtp_port" setting in php.ini or use ini_set()
in Z:\www\drupal\includes\mail.inc on line 193.
Unable to send e-mail. Please contact the site admin, if the problem persists.

If you are only exploring and testing Drupal's functionality, you can safely ignore this; it's only a warning and not an error.

However, if you would like to send emails via your ISP, you have four options.

A) Edit php.ini

Open php.ini located in folder UniServer\usr\local\php

Locate this section:

[mail function]
; For Win32 only.
SMTP = localhost
smtp_port = 25

; For Win32 only.
sendmail_from = me@localhost.com

Replace: SMTP = localhost with your ISP's SMTP server; for details check out this page PHP mail function

Replace: sendmail_from = me@localhost.com with your real email address issued to you by your ISP.

Note: The above changes also need to be made to files:

• php.ini_delvelopment_nano (note spelling error)
• php.ini_production_nano

These files are selectable from UniTray and overwrite php.ini. This allows switching between production and development for testing.

B) Install Fake Sendmail for Windows

If your ISP requires authentication, install Fake Sendmail for Windows

C) 5.3-Nano+ Enable msmtp

If your ISP requires authentication, 5.3-Nano+ has msmtp installed (replacement for Fake Sendmail) see 5.3-Nano: msmtp for details.

D) Install a mailserver

One final option: If you want to run your own mail server and your ISP does not block the mail ports, check out this page Installing hMailServer

Install and set-up Drupal

The Drupal set-up is straight forward. I have shown what needs to be entered in the action column.

For a test server enter what's highlighted in bold, or enter your own specific data.

Drupal Step	Action
	Start UniTray, in folder UniServer double click on Start.exe tray icon created. Switch to production, Left click tray icon > Advanced > click php.ini switch to Production. Start Uniform Server. Left click tray icon > click Start UniServer
	Type the following into browser address bar http://localhost/drupal/ This opens Drupal's installation page (http://localhost/drupal/install.php?profile=default)
1. Choose language	Click Install Drupal in English
2. Verify requirements	Automatically Confirmed OK
3. Set up database	Database name: drupal Database user name: root Database password: root Click Save and continue Note: Use Advanced Options if you moved servers (new MySQL port) Database host: localhost Database port: 3307 (Note: 3307 is an example. Use UniTray to find MySQL port. Run Server Status) Table prefix: (leave blank)
4. Install site	Automatically Confirmed
5. Configure site	Site name: localhost Site e-mail address: me@localhost Username (admin): admin Use your own admin name E-mail address: Use your own email address Password (admin):MPG-root66 Use your own password Confirm password: MPG-root66 Use your own password Clean URL's radio button is Enabled; no need to change Update notification leave checked. Click Save and continue

I mentioned in Preparation-2 you will receive a mail warning. This can safely be ignored. If you implemented any of the above solutions a warning will not be issued.

To view your new site, click "your newsite" link (or type http://localhost/drupal/).

When you log into admin (click administer link) at the top of the admin page you will see

"Cron has not run. Please visit the status report for more information."

1. Click the status report link:
2. Navigate to "Cron maintenance tasks" to the right click "run cron manually"
3. After a short time you will receive a message "Cron ran successfully."

Cron

Cron is unavailable on Windows. It is a Unix process that periodically runs certain scripts. Although Drupal allows you to manually run cron.php this can can be inconvenient. The following section shows how to enable UniServer5.0-Nano's portable cron.

Enable portable Cron

Edit file: UniServer\unicon\main\run_cron.php

Uncomment this line as shown:

$dummy = file("http://localhost/drupal/cron.php");

Change the timer to suit application

sleep(15);  // Set required delay (seconds)

Top

Run portable Cron

Manually run cron from UniTray

• Start: Left click tray icon > Advanced > click Start Portable Cron
• Stop: Left click tray icon > Advanced > click Stop Portable Cron

Top

Automatically start and stop with servers

Edit file: UniServer\unicon\tray_menu\UniTray1.ini

Locate these lines under [Menu.Left] Menu section (for convenience lines have been split):

Type: item; Caption: "Start UniServer (Apache MySQL)";
 Action: shellexecute; FileName: "%PHP%\php.exe";
 Parameters: " -n %ServerConMain%\start_servers.php 7";ShowCmd: hidden; Glyph: 9

Type: item; Caption: "Stop  UniServer (Apache MySQL)";
 Action: shellexecute; FileName: "%PHP%\php.exe";
 Parameters: " -n %ServerConMain%\stop_servers.php 7";ShowCmd: hidden; Glyph: 11

• Replace start_servers.php 7 with start_servers.php 23
• Replace stop_servers.php 7 with start_servers.php 23

Note: Values are binary coded

 Note: Binary 1+2+4+16 = 23  
 1  - Run Apache server 
 2  - Run MySQL  server
 4  - Start Index page
 16 - Run cron

Related links:

Portable Cron

LCC portable cron program

Top

Portability

If you want a portable version of Drupal, 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.

Plugin (not yet ready for 8-Coral)

The above instructions are generic allowing you to install the latest version of Drupal.

If you prefer a click and go solution go to SourceForge

• Under Plugins
• Navigate to sub-folder Uniform Server 5-Nano Plugins
• Download file V55_Drupal_6_15.exe

Save this to folder UniServer, to install double click on file. Drupal is pre-configured and ready to go. Check out the read me file for latest information.

Note: This plugin is intended to quickly get Drupal up and running allowing you to explore the software. If you intend running a production server delete the folders installed and perform a manual install this allows you to tailor Drupal and include any missing modules.

MySQL Security

The above installation guide and associated downloadable plugin are intended to get the application up and running purely for testing.

If you are intending to put the application on line make sure to read any security advice provided with the application and check providers web site.

More impotently the above installation is an extreme security risk if put online as is. Its imperative you secure the MySQL server before putting your servers online.

Please read the following page MySQL Security and restrict privileges to any user that has connection access to your server.

Summary

Installing Drupal on The Uniform Server 8-Coral is easy to do.

Cron is required to periodically update Drupal's status. Version 8-Coral uses Portable Cron, which is part of the server set.

---