[jira] [Resolved] (AIRAVATA-2704) Improve the process of running the Sharing Registry data migrator

["Marcus Christie (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/AIRAVATA-2704?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Marcus Christie resolved AIRAVATA-2704.
---------------------------------------
    Resolution: Fixed

> 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
>            Assignee: 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)