2. The installation
2.1 Language
2.2 Installation type
2.3 License
2.4 Database
2.5 Website
2.6 User account
2.7 Compatibility
2.8 Confirmation
2.8.1
Crossroads
2.9 Finish
2.10 Download configuration
file
2.11 E-mail alerts
3. Tips for a secure installation
3.1 Program files and configuration
file
3.2 Data files
3.2.1 Outside the
document root
3.2.2 Inside the
document root
4. After the installation
4.1 Virus scanning
4.2 Session name
4.3 Proxy friendly URLs
5. Errors
5.1 Canceled installation
5.2 Unable to write in data
directory
5.3 Config.php write
problems
We did our utmost to describe every detail of the installation. Please read this chapter. Comments and additions are welcome.
Confirmation or error messages will be displayed in this yellow bar. If necessary these messages can be copied and past in e-mail or forum posts for support.
root@exemplum root]# mysql -h localhost -u root -p Enter password:An example of a text block with user input in bold text.
background-color: #B6B6B6;
to... etc: A snippet code in a text.An easy way to install Website@School on a PC is XAMPP, described in Appendices XAMPP installation
You need some computer skills to install Website@School:
When you are uncertain about your skills, it's better to ask help at a local Linux group. They are virtually everywhere and are willing to perform a small service for the school and (possibly) your kids. See http://en.wikipedia.org/wiki/Linux_User_Group
Before you can begin with the actual installation of
Website@School, a few things have to be taken care of.
Depending on whether you have root (administrator) access to the
server or your server is located at an ISP (Internet Service
Provider), you have to follow different routes.
Start with creating some place to download files if it not already exists.
When on a server with root access, proceed to the next paragraph. When the server where Website@School is to be installed is located at an ISP (Internet Service Provider), proceed with paragraph 1.3.3 Installing on a server without root acces
[root@exemplum htdocs]# unzip /tmp/websiteatschool-<version>.zip
When using .tar file, unpack with:
[root@exemplum htdocs]# tar xzvf /tmp/websiteatschool-<version>.tar.gz
NOTE: The file is unpacked in the current directory.
-rw-r--r-- 1 root root 2210 Feb 1 14:00 admin.php -rw-r--r-- 1 root root 7827 Feb 1 14:00 config-example.php -rw-r--r-- 1 root root 2204 Feb 1 14:00 cron.php -rw-r--r-- 1 root root 2653 Feb 1 14:00 file.php -rw-r--r-- 1 root root 2675 Feb 1 14:00 index.php drwxr-xr-x 1 root root 824 Feb 2 10:11 program
We refer to this directory as the CMS Root Folder. In this case, the CMS Root Folder is the same as the web server Document Root.
NOTE: Even though it is strongly recommended to install Website@School in the web server Document Root, it is perfectly possible to install the program in a subdirectory of the web server Document Root. In that case the web server Document Root and the CMS Root Folder are not the same, hence the special name.
The program directory contains the program files and directories. The manual and optional language packs were uncompressed there.
drwx------ 2 www www 48 Feb 2 10:49 wasdata
When you are familiar with the Linux command line, you know how to create a database. If not, try this example which we adapted from our ServerAtSchool documentation at http://http://serveratschool.net/doc/install/configuring.html#h7.
Below the login procedure is shown. What you enter is emphasized. The password you enter is not visible:
[root@exemplum root]# mysql -h localhost -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 121 to server version: 4.0.23a Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql>
You are logged in now and ready to create a new database, with appropriate permissions and a new user, especially for the website database that will be accessed via the Webite@School content management system (CMS). Again, the commands to type are shown emphasized in the illustration below. The password 'ohF9quei' is used as an example. You should use a password of your own choice.
mysql> create database www; Query OK, 1 row affected (0.00 sec) mysql> grant all on www.* to wasuser@localhost identified by 'ohF9quei'; Query OK, 0 rows affected (0.02 sec) myssql> _
At this point you have created a new database named www and a user named wasuser who has been given full access to this database (but only from the host 'localhost'), provided the user produces the correct password, 'ohF9quei'.
The MySQL database is now ready for use. You can close the connection to the database and end the mysql program:
mysql> exit Bye [root@exemplum root]# _
Examples of database names: www or example_www.
NOTE: After finishing the installation and uploading the config.php file, change its permissions to read for owner and group. Do not forget this! Paragraph 3. Tips for a secure installation discusses this important subject.
You are now almost ready to install Website@School. Please first read paragraph 1.4 On secure passwords, before proceeding to 2. The installation.
We assume you have downloaded the files in the downloads directory as described in paragraph 1.3.1 Downloads, i.e. the downloads directory is in the users home directory.
[wblade@exemplum was]$ unzip ../downloads/websiteatschool-<version>.zip
And to untar:
[wblade@exemplum was]$ tar xvzf ../downloads/websiteatschool-<version>.tar.gz
NOTE: The file is unpacked in the current directory.
[wblade@exemplum was]$ ls -l total 25 -rw-r--r-- 1 wblade wblade 2204 Feb 3 15:04 admin.php -rw-r--r-- 1 wblade wblade 7821 Feb 3 15:04 config-example.php -rw-r--r-- 1 wblade wblade 2198 Feb 3 15:04 cron.php -rw-r--r-- 1 wblade wblade 2647 Feb 3 15:04 file.php -rw-r--r-- 1 wblade wblade 2669 Feb 3 15:04 index.php drwxr-xr-x 11 wblade wblade 824 Feb 9 01:46 program [wblade@exemplum was]$_
The program directory contains the program files and directories. The manual and optional language packs were unpacked there.
NOTE: Depending on the ISP the name of the Document Root, i.e. the directory to put the Website@School program files and directory in, differs from ISP to ISP.
NOTE 1:
Create the Data Directory, if possible, outside the
Document Root and outside the CMS Root Folder.
NOTE 2:
If it is not possible to follow the NOTE 1 above, the Data
Directory must be created in the Document Root.
Give this Data Directory a difficult to guess name,'for
example b27b7d81c9ea26q4885734564qda2e12. Do not use
this example, but create a difficult to guess directory
name.
NOTE
Necessary permissions are: read, write and execute for owner,
group and perhaps world, too. Once installation is complete,
all write permissions of the Data Directory can be revoked
again.
NOTE: After finishing the installation and uploading the config.php file, change its permissions to read for owner and group. Do not forget this! Paragrapfh 3. Tips for a secure installation discusses this important subject.
To create a database, you can use a program like phpMyAdmin. phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. It can be downloaded at http://www.phpMyAdmin.net.
NOTE: Using a web based program like phpMyAdmin is a security risk. Do not forget to (re)move phpMyAdmin to a place where the web server has no accces to.
You are now almost ready to install Website@School. Please first read the next paragraph 1.4 On secure passwords, before proceeding to 2. The installation.
Please bear this in mind when entering passwords during the installation. Nuff said, time to start!
The installation starts with the selection of the language in the dropdown menu. Please select a language and click [Next] to continue or [Cancel] to abort the installation.
To be able to install the program, you have to accept the license agreement by typing 'I agree' (without quotes) in the field. In languages other than English, the exact wording can be found at the bottom of the license agreement.
Click [Next] to continue, [Previous] to return to the previous dialogue or [Cancel] to abort the installation.
NOTE: This option is not available in the Standard installation, but only applies to the Custom installation.
All table names in the database start with this prefix. This allows for multiple installations in the same database. Note that the prefix must begin with a letter. Examples: was_ or cms2_.
Click [Next] to continue, [Previous] to return to the previous dialogue or [Cancel] to abort the installation.
NOTE: This option is not available in the Standard installation, but only applies to the Custom installation.
This e-mail address is added to outgoing mail and can be used to specify a mailbox where replies are actually read (by you) and not discarded (by the web server software).
NOTE: This option is not available in the Standard installation, but only applies to the Custom installation.
The path to the CMS Program Folder. As default setting the path is not the same as the CMS Root Folder (usually the CMS Root Folder followed by /program). Examples /home/httpd/htdocs/program or C:\Program Files\Apache Group\Apache\htdocs\program
NOTE: Do not change this path, unless you know exactly what you are doing!
NOTE: The folder name program should not be changed.
NOTE: This option is not available in the Standard installation, but only applies to the Custom installation.
This is the URL that leads to the program directory (usually the website URL followed by /program). Examples are: http://www.exemplum.eu/program or https://exemplum.eu:443/schoolsite/program.
It is very important that this directory is located outside the web servers Document Root [1], i.e. is not directly accessible with a browser. Note that the web server must have sufficient permissions to read, create and write files here. Examples the the CMS Data Folder are: /home/httpd/wasdata or C:\Program Files\Apache Group\Apache\wasdata.
[1] With many ISPs (Internet Service Providers) you have no access outside the Document Root.
NOTE: We strongly advise you to check this option. The demo data are excellent for trying the modules and the numerous management possibilities of Website@School. The demo data can be made invisible and erased later on if necessary.
NOTE: When not installing demodata, you have to at least add one page to avoid a Fatal Error:
Please see the Page Manager chapter on adding a page.
Click [Next] to continue, [Previous] to return to the previous dialogue or [Cancel] to abort the installation.
NOTE A user name consists of maximum 16 characters: lowercase (a-z), digits (0-9), underscore (_)and starts with a letter.
Click [Next] to continue, [Previous] to return to the previous dialogue or [Cancel] to abort the installation.
Below is an overview of required and desired settings. You need to make sure that the requirements are satisfied before you continue.
NOTE: Required items have an '*' asterisk.
NOTE: Not required but strongly advised. In php.ini set safe_mode = Off.
NOTE: Take care! Do not set this folder world readable!
You are about to install your new website. Carefully check the
configuration settings. Please do as suggested and print this
page for future reference.
Thereafter you can press [Next] to start the actual installation
process or press [Previous] to correct errors, or [Cancel] to
abort the installation.
The installation process may take a while.
The installation is finished.
It's not a bad idea to check for updates or bug fixes. We assume
your version is up to date. Proceed by selecting an item from the
dropdown menu:
Jump to:
Or click [OK] to go to the default destination: the admin.php login dialogue.
To download the file config.php, proceed as follows:
Select the was directory on your computer (see also 1.3.3 Installing on a server without root access) to save the config.php file.
Jump to:
Or click [OK] to go to the default destination: the admin.php login dialogue:
-------- E-mail Message -------- From: Exemplum Primary School <webmaster@exemplum.eu> Subject: Alerts for website Exemplum Primary School: 1 To: webmaster@exemplum.eu (Wilhelmina Bladergroen) 2014-07-22 12:50:17 Initial installation of demodata, including this test message. You will receive an alert at most once every 1440 minutes (1 day). Alerts will trigger on a change in any area. Alerts will be mailed to this address: webmaster@exemplum.eu (Wilhelmina Bladergroen)
-------- E-mail Message -------- From: Exemplum Primary School <a.cackle@exemplum.eu> Subject: Alerts for website Exemplum Primary School: 1 To: a.cackle@exemplum.eu (Amelia Cackle) 2014-07-22 12:50:17 Initial installation of demodata, including this test message. You will receive an alert at most once every 60 minutes (1 hour). Alerts will only be sent for changes on the intranet Alerts will be mailed to this address: a.cackle@exemplum.eu (Amelia Cackle)
This paragraph discusses the points to check for a secure installation. However, it is impossible to describe all possibilities and their exceptions. Do not hesitate to ask help from a local Linux group or ask for support.
All program files of Website@School are installed in the so called CMS Root Folder. The CMS Root Folder is often the same as the web server Document Root. However, it is also possible to use a subdirectory of the web server Document Root instead.
Furthermore, for a good installation a separate Data Directory is necessary. After installation is complete, this Data Directory will contain the CMS Data Folder.
-rw-r--r-- 1 root root 2210 Feb 1 14:00 admin.php -rw-r--r-- 1 root root 7827 Feb 1 14:00 config-example.php -r-------- 1 www root 754 Feb 1 11:10 config.php -rw-r--r-- 1 root root 2204 Feb 1 14:00 cron.php -rw-r--r-- 1 root root 2653 Feb 1 14:00 file.php -rw-r--r-- 1 root root 2675 Feb 1 14:00 index.php drwxr-xr-x 1 root root 824 Feb 2 10:11 program
The CMS Program Folder program/ contains dozens of files and subdirectories. Together these form the Website@School program.
Finally, there is the configuration file config.php. This file (which is created by the Install Wizard) must be placed in the same directory as the other files, i.e. in the CMS Root Folder.
It is sufficient for the web server (Apache) to only have read permissions on all these program files and subdirectories. This also applies to the configuration file config.php.
Security wise it is best to make sure that the web server (Apache) has no write permissions on these program files and (sub) directories. This also applies tot the configuration file config.php.
For additional security and protection of the data in config.php it makes sense to limit the permissions on that file even further.
On a Linux server it speaks for itself to set these read- and write permissions as follows:
- All files, with the exception of
config.php, get permissions 0644 and are owned by user
root and group root.
- Al directories get permissions 0755 and are owned by
user root and group root.
- The file config.php gets permissions 0400 and becomes
owned by user www and group root.
NOTE 1:
It is also possible to give the files (except
config.php) permissions 0444 and the directories
permissions 0555, but this adds factually little when the files
are owned by user root, because anyhow user
root has all permissions, also write permissions, on any
file.
NOTE 2:
In this example user www is used as the account under
which the web server (Apache) is running. Depending on the
specific system, this can also be the user apache or
nobody. Please consult the documentation and/or
configuration of the web server.
NOTE 3:
The file config.php is a case on its own. This file
contains the database password. For that reason it is good to
only and exclusively give the web server (Apache) read
permissions on this file and no other user or group.
NOTE 4:
If it is not possible to make the files (except
config.php) and directories owned by user root
and group root, then it is also possible to choose
another user and group, as long as it is not the web server user
and group for that purpose. Permissions 0644 or 0755 are
usable.
For security reasons the installer creates a subdirectory inside this directory: This we call the CMS Data Folder. The full path of the CMS Data Folder is the Data Directory path followed by a difficult to guess directory name of 32 letters and digits, for example: /home/httpd/wasdata/b27b7d81c0ea26c4885784564bda2e11.
It is necessary that, during the installation, the web server
(Apache) has read-, write- and execute permissions in the
Data Directory (for example wasdata), in order
to create the CMS Data Root.
After finishing the installation the write permissions can be
minimized, as long the read and search permissions for the web
server remain.
Example 1:
On the Linux server /home/httpd/htdocs is the web server
Document Root. In that case a secure choice for the Data
Directory is /home/httpd/wasdata. This results in:
- Data Directory: /home/httpd/wasdata
- CMS Data Folder:
/home/httpd/wasdata/fa0aff7743cd61f2afb473ca528fd431
During the installation, the Data Directory must have permissions 0700 with user www and group root. After finishing the installation, it is sufficient to set the permissions of this directory to 0500 with user www and group root.
Example 2:
On a Linux server /var/www is the web server Document
Root. The Data Directory could be located in
/var/wasdata. This results in:
- Data Directory: /var/wasdata
- CMS Data Folder:
/var/wasdata/fa0aff7743cd61f2afb473ca528fd431
During the installation, this Data Directory should have sufficient file access permissions, e.g. by -- temporarily -- elevating permissionss to 0777, with user wblade and group users. After finishing the installation, it is sufficient to set the permissions of this directory to 0555 with user wblade and group users.
User wblade is Wilhelmina Bladergroen, the systems administrator of the Exemplum Primary School. For explanation on this user and the school see the ServerAtSchool documentation at http://serveratschool.net/doc/manual/overview.html#h2
NOTE: The permissions and ownership of the underlying directories created by the Installation Wizard, must remain as they are. Here is an example:
drwx------ 3 www www 240 Feb 6 13:53 fa0aff7743cd61f2afb473ca528fd431
Example 1:
On a Linux server /home/httpd/htdocs is the web servers
Document Root. If the Data Directory and hence the CMS Data
Folder is to stay in there, then
b27b7d81c9ea26q4885734564qda2e12 looks like a good,
difficult to guess subdirectory name. This results in:
- Data Directory
/home/httpd/htdocs/b27b7d81c9ea26q4885734564qda2e12
- CMS Data Folder:
/home/httpd/htdocs/b27b7d81c9ea26q4885734564qda2e12/fa0aff7743cd61f2afb473ca528fd431
The permissions of the Data Directory during the installation are 0700 with user www and group root. After the installation permissions 0500 with user www and group root are enough.
Example 2:
On a Linux server /var/www is the web servers Document
Root. If the Data Directory and hence the CMS Data Folder is to
stay in there, then b27b7d81c9ea26q4885734564qda2e12
looks like a good, difficult to guess directory name. This
results in:
- Data Directory:
/var/www/b27b7d81c9ea26q4885734564qda2e12
- CMS Data Folder:
/var/www/b27b7d81c9ea26q4885734564qda2e12/fa0aff7743cd61f2afb473ca528fd431
During the installation, the Data Directory has --temporarily-- permissions 0777 with user wblade and group users. After the installation it is sufficient to set back the permissions of this directory to 0555 with user wblade and group users.
User wblade is Wilhelmina Bladergroen, the systems administrator on the Exemplum Primary School. For explanation on this user and the school see the ServerAtSchool Documentation at http://serveratschool.net/doc/manual/overview.html#h2
NOTE: The permissions and ownership of the underlying directories created by the installation wizard, must remain as they are.
NOTE: Before making use of your installation, please also read the next section to check some of the configuration items that affect security.
First check at [ ] Scan files for viruses on upload if the box is checked. Then perform the following test to verify the correct operation of the virus scanner by creating a special 'test virus'. There is a standard test, developed explicitly for testing anti-virus programs. It was developed by the European Institute for Computer Anti-Virus Research (EICAR). You can easily create this test using any text editor. The test file consists of 68 plain ASCII characters as shown below. Note that the 3rd character is a capital 'O' and not the digit '0'.
X5O!P%@AP[4\PZX54(P^)7CC)7}$EICAR-STANDARD-ANTIVIRUS-TEST-FILE!$H+H*
Now store these 68 characters in a file. Do not name the file
EICAR.COM as suggested by the Institute, because by default the
file extension .com is a not allowed extension in
Website@School. Maliciously we rename the file to
image.png, so it will be accepted and uploaded to your
My Files location.
The virus should be detected and an error message must be
generated like:
The virus scanner is properly installed and found
during installation because the virus was detected and not
uploaded.
However, if the virus scanner for some reason is not working
properly during the upload, a message like the following is
displayed. NOTE 'Error 2'.
.
If a virus is found, the webmaster receives an e-mail like the one we found on our public Website@School test site. For details and login, please see chapter Basic procedures for beginners, paragraph 7.2 Our sandbox).
-------- E-mail Message -------- From: Exemplum Test Site <jtester@wexample.org> Subject: Virusalert for website Exemplum Test Site: attempt to upload virus To: jtester@example.org (Exemplum Test Site) There was an attempt to upload a file containing a virus. The output of the virusscanner is as follows: /tmp/php1DGFo: PHP.Trojan.Agent-8 FOUND ----------- SCAN SUMMARY ----------- Infected files: 1 Time: 0.002 sec (0 m 0 s) The currently logged in user was Jane Tester (jtester) and the file was /tmp/phpP1DGFoj (b374k.php). Kind regards, Your automated webmaster
In a future release the senders IP address will be added, so you do not have to look up his IP address in the Website@School log file.
NOTE: Do not forget to keep the virus scanner on the server up to date!
More information on EICAR.COM can be found on the EICAR web site at http://www.eicar.org/anti_virus_test_file.htm.
Note that this EICAR.COM file in itself is a valid but harmless DOS program. When executed (in a DOS box), it simply displays the text 'EICAR-STANDARD-ANTIVIRUS-TEST-FILE!', nothing more.
This sub paragraph on testing with a virus is gracefully copied and slightly adapted from http://serveratschool.net/doc/, the ServerAtSchool Documentation, where the installation of a secure school server is discussed.
Click [OK] to return to the language selection. It is possible to download the config.php file. See paragraph 2.10 Download configuratoin file.
.
You get the same type of errors when the file permissions are too low (for example 000 or 600). Here is an example of minimal permissions and ownership:
drwx------ 2 www www 48 Feb 3 16:49 wasdata
[1] For example when Website@Schools CMS Root Folder has permissions like:
dr-x------ 3 www www 240 Oct 21 13:53 htdocs
It is impossible to write in the directory.