mysql client connectiosn work fine on localhost, but connections
from other hosts on local area network fail with the following error:
ERROR 2013: Lost connection to MySQL server during query
This is an existing installation. I had mysql-3.23.33 working
and was trying to upgrade to a more current version. I tried
mysql-3.23.53 and a few days later mysql-3.23.54a (this try).
I was able to go back to mysql-3.23.33, which still works.
I just did a make install in the old build directory that I
still had online.
I may try recompiling 3.23.33 to try to verify that its not a
problem related to compile time changes. I don't think it is,
but its possible due to the time span between the working and
non-working builds.
I noticed that the configure line listed below doesn't match
the actual configure line I used. This may be normal, but
it caught my eye.
I used:
./configure --prefix=/local --with-libwrap=/local \
--with-charset=usa7 --with-mysqld-user=mysql \
--localstatedir=/local/dbdata
>Submitter-Id: <submitter ID>
>Originator: Aaron Martin
>Organization: Institute for Crustal Studies, UCSB
---------------------------------------------------------------------------
Aaron J. Martin (805) 893-8415 voice and message
Institute for Crustal Studies (805) 893-8649 FAX
Girvetz 1140E (805) 448-4120 SCEC Cellular
UC Santa Barbara [EMAIL PROTECTED]
Santa Barbara, CA 93106 http://www.crustal.ucsb.edu/~aaron
PBIC Lab 1252 Arts (805) 893-3758 voice
---------------------------------------------------------------------------
>
>MySQL support: none
>Synopsis: Error 2013: Lost connection to MySQL server
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.54 (Source distribution)
>Environment:
System: SunOS fablio 5.8 Generic_108528-17 sun4u sparc SUNW,Ultra-5_10
Architecture: sun4
Some paths: /bin/perl /usr/ccs/bin/make /net/quake/opt/bin/gmake /local/bin/gcc
/local/apps/SUNWspro/bin/cc
GCC: Reading specs from /local/lib/gcc-lib/sparc-sun-solaris2.8/3.0.4/specs
Configured with: /local/apps/gcc-3.0.4/configure --prefix=/local
Thread model: posix
gcc version 3.0.4
Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs
-Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings
-Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX='gcc'
CXXFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts
-Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual
-Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors
-fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' LDFLAGS=''
LIBC:
-rw-r--r-- 1 root bin 1788196 Dec 4 15:03 /lib/libc.a
lrwxrwxrwx 1 root root 11 Oct 24 2000 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 1157872 Dec 4 15:03 /lib/libc.so.1
-rw-r--r-- 1 root bin 1788196 Dec 4 15:03 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Oct 24 2000 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 1157872 Dec 4 15:03 /usr/lib/libc.so.1
Configure command: ./configure '--prefix=/usr/local/mysql' '--enable-assembler'
'--with-extra-charsets=complex' '--enable-thread-safe-client' '--with-innodb'
'--with-berkeley-db' 'CFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment
-W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused
-mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 'CXXFLAGS=-Wimplicit -Wreturn-type
-Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses
-Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder
-Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti
-mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 'CXX=gcc'
---------------------------------------------------------------------
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
