Installation Guide

Disclaimer: We have not tested this application on IIS. It should work fine, in theory. If you install it on IIS and have any issue, our support team will be happy to assist you.

Following document is written for both Linux and Windows servers using Apache HTTP server.

Download tems.zip and uncompress all sources in a folder say, tems, under htdocs, that is, htdocs/tems.
For example, C:\Program Files\Zend\Apache2\htdocs\tems

Important note: Make sure that you have write authority in "config" and "log" folders.

  1. Give write permission to config folder (chmod config 777)
  2. Give write permission to log folder (chmod log 777)
  3. After installation is complete, change permission of config folder back to original (in most cases it is, chmod config 755)

NOTE: <HOSTNAME> has to be replaced by your actual host name. In this document <HOSTNAME> is a place holder.

Use url http://<HOSTNAME>/tems/index.php. For example, http://localhost/tems/index.php
This will redirect you to the appropriate page of installation based on certain factors of your server. See developers guide for more information. At the end of this installation process, it will create a file Database.ini in config directory, so the user who will install this application should have a write authority in auth directory under htdocs.

Installation process will create:
  • database including all tables, views etc.
  • two database level users (see below for more information).
  • install messages
  • install all language packs
  • a skeleton company record that you will replace with your company information.
  • an user record with id as admin and password as admin, so that you can login to the application and setup the rest.
You will need following three information in-hand to proceed with installation:
  • MySQL database server name,
  • MySQL Admin user ID [or the user id who has sufficient authority to create new database/schema], and
  • MySQL Admin user password.
You will setup the rest as described here:
  • Database name of this application,
  • A database user id, [Note: Installation process will create this user id (if it does not exist) and provide read, write, delete, and select authorities to this database],
  • A password for database user, [See security note (b) below],
  • A database administrator id, [Note: Installation process will create this user id (if it does not exist) and provide DBA level authorities to this database], and
  • A password of administrator user.
Security notes:
  • Application does not store the DBA/Administrator's user id or password. You have to remember this in order for you to use application level backup and recovery. This user id is not used anywhere else.
  • For application to work properly, application will store the normal user id and password in plain text in config/Database.ini file. It will be your responsibility to protect this file so that unwanted user cannot see this file.

Database.ini will look like as below. [This is just an example; your information will be different based on what you have provided.]

[database]
db_server = localhost
db_database = temsdb
db_user = temsDbUser
db_password = temsDbPwd

Questions and Answers:

How to go to the installation page forcefully?

Normally you will never go to the installation page after you have installed the application. However, for any reason if you are forced to go to the installation page use the following url.

http://<HOSTNAME>/tems/install/InstallPage.php?module=Install&action=Create

For example, http://localhost/tems/install/InstallPage.php?module=Install&action=Create

At the end of installation, I see that database has been created, but I am getting an PHP error. How can I resolve it?

First look for Database.ini file in config folder. If you do not find it there and you see the database has been created, that means you did not have write permission to config folder while running the installation program. You a two choices here:

  1. Give write permission to config folder (chmod 777 config), OR
  2. Create Database.ini in config folder using any text editor as below

[database]
db_server = <DATABASE_SERVER_NAME>
db_database = <DATABASE_NAME>
db_user = <DATABASE_USER_ID>
db_password = <DATABASE_USER_PASSWORD>

Note: Database.ini file name is case sensitive. Replace <......> above by actual names.

If problem continues, create a support ticket.