Hi Suresh,
Any email address for posting an issue to Airavata JIRA? I don't have login credentials for it. Thanks, Qiyang ________________________________ From: Suresh Marru <[email protected]> Sent: Monday, May 22, 2017 10:41:14 AM To: Hu, Qiyang; Supun Nakandala Cc: Airavata Users Subject: Re: problem when installing airavata Hi Supun, Any thoughts on this? Hi Qiyang, Sharing catalog is a newer capability and documentation is out dated. Can you please create an issue in Airavata JIRA so we will remember to fix the documentation - https://issues.apache.org/jira/browse/airavata/ Suresh On May 22, 2017, at 1:23 PM, Hu, Qiyang <[email protected]<mailto:[email protected]>> wrote: Hi Suresh, Thank you so much for your reply. It seems that I did grant the privileges for the databases MariaDB [(none)]> show grants for 'airavata'@'%'; +---------------------------------------------------------------------------------------------------------+ | Grants for airavata@% | +---------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'airavata'@'%' IDENTIFIED BY PASSWORD '*A7AD1AC787B8CABE6A58AEA652A8B3CF5035BA82' | | GRANT ALL PRIVILEGES ON `experiment_catalog`.* TO 'airavata'@'%' | | GRANT ALL PRIVILEGES ON `credential_store`.* TO 'airavata'@'%' | | GRANT ALL PRIVILEGES ON `workflow_catalog`.* TO 'airavata'@'%' | | GRANT ALL PRIVILEGES ON `replica_catalog`.* TO 'airavata'@'%' | | GRANT ALL PRIVILEGES ON `app_catalog`.* TO 'airavata'@'%' | | GRANT ALL PRIVILEGES ON `sharing_catalog`.`⁎` TO 'airavata'@'%' | +---------------------------------------------------------------------------------------------------------+ 7 rows in set (0.00 sec) MariaDB [(none)]> show grants for 'airavata'@'localhost'; +-----------------------------------------------------------------------------------------------------------------+ | Grants for airavata@localhost | +-----------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'airavata'@'localhost' IDENTIFIED BY PASSWORD '*A7AD1AC787B8CABE6A58AEA652A8B3CF5035BA82' | | GRANT ALL PRIVILEGES ON `sharing_catalog`.`⁎` TO 'airavata'@'localhost' | +-----------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) Note in the "Pre-installations" step 13, there is no command for creating 'sharing_catalog' database, I added it to avoid some errors, since it is shown up in "airavata-server.properties". Not sure if it causes the problem. Any idea on how to solve it? Thanks again, Qiyang ________________________________ From: Suresh Marru <[email protected]<mailto:[email protected]>> Sent: Friday, May 19, 2017 7:26:29 PM To: Airavata Users; Hu, Qiyang Subject: Re: problem when installing airavata Hi Qiyang, If you notice the error log - “Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: CREATE command denied to user 'airavata'@'localhost' for table 'DOMAIN’" The sharing database does not seem to have the write privileges for user name “ airavata”, can you check that and the try to run the server again? Suresh On May 19, 2017, at 5:01 PM, Hu, Qiyang <[email protected]<mailto:[email protected]>> wrote: Hello Apache Airavata Support, I am trying to install airavta onto CentOS 7 following the online guide: http://airavata.readthedocs.io/en/latest/Airavata-Installation/#airavata-installation-on-centos-7 However I get stuck in the step when running "sh airavata-server-start all", where I got some error message as attached log. Could you please give me some advise? Note that I manually created "sharing_catalog" database additionally and grant privileges on it, since it is shown up in "airavata-server.properties". Thanks, Qiyang <log_02.txt>
