Comments (5)
I get the same problem, but for all hosts throughout my cluster. I'm using a
non-root user. The manual checks from any host to any host succeed, but MHA
checks fail:
--------------------------------------------------------------
Mon Aug 27 18:30:22 2012 - [debug] Connecting via SSH from
[email protected](10.248.86.135:22) to
[email protected](10.248.109.158:22)..
Permission denied (publickey).
Mon Aug 27 18:30:23 2012 - [error][/usr/share/perl5/MHA/SSHCheck.pm, ln107] SSH
connection from [email protected](10.248.86.135:22) to
[email protected](10.248.109.158:22) failed!
Mon Aug 27 18:30:24 2012 - [error][/usr/share/perl5/MHA/SSHCheck.pm, ln63]
Mon Aug 27 18:30:22 2012 - [debug] Connecting via SSH from
[email protected](10.248.109.158:22) to
[email protected](10.248.86.135:22)..
Permission denied (publickey).
Mon Aug 27 18:30:24 2012 - [error][/usr/share/perl5/MHA/SSHCheck.pm, ln107] SSH
connection from [email protected](10.248.109.158:22) to
[email protected](10.248.86.135:22) failed!
Mon Aug 27 18:30:25 2012 - [error][/usr/share/perl5/MHA/SSHCheck.pm, ln63]
--------------------------------------------------------------
And, for example:
--------------------------------------------------------------
ubuntu@ip-10-248-109-158:~$ ssh [email protected]
Welcome to Ubuntu 12.04 LTS (GNU/Linux 3.2.0-25-virtual x86_64)
...(other successful login text snipped)...
--------------------------------------------------------------
I'm perplexed. I'll be digging in as well, and if I solve it, I'll post back
here.
Original comment by [email protected]
on 27 Aug 2012 at 6:53
from mysql-master-ha.
Timeless...,
I think it is safe to suppose that mha is not ready for open source users ..
The author probably would prefer that you approach his commercial company and
purchase support to help with this.
I moved on, and suggest you do too .. percona extradb cluster (with galera) is
a very neat solution and is still opensource but with commercial support ..
google for it, and move onto that .. It offers you master-slave if that is what
you want, but it provides a better solution through clusters of n-nodes ...
Good luck ..
Original comment by [email protected]
on 27 Aug 2012 at 9:56
from mysql-master-ha.
Does the error repeat every time? Or do you sometimes succeed and sometimes get
errors? If you succeed sometimes, would you please try increasing MaxStartups
parameter in all sshd_config, restart sshd and try again?
Original comment by [email protected]
on 27 Aug 2012 at 10:27
from mysql-master-ha.
This seems to be exactly the same issue as I posted about here:
http://code.google.com/p/mysql-master-ha/issues/detail?id=13#c9 - I needed to
have my SSH key named "id_dsa" and then it worked.
Original comment by [email protected]
on 28 Aug 2012 at 12:17
from mysql-master-ha.
Hello,
I had the same error.
The solution is :
each server should have their pub key in their authorized_keys.
Original comment by [email protected]
on 30 Apr 2013 at 9:15
from mysql-master-ha.
Related Issues (20)
- mysql innodb locks during checks on slaves
- Plaintext password in output HOT 3
- Not support for detecting poor perfomance masters HOT 1
- Manual switching | alive Old master does't become new slave HOT 3
- MHA automatic failover stop when I shutdown Master machine
- If Active Master goes Down, Slave running MHA manager can become Master?. HOT 2
- MHA IP failover / firewall issues
- got the error during the failover test "Applying all logs succeeded. But starting slave failed" HOT 3
- masterha_check_repl skips all slave checks on MySQL 5.6 with GTID enabled HOT 3
- Do mysql master failover only when there are more than one slaves HOT 3
- Maunal purge_relay_logs crash my replication HOT 2
- Failover aborts due to 1053 - Query partially completed on the master HOT 2
- masterha_manager can not start on 3306 ,but 3313 ok
- Does mysql-master-ha work if I already have traditional mysql replication running? HOT 1
- masterha_check_repl says ssh config failed, BUT masterha_check_ssh was okay HOT 1
- alert-only mode instead of failover
- Master Failover completed successfully. Error Establishing Database Connection. HOT 2
- Documentation not available HOT 1
- masterha_check_repl crashing HOT 2
- MHA Scalability HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mysql-master-ha.