Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 5 Next »

TermWeb 3.9 Installation Instructions

These instructions describes how to install TermWeb 3.9 with MySQL 5.x or SQL Server 2005/2008/2012 as database and Apache Tomcat 5.5 or later as Web application container.

The database system and Tomcat are assumed to be installed and working properly.

Downloading installation files

Connect to files.termweb.se using the credentials provided by InterverbumTech. Download the zip-archive for the desired TermWeb version. The archive contains the files termweb.war, createdb.sql, termweb.sql and termweb_sqlserver2005.sql.

Database setup

The default database name, user and login name, and password in the descriptions below can be replaced by other values. It is highly recommended to change the password for security reasons.

MySQL 5

  1. Create the TermWeb database by opening a DOS prompt and enter the following:

    mysql -u root -p < createdb.sql

    This creates an empty database called termweb and a user termwebuser with password termwebpwd. The user name and password can be changed as desired. The user currently needs all permissions (except GRANT) in the database.

  2. Import the termweb.sql file to the database, by running the following at the DOS prompt:

    mysql -u termwebuser -p termwebpwd termweb < termweb.sql

  3. The database is now set up.

SQL Server 2005/2008/2012

  1. Open SQL Server Management Studio and connect to the database server.

  2. Create a new database (right click on Databases -> New Database) and name it termweb.

  3. Create a new login (right click on Security -> New->Login) and name it termwebuser. Select SQL Server Authentication and enter termwebpwd as password.

  4. Create a user for the database (Databases->termweb->Security (right click) -> New -> User) and name it termwebuser. Enter termwebuser as Login name, and select Role Members db_datareader, db_datawriter and db_owner.

  5. Execute the termweb_sqlserver2005.sql file (File -> Open -> File, right click >Execute)

  6. The database is now set up.

Web application installation

Copy the termweb.war file to the webapp directory in Tomcat. The war file should be extracted automatically when Tomcat is restarted.

Database connection setup

 

Application setup

In the file <tomcat-installation>/webapps/termweb/WEB-INF/termweb.properties you will find settings that may have to be adjusted according to your environment. For a standard environment the settings should be correct as they are.

Logging

Configuration for logging is configured in <tomcat-installation>/webapps/termweb/WEB-INF/log4j.properties. You may want to change the path to the log file (log4j.appender.logfile.file) if you want TermWeb to write its log file to logs directory in Tomcat.

See http://logging.apache.org/log4j for more information about logging configuration options.

Installation complete

Start up Tomcat and enter http://localhost:8080/termweb in your web browser. You should see the TermWeb login screen. You can log in with client "admin", user "admin" and password "admin".

  • No labels