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]> 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]> > 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 >> >> <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>
