search

Home  >  Q&A  >  body text

Confluence MySQL connector connection not established

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粉057869348P粉057869348460 days ago730

reply all(1)I'll reply

  • P粉447495069

    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.

    reply
    0
  • Cancelreply