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