Ambari Ranger安装完成无法登陆Unable to connect DB

系统管理员 2023-06-16 07:51 54阅读 0赞

Ambari平台安装Ranger,一直都是正常安装,没报错,密码也对,就是登陆不上,研究了几天,期间装了好几次都一样,查看日志都是

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Cannot open jks [/etc/ranger/admin/conf/ranger-admin-keystore.jks (No such file or directory)]
    	at sun.reflect.GeneratedConstructorAccessor26.newInstance(Unknown Source)
    	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.Util.getInstance(Util.java:408)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
    	at com.mysql.jdbc.ExportControlled.getSSLSocketFactoryDefaultOrConfigured(ExportControlled.java:453)
    	at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:103)
    	at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4869)
    	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1656)
    	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1217)
    	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189)
    	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2220)
    	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2015)
    	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:768)
    	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    	at sun.reflect.GeneratedConstructorAccessor20.newInstance(Unknown Source)
    	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.ConnectionImpl.getInstance(ConnectionImpl.java:385)
    	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323)
    	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:1138)
    	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
    	at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
    	at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
    	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
    Caused by: java.io.FileNotFoundException: /etc/ranger/admin/conf/ranger-admin-keystore.jks (No such file or directory)
    	at java.io.FileInputStream.open0(Native Method)
    	at java.io.FileInputStream.open(FileInputStream.java:195)
    	at java.io.FileInputStream.<init>(FileInputStream.java:138)
    	at java.io.FileInputStream.<init>(FileInputStream.java:93)
    	at sun.net.www.protocol.file.FileURLConnection.connect(FileURLConnection.java:90)
    	at sun.net.www.protocol.file.FileURLConnection.getInputStream(FileURLConnection.java:188)
    	at java.net.URL.openStream(URL.java:1057)
    	at com.mysql.jdbc.ExportControlled.getSSLSocketFactoryDefaultOrConfigured(ExportControlled.java:422)
    	... 24 more

报以上错误,Google研究发现这个是缺少SSL连接证书,直接修改mysql连接信息,UseSSL=False即可正常登陆  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODc1MTUxMw_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODc1MTUxMw_size_16_color_FFFFFF_t_70 1]  
然后用admin账号和设置的admin密码就可以正常登陆  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODc1MTUxMw_size_16_color_FFFFFF_t_70 2]  
以上,原因我认为是Ranger连接MySQL数据库默认强制采用的SSL连接,而没有配置SSL证书,则会出现以上问题  
若采用SSL证书连接以下教程参考

> https://www.ibm.com/support/knowledgecenter/en/SSPT3X\_4.2.0/com.ibm.swg.im.infosphere.biginsights.admin.doc/doc/admin\_ranger\_ssl\_selfsigned\_admin.html

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODc1MTUxMw_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191125102152551.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODc1MTUxMw==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODc1MTUxMw_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/2019112510221167.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODc1MTUxMw==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODc1MTUxMw_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20191125102229578.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODc1MTUxMw==,size_16,color_FFFFFF,t_70