Advertisement
Guest User

Untitled

a guest
Mar 2nd, 2016
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.81 KB | None | 0 0
  1. $DENODO_HOME/bin/vqlserver_shutdown.sh
  2. sleep 15
  3. ps -ef | grep denodo | grep -v grep
  4.  
  5. /tmp/denodo-odata2-service-5.5-20160129
  6.  
  7. # copy the war file to the webapps folder
  8. cp /tmp/denodo-odata2-service-5.5-20160129/denodo-odata2-service-5.5.war $DENODO_HOME/resources/apache-tomcat/webapps/
  9.  
  10. # Copy the odata xml to the embedded tomcat container
  11. cp /tmp/denodo-odata2-service-5.5-20160129/scripts/denodo-odata2-service-5.5.xml $DENODO_HOME/resources/apache-tomcat/conf/DenodoPlatform-5.5/localhost/
  12.  
  13. # Copy the startup/shutdown scripts to the bin folder
  14. cp /tmp/denodo-odata2-service-5.5-20160129/scripts/*.sh $DENODO_HOME/bin
  15. chmod u+rwx $DENODO_HOME/bin/odata*.sh
  16.  
  17. # change the DENODO_HOME directory in the $DENODO_HOME/bin/odata*.sh scripts
  18. vi $DENODO_HOME/bin/odata_service_startup.sh # look for DENODO_HOME and update it
  19. vi $DENODO_HOME/bin/odata_service_shutdown.sh # look for DENODO_HOME and update it
  20.  
  21. # Add a reference to the Denodo JAR in the catalina.properties file
  22. vi $DENODO_HOME/resources/apache-tomcat/conf/catalina.properties
  23. # Look for shared.loader
  24. # Add this to the end of the shared.loader line:
  25. ${catalina.base}/../../lib/vdp-jdbcdriver-core/denodo-vdp-jdbcdriver.jar
  26.  
  27. # update the server.xml.template file to include a JNDI resource by putting the following in the <GlobalNamingResources> section
  28. vi $DENODO_HOME/resources/apache-tomcat/conf/server.xml.template
  29.  
  30. <Resource name="jdbc/VDPdatabase"
  31. auth="Container"
  32. type="javax.sql.DataSource"
  33. username="admin" password="***********"
  34. url="jdbc:vdb://localhost:9999/admin"
  35. driverClassName="com.denodo.vdp.jdbc.Driver"
  36. initialSize="5" maxWait="5000"
  37. maxActive="120" maxIdle="5"
  38. validationQuery="select * from dual()"
  39. poolPreparedStatements="true"/>
  40.  
  41. # Change the permissions on server.xml.template so other people can't read your denodo admin password:
  42. chmod go-rwx $DENODO_HOME/resources/apache-tomcat/conf/server.xml.template
  43. chmod go-rwx $DENODO_HOME/resources/apache-tomcat/conf/server.xml
  44.  
  45. # update the context.xml to point to the JNDI resource in and also add the properties to the <Context> section (add all of the below to the <Context> section)
  46. vi $DENODO_HOME/resources/apache-tomcat/conf/context.xml
  47.  
  48. <ResourceLink name="jdbc/VDPdatabase"
  49. global="jdbc/VDPdatabase"
  50. type="javax.sql.DataSource"/>
  51.  
  52. <Environment type="java.lang.String" name="odataserver.address" value="/denodo-odata.svc"/>
  53. <Environment type="java.lang.Integer" name="server.pageSize" value="1000"/>
  54. <Environment type="java.lang.Boolean" name="enable.adminUser" value="true"/>
  55.  
  56. $DENODO_HOME/bin/vqlserver_startup.sh
  57. # wait for Denodo and Tomcat to start
  58.  
  59. # deploy/start the odata webapp
  60. $DENODO_HOME/bin/odata_service_startup.sh
  61.  
  62. # Go to
  63. http://hostname:9090/denodo-odata2-service-5.5/denodo-odata.svc/databasename
  64. (but change "databasename" to your virtual database name)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement