Welcome to AggreGate Community

MySQL v8 connection

Questions related to relational databases, key-value databases, NoSQL databases, round-robin databases, and file-based storage.

MySQL v8 connection

Postby moskons&gmail.com » Sun Oct 31, 2021 7:42 pm

Regarding the connection to MySQL v8, you need to replace the jdbc connector mysql-connector-java-5.1.30-bin.jar, located in c: \ Program Files \ AggreGate \ jar \ with the one in the attachment when the server is stopped and the client is closed.

Also in the URL to connect to the database you need to register:

jdbc: mysql: // {ip_address}: {port} / {database_name}?useLegacyDatetimeCode=false&serverTimezone=UTC&useSSL=false

AGG did not support SSL connection with DB yet.

If "ag.stderr - Loading class com.mysql.jdbc.Driver" INFO message in log, change jdbc class driver to "com.mysql.cj.jdbc.Driver"
moskons&gmail.com
 
Posts: 21
Joined: Mon Sep 20, 2021 3:41 pm

Re: MySQL v8 connection

Postby moskons&gmail.com » Tue Nov 23, 2021 9:11 am

The message can be supplemented
moskons&gmail.com
 
Posts: 21
Joined: Mon Sep 20, 2021 3:41 pm

Re: MySQL v8 connection

Postby jacek.brozyna&dipolpolska.pl » Sun Jan 16, 2022 5:20 pm

On Linux, I have a problem with AggreGate Server 5.41.11 and MySQL 8.0.27
In /usr/local/AggreGate/jar I replaced mysql-connector-java-5.1.30-bin.jar with mysql-connector-java-8.0.27.jar
In AggreGate configuration in Database section I set:
Database Driver: com.mysql.jdbc.Driver
Database URL: jdbc:mysql://localhost:3306/aggregate?useLegacyDatetimeCode=false&serverTimezone=UTC&useSSL=false
Database SQL Dialect: I tested MySQL and MySQL5
I also tried different users with both caching_sha2_password and mysql_native_password password encryption algorithm.
I don't have a problem connecting with this database using any other tools.

What can I do more to connect with MySQL 8?
jacek.brozyna&dipolpolska.pl
 
Posts: 4
Joined: Wed Oct 31, 2018 7:24 am


Return to Data Storage

Who is online

Users browsing this forum: No registered users and 1 guest