mysql getname_MYSQL : "Can't get hostname for your address"

于 2021-02-07 08:09:27 发布
阅读量148 收藏
点赞数
文章标签： mysql getname
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_33088763/article/details/113907388
版权

在做Docker集成WEB项目时，tomcat容器正常启动，MySQL容器正常启动，只是外部访问tomcat进行数据库操作时，应用报错如下：

Last packet sent to the server was 0 ms ago.); nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.Java:83)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)

at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)

at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)

at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)

at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)

at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:912)

at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:908)

at com.xgni.dao.impl.InstrumentsDaoImpl.findByProperty(InstrumentsDaoImpl.java:95)

at com.xgni.dao.impl.InstrumentsDaoImpl.findByIsJPTJ(InstrumentsDaoImpl.java:233)

at com.xgni.service.impl.InstrumentsServiceImpl.findByIsJPTJ(InstrumentsServiceImpl.java:98)

at com.xgni.controller.InstrumentController.initJPTJ(InstrumentController.java:496)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)

at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)

at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)

at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)

at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)

at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)

at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)

at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)

at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)

at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)

at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)

at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:442)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1083)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:640)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:724)

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)

at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)

at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)

at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)

at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)

at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)

at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)

at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1577)

at org.hibernate.loader.Loader.doQuery(Loader.java:696)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)

at org.hibernate.loader.Loader.doList(Loader.java:2232)

at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)

at org.hibernate.loader.Loader.list(Loader.java:2124)

at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)

at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)

at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)

at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)

at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)

at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:921)

at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:1)

at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)

... 77 more

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

Last packet sent to the server was 0 ms ago.

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:406)

at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2103)

at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:718)

at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)

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:406)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)

at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)

at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)

at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)

at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)

... 96 more

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communication link failure,  message from server: "Can't get hostname for your address"

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:406)

at com.mysql.jdbc.Util.getInstance(Util.java:381)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1095)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2031)

... 109 more

最重要的是最后的一个异常报错：Communication link failure,  message from server: "Can't get hostname for your address"

使用navicat远程连接时需要设置ssh选项，点击连接mysql时还需要输入操作系统用户密码才能登陆；

82bc2475aa0aa325705531c1bb80fff3.png

97f84467186ce69d2e747c0c82d3f185.png

3b9b6f649ed8ebf6d73665a290b915c5.png

造成这个异常的原因是mysql启动时，默认启用了域名解析或DNS解析，需要在mysql的控制文件中加入一个参数：skip-name-resolve ，通过命令

mysql --help|grep my查看mysql的配置文件地址/etc/my.cnf，在[mysqld]下添加skip-name-resolve 重新启动mysql或重启docker容器即可。

重启完成后，应用就可以正常操作数据库而不会报：message from server: "Can't get hostname for your address"，navicat连接数据库取消掉SSH选项，只需点击即可连接数据库。

8ff346d7273271486903e5d2055721eb.png

5e2160340d16214ec38de962ee6e8278.png

极兔
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
关于Mysql异常：Can't get hostname for your address的解决方法
qq_43217940的博客
04-06 714
Mysql异常：Communication link failure, message from server: "Can't get hostname for your address"的解决方法及验证 1.异常发现2.异常解决3.验证测试 ) 1.异常发现 在JDBC中用Eclipse与MySql通过DriverManager建立连接时，出现这样的错误（已导包）： com.mysql....
mysql : Can't get hostname for your address
谢绝留言与私信
04-02 645
前言 公司里有一台windows测试机，装着mysql5.5. 同事和我的计算机都在一个网段，他是win7, 我是win10. 用同样的连接参数，他用Navicat就正常，我连上去，报错：Can’t get hostname for your address 开始以为是我找的Navicat有问题，装了几个版本的Navicat都不行。 最后装mysql-installer-...
Can‘t get hostname for your address解决办法
热门推荐
小识的博客
11-19 2万+
前言意思是根据你的地址找不到主机名，试了在my.ini文件加各种东西还是不管用，看到能改服务就试了一下，果然就成功了，这个方法只限于本地访问MySQL数据库失败，要是你真是用网络服务，还是在my.ini文件中加各种东西吧打开服务页面，观察MySQL的服务是否为网络服务 我这里MySQL57已经改为本地系统了，原来是网络服务如果是网络服务，点击选中MySQL服务，右键打开属性设置为如下即可，
MySQL数据库连接错误：Can't get hostname for your address
浮生若梦的博客
07-04 2504
执行java类连接MySQL数据库时报错： “Communication link failure, message from server: “Can’t get hostname for your address” 解决方法： 1.在开始菜单中搜索“服务” 2.找到MySQL服务： 3.右键并修改属性，如下图所示： 4.再次运行Java即可，如果提示： “Establishi
数据库-mysql-Can't get hostname for your address
05-20 2579
昨天晚上活动开始之前，服务器上突然报Can't get hostname for your address
MySql连接错误：Can‘t get hostname for your address解决办法之小白篇
AdolphKevin的博客
04-26 1万+
最详细的MySql连接错误：Can't get hostname for your address 解决方法：适合小白
_.java:Java 8功能实用程序_ Belt
05-18
_.java Java 8功能实用程序_ Belt 例子 _ . map( Field :: getName, fields) currySum = _ . curry(( int a, int b) - > a + b); sumWith7 = currySum . apply( 7 ); 执照 麻省理工学院
BigDataAnalysis_Exp3:实时大数据分析_PageRank算法
05-16
实时大数据分析实验三——PageRank算法一、实验内容1.采用基于“抽税”法在MapReduce框架下，分析图1的网页PageRank排名；2.图1中，若节点②和节点⑤是主题节点，采用面向主题的...public String getName() {ret
详解spring开发_JDBC操作MySQL数据库
08-31
} public DataSource getDataSource() { return dataSource; } // JdbcTemplate setter和getter方法 public void setJdbcTemplate(JdbcTemplate jdbcTemplate) { this.jdbcTemplate = jdbcTemplate; } public ...
getname_main_python2
11-21
getname_main_python2................
java 导出mysql表结构至word文档
03-08
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password"); ``` 2. **获取表元数据**：通过`DatabaseMetaData`接口的`getColumns()`方法，可以获取指定...
LoadRunner使用odbc时报错can't get hostname for your address的解决方法
weixin_33924312的博客
04-09 93
此问题以前没有出现过，是这次在我带领的小强性能测试班中有个别同学出现了这个问题，正好也就整理下说下解决方法吧。此问题是由于检测hostname的时候出现的问题，解决方法如下：1、在本机的hosts文件中新加一行 127.0.0.1       localhost2、修改mysql的配置文件my.cnf，然后在[mysqld] 下面增加一行：skip-name-resolve，之后保存退出，再重启m...
MySql连接错误：Cannot get hostname for your address
tpl_01
05-11 982
01.MySql连接错误：Cannot get hostname for your address 郑昀 2010 隶属于《05.数据入库》小节   某Web应用的数据库部署在 100.ZZZ.YYY.XXX 的 MySql 5.5.5 实例（新装机器）上， 但是当用PHP或者Python从远端机器上试图访问该数据库时，会得到如下错误提示： “Can't get hostname for
MySQL有关1042 Can’t get hostname for your address的问题分析解决过程
系统 运维
08-12 264
[Comment 1]前同事企鹅上面说他安装的mysql 5.5，发现用mysql客户端远程连接的时候，报1042-Can’t get hostname for your address错误，但是权限已经grant了并且grant成功了。 这个报错的意思是“您的地址无法获得主机名”，我就想到了skip-name-resolve参数。 官方文档: --skip-name-resolve ...
MySQL数据库罕见的BUG——Can't get hostname for your address
weixin_30896511的博客
01-03 119
在连接mysql jdbc时候，抛出了 com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:Communicationlinkfailure,messagefromserver:"Can'tgethostnameforyouraddress" 的错误，无论是使用jdbc:mysql:...
MYSQL : "Can't get hostname for your address"
clm20482的博客
03-24 272
在做Docker集成WEB项目时，tomcat容器正常启动，MySQL容器正常启动，只是外部访问tomcat进行数据库操作时，应用报错如下： Last packet sent to the server...
MYSQL Communication link failure, message from server: "Can't get hostname for your address"
www_xue_xi的博客
03-24 4202
MYSQL Communication link failure, message from server: "Can't get hostname for your address"
Navicat连接数据库Can't get hostname for your address 解决方法
Thuantanon的博客
10-31 3345
我只是把自己遇到的问题分享出来，希望能解决大家的问题，特别是新手上路，很容易就因为一两个困难打击了学习的信心，编程是个耐心活儿，加油吧。
mysql连接错误：Cannot get hostname for your address
diaoyunsao6081的博客
11-10 329
问题 　　 　　环境：win7 + 64Bit + 本地mysql5.6　　 　　问题：navicat连接本地mysql数据库，提示“Cannot get hostname for your address”，但是连接其他远程mysql均没有问题，排除navicat客户端的问题。 　　试验：将localhost修改为本地ip：127.0.0.1，不起作用。 解决方...
设计一个类Person，实现以下方法： __init__():构造方法，带两个输入参数：姓名（字符串）和出生年份（整数） getAge()：返回年龄，当前年是2022年 getName()：返回姓名 __str__()：返回姓名、年龄的描述 设计一个子类Instructor，继承Person类，实现以下方法： __init__():构造方法，参数除了姓名和出生年份外，还包括学历 getDegree()：返回教师的学历 __str__()：返回姓名、年龄、学历的描述 设计一个子类Student，继承Pe
最新发布
05-25
def getName(self): return self.name def __str__(self): return f"{self.name}, {self.getAge()} years old" class Instructor(Person): def __init__(self, name, birth_year, degree): super().__init_...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值