[
https://issues.apache.org/jira/browse/AIRAVATA-2704?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Marcus Christie updated AIRAVATA-2704:
--------------------------------------
Description:
Currently the process of running the sharing registry data migrator is
undocumented and probably unnecessarily complex. Here's what [~tilaks26] and I
had to do to run it:
* (/) create a src/main/resources directory and copy the
airavata-server.properties file from airavata-server-configuration into this
directory
* (/) we then needed to change the following properties
** sharingcatalog.jdbc.driver=org.mariadb.jdbc.Driver
** sharingcatalog.jdbc.url=jdbc:mariadb://XXX.XXX.XXX.XXX:3306/sharing_catalog
** sharingcatalog.jdbc.user=airavata
** sharingcatalog.jdbc.password=XXXXXXXXXXXXXX
** credential.store.server.host=XXX.XXX.XXX.XXX
** regserver.server.host=XXXXX.XXXXX.XXXXX
** regserver.server.port=8970
** trust.store=/path/to/client_truststore.jks
** trust.store.password=...
* (/) next was modifying ConnectionFactory and add the MySQL connection info
* (/) we also needed to add the mariadb driver to the pom.xml
{code:xml}
<dependency>
<groupId>org.mariadb.jdbc</groupId>
<artifactId>mariadb-java-client</artifactId>
<version>2.0.2</version>
</dependency>
{code}
* also had to run {{mvn install}} in sharing-registry to run the openjpa
enhancement otherwise we got errors about the models not being enhanced.
I think ideally we would only make calls to the services instead of accessing
the database directly, but perhaps I'm missing something and we really do need
to access the database directly. Also we need an easier way of running it,
maybe with some Maven integration so we can run it from Maven.
was:
Currently the process of running the sharing registry data migrator is
undocumented and probably unnecessarily complex. Here's what [~tilaks26] and I
had to do to run it:
* create a src/main/resources directory and copy the airavata-server.properties
file from airavata-server-configuration into this directory
* we then needed to change the following properties
** sharingcatalog.jdbc.driver=org.mariadb.jdbc.Driver
** sharingcatalog.jdbc.url=jdbc:mariadb://XXX.XXX.XXX.XXX:3306/sharing_catalog
** sharingcatalog.jdbc.user=airavata
** sharingcatalog.jdbc.password=XXXXXXXXXXXXXX
** credential.store.server.host=XXX.XXX.XXX.XXX
** regserver.server.host=XXXXX.XXXXX.XXXXX
** regserver.server.port=8970
** trust.store=/path/to/client_truststore.jks
** trust.store.password=...
* next was modifying ConnectionFactory and add the MySQL connection info
* we also needed to add the mariadb driver to the pom.xml
{code:xml}
<dependency>
<groupId>org.mariadb.jdbc</groupId>
<artifactId>mariadb-java-client</artifactId>
<version>2.0.2</version>
</dependency>
{code}
* also had to run {{mvn install}} in sharing-registry to run the openjpa
enhancement otherwise we got errors about the models not being enhanced.
I think ideally we would only make calls to the services instead of accessing
the database directly, but perhaps I'm missing something and we really do need
to access the database directly. Also we need an easier way of running it,
maybe with some Maven integration so we can run it from Maven.
> Improve the process of running the Sharing Registry data migrator
> -----------------------------------------------------------------
>
> Key: AIRAVATA-2704
> URL: https://issues.apache.org/jira/browse/AIRAVATA-2704
> Project: Airavata
> Issue Type: Bug
> Reporter: Marcus Christie
> Priority: Major
>
> Currently the process of running the sharing registry data migrator is
> undocumented and probably unnecessarily complex. Here's what [~tilaks26] and
> I had to do to run it:
> * (/) create a src/main/resources directory and copy the
> airavata-server.properties file from airavata-server-configuration into this
> directory
> * (/) we then needed to change the following properties
> ** sharingcatalog.jdbc.driver=org.mariadb.jdbc.Driver
> ** sharingcatalog.jdbc.url=jdbc:mariadb://XXX.XXX.XXX.XXX:3306/sharing_catalog
> ** sharingcatalog.jdbc.user=airavata
> ** sharingcatalog.jdbc.password=XXXXXXXXXXXXXX
> ** credential.store.server.host=XXX.XXX.XXX.XXX
> ** regserver.server.host=XXXXX.XXXXX.XXXXX
> ** regserver.server.port=8970
> ** trust.store=/path/to/client_truststore.jks
> ** trust.store.password=...
> * (/) next was modifying ConnectionFactory and add the MySQL connection info
> * (/) we also needed to add the mariadb driver to the pom.xml
> {code:xml}
> <dependency>
> <groupId>org.mariadb.jdbc</groupId>
> <artifactId>mariadb-java-client</artifactId>
> <version>2.0.2</version>
> </dependency>
> {code}
> * also had to run {{mvn install}} in sharing-registry to run the openjpa
> enhancement otherwise we got errors about the models not being enhanced.
> I think ideally we would only make calls to the services instead of accessing
> the database directly, but perhaps I'm missing something and we really do
> need to access the database directly. Also we need an easier way of running
> it, maybe with some Maven integration so we can run it from Maven.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
