Difference between revisions of "WebServices ASE"
From SybaseWiki
m |
|||
| Line 1: | Line 1: | ||
==Installation== | ==Installation== | ||
| − | Based on an Linux installation using ASE version 15.0 | + | 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. | ||
| − | |||
* 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 | + | * 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 | ||
| − | |||
| − | |||
| − | |||
| − | |||
[[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
