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