Ambari Server安装失败解决

1.问题描述：    Ambari Server启动失败,通过ambari-server.log发现如下信息：

   

      10 Jul 2017 12:22:57,596 ERROR [main] DBAccessorImpl:106 - Error while creating database accessor 

                com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

                The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
                        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
                        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
                        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
                        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
                        at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
                        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:989)
                        at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:632)
                        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1016)

2.问题原因:

       /etc/ambari-server/conf/ ambari.properties 文件中，关于mysql的配置错，mysql访问端口应该为3306,而不是5432。错误配置如下：
       server.jdbc.driver=com.mysql.jdbc.Driver
       server.jdbc.database=mysql
       server.jdbc.rca.url=jdbc:mysql://node3:5432/ambari
       server.jdbc.rca.driver=com.mysql.jdbc.Driver
       server.jdbc.url=jdbc:mysql://node3:5432/ambari



3.解决办法：
   将5432端口改为3306即可。


参考：https://community.hortonworks.co ... -ambari-server.html