I work with Api Manager version 3.0.0 and implement database, MySQL version 5.7.28 in Ubuntu 18.04.3 LTS in localhost with this steps:
- In MySQL, create two databases, shared_db and apim_db.
- Create a new user for MySQL and add privileges for the user a create in the databases, shared_db and apim_db.
In terminal execute this lines:
mysql -u **NEWUSER** -p -Dshared_db < '[API-MANAGER]/dbscripts/mysql.sql';
mysql -u **NEWUSER** -p -Dapim_db < '[API-MANAGER]/dbscripts/apimgt/mysql.sql';
Create a JAR with this:
apt-get install libmysql-java
In this path /usr/share/java execute:
cp mysql.jar [API-MANAGER]/repository/components/lib
In [API-MANAGER]/repository/conf, the file deployment.toml, edit this lines:
deployment.toml
[database.apim_db]
type = "mysql"
url = "jdbc:mysql://localhost:3306/apim_db?useSSL=false"
username = "NEWUSER"
password = "PASS"
[database.shared_db]
type = "mysql"
url = "jdbc:mysql://localhost:3306/shared_db?useSSL=false"
username = "NEWUSER"
password = ""
- Restart to server and works, BUT necessarily use this ?useSSL=false.
So, my cuestion is: Why needs this ?useSSL=false? In production needs this lines?
Thanks.