I'm trying to connect to MySQL DB (installed in my laptop) from Confluence Cloud Remote access using the MySQL Source connector. I cannot connect to the MySQL Connector.
Error: Unable to verify configuration. if right configuration, which means the configuration is invalid, and The connector continues to run on the previously passed configuration verify. mistake:
Connection.Password: Unable to connect to database
table.whitelist: Unable to check if table exists due to connection error
The same JDBC connection works through a Java program on my laptop.
Sample program I used:
try { // connect way #1 String url1 = "jdbc:mysql://192.168.2**.**:3306/test_kafka_connectors"; String user = "Adhi"; String password = "*****"; conn1 = DriverManager.getConnection(url1, user, password); if (conn1 != null) { System.out.println("Connected to the database test1"); }
Hostname (localhost with port 3306 or 192.168.2**.**:3306 (my laptop IP address)) works fine in Java programs.
Using the Confluence connector, I cannot establish a connection. Steps I completed below
step 1. I have added connection string details along with username and password inside the connector.
Authentication
Connect to host\
192.168.2**.2**
Connection port
3306
Connect user
Adi
Connection password
******************
Name database
test_kafka_connectors
SSL mode
prefer
Step 2. Create a user (Adhi, IP address is Confluence) in MySQL below and grant permissions. Please refer to the database user picture.
Step 3: I tried putting the bind address attribute of the Confluence IP address into the MySQLconf file mysqlrouter.conf and restarting the mysql service, but the Connector connection still doesn't work.
P粉4474950692023-09-10 09:28:01
192.168.2**.2**
is the LAN subnet on your home network. You need to use the public IP provided by your ISP. You will also need to forward port 3306 through your router.
Not sure why you "need" Confluence Cloud. You should be able to run the Kafka Connect JDBC connector (and Kafka) with MySQL on your local machine.