Installing Presto as Windows Services

STEPS FOR INSTALLING PRESTO AS WINDOWS SERVICES

(for the PDF version click here)

HSQLDB as a Service
1. Go to http://wrapper.tanukisoftware.org/ and download their community edition (
For Windows x86:
http://wrapper.tanukisoftware.org/download/3.3.3/wrapper-windows-x86-32-....
zip)
2. Unzip the file into a folder, for example: C:\wrapperJava (we will make reference to
this folder as wrapper-home)
3. Copy the following files
(Wrapper Files Section)
from: wrapper-home/lib/wrapper.dll
to: presto-install/prestorepository/hsqldb/lib/wrapper.dll
from: wrapper-home/lib/wrapper.jar
to: presto-install/prestorepository/hsqldb/lib/wrapper.jar
from: wrapper-home/bin/wrapper.exe
to: presto-install/prestorepository/hsqldb/wrapper.exe
from: wrapper-home/src/conf/wrapper.conf.inc
to: presto-install/prestorepository/hslqdb/wrapper_hsql.conf
(Script Files Section)
from: wrapper-home/src/bin/App.bat.in
to: presto-install/prestorepository/hsqldb/HSQL.bat
(change the file name when you finish copying)
from: wrapper-home/src/bin/InstallApp-NT.bat.in
to: presto-install/prestorepository/hsqldb/InstallHSQL-NT.bat
(change the file name when you finish copying)
from: wrapper-home/src/bin/UninstallApp-NT.bat.in
to: presto-install/prestorepository/hsqldb/UninstallHSQL-NT.bat
(change the file name when you finish copying)
4. Add the following line:
Call ..\..\jbenv.bat
As the very first line of this files: HSQL.bat, InstallHSQL-NT.bat,
UninstallHSQL-NT.bat, save the files.
5. Edit the file: presto-install/prestorepository/hslqdb/wrapper_hsql.conf and add this
properties (NOTE: you may need to add new lines for some properties like
wrapper.java.classpath.2)
INSTALLING PRESTO AS WINDOWS SERVICES
Property Update Value To
wrapper.java.command %JAVA_HOME%/bin/java
wrapper.java.classpath.1 lib/wrapper.jar
wrapper.java.classpath.2 lib/hsqldb.jar
wrapper.app.parameter.1 org.hsqldb.Server
wrapper.app.parameter.2 -database rdsdb
wrapper.app.parameter.3 -port 9001
(place here your HSQLDB port number, default
is 9001)
wrapper.ntservice.name PrestoRepositoryService
wrapper.ntservice.displayname Presto 2.6.1 Repository Service
(you may want to change the 2.6.1 to your
presto version)
wrapper.ntservice.description Presto 2.6.1 Repository Service
(you may want to change the 2.6.1 to your
presto version)
6. Open the HSQL.bat file and look for a line that says:
set _WRAPPER_CONF
Modify this line so that it reads:
set _WRAPPER_CONF="%_REALPATH%wrapper_hsql.conf"
7. Go to your command line and run the file: InstallHSQL-NT.bat
8. Your services will be registered and ready to be use in Windows.
TOMCAT as a Service
1. Go to yout bin tomcat folder ( presto_home/server/apache-tomcat-5.5.20/bin)
2. Run the following command:
service.bat install Presto261Tomcat
INSTALLING PRESTO AS WINDOWS SERVICES
(Note:You can change: Presto261Tomcat to the name you would like give to
the service)
3. If you want to start this service when windows starts, go to Start menu ->
Administrative Tools -> Services, choose the PrestoTomcat service, right click
on it, select properties and set the Startup Type to: Automatic.
INSTALLING PRESTO AS WINDOWS SERVICES