[MCOL-2129] Add a new postConfigure flag to resolve submitted hostnames to correct reverse dns names Created: 2019-02-01  Updated: 2023-10-26  Resolved: 2019-04-04

Status: Closed
Project: MariaDB ColumnStore
Component/s: ?, installation
Affects Version/s: 1.2.2
Fix Version/s: 1.2.4

Type: New Feature Priority: Major
Reporter: Jens Röwekamp (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: containers, documentation, relnote

Issue Links:
Relates
relates to MCOL-2133 Enforce max hostname length of 60 cha... Closed
relates to MCOL-1607 postConfigure must support hostnames ... Closed
Sprint: 2019-01, 2019-02, 2019-03

 Description   

With the new postConfigure option -x (MCOL-1607) to not resolve hostnames to IP addresses the replication of multi node UM setups fails, if hostnames are entered whose IP address doesn't resolve into the entered hostname via reverse dns lookup.

In this case the replication connection from the secondary um to the primary fails, as the secondary's um's wrong hostname is stated in mysql.user.

This ticket should solve the issue by introducing an optional flag to -x that translates the entered hostname in postConfigure into its reverse dns lookup hostname.

 Comments   
Comment by Jens Röwekamp (Inactive) [ 2019-02-01 ]

Added postConfigure flag -xr to reverse lookup the submitted hostnames and use the returned name instead.

Comment by Daniel Lee (Inactive) [ 2019-04-04 ]

Build verified: 1.2.3-1 ColumnStore Docker

The fix was actually in 1.2.3-1

https://github.com/mariadb-corporation/mariadb-columnstore-docker.git

Followed instructions to do a docker setup for 2um2pm stack.

and verified the stack is working properly.

Also verified the reverse dns lookup is working.

[dlee@master columnstore_zeppelin]$ sudo docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
7f6799b2bba3 mariadb/sandboxzeppelin "/zeppelin/bootstrap…" 13 minutes ago Up 13 minutes 0.0.0.0:8080->8080/tcp columnstorezeppelin_zeppelin_1
d120b997595b mariadb/columnstore:1.2 "docker-entrypoint.s…" 13 minutes ago Up 13 minutes 3306/tcp columnstorezeppelin_pm1_1
5d3526793194 mariadb/columnstore:1.2 "docker-entrypoint.s…" 13 minutes ago Up 13 minutes 0.0.0.0:3307->3306/tcp columnstorezeppelin_um2_1
12c0f9521f24 mariadb/columnstore:1.2 "docker-entrypoint.s…" 13 minutes ago Up 13 minutes 3306/tcp columnstorezeppelin_pm2_1
8900481df985 mariadb/columnstore:1.2 "docker-entrypoint.s…" 13 minutes ago Up 13 minutes 0.0.0.0:3306->3306/tcp columnstorezeppelin_um1_1
[dlee@master columnstore_zeppelin]$ sudo docker exec -it columnstorezeppelin_um1_1 /bin/bash

[root@8900481df985 /]# ls
anaconda-post.log dev docker-entrypoint.sh home lib64 media opt root sbin sys usr
bin docker-entrypoint-initdb.d etc lib log mnt proc run srv tmp var
[root@8900481df985 /]# ping um2 -c2
PING um2 (10.5.0.3) 56(84) bytes of data.
64 bytes from columnstorezeppelin_um2_1.columnstorezeppelin_mcsnet (10.5.0.3): icmp_seq=1 ttl=64 time=0.039 ms
64 bytes from columnstorezeppelin_um2_1.columnstorezeppelin_mcsnet (10.5.0.3): icmp_seq=2 ttl=64 time=0.129 ms

— um2 ping statistics —
2 packets transmitted, 2 received, 0% packet loss, time 999ms
rtt min/avg/max/mdev = 0.039/0.084/0.129/0.045 ms
[root@8900481df985 /]# mcsmysql mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@8900481df985 /]# mcsmysql mysql -ppass
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 58
Server version: 10.3.13-MariaDB-log Columnstore 1.2.3-1

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [mysql]> quit

[root@8900481df985 /]# nslookup 10.5.0.3
Server: 127.0.0.11
Address: 127.0.0.11#53

Non-authoritative answer:
3.0.5.10.in-addr.arpa name = columnstorezeppelin_um2_1.columnstorezeppelin_mcsnet.

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