This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
documentation:software:webapi:webapi_installation_guide [2016/08/23 20:33] jhardin [Errors when calling sources URL] |
documentation:software:webapi:webapi_installation_guide [2019/02/22 21:19] chrisknoll |
||
---|---|---|---|
Line 13: | Line 13: | ||
=== MS SQL Server === | === MS SQL Server === | ||
---- | ---- | ||
- | Coming Soon. | + | |
+ | Please refer to the [[documentation:software:webapi:sqlserver_installation_guide|SQL Server Setup Guide]] article for installation and setup details. | ||
=== PostgreSQL 9.3 === | === PostgreSQL 9.3 === | ||
---- | ---- | ||
- | Please refer to the [[https://github.com/OHDSI/WebAPI/wiki/PostgreSQL-Installation-Guide|PostgreSQL 9.2]] article for installation and setup details. | + | Please refer to the [[documentation:software:webapi:postgresql_installation_guide|PostgreSQL Setup Guide]] article for installation and setup details. |
Line 24: | Line 25: | ||
---- | ---- | ||
- | Please refer to the [[https://github.com/OHDSI/WebAPI/wiki/Oracle-DB-Setup-Guide|Oracle 11g XE]] article for installation and setup details. | + | Please refer to the [[documentation:software:webapi:oracle_db_setup_guide|Oracle Setup Guide]] article for installation and setup details. |
Line 49: | Line 50: | ||
=== Microsoft SQL Server === | === Microsoft SQL Server === | ||
- | Coming Soon. | + | **Create settings.xml File** |
+ | |||
+ | Specify user name, password, and location of the OHDSI database (this was created as ‘ohdsi_app_user’ from the [[documentation:software:webapi:sqlserver_installation_guide|SQL Server Setup Guide]]. Note that the user should have read, write, and create privileges on the OHDSI database. Here is an example XML that is based on the above configuration: | ||
+ | |||
+ | <settings> | ||
+ | <profiles> | ||
+ | <profile> | ||
+ | <id>webapi-mssql</id> | ||
+ | <properties> | ||
+ | <datasource.driverClassName>com.microsoft.sqlserver.jdbc.SQLServerDriver</datasource.driverClassName> | ||
+ | <datasource.url>jdbc:sqlserver://localhost;databaseName=OHDSI</datasource.url> | ||
+ | <datasource.username>ohdsi_app_user</datasource.username> | ||
+ | <datasource.password>app1</datasource.password> | ||
+ | <datasource.dialect>sql server</datasource.dialect> | ||
+ | <datasource.ohdsi.schema>dbo</datasource.ohdsi.schema> | ||
+ | <flyway.datasource.driverClassName>${datasource.driverClassName}</flyway.datasource.driverClassName> | ||
+ | <flyway.datasource.url>${datasource.url}</flyway.datasource.url> | ||
+ | <flyway.datasource.username>ohdsi_app_user</flyway.datasource.username> | ||
+ | <flyway.datasource.password>app1</flyway.datasource.password> | ||
+ | <flyway.locations>classpath:db/migration/sqlserver</flyway.locations> | ||
+ | <security.enabled>false</security.enabled> | ||
+ | <security.token.expiration>43200</security.token.expiration> | ||
+ | <security.origin>*</security.origin> | ||
+ | <security.ssl.enabled>false</security.ssl.enabled> | ||
+ | <security.oauth.callback.ui>http://localhost/atlas/#/welcome</security.oauth.callback.ui> | ||
+ | <security.oauth.callback.api>http://localhost:8080/WebAPI/user/oauth/callback</security.oauth.callback.api> | ||
+ | <security.oauth.google.apiKey></security.oauth.google.apiKey> | ||
+ | <security.oauth.google.apiSecret></security.oauth.google.apiSecret> | ||
+ | <security.oauth.facebook.apiKey></security.oauth.facebook.apiKey> | ||
+ | <security.oauth.facebook.apiSecret></security.oauth.facebook.apiSecret> | ||
+ | </properties> | ||
+ | </profile> | ||
+ | </profiles> | ||
+ | </settings> | ||
+ | |||
+ | Note: this file above is saved as /WebAPIConfig/settings.xml and will be referred to in the “Building the .war file section”. | ||
+ | |||
+ | **Download the appropriate JDBC driver** | ||
+ | |||
+ | For SQL Server, the driver is available from the Maven repository, so no additional steps are required. | ||
=== PostgreSQL === | === PostgreSQL === | ||
**Create settings.xml File** | **Create settings.xml File** | ||
- | Specify user name, password, and location of the OHDSI schema (this was created as ‘webapi’ from the [[https://github.com/OHDSI/WebAPI/wiki/PostgreSQL-Installation-Guide|PostgreSQL Setup Guide]]. Note that the user should have read, write, and create privileges on the OHDSI schema. | + | Specify user name, password, and location of the OHDSI schema (this was created as ‘webapi’ from the [[documentation:software:webapi:postgresql_installation_guide|PostgreSQL Setup Guide]]. Note that the user should have read, write, and create privileges on the OHDSI schema. |
Here is an example XML that is based on the above configuration: | Here is an example XML that is based on the above configuration: | ||
Line 73: | Line 113: | ||
<flyway.datasource.password>!PASSWORD!</flyway.datasource.password> | <flyway.datasource.password>!PASSWORD!</flyway.datasource.password> | ||
<flyway.locations>classpath:db/migration/postgresql</flyway.locations> | <flyway.locations>classpath:db/migration/postgresql</flyway.locations> | ||
+ | <security.enabled>false</security.enabled> | ||
+ | <security.token.expiration>43200</security.token.expiration> | ||
+ | <security.origin>*</security.origin> | ||
+ | <security.ssl.enabled>false</security.ssl.enabled> | ||
+ | <security.oauth.callback.ui>http://localhost/atlas/#/welcome</security.oauth.callback.ui> | ||
+ | <security.oauth.callback.api>http://localhost:8080/WebAPI/user/oauth/callback</security.oauth.callback.api> | ||
+ | <security.oauth.google.apiKey></security.oauth.google.apiKey> | ||
+ | <security.oauth.google.apiSecret></security.oauth.google.apiSecret> | ||
+ | <security.oauth.facebook.apiKey></security.oauth.facebook.apiKey> | ||
+ | <security.oauth.facebook.apiSecret></security.oauth.facebook.apiSecret> | ||
</properties> | </properties> | ||
</profile> | </profile> | ||
Line 86: | Line 136: | ||
=== Oracle === | === Oracle === | ||
**Create settings.xml File** | **Create settings.xml File** | ||
- | Specify user name, password, and location of the OHDSI schema (this was created as ‘ohdsi’ above). Note that the user should have read, write, and create privileges on the OHDSI schema because this user is the owner of the 'ohdsi' schema. | + | Specify user name, password, and location of the OHDSI schema (this was created as ‘ohdsi’ in the [[documentation:software:webapi:oracle_db_setup_guide|Oracle Setup Guide]]). Note that the user should have read, write, and create privileges on the OHDSI schema because this user is the owner of the 'ohdsi' schema. |
Here is an example XML that is based on the above configuration: | Here is an example XML that is based on the above configuration: | ||
Line 104: | Line 154: | ||
<flyway.datasource.password>{password}</flyway.datasource.password> | <flyway.datasource.password>{password}</flyway.datasource.password> | ||
<flyway.locations>classpath:db/migration/oracle</flyway.locations> | <flyway.locations>classpath:db/migration/oracle</flyway.locations> | ||
+ | <security.enabled>false</security.enabled> | ||
+ | <security.token.expiration>43200</security.token.expiration> | ||
+ | <security.origin>*</security.origin> | ||
+ | <security.ssl.enabled>false</security.ssl.enabled> | ||
+ | <security.oauth.callback.ui>http://localhost/atlas/#/welcome</security.oauth.callback.ui> | ||
+ | <security.oauth.callback.api>http://localhost:8080/WebAPI/user/oauth/callback</security.oauth.callback.api> | ||
+ | <security.oauth.google.apiKey></security.oauth.google.apiKey> | ||
+ | <security.oauth.google.apiSecret></security.oauth.google.apiSecret> | ||
+ | <security.oauth.facebook.apiKey></security.oauth.facebook.apiKey> | ||
+ | <security.oauth.facebook.apiSecret></security.oauth.facebook.apiSecret> | ||
</properties> | </properties> | ||
</profile> | </profile> | ||
Line 120: | Line 180: | ||
==== Building the .war file ==== | ==== Building the .war file ==== | ||
- | Open command prompt, go to WebAPI folder, type | + | Open command prompt, **go to the WebAPI folder**, type |
- | set JAVA_HOME=C:/Program Files/Java/jdk1.7.0_67 | + | set JAVA_HOME=C:/Program Files/Java/jdk1.8.0_112 |
//Make sure you point to a JDK, not a JRE. It is probably a good idea to stick to the same Java version that is running Tomcat// | //Make sure you point to a JDK, not a JRE. It is probably a good idea to stick to the same Java version that is running Tomcat// | ||
- | mvn clean package -s /WebAPIConfig/settings.xml -P {profile id} | + | mvn clean package -DskipTests -s WebAPIConfig/settings.xml -P {profile id} |
This will create the file WebAPI.war in the target subfolder. | This will create the file WebAPI.war in the target subfolder. | ||
Line 133: | Line 193: | ||
=== Deploy the war file === | === Deploy the war file === | ||
---- | ---- | ||
- | In Tomcat (e.g. using the manager app), deploy the war file. | + | |
+ | In Tomcat, you will need to increase the maximum file size allowed for WAR files. Go to webapps/manager/WEB-INF/web.xml and then increase the max-file-size and max-request-size to at least the size of the WAR file. | ||
+ | |||
+ | <multipart-config> | ||
+ | <max-file-size></max-file-size> | ||
+ | <max-request-size></max-request-size> | ||
+ | <file-size-threshold>0</file-size-threshold> | ||
+ | </multipart-config> | ||
+ | |||
+ | In Tomcat (e.g. using the manager app), deploy the war file. | ||
+ | |||
This should automatically create a large number of tables in the webapi schema. | This should automatically create a large number of tables in the webapi schema. | ||
Line 224: | Line 294: | ||
====Errors when calling sources URL==== | ====Errors when calling sources URL==== | ||
---- | ---- | ||
- | The most likely error you will receive when accessing [[http://localhost:8080/WebAPI/source/sources]] | + | The most likely error you will receive when accessing %%http://localhost:8080/WebAPI/source/sources%% |
is the ohdsi_app_user does not have permission on relation ‘source’. This means the default privileges were not assigned when logged into the database as ohdsi_admin_user. These table permissions will have to be granted manually. | is the ohdsi_app_user does not have permission on relation ‘source’. This means the default privileges were not assigned when logged into the database as ohdsi_admin_user. These table permissions will have to be granted manually. | ||
If no error is appearing in the logs at all, please confirm the Tomcat servlet engine is listening on port 8080. If it is on a different port, you will need to adjust the URLs above to the correct port. | If no error is appearing in the logs at all, please confirm the Tomcat servlet engine is listening on port 8080. If it is on a different port, you will need to adjust the URLs above to the correct port. |