[jira] [Commented] (RANGER-3669) Connection to DB fails for MySQL version above 8.0
[ https://issues.apache.org/jira/browse/RANGER-3669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17538113#comment-17538113 ] Pradeep Agrawal commented on RANGER-3669: - have reverted this commit as wrong patch was committed. > Connection to DB fails for MySQL version above 8.0 > -- > > Key: RANGER-3669 > URL: https://issues.apache.org/jira/browse/RANGER-3669 > Project: Ranger > Issue Type: Improvement > Components: kms >Affects Versions: 3.0.0, 2.3.0 >Reporter: Vishal Suvagia >Assignee: Vishal Suvagia >Priority: Major > Fix For: 3.0.0, 2.3.0 > > Attachments: RANGER-3669.01.patch, RANGER-3669.patch > > > Observed that Ranger KMS DB setup fails when using with MySQL version above > 8.0. -- This message was sent by Atlassian Jira (v8.20.7#820007)
[jira] [Commented] (RANGER-3669) Connection to DB fails for MySQL version above 8.0
[ https://issues.apache.org/jira/browse/RANGER-3669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17522547#comment-17522547 ] gomathinayagam commented on RANGER-3669: all are saying to upgrade teh jdbc driver, not mentioned about passing connectionstring, if so please let me know. > Connection to DB fails for MySQL version above 8.0 > -- > > Key: RANGER-3669 > URL: https://issues.apache.org/jira/browse/RANGER-3669 > Project: Ranger > Issue Type: Improvement > Components: kms >Affects Versions: 3.0.0 >Reporter: Vishal Suvagia >Assignee: Vishal Suvagia >Priority: Major > Attachments: RANGER-3669.01.patch, RANGER-3669.patch > > > Observed that Ranger KMS DB setup fails when using with MySQL version above > 8.0. -- This message was sent by Atlassian Jira (v8.20.1#820001)
[jira] [Commented] (RANGER-3669) Connection to DB fails for MySQL version above 8.0
[ https://issues.apache.org/jira/browse/RANGER-3669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17522546#comment-17522546 ] gomathinayagam commented on RANGER-3669: how the below issue can be solved? more details here [https://bugs.mysql.com/bug.php?id=93042] ava.sql.SQLException: Unknown system variable 'query_cache_size' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381) > Connection to DB fails for MySQL version above 8.0 > -- > > Key: RANGER-3669 > URL: https://issues.apache.org/jira/browse/RANGER-3669 > Project: Ranger > Issue Type: Improvement > Components: kms >Affects Versions: 3.0.0 >Reporter: Vishal Suvagia >Assignee: Vishal Suvagia >Priority: Major > Attachments: RANGER-3669.01.patch, RANGER-3669.patch > > > Observed that Ranger KMS DB setup fails when using with MySQL version above > 8.0. -- This message was sent by Atlassian Jira (v8.20.1#820001)
[jira] [Commented] (RANGER-3669) Connection to DB fails for MySQL version above 8.0
[
https://issues.apache.org/jira/browse/RANGER-3669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17522179#comment-17522179
]
Vishal Suvagia commented on RANGER-3669:
[~gomesnayagam] , lets say we have jdbc with some additional flags which we
need to configure, in cases where need to add unicode and character-encoding
support for the jdbc url.
in that case we can set the below in install.properties.
{noformat}
is_override_db_connection_string=true
db_override_connection_string=jdbc:mysql://localhost:3306/test?autoReconnect=trueuseUnicode=truecharacterEncoding=UTF-8
{noformat}
This jdbc url should now be used during setup for communication with DB
> Connection to DB fails for MySQL version above 8.0
> --
>
> Key: RANGER-3669
> URL: https://issues.apache.org/jira/browse/RANGER-3669
> Project: Ranger
> Issue Type: Improvement
> Components: kms
>Affects Versions: 3.0.0
>Reporter: Vishal Suvagia
>Assignee: Vishal Suvagia
>Priority: Major
> Attachments: RANGER-3669.01.patch, RANGER-3669.patch
>
>
> Observed that Ranger KMS DB setup fails when using with MySQL version above
> 8.0.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
[jira] [Commented] (RANGER-3669) Connection to DB fails for MySQL version above 8.0
[ https://issues.apache.org/jira/browse/RANGER-3669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17519742#comment-17519742 ] gomathinayagam commented on RANGER-3669: can you provide e.g. for this value [~vishalsuvagia] is_override_db_connection_string=false db_override_connection_string= > Connection to DB fails for MySQL version above 8.0 > -- > > Key: RANGER-3669 > URL: https://issues.apache.org/jira/browse/RANGER-3669 > Project: Ranger > Issue Type: Improvement > Components: kms >Affects Versions: 3.0.0 >Reporter: Vishal Suvagia >Assignee: Vishal Suvagia >Priority: Major > Attachments: RANGER-3669.01.patch, RANGER-3669.patch > > > Observed that Ranger KMS DB setup fails when using with MySQL version above > 8.0. -- This message was sent by Atlassian Jira (v8.20.1#820001)
[jira] [Commented] (RANGER-3669) Connection to DB fails for MySQL version above 8.0
[ https://issues.apache.org/jira/browse/RANGER-3669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17508972#comment-17508972 ] Jeevan p commented on RANGER-3669: -- hello, im so sorry but this comment is not of any use to this issue, i can you kindly please look into this issue https://issues.apache.org/jira/browse/RANGER-3668 > Connection to DB fails for MySQL version above 8.0 > -- > > Key: RANGER-3669 > URL: https://issues.apache.org/jira/browse/RANGER-3669 > Project: Ranger > Issue Type: Improvement > Components: kms >Affects Versions: 3.0.0 >Reporter: Vishal Suvagia >Assignee: Vishal Suvagia >Priority: Major > > Observed that Ranger KMS DB setup fails when using with MySQL version above > 8.0. -- This message was sent by Atlassian Jira (v8.20.1#820001)
