MySQL Bugs: #46476: name reslove not working

Bug #46476	name reslove not working
Submitted:	30 Jul 2009 13:53	Modified:	30 Jul 2009 20:56
Reporter:	Kaloyan Kovachev	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: General	Severity:	S2 (Serious)
Version:	mysql-cluster-gpl-7.0.6	OS:	Linux
Assigned to:		CPU Architecture:	Any
Tags:	5.1.34

Description:
After upgrade from cluster 6.3.20 (with 5.1.30) i get "ERROR 1130 (HY000): Host 'X.X.X.X' is not allowed to connect" even the DNS is working properly and both the hostname points to the IP and the IP points to the same host. Also tested by adding it in the hosts file without luck. After reinstalling back 6.3.20 the login works fine without any changes.

The ndb storage is not configured and used yet, so it is server problem not cluster

How to repeat:
on fresh install create user root@some_hostname_not_IP and attempt login not to localhost, but to the hostname

tested on Windows and the problem is not present so it is OS/installation specific ... adding additional info:
 OS Slackware 12.1.0
 CPU Pentiu4 2.4 GHz
 Kernel SMP 2.6.26.3 (vanilla custom config)
 mysql compiled from source with:
 ./configure --prefix=/usr --with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysql/mysql.sock --localstatedir=/var/lib/mysql --enable-assembler --with-charset=utf8 --with-extra-charsets=all --without-debug --enable-thread-safe-client --with-ssl --with-big-tables --with-mysqld-ldflags=-rdynamic --with-client-ldflags=-rdynamic --with-collation=utf8_general_ci --with-pic --with-pthread --with-plugins=all

looking at the source (and after some tests) i think it is related to the conversion of vio->remote to struct sockaddr (vio/viosocked.c) - i have applied the patch from bug 45817 and issued 'show hosts' after several login attempts and after each of them i got a row for different IP which was incremented on each attempt and had nothing to do with the actual IP of the connecting host, so it is probably 'shifted' and the src port comes as part of the checked IP

I have tried using the code from 6.3.20 'my_inet_ntoa(vio->remote.sin_addr,buf)', but i got a compilation error that the structure has no member named remote.sin_addr

Any hints of how to pinpoint and resolve the problem?

Thank you for the report.

This looks like duplicate of bug #46336/bug #38247. Please check if you experience same problem and update the report. Thanks in advance.

Yes it is a duplicate, sorry i didn't found them initially. Will try the patch from http://lists.mysql.com/commits/76095 ... where should i report the update: here or in some of the duplicates (38247)?

P.S. it is the same on Windows - i was able to login because of another wildcard user, but removing it caused the same behavior

Thank you for the feedback.

I mark this as duplicate of bug #46336 and link these reports. Please subscribe to bug #46336 to get updates.

> Will try the
> patch from http://lists.mysql.com/commits/76095 ... where should i
> report the update: here or in some of the duplicates (38247)?

As I link reports you can report update in any, but better if you do in bug #46336