Skip to main content
jkoral
jkoral
Gold ⭐️
July 15, 2025
Solved

Getting access denied in MariaDB for Reports Manager database user

I am using MariaDB and CMS is up and running, but I am getting the following message in the logs for Reports Manager. I actually deleted the rman user, recreated the database, I logged into mysql with that user, but I am still getting access denied to the database. Any ideas?

com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@619cdccb -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (5). Last acquisition attempt exception:
java.sql.SQLException: Access denied for user 'rman'@'dmidlkprdls01.svr.luc.edu' (using password: YES)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:113)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:861)
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:449)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:234)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:180)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

upadhyayk04
upadhyayk04Answer
Gold ⭐️⭐️⭐️
July 16, 2025

Hello @jkoral 

Thank you for reaching out to the Cloudera Community

From the error it seems privilege issue. Could you please confirm if you have provided the below permission in the DB

 

GRANT ALL PRIVILEGES ON <db-name>.* TO 'rman'@'%';
GRANT ALL PRIVILEGES ON <db-name>.* TO 'rman'@'localhost';
GRANT ALL PRIVILEGES ON <db-name>.* TO 'rman'@dmidlkprdls01.svr.luc.edu' 

If not, please do the same and restart the Reports Manager.Ensure that you are providing the correct DB details in CMS >> Configuraiton >> Reports manager >> Database

We will be waiting for your response

Thank you

Kshitij Upadhyay

View in thread

3 replies

DianaTorres
Community Manager
DianaTorres
Community Manager
July 16, 2025

Hi @soychago @upadhyayk04 Do you have any insights here? Thanks!

Translate
Regards, Diana Torres, Senior Community Moderator
upadhyayk04
Gold ⭐️⭐️⭐️
upadhyayk04Answer
Gold ⭐️⭐️⭐️
July 16, 2025

Hello @jkoral 

Thank you for reaching out to the Cloudera Community

From the error it seems privilege issue. Could you please confirm if you have provided the below permission in the DB

 

GRANT ALL PRIVILEGES ON <db-name>.* TO 'rman'@'%';
GRANT ALL PRIVILEGES ON <db-name>.* TO 'rman'@'localhost';
GRANT ALL PRIVILEGES ON <db-name>.* TO 'rman'@dmidlkprdls01.svr.luc.edu' 

If not, please do the same and restart the Reports Manager.Ensure that you are providing the correct DB details in CMS >> Configuraiton >> Reports manager >> Database

We will be waiting for your response

Thank you

Kshitij Upadhyay

Translate
    jkoral
    jkoralAuthor
    Gold ⭐️
    July 16, 2025

    Kshitij,

    Wow, that worked like a charm. When I was granting privileges to the database, I was using the following statement for all three of those including the actual password, but that did not work for me.

    GRANT ALL ON rman.* TO 'rman'@'%' IDENTIFIED BY 'password';

    I am not really a DB person, so figured I would get the right solution from someone that is. I was going to say to keep an eye for my next posted issue regarding HDFS, but it looks like after fixing the DB issue and after restarting HDFS, we are all GREEN now!!!

    Translate
    Terms & ConditionsAccessibility statement