| 主题 : 安装部署报错：java.net.SocketException: Can't assign requested address |
级别: 童生
 |
1# 发表于:2022-03-11 08:45:18 IP:72.3.*.*
|
||||
|---|---|---|---|---|---|
级别: 童生
|
3# 发表于:2022-03-14 01:48:42 IP:72.3.*.*
回复第2楼
用的是JEECMSx1.11.0_mysql_ROOT.zip tomcat 8, mysql 按照这个步骤安装的： 欢迎使用JEECMS，请按照以下步骤进行软件安装： 一、安装运行环境（JDK1.8+TOMCAT8+MYSQL5.6及以上，具体安装过程请参考 下载贴中的相关说明文档）; 二、将程序解压后的ROOT文件夹拷贝到tomcat安装目录下的webapps文件夹下（例如：D:\Tomcat8\webapps\）， application.properties 请自行切换 spring.profiles.active 属性值 application-beta.properties 测试环境配置文件 application-prod.properties 生产环境配置文件（不可管理菜单和接口功能） 三、修改jdbc信息 ROOT\WEB-INF\classes\application-prod.properties spring.datasource.driver-class-name=com.mysql.jdbc.Driver spring.datasource.url=jdbc:mysql://192.168.0.200:3306/jeecms?useUnicode=true&characterEncoding=UTF-8&useSSL=false spring.datasource.username=root spring.datasource.password=jlkj@jeecms9 spring.jpa.database-platform=MySQL5InnoDB 设置成自己数据库的信息 启动tomcat |
||
|---|---|---|---|
启用上面的那段，注释下面的那段配置
文件是这个文件
级别: 举人
 |
6# 发表于:2022-03-14 11:16:36 IP:72.3.*.*
回复第5楼
我安装这个修改后，碰到这个问题，是我数据库的配置没有配置好吗？ 2022-03-13 22:02:23.214 [localhost-startStop-1] WARN o.s.boot.autoconfigure.orm.jpa.DatabaseLookup - Unable to determine jdbc url from datasource org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta-data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:328) at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:356) at org.springframework.boot.autoconfigure.orm.jpa.DatabaseLookup.getDatabase(DatabaseLookup.java:72) #\u6570\u636E\u9A71\u52A8 spring.datasource.driver-class-name=com.mysql.jdbc.Driver spring.datasource.url=jdbc:mysql://localhost:3306/jeecms?characterEncoding=utf-8&serverTimezone=UTC&useSSL=false spring.datasource.username=root spring.datasource.password=12345678 spring.jpa.database-platform=MySQL5InnoDB #mysql,sqlserver\u7528select 1\uFF0Coracle\u6570\u636E\u5E93\u7528select 1 from dual #spring.datasource.hikari.connection-test-query=select 1 #mysql,sqlserver\u7528select 1\uFF0Coracle\u6570\u636E\u5E93\u7528select 1 from dual #spring.datasource.tomcat.validation-query=select 1 #hibernate\u662F\u5426\u663E\u793Asql\u6216\u683C\u5F0F\u5316\u663E\u793A spring.jpa.properties.hibernate.show_sql=false spring.jpa.properties.hibernate.format_sql=false 我通过客户端，是可以链接上mysql的 |
||
|---|---|---|---|
级别: 举人
|
9# 发表于:2022-03-14 11:25:56 IP:72.3.*.*
回复第8楼
2022-03-13 22:02:20.820 [localhost-startStop-1] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$673e606] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-03-13 22:02:21.097 [localhost-startStop-1] INFO org.springframework.web.context.ContextLoader - Root WebApplicationContext: initialization completed in 6012 ms 2022-03-13 22:02:21.974 [localhost-startStop-1] INFO com.zaxxer.hikari.HikariDataSource - HikariCP - Starting... 2022-03-13 22:02:23.204 [localhost-startStop-1] ERROR com.zaxxer.hikari.pool.HikariPool - HikariCP - Exception during pool initialization. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed 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.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.SQLError.createSQLException(SQLError.java:887) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:878) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:874) 这个错误 |
||
|---|---|---|---|
级别: 举人
|
10# 发表于:2022-03-14 11:26:46 IP:72.3.*.*
2022-03-13 22:02:23.214 [localhost-startStop-1] WARN o.s.boot.autoconfigure.orm.jpa.DatabaseLookup - Unable to determine jdbc url from datasource
org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta-data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:328) at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:356) at org.springframework.boot.autoconfigure.orm.jpa.DatabaseLookup.getDatabase(DatabaseLookup.java:72) |
||
|---|---|---|---|