Step-by-step Install Guide for Solaris 10 with Oracle 10

The VDAB (Public employment and vocational training service of the Dutch-speaking part of Belgium) is currently preparing an implementation of Moodle 1.9 on a large scale for its clients.

As a first step we have installed Moodle on a standard environment for VDAB being a Solaris 10 with Oracle 10g. Since this operation went succefully, problems encountered were solved, the VDAB offers the installation documentation to the Moodle community.

Contact person: Gerd Goetschalckx

<style> </style>

Installation Documentation<o:p></o:p>

for<o:p></o:p>

Moodle at VDAB<o:p></o:p>

1                Document information<o:p></o:p>

Document status:	Final 2008/07/23
Owning process:	VDAB
Created by:	Toby De Loght

<o:p> </o:p>

2                Purpose of this document<o:p></o:p>

This document provides an in-depth installation manual for Moodle on Solaris 10 with Oracle 10.2.0.2.<o:p></o:p>

We provide an overview of the different steps involved:

l  Preparing Oracle 10g for a large Moodle installation<o:p></o:p>

l  Configuring Apache 2.2 for a secure and high-performance webserver<o:p></o:p>

l  Preparing all necessary PHP packages for Apache and Oracle<o:p></o:p>

l  Preparing PHP settings for Moodle

l  An overview of the steps in the Moodle installation wizard.

3                Setting up the Oracle Database<o:p></o:p>

We set up 2 parallel Moodle installations on one and a database on a separate server. Both installations share the same Oracle database, but use a different tablespace.<o:p></o:p>

The Oracle 10.2.0.2 database runs on a Solaris 10 and is set up using Oracle's DBCA tool. <o:p></o:p>

l  This is testzone1 on the test server testitis00<o:p></o:p>

l  Database name = testitis02.vdab.be<o:p></o:p>

l  We used the General purpose template for the database set-up;<o:p></o:p>

l  And set UTF8 character encoding to NLS_LANG=AMERICAN_AMERICA.AL32UTF8

For each Moodle installation we create a separate Tablespace:<o:p></o:p>

l  First Moodle installation on testzone2:<o:p></o:p>

  MOODLE_DATA with initial size of 300MB

  User: MOODLEUSER, password: moodle

  The user only has rights within the specified tablespace

l  Second Moodle installation on testzone3:

  MOODLE_DATA2 with initial size of 300MB

  User: MOODLEUSER2, password: moodle

  The user only has rights within the specified tablespace

  

4                Configuring Apache<o:p></o:p>

4.1          Install Apache<o:p></o:p>

First download the latest Apache e.g. httpd-2.2.8.tar.gz from <a href="http://httpd.apache.org/download.cgi">http://httpd.apache.org/download.cgi</a> to the folder /usr/local/apache2

Log in as root, uncompress the Apache files and go to the installation folder.

# gzip -d httpd-2.2.8.tar.gz

# tar -xvf httpd-2.2.8.tar

# cd httpd-2.2.8

Adapt the Environment Variables to make sure the correct gcc and make are used.

# export PATH=$PATH:/usr/sfw/bin:/usr/ccs/bin:.

Configure and make Apache:

# make clean --> only if necessary

# ./configure \<o:p></o:p>

--prefix=/usr/local/apache2 \<o:p></o:p>

--with-included-apr

# make

# make install

In order to increase performance edit the following in the httpd.conf file:

# vi /usr/local/moodle_1.9+/moodle/httpd.conf -- > opens text editor

DirectoryIndex index.php<o:p></o:p>

Listen 8002 -- > for VDAB<o:p></o:p>

DocumentRoot “/usr/local/moodle_1.9+/moodle”<o:p></o:p>

AcceptPathInfo on<o:p></o:p>

 <o:p></o:p>

4.2          Install OCI 8 and Oracle Instant Client<o:p></o:p>

Download the 32bit Solaris Basic en SDK: instantclient-basic-solaris6432-10.2.0.3-20070101.zip and <o:p></o:p>

instantclient-sdk-solaris6432-10.2.0.3-20070101.zip from <o:p></o:p>

<a href="http://www.oracle.com/technology/tech/oci/instantclient/index.html">http://www.oracle.com/technology/tech/oci/instantclient/index.html</a> to a folder e.g. /oracle/product.<o:p></o:p>

 <o:p></o:p>

Log in as the user oracle and uncompress the installation files:<o:p></o:p>

$ cd /oracle/product<o:p></o:p>

$ unzip instantclient-basic-solaris6432-10.2.0.3-20070101.zip --> creates the directory instantclient_10_2<o:p></o:p>

$ unzip instantclient-sdk-solaris6432-10.2.0.3-20070101.zip --> is put into the directory instantclient_10_2<o:p></o:p>

 <o:p></o:p>

Adapt the tnsnames to set an alias or Oracle net service name. Each net service name entry contains connect descriptors that define listener and service information.<o:p></o:p>

$ cd $TNS_ADMIN --> for VDAB this is /var/opt/oracle)

$ vi tns_admin _--> Below an example adaptation:_<o:p></o:p>

moodle =<o:p></o:p>

       (DESCRIPTION =<o:p></o:p>

             (ADDRESS =<o:p></o:p>

                   (COMMUNITY = TCPDEV.world)<o:p></o:p>

                   (PROTOCOL = TCP)<o:p></o:p>

                   (HOST = testzone1)<o:p></o:p>

                   (PORT = 1521)<o:p></o:p>

             )<o:p></o:p>

             (CONNECT_DATA = <o:p></o:p>

                   (SID = testitis02)<o:p></o:p>

             )<o:p></o:p>

       )<o:p></o:p>

 <o:p></o:p>

If necessary, create and adapt a sqlnet.ora file. For VDAB this was not necessary.

 

Create two Symbolic Links.<o:p></o:p>

$ ln -s /oracle/product/instantclient_10_2/libclntsh.so.10.1<o:p></o:p>

/oracle/product/instantclient_10_2/libclntsh.so<o:p></o:p>

$ ln -s /oracle/product/instantclient_10_2/libocci.so.10.1<o:p></o:p>

/oracle/product/instantclient_10_2/libocci.so<o:p></o:p>

4.3          Install PHP<o:p></o:p>

To install PHP on the Apache server, download php-5.2.5.tar.gz from <a href="http://www.php.net/downloads">http://www.php.net/downloads</a> to the folder /usr/local/apache2<o:p></o:p>

Log in as root, uncompress the PHP files and go to the installation folder.<o:p></o:p>

# gzip -d php-5.2.5.tar.gz<o:p></o:p>

# tar -xvf php-5.2.5.tar<o:p></o:p>

# cd php-5.2.5<o:p></o:p>

Adapt the Environment Variables to make sure the correct gcc and make are used.<o:p></o:p>

# export PATH=$PATH:/usr/sfw/bin:/usr/ccs/bin<o:p></o:p>

# export LD_LIBRARY_PATH=/oracle/product/instantclient_10_2<o:p></o:p>

The following table provides a brief overview of the PHP extensions and what they are used for. All of these are required to do a fully functional Moodle installation.

 

<thead> </thead>

PHP Extensions	Description
GD Freetype 2	GD is commonly used to generate charts, graphics, thumbnails, etc. on the fly. <o:p></o:p> Freetype provides an API to manipulate fonts.  <o:p></o:p> Moodle uses these modules to generate dynamic graphs from the logs.<o:p></o:p>
OCI8	Required connector for Oracle
zlib (alternatively use zip or unzip)	Zlib is required for zip/unzip funcitonality based on the deflate compression method. Moodle itself can also handle this functionality, but this impacts the use of server resources.
curl	curl is a client to get files from servers. It is used for handling files using a wide variety of protocols. This is a requirement for Moodle 1.8 and later
openssl	Library to enable secured connections to a server. This is mainly used for connections between Moodle installations e.g. to share courses.<o:p></o:p>
php5-LDAP	Enables the use of LDAP functions in PHP
aspell-xx	The optional aspell modules provide a free spelling checker functionality embedded in Moodle. This module support a very large number of languages. XX represents the 2-letter code for the language.<o:p></o:p>

 <o:p></o:p>

For a default Solaris most of these modules are available by default. We only need to install curl and enable these modules in the Apache-Php configuration.

We first install curl. Download the package curl-7.18.1.tar.gz from <a href="http://curl.haxx.se/">http://curl.haxx.se</a> to /usr/local/apache2.

Log in as root, uncompress the curl files and go to the installation folder to make and install.

# gunzip curl-7.18.1.tar.gz

# tar -xvf curl-7.18.1.tar<o:p></o:p>

# cd curl-7.18.1<o:p></o:p>

# ./configure<o:p></o:p>

# make

# make install

In order to test the curl installation do

/usr/local/bin/curl -V<o:p></o:p>

If necessary, extend PATH to /usr/local/bin. This was not necessary for VDAB.

Next, we will configure, and install the PHP for Apache make links to the PHP extensions.

# cd /usr/local/apache2/php-5.2.5<o:p></o:p>

# ./configure \<o:p></o:p>

--with-apxs2=/usr/local/apache2/bin/apxs \<o:p></o:p>

--with-config-file-path=/usr/local/apache2/conf \<o:p></o:p>

--with-oci8=instantclient,/oracle/product/instantclient_10_2 \<o:p></o:p>

--enable-sigchild \

--enable-mbstring \

--with-gd \

--with-openssl \

--with-curl=/usr/local/apache2/curl-7.18.1

# make

# make install

 

4.4          Change PHP settings<o:p></o:p>

By default there is no php.ini file. However, there is a php.ini-recommended which we will use to make the required adaptations listed in the table below. Afterwards we will make a copy of this file and make it the active Php configuration file.

# vi /usr/local/apache2/conf/php.ini-recommended --> Open text editor and make adaptations<o:p></o:p>

# cp /usr/local/apache2/php-5.2.5/php.ini-recommended /usr/local/apache2/conf/php.ini<o:p></o:p>

In the file edit the following settings:

<thead> </thead>

Setting	Value we used in php.ini
Safe mode must be off<o:p></o:p>	; Safe mode<o:p></o:p> safe_mode = Off<o:p></o:p>
memory_limit is at least 128MB	; Resource Limits<o:p></o:p> memory_limit = 128M      ; Maximum amount of memory a script may consume<o:p></o:p>
session.save_handler needs to be set to FILES.	[Session]<o:p></o:p> ; Handler used to store/retrieve data.<o:p></o:p> session.save_handler = files<o:p></o:p>
magic_quotes_gpc needs to be ON<o:p></o:p> magic_quotes_runtime needs to be OFF<o:p></o:p>	; Magic quotes for incoming GET/POST/Cookie data.<o:p></o:p> magic_quotes_gpc = On<o:p></o:p> ; Magic quotes for runtime-generated data, e.g. data from SQL, from exec(), etc.<o:p></o:p> magic_quotes_runtime = Off
file_uploads needs to be ON<o:p></o:p>	; Whether to allow HTTP file uploads.<o:p></o:p> file_uploads = On
session.auto_start needs to be OFF	; Initialize session on request startup.<o:p></o:p> session.auto_start = 0
session.bug_compat_warn needs to be OFF	session.bug_compat_warn = 0
post_max_size is too small by default and needs to be increased e.g. when you run into problems while creating online content	; Maximum size of POST data that PHP will accept. post_max_size = 300M
upload_max_filesize needs to be increased e.g. to allow uploading larger course packages<o:p></o:p>	; Maximum allowed size for uploaded files.<o:p></o:p> upload_max_filesize = 300M
magic_quotes_sybase should be on for Oracle installations.<o:p></o:p>	magic_quotes_sybase = On

 

4.5          Add GNU Coreutils<o:p></o:p>

Also install the GNU Coreutils for Solaris in order to avoid Apache error described in case MDL-6850 . The Coreutils will include the du command which is required by Moodle to collect and calculate data on file sizes.

Download coreutils-6.4-sol10-sparc-local.gz from <a href="http://www.sunfreeware.com/solaris_2.5_list.html#coreutils">http://www.sunfreeware.com/solaris_2.5_list.html#coreutils</a> to your global zone as root .<o:p></o:p>

gunzip coreutils-6.4-sol10-sparc-local.gz<o:p></o:p>

pkgadd -d coreutils-6.4-sol10-sparc-local.gz<o:p></o:p>

Go to Administration > Configuration > Variables > Operating System and enter the path to entry pathtodu to the GNU du in /usr/local/bin/du (was /usr/bin/du) .<o:p></o:p>

Set the correct path in the Moodle administration interface. Go to Administration > Server > System Paths and fill out the correct path in the Path to du entry.<o:p></o:p>

5                Install Moodle<o:p></o:p>

5.1          Prepare the Moodle installation files<o:p></o:p>

Now that we have completed the set-up for Apache, PHP, Oracle and the connection between PHP and Oracle we prepare for the Moodle installation.

Log in as root and create a moodle user assigned to a group and set a password.<o:p></o:p>

# mkdir /export/home/moodle

# useradd -u 1005 -g 101 -d /export/home/moodle -s /bin/bash -c "Moodle" -m moodle

# chown moodle:users /export/home/moodle

# passwd moodle

Log in as root to create a directory for the Moodle installation:

# mkdir /usr/local/moodle_1.9+

# chown moodle:users /usr/local/moodle_1.9+

Download moodle-weekly-19.tgz from <a href="http://download.moodle.org/">http://download.moodle.org/</a>. Log in as the user moodle and copy the file to /usr/local/moodle_1.9+ and uncompress the file:<o:p></o:p>

$ gunzip moodle-weekly-19.tgz<o:p></o:p>

$ tar -vxf moodle-weekly-19.tar --> creates subdirectory 'moodle'

Now log onto the system where you will install Moodle e.g. testzone3 on server testitis03 as the user moodle.

Set the environment variables, preferable in the .profile of the  de user moodle: <o:p></o:p>

$ export ORACLE_HOME=/oracle/product/instantclient_10_2 <o:p></o:p>

$ export LD_LIBRARY_PATH=$ORACLE_HOME <o:p></o:p>

$ export TNS_ADMIN=/var/opt/oracle <o:p></o:p>

$ export PATH=$PATH:/usr/local/bin:/local/bin:. <o:p></o:p>

Start Apache with the configuration file adapted to moodle: <o:p></o:p>

$ /usr/local/apache2/bin/apachectl -k start -f /usr/local/moodle_1.9+/moodle/httpd.conf <o:p></o:p>

If desired you can install other languages during the installation wizard by downloading the appropriate language files e.g. Dutch (<a href="http://download.moodle.org/lang16/nl_utf8.zip">http://download.moodle.org/lang16/nl_utf8.zip</a>) to /usr/local/moodle_1.9+/moodledata/lang and uncompress the file.<o:p></o:p>

# unzip nl_utf8.zip <o:p></o:p>

A list of additional languages is available from the administration interface. Moodle then automatically downloads and installs the selected languages.<o:p></o:p>

5.2          Choose installation language<o:p></o:p>

Choose the installation language from the drop-down list. This choice only applies to the installation wizard.<o:p></o:p>

Click the next button to continue.<o:p></o:p>

<img border=0 width=391 height=238 id="_x0000_i1041" src="VDAB_Moodle_Installation_DOC_1.0_bestanden/image001.jpg">

5.3          Check PHP settings<o:p></o:p>

If you followed the above mentioned instructions for php, you should get the following screen.

In case of a Fail, recheck the PHP settings in php.ini.

<img border=0 width=381 height=335 id="_x0000_i1040" src="VDAB_Moodle_Installation_DOC_1.0_bestanden/image002.jpg">

5.4          Set installation and data directories<o:p></o:p>

In this step you define the basic locations of all Moodle-related files. Unless you chose a different location for the moodledata folder you do not need to change anything.

It is adviseable to keep the Moodle software and the data (courses, uploaded assignments etc.) separately;

In case of VDAB the web address is e.g. testzone2 or testzone3 and the data directory is /usr/local/moodle_1.9+/moodle

<img border=0 width=398 height=334 id="_x0000_i1039" src="VDAB_Moodle_Installation_DOC_1.0_bestanden/image003.jpg">

 

5.5          Set Database connection<o:p></o:p>

In this step we will set up the connection to the database:

l  Select Oracle from the drop-down list<o:p></o:p>

l  For an Oracle installation, leave the Host entry empty<o:p></o:p>

l  Provide the name of the Oracle database you created e.g. moodle

l  The database admin username and password<o:p></o:p>

l  Add a table prefix e.g. m_<o:p></o:p>

<img border=0 width=416 height=475 id="_x0000_i1038" src="VDAB_Moodle_Installation_DOC_1.0_bestanden/image004.jpg">

5.6          Server checks for installed components<o:p></o:p>

The installation wizard will now perform an availability check on the required System Components.<o:p></o:p>

If you checked all the required PHP settings and modules during the pre-installation phase, you should get the following screen.<o:p></o:p>

<img border=0 width=395 height=556 id="_x0000_i1037" src="VDAB_Moodle_Installation_DOC_1.0_bestanden/image005.jpg">

5.7          Install language packs<o:p></o:p>

Since we chose a Dutch installation, we now get an option to download the Dutch language files for the user interface. Provided you have direct write access to the Moodle server, the set-up of the language pack is automatic.

<img border=0 width=419 height=270 id="_x0000_i1036" src="VDAB_Moodle_Installation_DOC_1.0_bestanden/image006.jpg">
If the download is unsuccessful, you will get the error message below. To resolve this problem, you can either:<o:p></o:p>

l  Select other languages by using the Administrator interface when the installation is complete (Administration > Language > Language packs).<o:p></o:p>

l  Unzip the language file on the server in the lang files directory e.g. <path to Moodle directory>/moodledata/lang

<img border=0 width=420 height=385 id="_x0000_i1035" src="VDAB_Moodle_Installation_DOC_1.0_bestanden/image007.jpg">

5.8          Confirmation for written configuration file.<o:p></o:p>

All the settings we made in prior steps are now collected and written to the Moodle configuration file (config.php).

<img border=0 width=393 height=190 id="_x0000_i1034" src="VDAB_Moodle_Installation_DOC_1.0_bestanden/image008.jpg">
In this step, the basic Moodle configuration is complete. In the next steps, the setup will add the database tables and prepare Moodle for use.

5.9          Licence agreement<o:p></o:p>

Carefully read and accept the licence agreement before proceeding to the final installation steps.<o:p></o:p>

<img border=0 width=665 height=259 id="_x0000_i1033" src="VDAB_Moodle_Installation_DOC_1.0_bestanden/image009.jpg">

5.10      Release information<o:p></o:p>

This page provides the release information and the possibility to perform the following steps automatically (unattended). We will simply click next in order to capture potential setup errors.

<img border=0 width=665 height=139 id="_x0000_i1032" src="VDAB_Moodle_Installation_DOC_1.0_bestanden/image010.jpg">

<a name="DDE_LINK">Following steps can be performed automatically (unattended) or with manual confirmation.</a>

5.11      Automatic database setup<o:p></o:p>

What follows is a series of screens for the setup of the database tables for all of the standard Moodle components. Apart from clicking next, no user interaction is required.<o:p></o:p>

<img border=0 width=469 height=439 id="_x0000_i1031" src="VDAB_Moodle_Installation_DOC_1.0_bestanden/image011.jpg">
After each sequence a confirmation of success appears. <o:p></o:p>

<img border=0 width=599 height=402 id="_x0000_i1030" src="VDAB_Moodle_Installation_DOC_1.0_bestanden/image012.jpg">
This is the final step in the database set-up sequence.

<img border=0 width=534 height=250 id="_x0000_i1029" src="VDAB_Moodle_Installation_DOC_1.0_bestanden/image013.jpg">

5.12      Setting up the administrator account<o:p></o:p>

Now that the system is ready, we only need to provide details for an initial administrator account.

These data can be changed and/or complemented later. This is the account that will initially be used after installation to allow further configuration of the system.

<img border=0 width=665 height=452 id="_x0000_i1028" src="VDAB_Moodle_Installation_DOC_1.0_bestanden/image014.jpg">

5.13      Set up Frontpage<o:p></o:p>

During this final step of the installation wizard, we will put:

l  The Full site name e.g. the name of the institution. This will be visible in the title bar in all of the standard templates.

l  As Short name for the site.<o:p></o:p>

l  A Front page description of the site. This will be displayed as a welcome message on the start page.

 

<img border=0 width=665 height=375 id="_x0000_i1027" src="VDAB_Moodle_Installation_DOC_1.0_bestanden/image015.jpg">

5.14      Start with empty Moodle<o:p></o:p>

We are then automatically redirected to the Moodle start page. Our Moodle is up and running and we can now continue with the configuration of the system.

<img border=0 width=665 height=295 id="_x0000_i1026" src="VDAB_Moodle_Installation_DOC_1.0_bestanden/image016.jpg">

When we click Turn editing on we can start the configuration. We will need to verify the system location of some additional components. The installation procedure does not check for the availability of a zip program. Moodle especially needs zip and unzip when handling SCORM packages. Using the built-in unzip feature may impact server performance.

<img border=0 width=665 height=431 id="_x0000_i1025" src="VDAB_Moodle_Installation_DOC_1.0_bestanden/image017.jpg">