Ambari server start always fails

[#1]

Hello,

I did a reboot/restart of my ec2 cluster and then when i try to start ambari server it always fails.

This is the screenshot,

This is the log info,

18 Jun 2020 05:13:37,523 ERROR [main] DBAccessorImpl:119 - Error while creating database accessor
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

I also tried to restart my server( I know that its not already running)

 

Can anyone help me in resolving this issue?

Thank you in Advance.

[#2]

@Udhav  check is database properties are correctly set in ambari.properties file

# cat /etc/ambari-server/conf/ambari.properties |grep -i jdbc

[#3]

@Scharan 

Hello, I dont know how to check because i am new to these, Can you help me check it out?

this is the output i got

udhav@ip-10-70-14-10:~$ cat /etc/ambari-server/conf/ambari.properties |grep -i jdbc
custom.mysql.jdbc.name=mysql-connector-java.jar
previous.custom.mysql.jdbc.name=mysql-connector-java.jar
server.jdbc.connection-pool=c3p0
server.jdbc.connection-pool.acquisition-size=5
server.jdbc.connection-pool.idle-test-interval=7200
server.jdbc.connection-pool.max-age=0
server.jdbc.connection-pool.max-idle-time=14400
server.jdbc.connection-pool.max-idle-time-excess=0
server.jdbc.database=mysql
server.jdbc.database_name=ambari
server.jdbc.driver=com.mysql.jdbc.Driver
server.jdbc.hostname=127.0.0.1
server.jdbc.port=3306
server.jdbc.rca.driver=com.mysql.jdbc.Driver
server.jdbc.rca.url=jdbc:mysql://127.0.0.1:3306/ambari
server.jdbc.rca.user.name=ambari
server.jdbc.rca.user.passwd=/etc/ambari-server/conf/password.dat
server.jdbc.url=jdbc:mysql://127.0.0.1:3306/ambari
server.jdbc.user.name=ambari
server.jdbc.user.passwd=/etc/ambari-server/conf/password.dat

Thank you!

[#4]

Hi @Udhav ,

Please check below solved post if it can help you with this issue.

https://community.cloudera.com/t5/Support-Questions/unable-to-start-ambari-server/td-p/158488

[#5]

@Udhav From the output I see database is running on ambari server host , Can you check is mysql is  up and running 

[#6]

@Udhav It appears your mysql is not running after a restart.  Try this:

service mariabdb start
chkconfig mariadb on

Also, I would refrain from using "localhost" or "127.0.0.1".  This opens doors for networking and permissions issues.   Please always use an FQDN, for example: c3701.ambari.apache.org that is mapped to public IP addresses on any given node via /etc/hosts.  That FQDN should also be the hostname for each node as well.

If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.  

Thanks,

Steven @ DFHZ