根據北京尚學堂視頻學習安裝，在配置CM Server數據庫時

執行命令提示錯誤如下：

./scm_prepare_database.sh mysql temp -h cdh1 -utemp -ptemp --scm-host cdh1 scm scm scm JAVA_HOME=/usr/java/jdk1.7.0_67 Verifying that we can write to /opt/cloudera-manager/cm-5.4.3/etc/cloudera-scm-server 2021-02-05 01:27:00,379 [main] ERROR com.cloudera.enterprise.dbutil.DbProvisioner - Exception when creating/dropping database with user 'temp' and jdbc url 'jdbc:mysql://cdh1/?useUnicode=true&characterEncoding=UTF-8' com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe 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:57)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)at java.lang.reflect.Constructor.newInstance(Constructor.java:526)at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1121)at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:357)at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2482)at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2519)at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2304)at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)at java.lang.reflect.Constructor.newInstance(Constructor.java:526)at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)at java.sql.DriverManager.getConnection(DriverManager.java:571)at java.sql.DriverManager.getConnection(DriverManager.java:215)at com.cloudera.enterprise.dbutil.DbProvisioner.executeSql(DbProvisioner.java:283)at com.cloudera.enterprise.dbutil.DbProvisioner.doMain(DbProvisioner.java:95)at com.cloudera.enterprise.dbutil.DbProvisioner.main(DbProvisioner.java:110) Caused by: java.net.UnknownHostException: cdh1: Name or service not knownat java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)at java.net.InetAddress$1.lookupAllHostAddr(InetAddress.java:901)at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1293)at java.net.InetAddress.getAllByName0(InetAddress.java:1246)at java.net.InetAddress.getAllByName(InetAddress.java:1162)at java.net.InetAddress.getAllByName(InetAddress.java:1098)at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:249)at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:307)... 17 more 2021-02-05 01:27:00,388 [main] ERROR com.cloudera.enterprise.dbutil.DbProvisioner - Stack Trace: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe 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:57)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)at java.lang.reflect.Constructor.newInstance(Constructor.java:526)at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1121)at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:357)at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2482)at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2519)at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2304)at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)at java.lang.reflect.Constructor.newInstance(Constructor.java:526)at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)at java.sql.DriverManager.getConnection(DriverManager.java:571)at java.sql.DriverManager.getConnection(DriverManager.java:215)at com.cloudera.enterprise.dbutil.DbProvisioner.executeSql(DbProvisioner.java:283)at com.cloudera.enterprise.dbutil.DbProvisioner.doMain(DbProvisioner.java:95)at com.cloudera.enterprise.dbutil.DbProvisioner.main(DbProvisioner.java:110) Caused by: java.net.UnknownHostException: cdh1: Name or service not knownat java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)at java.net.InetAddress$1.lookupAllHostAddr(InetAddress.java:901)at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1293)at java.net.InetAddress.getAllByName0(InetAddress.java:1246)at java.net.InetAddress.getAllByName(InetAddress.java:1162)at java.net.InetAddress.getAllByName(InetAddress.java:1098)at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:249)at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:307)... 17 more --> Error 1, giving up (use --force if you wish to ignore the error)

?

初步排查，更換mysql（centos6.5安裝時自帶的數據庫，版本5.1）驅動包，排除了驅動包版本問題。

最后排查，是/etc/hosts中忘記添加本地的解析地址，增加了

ip地址 cdh1

?

?

總結

以上是生活随笔為你收集整理的CDH 配置CM Server的数据库时错误的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。