Unicenta with MySQL on AWS Cloud using Amazon RDS

[Jude]

Hello All,

I have installed Unicenta-4.6.2 on my PC, and using MySQL on AWS Cloud using Amazon RDS. I'm unable to connect to the database, I'm getting error.

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: 
Could not create connection to database server.

java.lang.NullPointerException: 
null

I'm using the default jarfile , unicentaopos-4.6.2.\mysql-connector-java-5.1.39.jar.

But I'm able to connect to the AWS Cloud database using MySQL workbench. Also I'm able to connect to the locally installed MySQL database using jdbc:mysql://localhost:3306/.

I'm unable to see the DB2 option where I can enter the second Database for testing. Am I missing something?

Thanks.

[paddy downey]

ln img2.PNG turn Multi-DB to on then add second database.
Try this link
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToInstance.html

[Jude]

Hi Paddy,

Thanks, But I have created a DB instance and am able to connect to the Cloud DB using MySQL Workbench.
The issue is I'm unable to connect using Unicenta. The connection URL that I'm using is something like below

jdbc:mysql://xxxx-rds-mysql.xxxxx.ap-xxxxeast-2.rds.amazonaws.com:3306/

Thanks

[paddy downey]

I'm not familiar with amazon but connection should look like this;
jdbc:mysql://xxxx.cz3dqvoc8st5.eu-west-1.rds.amazonaws.com:3306/

Are you using same credentials as you use in workbench?

[Hugh]

Make sure you are using mysql 5.7 and not version 8

[Jude]

Thanks. I was using a different version. Created a new instance with MySQL version5.7 and successfully connected. Now I'm running Unicenta on my local machine with MySQL database on AWS Cloud!

[paddy downey]

Great!