2.1 Setting up the database using Ant

The easiest and fastest way to create the database is to use Ant. That's why, before that, you have to install Ant.

Please follow this procedure in order to install it :

2.2 Setting up the database using MySQL commands

The other way to install the database is to use MySQL commands. To do that, you only have to have MySQL installed. To install and configure MySQL, please go to the the part I.1. MySQL Installation.

Information : the *.sql files are used by "source" MySQL command are found in the WEB-INF/sql folder.

To use the "source" command as mentioned below, put the *.sql files in the MySQL bin folder. Otherwise, indicate the absolute path of the files in the command.

Create Lutece database :

[Win32] :

Launch MySQL from the bin folder <mysql_home> (where <mysql_home> is the mysql installation folder).

Run the following command :

mysql.exe
mysql> create database lutece;
	                        

[Unix] :

# mysql -u root -p new_password

mysql> create database lutece;
							

Connect to the database :

[Win32] & [Unix] :

mysql> use lutece;
	                        

Create and initialize the database : (the SQL scripts are packed in Lutece distribution)

For this step, you have to differenciate core tables and plugin tables.

• Core tables :

[Win32] & [Unix] :

mysql> source create_db_lutece_core.sql;
mysql> source init_db_lutece_core.sql;
	                        

• Plugin tables (if these plugins are deployed in the webapp) :

In the WEB-INF/sql/plugins directory, you have to execute all SQL scripts (create_<X>.sql and init_<X>.sql) of each sub-directory.

[Win32] & [Unix] :

mysql> source create_<X>.sql;
mysql> source init_<X>.sql;
			                

To verify whether the database is correctly configured for user lutece (by default), run the commands :

[Win32] & [Unix] :

mysql> show tables;
mysql> select * from core_admin_right;
	                        

3.1 JDK 5.0 Installation

Tomcat installation needs the installation of Java 2 SDK Standard Edition (the version used must be at least jdk 1.5.0) on the server.

Installation of Java 2 SDK, Standard Edition :

Download the JDK version from Sun website : http://java.sun.com/j2se/downloads.html.

Configure the JAVA_HOME environment variable value to the path of the JDK containing folder.

Update the environment variable PATH by adding JAVA_HOME\bin to its definition.

3.2 Tomcat Installation

Download Tomcat from the following address: http://jakarta.apache.org/tomcat/index.html.

Then configure the TOMCAT_HOME environment variable value to the path of the Tomcat folder.

Reload the file containing the environment variables for the update to take effect.

3.3 Installation Checking

• Run Tomcat : (<tomcat_home> is the installation folder of Tomcat).

  [Win32] : <tomcat_home>/bin/startup.bat

  [Unix] : <tomcat_home>/bin/startup.sh

• Run a browser and type the following url : http://localhost:8080. The Welcome page of Tomcat should appear.
• To stop Tomcat :

  [Win32] : <tomcat_home>/bin/shutdown.bat

  [Unix] : <tomcat_home>/bin/shutdown.sh

3.4 Server Configuration

• To disable the list file display from the webapp URL, modify the <tomcat_home>/conf/web.xml file :

  <init-param>
  <param-name>listings</param-name>
  <param-value>false</param-value>
  
  </init-param>
                                          

• Modify the size of the memory allocated for the java virtual machine :

  Add the line below in the files <tomcat_home>/bin/catalina.bat and <tomcat_home>/bin/catalina.sh :

  CATALINA_OPTS="-Xms128m -Xmx512m"
                                          

  to set the initial (128 Mo) and maximum (512 Mo) amounts allocated for the JVM.