AnsweredAssumed Answered

CA API Gateway MySQL database connection

Question asked by mensur.durakovic on Oct 15, 2018
Latest reply on Oct 17, 2018 by mensur.durakovic

I am trying to configure my CA API Gateway on remote database connection. I followed steps in "CA API Gateway – Virtual Appliance" PDF document. On my remote database server I added MySQL user and granted him all privileges:


On CA API Gateway after I confirm my configuration summary I get this result:



However, after I check databases on database server I can see that it created "ssg" database:


I am without ideas what to try next ? I tried playing with privileges and allowed port 3306 for all incoming IP's with this command: 

iptables -A INPUT -i eth0 -p tcp --destination-port 3306 -j ACCEPT

but error message is still displayed with this code 42000 and I don't understand what I am doing wrong.


After I added privileges with GRANT option:


I got other error and database "ssg" is not created anymore:


Any help will be appreciated!