You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ranger.apache.org by Gagan M <ga...@qi-cap.com> on 2025/01/30 07:35:18 UTC
why is ranger not able to log in the server when all the permissions are given and also when the setup.sh is passed
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)
Re: why is ranger not able to log in the server when all the permissions are given and also when the setup.sh is passed
Posted by Gagan M <ga...@qi-cap.com>.
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 <lo...@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 <ga...@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)
>>
>
Re: why is ranger not able to log in the server when all the permissions are given and also when the setup.sh is passed
Posted by Loïc CHANEL <lo...@telecomnancy.net>.
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 <ga...@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)
>