Member since
01-30-2020
10
Posts
0
Kudos Received
0
Solutions
02-16-2020
01:04 PM
Hi @AarifAkhter,
As this thread was marked 'Solved' 03-18-2017 you would have a better chance of receiving a resolution by starting a new thread. This will also provide the opportunity to provide details specific to your environment that could aid others in providing a more targeted answer to your question.
... View more
02-13-2020
02:23 PM
@AarifAkhter We see the error is cause by some DB access/connect Caused by: java.lang.RuntimeException: Error while creating database accessor
at org.apache.ambari.server.orm.DBAccessorImpl.<init>(DBAccessorImpl.java:120) So few queries: 1. Is this a newly setup ambari server? 2. Do you see the DataBase is running fine and the DB host/port is accessible ? 3. Are you using Embedded Postgres Database? 4. When was last time ambari server running fine? Any recent chances made to ambari server config/host ? I am suspecting that there should be some more detailed log like some more "Caused By" section in your ambari-server.log which is not copied fully in your last update. So can you please recheck your ambari log and let us know what was the first error and if you can share the Full stack trace. some times there are more than on "Caused By" section in a single stack trace.
... View more
02-12-2020
04:57 AM
@AarifAkhter
You need to create permissions within mysql for your ranger user.
An example of this is:
CREATE DATABASE ranger;
CREATE USER 'ranger'@'hdp.cloudera.com' IDENTIFIED BY 'ranger';
GRANT ALL PRIVILEGES ON *.* TO 'ranger'@'hdp.cloudera.com' WITH GRANT OPTION;
FLUSH PRIVILEGES;
where you replace in your hostname for ranger in place of hdp.cloudera.com above:
ip-xxx-xx-xx-xx.ec2.internal
I would also recommend to install using FQDNs (Fully Qualified Domain Names).
Please accept this answer as the solution to close the topic.
... View more
01-30-2020
05:02 AM
@AarifAkhter While setting up your maria DB have you performed the step mentioned in the doc as https://docs.cloudera.com/HDPDocuments/Ambari-2.5.2.0/bk_ambari-administration/content/using_ambari_with_mysql.html You must pre-load the Ambari database schema into your MySQL database using the schema script. Run the script in the same location where you find the Ambari-DDL-MySQL-CREATE.sql file. You should find the Ambari-DDL-MySQL-CREATE.sql file in the /var/lib/ambari-server/resources/ directory of the Ambari Server host, after you have installed Ambari Server. Ambari also shows this kind of message whenuser performs "ambari-server setup" while setting up the database. WARNING: Before starting Ambari Server, you must run the following DDL directly from the database shell to create the schema: /var/lib/ambari-server/resources/Ambari-DDL-MySQL-CREATE.sql . Also please let us know if your MariaDB instance running on "localhost" Or on "ip-172-31-9-188.xxxxxxxxxxxxxxx.internal" Can you please change the "localhost" to the hostname of the DB. server.jdbc.hostname=ip-172-31-9-188.xxxxxxxxxxxxxxx.internal Also please verify if the "MariaDB" exist on the mariaDB running on host 'ip-172-31-9-188.xxxxxxxxxxxxxxx.internal' # mysql -u ambari -p
Enter password:
show databases; .
... View more