>Description:
Unf... this all started on the weekend when *nothing* had ostensibly
changed with my client's system, running vanilla RedHat 6.1. All of a sudden,
all client connections (e.g. $mysql -p test) would simply hang forever on
the password prompt. NOTHING. Tried mysqladmin, same thing. rc script
couldn't even kill the server... had to kill -9 it.
So I xferred the db's to a FreeBSD box I own (no problems there... :-), and
they worked fine. Must be a server problem. Instead of fiddling, I figured it
easier to purge the RPMS, reinstall, and resurrect from the dumpfiles. Upon
reinstalling them (after killing /var/lib/mysql), I found that it was hanging
on "Installing all prepared tables".
Okay... I never liked RPMS anyway. Compile from source. Configure goes fine,
make goes fine, install goes fine, mysql_install_db - BAM. Hangs in the same
place. Tried futzing with permissions and install prefixes to no avail.
Followed all install instructions *precisely*, removing all data, socket,
and pid files each time. Nada. Started scouring the web for fixes... found
*tons* of reports of this same problem, but no solutions that worked.
In Linux Install notes at mysql.com, found something saying that it's a
problem with older glibc versions (I'm using 2.1.3) and linuxthreads (I'm
using 0.7). Said it wouldn't be a problem if I used the binary distro (non-
RPM) since it's statically linked. Sweet! But, I only ran into the same
problems again. Hanging after "Installing all prepared tables".
Note that after each of these installs, I tried to run mysqld (using the
safe_ wrapper) as mysql, with --skip-grant-tables, but I only kept running
into the original problem: the server doesn't respond to *anything*. Gotta
kill -9.
This problem has been reported a gazillion times, and I'm terribly sorry if
I'm just not R'ingTFM, but I swear I tried!!! Please help me! I'm going
insane!
>How-To-Repeat:
easy: try and run mysql_install_db on this here system!
>Fix:
To be determined
>Submitter-Id: <submitter ID>
>Originator: root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
mysql_install_db errors on RH6.1
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.23.33 (Official MySQL binary)
>Environment:
System: Linux riverside2.infowks.com 2.2.14-5.0 #1 Tue Mar 7 21:07:39 EST 2000 i686
unknown
Architecture: i686
Some paths: /usr/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/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc' CFLAGS='-O6 -mpentium ' CXX='gcc' CXXFLAGS='-O6
-mpentium -felide-constructors' LDFLAGS='-static'
LIBC:
lrwxrwxrwx 1 root root 13 Jan 31 1999 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 20272704 Feb 29 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Feb 29 2000 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official
MySQL binary' --with-extra-charsets=complex --enable-assembler
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared
Perl: This is perl, version 5.005_03 built for i386-linux
---------------------------------------------------------------------
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
