Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Not a Bug
-
Affects Version/s: 5.5.33a-galera
-
Fix Version/s: None
-
Component/s: None
-
Labels:
-
Environment:Ubuntu server 13.10 64 bit (saucy)
Description
Ok - I am still scratching my head because I keep thinking it can't be, it's me, I am missing something very, very silly.
Anyway - I have installed MariaDB Galera 5.5.33a and I have setup a three node cluster. The environment is 3 Ubuntu servers 13.10 64 bit with 3 or 4 adapters, depending on the node (see attachment).
Galera replication works, 3306 is open, but I cannot connect to a DB from a remote client.
I thought there was something missing at OS level, so I installed a MariaDB 5.5.33 NO Galera, and it works with NO problems.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Hi Elena, nothing in the error log. But I will do more tests today and report. Hopefully it's just been me to much in a hurry and not seeing the obvious right in front of me!
Anyway, I will reply with more info by the end of the day.
Hi Again!
So I a ran some tests, I have reinstalled everything and it seems to work fine. I think the installation is completely messed up because I installed mariadb galera, mysql client and I had to move filed to make OpenStack work. So, the DB worked fine, but remote connections for whatever reason stopped working.
But as I said, it is because of the mess I had to do with the installation - so, essentially, it is not a bug!
Thanks!
-ivan
Okay, thanks for the update.
In general, it would be interesting to know what exactly happened, because if it broke for you, it's bound to break for somebody else sooner or later.
But for now closing as "not a bug" based on the above.
Hi Ivan,
Is there anything suspicious in the log, like wsrep trying to guess some addresses, redefine, or whatever?
Are all these commented wsrep* lines in the cnf active when you run Galera?
What does the client say when it can't connect?
I seem to be able to connect to a remote Galera node all right, so it's not a general problem; but I don't have multiple interfaces, so maybe there is something about that. As far as I remember, wsrep does some guesswork based on network configuration (and some time ago it used to guess wrong in some cases), but so far I only saw it do so when wsrep_node_address wasn't set.