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

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

Marcus Christie created AIRAVATA-2704:
-----------------------------------------

             Summary: 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


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
* 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}

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)