Installation Guide: Difference between revisions

From tehowiki
Jump to navigation Jump to search
imported>Gfis
Created page with "===Tomcat=== * Modify 1 line in catalina.properties: common.loader="c:/var/lib/tomcat/openlib/*.jar","${catalina.base}/lib","${catalina.base}/lib/*.jar","${catalina.home}/lib..."
 
imported>Gfis
No edit summary
Line 1: Line 1:
===Tomcat===
===Java SDK===
* Modify 1 line in catalina.properties:
===Apache Ant===
  common.loader="c:/var/lib/tomcat/openlib/*.jar","${catalina.base}/lib","${catalina.base}/lib/*.jar","${catalina.home}/lib","${catalina.home}/lib/*.jar"
* Download a binary distribution (currently 1.9.7) from [https://ant.apache.org/bindownload.cgi Apache] and install it without modification.
              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
* Under Linux this may be achieved by
apt-get install ant
===MySQL Server===
* Download and install a MySQL server. A compatible product like MariaDB may also be used.
* Under Linux you may use
apt-get install mysql-server
==== SQL concatenation operator '||' ====
A lot of Dbat specifications use '||' as the SQL concatenation operator. See [http://stackoverflow.com/questions/8212192/can-mysql-concatenate-strings-with this question at stackoverflow.com] how to add a MySQL configuration setting which enables this operator. For example, manually create an additional configuration file <code>/etc/mysql../mysql.conf.d/ansi.cnf</code>:
    root@dubhe:/etc/mysql/mysql.conf.d# cat ansi.cnf
    [mysqld]
    sql_mode=PIPES_AS_CONCAT
===Apache Tomcat===
* Modify one line in <code>catalina.properties</code> (under Linux for example in <code>/etc/tomcat8/conf/</code>,  under Windows in some path like <code>C:\Program Files\Apache Software Foundation\Tomcat 6.0\conf\</code>:
  common.loader='''"c:/var/lib/tomcat/openlib/*.jar",'''"${catalina.base}/lib","${catalina.base}/lib/*.jar","${catalina.home}/lib","${catalina.home}/lib/*.jar"
This entry directs Tomcat to use an additonal directory <code>openlib</code> which contains the JAR files to be shared between all subprojects. Its location is arbitrary, but the <code>ant build.xml</code> files contain the path mentioned above (without "c:" for Linux).

Revision as of 08:04, 12 September 2016

Java SDK

Apache Ant

  • Download a binary distribution (currently 1.9.7) from Apache and install it without modification.
  • Under Linux this may be achieved by
apt-get install ant

MySQL Server

  • Download and install a MySQL server. A compatible product like MariaDB may also be used.
  • Under Linux you may use
apt-get install mysql-server

SQL concatenation operator '||'

A lot of Dbat specifications use '||' as the SQL concatenation operator. See this question at stackoverflow.com how to add a MySQL configuration setting which enables this operator. For example, manually create an additional configuration file /etc/mysql../mysql.conf.d/ansi.cnf:

    root@dubhe:/etc/mysql/mysql.conf.d# cat ansi.cnf 
    [mysqld] 
    sql_mode=PIPES_AS_CONCAT

Apache Tomcat

  • Modify one line in catalina.properties (under Linux for example in /etc/tomcat8/conf/, under Windows in some path like C:\Program Files\Apache Software Foundation\Tomcat 6.0\conf\:
common.loader="c:/var/lib/tomcat/openlib/*.jar","${catalina.base}/lib","${catalina.base}/lib/*.jar","${catalina.home}/lib","${catalina.home}/lib/*.jar"

This entry directs Tomcat to use an additonal directory openlib which contains the JAR files to be shared between all subprojects. Its location is arbitrary, but the ant build.xml files contain the path mentioned above (without "c:" for Linux).