mysql assuming server is not running_ERROR 2013 (HY000): Lost connection to MySQL server at 'reading...

I am getting the following error

ERROR 2013 (HY000): Lost connection to MySQL server at

'reading authorization packet', system error: 0

when trying to connect to my MySQL server.

What I am doing:

I have Master - Slave replication in MySQL that is working and just added load balance capabilities using F5.

I have configured the F5 according to their site.

But when I am trying to connect to my MySQL server using the IP that the F5 was configured with I get

ERROR 2013 (HY000): Lost connection to MySQL server at

'reading authorization packet', system error: 0

Any ideas?

Update on my progress : ZERO

- i am getting the same error

I get no entries in the /var/log/secure as if somebody would try to authenticate coming form the ip where i had created my load balance server.

No enties in the mysql error log.

The command - returns nothing

mysql> SHOW GLOBAL STATUS LIKE 'Aborted_connections';

Empty set (0.00 sec)

I've already altered my my.cnf file and add the

[mysqld]

skip-name-resolve

Alterd the connect_timeout to 10.

So it seems i get no response for the server i have created on my F5

I finally convinced the F5 admin to pass me the log for the F5 server and i have exctraced all i need form it.

Here is the output :

Jan 28 15:46:39 tmm debug tmm[6459]: Rule /Common/iRule-f5_mysql_proxy : BIG-IP MySQL Proxy -- clientside initial connection

Jan 28 15:46:39 tmm debug tmm[6459]: Rule /Common/iRule-f5_mysql_proxy : BIG-IP MySQL Proxy -- clientside responding with server WELCOME packet

Jan 28 15:46:39 tmm debug tmm[6459]: Rule /Common/iRule-f5_mysql_proxy : BIG-IP MySQL Proxy -- clientside authenticated flag not set

Jan 28 15:46:39 tmm err tmm[6459]: Rule /Common/iRule-f5_mysql_proxy : BIG-IP MySQL Proxy -- mysql client: attempting to do something before authentication

Jan 28 15:46:39 tmm debug tmm[6459]: Rule /Common/iRule-f5_mysql_proxy : BIG-IP MySQL Proxy -- serverside selected pool /Common/foss-mysql-slave_pool node SLAVE-IP

Jan 28 15:46:39 tmm debug tmm[6459]: Rule /Common/iRule-f5_mysql_proxy : BIG-IP MySQL Proxy -- clientside connection closed from MASTER-IP(XXXXXXX)

Jan 28 15:46:39 tmm debug tmm[6459]: Rule /Common/iRule-f5_mysql_proxy : BIG-IP MySQL Proxy -- serverside connection closed from node SLAVE-IP(XXXXXXXX)

I've replaced the ip for security sake !

just as an extra - and i think is here the problem - my mysql version is 5.1.69-log

Thx All

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值