>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: <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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
