Difference between revisions of "WebServices ASE"

From SybaseWiki
Jump to: navigation, search
m
Line 1: Line 1:
 
==Installation==
 
==Installation==
  
Based on an Linux installation using ASE version 15.0 (ebf 12780), here are some steps to install WebServices on an existing database server.
+
Based on an Linux installation using ASE version 15.0.2, here are some steps to install WebServices on an existing database server.
  
 
* Run the aseplugin executable (located in $SYBASE/ASEP/bin). Pass the parameter -i for interactive mode (not -I as stated in the Sybase documentation)
 
* Run the aseplugin executable (located in $SYBASE/ASEP/bin). Pass the parameter -i for interactive mode (not -I as stated in the Sybase documentation)
 
* Answer all the questions.
 
* Answer all the questions.
* During the installation an sp_configure "enable webservices",1 is done
 
 
* The script $SYBASE/$SYBASE_WS/bin/installws is loaded into the database server, basically installing the procedures sp_webservices and sp_get_unique_table into the sybsystemprocs database.
 
* The script $SYBASE/$SYBASE_WS/bin/installws is loaded into the database server, basically installing the procedures sp_webservices and sp_get_unique_table into the sybsystemprocs database.
* At the end a properties file is generated in $SYBASE/$SYBASE_WS/props. You can manualy changed this file.
+
* At the end a properties file "ws.properties" is generated in $SYBASE/$SYBASE_WS/props. You can manualy change this file.
* When you specified a non-default consumer port, please change the properties file afterwards with the right port number.
+
* The installation software does not set all non-default configuration values to the value that has been specified during the installation. Check the generated ws.properties file to verify it is correct. A sample is provided here:
* Modify the properties file to indicate the location of the interfaces file. Put the location in the line starting with "com.sybase.ase.ws.interfaces".
+
 
 +
com.sybase.ase.ws.name = ASE1_WS
 +
com.sybase.ase.ws.producer.httpport = 8181
 +
com.sybase.ase.ws.consumer.cisport = 8183
 +
com.sybase.ase.ws.logfilename = /opt/sybase/admin/ASE1_WS/webservice.log
 +
com.sybase.ase.ws.producer.jettylogfile = /opt/sybase/admin/ASE1_WS/http.log
 +
com.sybase.ase.ws.interfaces = /opt/sybase/ase1502/interfaces
 +
com.sybase.ase.ws.libtcl = /opt/sybase/ase1502/OCS-15_0/config/libtcl.cfg
 +
com.sybase.ase.ws.ui.activate = true
 +
com.sybase.ase.ws.producer.tuning.maxthreads = 250
 +
com.sybase.ase.ws.producer.tuning.minthreads = 45
 +
com.sybase.ase.ws.producer.tuning.maxidletime = 60000
 +
com.sybase.ase.ws.producer.tuning.ssl.maxthreads = 125
 +
com.sybase.ase.ws.producer.tuning.ssl.minthreads = 10
 +
com.sybase.ase.ws.producer.tuning.ssl.maxidletime = 60000
 +
com.sybase.ase.ws.producer.ssl.password =
 +
com.sybase.ase.ws.producer.ssl.httpsport =
 +
com.sybase.ase.ws.producer.ssl.keystore =
 +
com.sybase.ase.ws.producer.ssl.keypassword =
 +
 
 +
* Enable web services in ASE by enabling it:
 +
sp_configure "enable webservices",1
 +
 
 +
==Starting==
 +
Start webservices like this:
 +
$SYBASE/$SYBASE_WS/bin/runws -Usa_webservices -P webs01 -SASE1 -f /opt/sybase/admin/ASE1_WS/ASE1_WS.properties
 +
Some notes
 +
* Keep a space between the -P and the actual password.
 +
* The login specified, in this case sa_webservices, should have sa_role.
 +
* Look in the file specified at com.sybase.ase.ws.logfilename if there were any errors during start-up.
 +
 
 +
==Stopping==
 +
Stop webservices like this:
 +
$SYBASE/$SYBASE_WS/bin/stopws -Usa_webservices -P webs01 -SASE1 -f /opt/sybase/admin/ASE1_WS/ASE1_WS.properties
  
==Starting / Stopping==
 
Starting or stopping the producer
 
* run the runws / stopws script, but do not supply a "-v" argument.
 
* For better debugging when you run into problems, change the runws script so that the output generated by the producer is not being written to /dev/null, but write it into a file.
 
  
 
[[Category:ASE]]
 
[[Category:ASE]]

Revision as of 21:25, 3 July 2007

Installation

Based on an Linux installation using ASE version 15.0.2, here are some steps to install WebServices on an existing database server.

  • Run the aseplugin executable (located in $SYBASE/ASEP/bin). Pass the parameter -i for interactive mode (not -I as stated in the Sybase documentation)
  • Answer all the questions.
  • The script $SYBASE/$SYBASE_WS/bin/installws is loaded into the database server, basically installing the procedures sp_webservices and sp_get_unique_table into the sybsystemprocs database.
  • At the end a properties file "ws.properties" is generated in $SYBASE/$SYBASE_WS/props. You can manualy change this file.
  • The installation software does not set all non-default configuration values to the value that has been specified during the installation. Check the generated ws.properties file to verify it is correct. A sample is provided here:
com.sybase.ase.ws.name = ASE1_WS
com.sybase.ase.ws.producer.httpport = 8181
com.sybase.ase.ws.consumer.cisport = 8183
com.sybase.ase.ws.logfilename = /opt/sybase/admin/ASE1_WS/webservice.log
com.sybase.ase.ws.producer.jettylogfile = /opt/sybase/admin/ASE1_WS/http.log
com.sybase.ase.ws.interfaces = /opt/sybase/ase1502/interfaces
com.sybase.ase.ws.libtcl = /opt/sybase/ase1502/OCS-15_0/config/libtcl.cfg
com.sybase.ase.ws.ui.activate = true
com.sybase.ase.ws.producer.tuning.maxthreads = 250
com.sybase.ase.ws.producer.tuning.minthreads = 45
com.sybase.ase.ws.producer.tuning.maxidletime = 60000
com.sybase.ase.ws.producer.tuning.ssl.maxthreads = 125
com.sybase.ase.ws.producer.tuning.ssl.minthreads = 10
com.sybase.ase.ws.producer.tuning.ssl.maxidletime = 60000
com.sybase.ase.ws.producer.ssl.password =
com.sybase.ase.ws.producer.ssl.httpsport =
com.sybase.ase.ws.producer.ssl.keystore =
com.sybase.ase.ws.producer.ssl.keypassword =
  • Enable web services in ASE by enabling it:
sp_configure "enable webservices",1

Starting

Start webservices like this:

$SYBASE/$SYBASE_WS/bin/runws -Usa_webservices -P webs01 -SASE1 -f /opt/sybase/admin/ASE1_WS/ASE1_WS.properties

Some notes

  • Keep a space between the -P and the actual password.
  • The login specified, in this case sa_webservices, should have sa_role.
  • Look in the file specified at com.sybase.ase.ws.logfilename if there were any errors during start-up.

Stopping

Stop webservices like this:

$SYBASE/$SYBASE_WS/bin/stopws -Usa_webservices -P webs01 -SASE1 -f /opt/sybase/admin/ASE1_WS/ASE1_WS.properties