[MDEV-5229] MariaDB Galera does not accept remote connections Created: 2013-11-03  Updated: 2013-11-03  Resolved: 2013-11-03

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.33a-galera
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Ivan Zoratti (Inactive) Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: galera
Environment:

Ubuntu server 13.10 64 bit (saucy)

Attachments: HTML File ifconfig     File my.cnf     HTML File user_table    

 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.

 Comments   
Comment by Elena Stepanova [ 2013-11-03 ]

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.

Comment by Ivan Zoratti (Inactive) [ 2013-11-03 ]

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.

Comment by Ivan Zoratti (Inactive) [ 2013-11-03 ]

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

Comment by Elena Stepanova [ 2013-11-03 ]

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.

Generated at Thu Feb 08 07:02:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.