Contents
1. Introduction
1.1 To Dutch readers
1.2 Preparations
2. Acitvating the database
3. Preparations revisited
4. Downloading files
5. Uploading, unpacking, data directory
5.1 Uploading files
5.2 Unpacking files
5.3 Creating the data directory
6. Installing Website@School on XS4ALL
7. Concluding remarks
The Dutch ISP (Internet
Service Provider) XS4ALL offers
all Dutch schools low priced Internet access, server space and a database.
This appendix to the Website@School Users' Guide describes how to
handle a Website@School installation on an XS4ALL server. Their installation
procedure has, like those of many ISP's, its own anomalies and quirks.
This appendix might thus serve as just another installation example,
illustrating the problems one encouters at some ISP's.
NOTICE:
One of Website@School's features are proxy server friendly
URL's, as described in the Configuration Manager, paragraph 4. Site. This feature is
not functioning at XS4ALL and is automatically disabled during the
installation.
Although this
appendix is meant for Dutch readers, it is in English. Reason: there are many
IPS's that operate more or less like our XS4ALL, so other users might
benefit from this short guide.
Some specific XS4ALL Dutch terms are in Dutch followed by an English
translation.
When your school has an
XS4ALL account, it has received a letter from XS4ALL with information needed
during the installation.
NOTICE:
Also in this appendix we use the (fictional) Exemplum Primary School, with
the URL (Universal Resource Locator) http://exemplum.eu.
In the letter you find something like:
Server: Advanced Unix Website
Domein: http://exemplum.eu
Login name: exempps
Password: dwwinmG!
FTP host name: exempps.websites.xs4all.nl
The website is also accessbile via: http://exempps.websites.xs4all.nl.
|
This information is needed to activate the schools database at XS4ALL. For
this appendix we assume it's not activated. If it is activated, you can
skip the next paragraph and proceed to 3.
Preparations revisited.
(top)
It's very
well possible that the schools database at XS4ALL is not yet activated.
Porceed as follows to activate it:
- Open a browser and navigate to XS4ALL's Service Centre by going:
http://xs4all.nl > Service Centre >
Website & Colocation > Database maken (Create database).
- Please read the page and carefully choose a database name. In our
example we choose the name
www
. Use the supplied passwords or
enter new passwords that must be as secure as the old ones. This
results in:
Database naam: www
admin wachtwoord: eGPw=w$!
read-only wachtwoord: r0ly=nzB
|
- Click [Verder] (Continue) to proceed to the 'Database
activeren' (Activate database) dialogue. Carefully check the data you
entered earlier and write them down before clicking [Verder]
(Continue).
- You enter the 'Opgeslagen' (Saved) page. The database is
activated. Click the [OK] button.
In the next paragraph we will gather data that is required for the
Website@School installation.
(top)
Now that the
database is activated, we can obtain the necessary information to
successfully install Website@School. Proceed as follows.
- You return to the 'Website & Colocation' page. Select
'Overzicht website gegevens' (Overvieuw website data) to see
someting like:
-
Website
Website adres: |
www.exemplum.eu |
Website type: |
Advanced Unix [1] |
Virtual hosts: |
www.exemplum.eu, exempps.websites.xs4all.nl |
Schijfruimte: |
1000 MB totaal |
Dataverkeer: |
100 GB per maand |
FTP hostnaam: |
www.exemplum.eu |
FTP serverpoort: |
21 |
FTP loginnaam: |
exempps |
FTP remote directory: |
/htdocs |
SSH hostnaam: |
wh-shell1.xs4all.nl |
SSH loginnaam: |
exempps |
SSH remote directory: |
~/Webhosting/htdocs |
Standaard scripts: |
Ja |
Eigen scripts: |
Ja |
Database
Database type: |
mysql |
Database naam: |
exempps_www |
Database hostnaam: |
exempps.mysqlservers.xs4all.nl |
Database admin loginnaam: |
exempps_wwwa [2] |
Database read-only loginnaam: |
exempps_wwwr |
[1] Schools can choose between a Winodws or a Unix server. Only the
Unix server provides a MySQL database.
[2] The database login names are composed with the
username, an underscore, the datase name with an added 'a' or
'r' (respectively for admin and read ony access). Thus, in our
examples: exempps_wwwa
and exempps_wwwr
.
- The necessary data for the Website@School installation are:
SSH hostnaam: wh-shell1.xs4all.nl
SSH loginnaam: exempps
SSH remote directory: ~/Webhosting/htdocs
Database hostnaam: exempps.mysqlservers.xs4all.nl
Database admin loginnaam: exempps_wwwa
Database naam: exempps_www
Admin wachtwoord: eGPw=w$!
|
The Admin password was obtained when entering the the database name in
paragraph 2. Activating the database.
These data are required during the installation of the Website@School
program on the XS4ALL server. Please make notes of all data, for later
reference. Keep the data in a safe place!
(top)
NOTICE:
The download procedure for the Website@school program, manual and optional
language packs is described in the Installation chapter, paragraph 1.3.1 Downloads.
(top)
In
this paragraph we will use Linux and the CLI (Command Line Interface) with
SCP (Secure CoPy) to upload files and SSH (Secure SHell) to do our job on the
XS4ALL server.
Both programs are available for Windows as PuTTY, created by Simon
Tatham. PuTTY can be found on http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html.
We assume you either use the Linux command line or use PuTTY on Windows.
NOTICE:
In the examples below, The user ffrint
is logged in on the
server of the Exemplum Primary School (name: praeceptor) to upload files. He
uses his home directory, where he has created a download directory:
/home/userdata/home/users/ffrint/downloads
. In the examples
below the user imput is bolded.
To upload the files
to the right directory on the XS4ALL server, you can use an FTP (File
Transfer Protocol) program or SCP (Secure Copy Protocol).
The FTP procedure to upload files to an ISP's server is described in the
the Installation chapter, paragrapth 1.3.2
Installing on a server without root access.
[ffrint@praeceptor downloads]$ ls
websiteatschool-0.90.3.zip websiteatschool-manuals-en-0.71.zip
[ffrint@praeceptor downloads]$ scp websiteatschool-0.90.3.zip exempps@wh-shell1.xs4all.nl:~/Webhosting/htdocs
exempps@wh-shell1.xs4all.nl's password:dwwinmG!
The authenticity of host 'wh-shell1.xs4all.nl
(194.109.21.5)' can't be established.
DSA key fingerprint is
81:09:4a:72:ac:95:25:45:7b:49:c5:b0:91:e7:ae:f5.
Are you sure you want to continue connecting (yes/no)?
yes
Warning: Permanently added
'wh-shell1.xs4all.nl,194.109.21.5' (DSA) to the list
of known hosts.
websiteatschool-0.90.3.zip 100% 1797KB 85.6KB/s 00:21
[ffrint@praeceptor downloads]$
|
Copy the manual and optional language packs in the same way.
To log in on the
XS4ALL server, open a terminal or PuTTY, using the data below:
SSH hostnaam:wh-shell1.xs4all.nl
SSH loginnaam: exempps
Password: dwwinmG!
|
After a successfull login you are on the server:
exempps@wh-shell1:/WWW/e/exempps$
|
Proceed as follows:
exempps@wh-shell1:/WWW/e/exempps$ ls
cgi-bin htdocs
exempps@wh-shell1:/WWW/e/exempps$ cd htdocs
exempps@wh-shell1:/WWW/e/exempps/htdocs$ ls
401.html index-xs4all.html
403.html index.php
404.html websiteatschool-0.90.3.zip
forum websiteatschool-manuals-en-0.71.zip
exempps@wh-shell1:/WWW/e/exempps/htdocs$
|
The htdocs
directory is already occupied by the Exemplum
Forum. Thus we decide to make a directory for Website@School.
exempps@wh-shell1:/WWW/e/exempps/htdocs$ mkdir -p was
exempps@wh-shell1:/WWW/e/exempps/htdocs$ chmod 755 was
exempps@wh-shell1:/WWW/e/exempps/htdocs$ ls
total 24
... [skipped files]
drwxr-xr-x 3 exampps user 4096 Jun 26 09:39 was
-rw-r----- 1 exempps user 1838600 Jun 26 09:21
websiteatschool-0.90.3.zip
-rw-r----- 1 exemppps user 6397321 Jun 26 09:25 websiteatschool-manuals-en-0.71.zip
exempps@wh-shell1:/WWW/e/exempps/htdocs$ mv websiteatschool-0.90.3.zip websiteatschool-manuals-en-0.71.zip was
exempps@wh-shell1:/WWW/e/exempps/htdocs$ ls
401.html index-xs4all.html
403.html index.php
404.html was
forum
exempps@wh-shell1:/WWW/e/exempps/htdocs/$ cd was
exempps@wh-shell1:/WWW/e/exempps/htdocs/was$ ls
websiteatschool-0.90.3.zip websiteatschool-manuals-en-0.71.zip
exempps@wh-shell1:/WWW/e/exempps/htdocs/was$ unzip websiteatschool-0.90.3.zip
inflating: admin.php
inflating: config-example.php
inflating: cron.php
inflating: file.php
inflating: index.php
inflating: program/languages/en/admin.php
inflating: program/languages/en/was.php
inflating: program/languages/en/loginlib.php
inflating: program/languages/en/en_manifest.php
inflating: program/languages/es/es_manifest.php
Many files later...
inflating: program/install/tabledefs.php
inflating: program/install/index.php
inflating: program/install/tabledata.php
|
Also copy and unzip the manual and optional language packs and
proceed.
exempps@wh-shell1:/WWW/e/exempps/htdocs/was$ ls -l
total 1828
-rw-r--r-- 1 exempps user 2204 Feb 3 15:04 admin.php
-rw-r--r-- 1 exempps user 7821 Feb 3 15:04
config-example.php
-rw-r--r-- 1 exempps user 2198 Feb 3 15:04 cron.php
-rw-r--r-- 1 exempps user 2647 Feb 3 15:04 file.php
-rw-r--r-- 1 exempps user 2669 Feb 3 15:04 index.php
drwxr-xr-x 11 exempps user 4096 Jun 26 09:26 program
-rw-r----- 1 exempps user 1838600 Jun 26 09:21
websiteatschool-0.90.3.zip
-rw-r----- 1 exemppps user 6397321 Jun 26 09:25 websiteatschool-manuals-en-0.71.zip
exempps@wh-shell1:/WWW/a/exempps/htdocs/was$ exit
|
The files are unpacked. Please carefully check if file and directory
permissions are set as above.
The files and the directories are in place, ready for installaton.
For a
general discussion on the data directory, see the Installation chapter.
At XS4ALL it is possible to place the data directory outside the document
root directory. This improves security. Proceed as follows:
exempps@wh-shell1:/WWW/e/exempps$ ls
cgi-bin htdocs
exempps@wh-shell1:/WWW/e/exempps$ mkdir -p wasdata
exempps@wh-shell1:/WWW/e/exempps$ chmod 701 wasdata
exempps@wh-shell1:/WWW/e/exempps$ ls -l
total 16
drwx-----x 2 exampps user 4096 Nov 29 2005 cgi-bin
drwx-----x 4 exampps user 4096 Jun 28 15:16 htdocs
drwx-----x 4 exampps user 4096 Jun 28 09:30 wasdata
exempps@wh-shell1:/WWW/e/exempps$
|
we are ready on the server and can move on to the Website@School
installation at http://exemplum.eu/was/program/install.php.
exempps@wh-shell1:/WWW/e/exempps$ exit
|
In the next paragraph we will install the Website@School program.
(top)
The
installation on http://exemplum.eu/was/program/install.php is rather
straightforward.
Follow the installation as described in 2. The installation, until you are on step 2.4 Database. To stay
in our example, enter:
4. Database:
Type MySQL
Server exempps.mysqlservers.xs4all.nl
Gebruikersnaam exempps_wwwa
Wachtwoord ********
Databasenaam exempps_www
Voorvoegsel was_
|
NOTICE:
The 'Voorvoegsel' (Prefix) is only accessible when a
'Aangepast' (Custom) installation was chosen.
5. Website:
Naam Exemplum Primary School
From: e-mail-adres webmaster@exemplum.eu
Reply-To: e-mail-adres webmaster@exemplum.eu
Website-directory /usr/local/WWW/E/.5c1/e/exempps/htdocs/was
Website URL http://www.exemplum.eul/was
Programma-directory /usr/local/WWW/E/.5c1/e/exempps/htdocs/was/program
Programma-URL http://www.exemplum.eu/was/program
Datadirectory /usr/local/WWW/E/.5c1/e/exempps/wasdata
|
NOTICE:
The Reply-To: e-mail-adres, the Programma-directory and the Programma-URL are
only accessible when a 'Aangepast' (Custom) installation was
chosen.
Now please follow the Installation, paragraph
2. The installation.
(top)
None so far
(top)
Author: Dirk Schouten <schoiutdi (at) knoware (dot) nl
>
Last updated: 2011-06-30