[MXS-3169] issue between java connector and maxscale proxy Created: 2020-09-10  Updated: 2021-04-19  Resolved: 2020-09-10

Status: Closed
Project: MariaDB MaxScale
Component/s: N/A
Affects Version/s: 2.5.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: rakotoniaina Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

Preprod



 Description   

Hi support,

we have a connection problem between java connector and maxscale proxy.
1 - the access to Max Scale Proxy works fine from mysql client.
2 - the access to Backends servers works fine from jdbc
3 - Error only appears when connecting through MaxScale Proxy from java mysql connector library
The Main error message is as below,
Caused by: java.sql.SQLException: Access denied for user 'user'@'::ffff:XXX.XXX.XX.XX' (using password: YES)

Appreciate if you can help us resolve this issue with connecting through Max Scale proxy using java mysql libs.

maxscale version 2.5.
mariadb version 10.5.4
mysql-connector-java-8.0.21.jar

Regards,
David DBA



 Comments   
Comment by markus makela [ 2020-09-10 ]

Does this happen with the MariaDB Connector/J?

Comment by rakotoniaina [ 2020-09-10 ]

Hi markus

Currently we are using mysql connector. We will test the same configuration using mariadb connector/j and will get back to you asap

Regards

Comment by rakotoniaina [ 2020-09-10 ]

We have tested with mariadb connector/j and it is working now. Thank you very much for your support.
Regards,
Davida

Generated at Thu Feb 08 04:19:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.