hi , i have connected to the database and solved the above problem . However, the next issue that i have come into is that :- 1. https://doris.apache.org/docs/admin-manual/auth/ranger doc tells us to directly place the files in a specific directory which is ranger-plugins/doris/ but when i went to the rid of ranger-plugin there was no directory named doris . 2. after creating and following the steps i came to a part where in the jdbc connection that is being used by Ranger internally is encrypting the password making it unable to connect to the database and fetch any informations. ERROR [DorisConnectionManager.java:58] Error connecting to Doris cluster: doris using config: {jdbc.driver_class=com.mysql.cj.jdbc.Driver, password=PBEWithHmacSHA512AndAES_128,tzL1AKl5uc4NKYaoQ4P3WLGIBFPXWPWdu1fRm9004jtQiV,f77aLYLo,1000,3aiGVYKA3muXXIPztnyXfA==,T2XMMgSAnIE6+T7xYeUY+Q==, enable.hive.metastore.lookup=false, resource.lookup.timeout.value.in.ms=10000, hive.site.file.path=, jdbc.url=jdbc:mysql://--------030?useSSL=false, username=admin} org.apache.ranger.plugin.client.HadoopException: Unable to connect to Presto instance. at org.apache.ranger.services.doris.client.DorisClient.initConnection(DorisClient.java:144) at org.apache.ranger.services.doris.client.DorisClient.access$000(DorisClient.java:47) at org.apache.ranger.services.doris.client.DorisClient$1.run(DorisClient.java:72) at org.apache.ranger.services.doris.client.DorisClient$1.run(DorisClient.java:70) at java.base/java.security.AccessController.doPrivileged(Native Method) at java.base/javax.security.auth.Subject.doAs(Subject.java:361) at org.apache.ranger.services.doris.client.DorisClient.init(DorisClient.java:70)
is there a turnaround for this such that ranger does not use the encrypted password instead use a string based plain-text-password as the database [APACHE DORIS] does not support encrypted password. On Thu, 30 Jan 2025 at 15:29, Loïc CHANEL <loic.cha...@telecomnancy.net> wrote: > Hi, > > Are you able to connect to the database with the same credentials you set > in the setup ? > Regards, > > > Loïc CHANEL > Technical leader Big Data > Capgemini (Lyon, France) > > > Le jeu. 30 janv. 2025 à 08:36, Gagan M <gaga...@qi-cap.com> a écrit : > >> ERROR [ServiceDBStore.java:2032] ServiceDBStore.initStore(): Failed to >> update DB: >> org.springframework.transaction.CannotCreateTransactionException: Could not >> open JPA EntityManager for transaction; nested exception is >> javax.persistence.PersistenceException: Exception [EclipseLink-4002] >> (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): >> org.eclipse.persistence.exceptions.DatabaseException >> Internal Exception: java.sql.SQLException: Access denied for user >> 'rangeradmin'@'localhost' (using password: YES) >> Error Code: 1045 >> 2025-01-30 07:19:29,440 [localhost-startStop-1] INFO >> [RangerCSRFPreventionFilter.java:93] Adding cross-site request forgery >> (CSRF) protection >> 2025-01-30 07:19:30,516 [localhost-startStop-1] INFO >> [RangerJsonProvider.java:42] RangerJsonProvider() instantiated >> 2025-01-30 07:32:52,164 [http-nio-6080-exec-1] ERROR >> [HikariPool.java:594] HikariPool-1 - Exception during pool initialization. >> java.sql.SQLException: Access denied for user 'rangeradmin'@'localhost' >> (using password: YES) >> at >> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) >> at >> com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) >> at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:833) >> at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:453) >> at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) >> at >> com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) >> at net.sf.log4jdbc.DriverSpy.connect(DriverSpy.java:728) >> at >> com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) >> >
