after pawing through octobers messages on this mailing list I found out
that I can put the requesting ip's in /etc/hosts and everything is ok.
must be some bad mojo in glibc's resolver.
(I would hope redhat would come out with erratta for redhat8)
k
Joseph Bueno wrote:
> Try to upgrade glibc:
> https://rhn.redhat.com/errata/RHSA-2002-197.html
>
>
>
> quinn@stripped wrote:
>
>
>>>Description:
>>
>>I just installed redhat8 this weekend and am using the rpm's provided
>>by them. when mysql runs it will only run a single process. and even
>>worse... when I try and connect to port 3306 (even via telnet) the
>>process is immediately killed and safe_mysqld restarts it. it logs
>>the following to /var/log/mysqld.log
>>
>>Number of processes running now: 1
>>mysqld process hanging, pid 32456 - killed
>>021118 11:32:44 mysqld restarted
>>/usr/libexec/mysqld: ready for connections
>>
>>
>>
>>
>>>How-To-Repeat:
>>
>>any mysql command from a remote host will "hang" the process immediately.
>>even if I telnet to 3306 it immediately closes and reports the above
>>error.
>>
>>
>>>Fix:
>>
>>
>>
>>>Submitter-Id:
>>>Originator: Kevin Quinn
>>>Organization: BitWrench Incorporated
>>>MySQL support: none
>>>Synopsis: redhat8 mysql install not allowing remote connections
>>>Severity: critical
>>>Priority:
>>>Category: mysql
>>>Class:
>>>Release: mysql-3.23.52 (Source distribution)
>>
>>
>>>Environment:
>>
>>
>>System: Linux lug 2.4.18-14smp #1 SMP Wed Sep 4 12:34:47 EDT 2002 i686
>>i686 i386 GNU/Linux
>>Architecture: i686
>>
>>Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake
>>/usr/bin/gcc /usr/bin/cc
>>GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs
>>Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
>>--infodir=/usr/share/info --enable-shared --enable-threads=posix
>>--disable-checking --host=i386-redhat-linux --with-system-zlib
>>--enable-__cxa_atexit
>>Thread model: posix
>>gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
>>Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686
>>-D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' CXX='g++'
>>CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE
>>-D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions'
>> LDFLAGS=''
>>LIBC:
>>lrwxrwxrwx 1 root root 14 Nov 16 22:13 /lib/libc.so.6
>>-> libc-2.2.93.so
>>-rwxr-xr-x 1 root root 1235468 Sep 5 19:12
>>/lib/libc-2.2.93.so
>>-rw-r--r-- 1 root root 2233342 Sep 5 18:59 /usr/lib/libc.a
>>-rw-r--r-- 1 root root 178 Sep 5 18:50 /usr/lib/libc.so
>>Configure command: ./configure --prefix=/usr --exec-prefix=/usr
>>--bindir=/usr/bin --datadir=/usr/share --libdir=/usr/lib
>>--mandir=/usr/share/man --infodir=/usr/share/info --without-readline
>>--without-debug --enable-shared --with-extra-charsets=complex
>>--with-bench --localstatedir=/var/lib/mysql
>>--with-unix-socket-path=/var/lib/mysql/mysql.sock
>>--with-mysqld-user=mysql --with-extra-charsets=all --with-innodb
>>--enable-local-infile --enable-large-files=yes --enable-largefile=yes
>>--with-berkeley-db --with-thread-safe-client 'CFLAGS=-O2 -march=i386
>>-mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE'
>>'CXXFLAGS=-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE
>>-D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions'
>>
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread125203@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-quinn=bitwrench.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
--
Kevin Lee Quinn
BitWrench Incorporated
