Getting access denied in MariaDB for Reports Manager database user

[#1]

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)

[#2]

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

[#3 · Accepted solution]

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

[#4]

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!!!