The following chapters illustrate the installation process of the Asio-Data Classroom Booking System on a Windows server. The installation process on a Linux platform is very similar, please refer to the Apache web server, MySQL database server and PHP general-purpose scripting language documentation for detailed Linux installation instructions.
The Classroom Booking System is entirely Web-based. Workstations accessing the server need only a web browser and a network connection.
The system requirements for a server running the Asio-Data Classroom Booking System are as follows. It should be noted that the processor and memory requirements are dependent on the number of concurrent users. The software will run fine on lower performance hardware with a reduced volume of users.
All thats required to use the Asio Classroom Booking system on a work station is a web browser.
Asio Classroom Booking System is tested to work on Internet Explorer 6 browsers or above and Mozilla/Firefox browsers.
Apache is a freely-available web server available for the majority of popular operating systems. The installation packages can be downloaded from http://httpd.apache.org/dist/httpd/binaries/
Please note that on some NT platforms the Apache installation program may require prior installation of 'Windows Installer'.
During installation of the Apache web server, set your organizations domain properly (e.g.
and set the computers name as
'myorganization.org' with your appropriate domain dame)
On the next screen, select the installation mode as
After Apache has been installed, you can begin installing the PHP module.
PHP can be downloaded free-of-charge from http://www.php.net/downloads.php/. You should only use version PHP4 with the Asio-Data Classroom Booking System, PHP5 is not currently supported.
We recommend downloading the PHP Installer for Windows platfoms to ease the installation process.
You must set Apache's default document directory to
C:\ASIO\HTTPD. To do this, select
"Configure" from Apache's program
group and search for
'DocumentRoot' in the opened file. Set this to
C:\ASIO\HTTPD. In the same file, find the text Directory
"C:\Program files\Apache Group......." and change it to
Ensure the server port in use is not the default one
(80). The port parameter is located at the beginning of the configuration file.
'LoadModule php4_module c:\php\sapi\php4apache.dll'
"application\x-xxx"strings are located)
AddType application\x-httpd-php .php .phtml
AddType application\x-httpd-php .php3 .phtml
Start the PHP Installer and select
"Standard" as the installation type.
On the following screen you must provide a name for your
SMTP mail server.
You may write anything you want in the
The e-mail settings are only important if you are going to run PHP scripts that send e-mail, (e.g. booking
On the following screen, select
Apache as the server type.
It's possible the installer may not have installed all the required files even though you have configured the module correctly.
Unpack the PHP package to the directory
C:\PHP but do not replace any existing files!
Copy the file
C:\PHP to your Windows
SYSTEM subfolder (
C:\WINNT\SYSTEM or similar). In order for all changes to take effect, restart Apache.
When PHP has been installed, go to the root directory of your Windows system (usually
C:\WINNT) and open the file
with a text editor (notepad, for example). For Linux and Unix systems the php.ini is usually
located in the /etc/ directory, but this can vary between distributions.
Locate the row
error_reporting = E_ALL; display all errors, warnings and notices
and change it to the following:
error_reporting = E_COMPILE_ERROR|E_ERROR|E_CORE_ERROR
Then locate the row
"register_globals" and ensure the setting is enabled
("On") and not disabled
You may also want to change the setting
"max_execution_time" to reflect the maximum time the program is
allowed to run when undertaking long operations (e.g. importing large Untis-files). PHP's default is
however we recommend a value of
600 or more.
If you are using other default encoding than ISO-8859-1 in Apache, uncomment the following lines
in php.ini to make sure that PHP content is treated as ISO-8859-1 encoded:
default_mimetype = "text/html"
default_charset = "iso-8859-1"
If you plan to use email file attachment sending functions in the application, you
should make the following changes:
safe_mode = Off (or other suitable maximum attachment file size)
file_uploads = On
upload_max_filesize = 16M
(should be at least equal to the maximum attachment file size)
post_max_size = 16M
Depending on server load, it might be a good idea to adjust the
output_buffering directive. Instead of
you should use a numerical value, which represents the maximum size of the output buffer. Value
"4096" is recommended.
MySQL is an open-source SQL-database and it is available for Windows operating systems and most Unix/Linux platforms. We recommend MySQL version 4.0. It can be downloaded from http://dev.mysql.com/downloads/
Using MySQL with non-GPL software such as the Asio-Data Classroom Booking System requires the purchase of a commercial license, (e.g. MySQL's Classic license). For more information, see https://order.mysql.com/
Installation is easy: just unpack the installation package and install the software to its default directory:
MySQL versions 4.1 and later default to INNODB storage engine and UTF-8 charachter encoding, both of which are not recommeded with Asio software. (You can use UTF-8 encoding if you need it, but it will negatively affect the performance of the database, and can cause minor incompatibility issues when importing non-UTF-8 database dump files.)
Turn off INNODB and UTF-8 by following the instructions below:
To ensure that MySQL was installed as an NT service, start the command prompt, navigate to
enter the commands
Finally restart the MySQL service from the control panel.
If you are using MySQL in an open network and with Windows please note:
MySQL has a default root account with no password. You should make sure that
the database server cannot be accessed using this account from any non-trusted network host.
We recommend that you only enable local connections to the MySQL server.
This can be done by changing all values of the
Host column in the
mysql.user table to
"localhost". The other alternative is to change
the password for the
If you use a MySQL version 4.1 or later, you'll need to run the following query in MySQL
after installing the Asio software in order to make the database compatible with PHP:
SET PASSWORD FOR 'database_user_name'@'localhost' = OLD_PASSWORD('database_password');
"database_password" with the values you used during the installation.)
Here are the step-by-step instructions for installing the Asio-Data Classroom Booking System. It is assumed that Apache, PHP and MySQL have been successfully installed, and the installion package containing the necessary files has been unpacked somewhere on the server.
/var/wwwwill be used as an example in these instructions), or into a folder of your choice below the document root.
create database Asio;
create database xxxxx;(The database name
xxxxxwill be given to you before the installation.)
grant.sqlfile if you do not wish to use the default MySQL user and password. This is recommended if the server is not situated on a secure network. If you do modify the defaults, ensure you make the corresponding changes at the end of the application's run-time configuration file which is located at
grant.sqlfile in MySQL with root privileges. This script creates the necessary grants and the required privileges for the application's database user.
"Asio"and the user organization's own database(s). The command-line syntax for import is as follows:
"mysql database_name < dump_file_name.sql"
inc/ext_auth.php. The following modules are available:
inc/server_settings.php. You should check at least the following settings in the server settings file:
$db_user = Database user ID
$db_password = Database password
$ext_udb_config = Settings for the external authentication module.
"interface" = HTTP URL for the PL/SQL interface module of the Asio school administration software
"synchonize.php", you should run it according to these instructions:
mysql_connect rowin the beginning of
synchronize.phpas you did with the
synchronize.phpto the www-server, then open it using a www-browser
"perform operations"link at the bottom of the page
synchronize.phpfile from the server after the synchronization has been successfully completed.
chmod -R ugo+w kokvar/tilakuvat
Here are the step-by-step instructions on how to migrate the Asio Classroom Booking System onto a new server.
It is assumed that you have the installation packages of the desired version of the software at hand.
You will also need the database synchronization script,
If any of the aforementioned items are unavailable, please contact Asio-Data.
xxxxxis the same you used during the first installation.
mysqldump Asio -K --quote-names --compatible=mysql323 -uUSER_ID -pPASSWORD > Asio.sql
mysqldump xxxxx -K --quote-names --compatible=mysql323 -uUSER_ID -pPASSWORD > xxxxx.sql
CREATE DATABASE Asio;
CREATE DATABASE xxxxx;
mysql Asio < Asio.sql
mysql xxxxx < xxxxx.sql