RE: Cannot connect from WInXp > MYSQL server - help
I've been having the same problem with WinXP to MySQL running under a totally "up2date-ed" Red Hat 8 installation. What I did was to modify my /etc/my.cnf to look like: [mysqld] datadir=/raid/mysql socket=/raid/mysql/mysql.sock set-variable=max_allowed_packet=10M set-variable=thread_stack=1M [mysql.server] user=mysql basedir=/raid [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [client] port=3306 socket=/raid/mysql/mysql.sock That, according to a Bugzilla note at Red Hat (which, IIRC, mentions the problem being with glibc) should fix the problem. And it did - sort of. The MySQLGUI.exe Windows client could connect from WinXP, but Access databases through MyODBC would not. After taking a close look at the c:\my.cnf file: [mysqld] datadir=/raid/mysql socket=/raid/mysql/mysql.sock [mysql.server] user=mysql basedir=/raid [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid seems correct to me. There was one thing missing: When configuring the MyODBC driver, I had to check the option Read options from C:\my.cnf for this to work. The **really** strange thing is that I have a different database on the same RedHat 8 server, and I **didn't** have to select that option for it to connect... Cheers, Mike -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 25, 2003 7:18 PM To: Scott Lewis; [EMAIL PROTECTED] Subject: Re: Cannot connect from WInXp > MYSQL server - help Scott, most probably, you've got a glibc problem on your Red Hat box. Try upgrading to a newer version of glibc, and if the problem (mysqld dies when trying to connect from anywhere else than localhost) has gone, I was right :) (There was a very similar question a couple of days ago on this list. I don't know if the Red Hat problem is exactly the same as the SuSE problem I could solve by updating glibc, but the symptom is the same.) Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Scott Lewis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 25, 2003 6:51 PM Subject: Cannot connect from WInXp > MYSQL server - help > OK, > > I have a mysql server running on my home server. The main os is Redhat8. > > I know that Mysql is running on port 3306 as its showing as listening. I > ahve opened the tcp port for boh internal and external connections - fione. > I ahve also disbaled it to test aswell. > > Anyway - I have loaded several MYsql clients on my winxp pro pc on my home > LAN, eg Dbmanager. I ahve set the settinsg fine, and each time I try and > connection I get the error:- > > Lost connection to mysql durring query. > > In the loags it says:- > > Number of processes running now: 1 > mysqld process hanging, pid 2522 - killed > 030125 17:49:36 mysqld restarted > /usr/libexec/mysqld: ready for connections > > > So - its killing the pid, which I assume is my connections. > > Any ideas on what to look for. > > Scott > www.toptravelsites.net > www.myeyes-youreyes.co.uk > > > > - > 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 > - 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 - 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
Re: Cannot connect from WInXp > MYSQL server - help - cont.
I ahve upgraded to gcc v 3.2.7:- 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-redha t-linux --with-system-zlib --enable-__cxa_atexit Thread model: posix gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) I have also added the line:= set-variable = thread_stack=256K// Thats a uppercase 'K' in my my.cnf file Same bloady error. Ideas? Scott - Original Message - From: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]> To: "Scott Lewis" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, January 25, 2003 10:48 PM Subject: Re: Cannot connect from WInXp > MYSQL server - help > Scott, > > most probably, you've got a glibc problem on your Red Hat box. Try > upgrading to a newer version of glibc, and if the problem (mysqld dies > when trying to connect from anywhere else than localhost) has gone, I > was right :) > > (There was a very similar question a couple of days ago on this list. I > don't know if the Red Hat problem is exactly the same as the SuSE > problem I could solve by updating glibc, but the symptom is the same.) > > Regards, > -- > Stefan Hinz <[EMAIL PROTECTED]> > Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> > Heesestr. 6, 12169 Berlin (Germany) > Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 > > - Original Message - > From: "Scott Lewis" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, January 25, 2003 6:51 PM > Subject: Cannot connect from WInXp > MYSQL server - help > > > > OK, > > > > I have a mysql server running on my home server. The main os is > Redhat8. > > > > I know that Mysql is running on port 3306 as its showing as listening. > I > > ahve opened the tcp port for boh internal and external connections - > fione. > > I ahve also disbaled it to test aswell. > > > > Anyway - I have loaded several MYsql clients on my winxp pro pc on my > home > > LAN, eg Dbmanager. I ahve set the settinsg fine, and each time I try > and > > connection I get the error:- > > > > Lost connection to mysql durring query. > > > > In the loags it says:- > > > > Number of processes running now: 1 > > mysqld process hanging, pid 2522 - killed > > 030125 17:49:36 mysqld restarted > > /usr/libexec/mysqld: ready for connections > > > > > > So - its killing the pid, which I assume is my connections. > > > > Any ideas on what to look for. > > > > Scott > > www.toptravelsites.net > > www.myeyes-youreyes.co.uk > > > > > > > > - > > 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 > > > > > - > 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 > > - 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
Re: Cannot connect from WInXp > MYSQL server - help
Scott, most probably, you've got a glibc problem on your Red Hat box. Try upgrading to a newer version of glibc, and if the problem (mysqld dies when trying to connect from anywhere else than localhost) has gone, I was right :) (There was a very similar question a couple of days ago on this list. I don't know if the Red Hat problem is exactly the same as the SuSE problem I could solve by updating glibc, but the symptom is the same.) Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Scott Lewis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 25, 2003 6:51 PM Subject: Cannot connect from WInXp > MYSQL server - help > OK, > > I have a mysql server running on my home server. The main os is Redhat8. > > I know that Mysql is running on port 3306 as its showing as listening. I > ahve opened the tcp port for boh internal and external connections - fione. > I ahve also disbaled it to test aswell. > > Anyway - I have loaded several MYsql clients on my winxp pro pc on my home > LAN, eg Dbmanager. I ahve set the settinsg fine, and each time I try and > connection I get the error:- > > Lost connection to mysql durring query. > > In the loags it says:- > > Number of processes running now: 1 > mysqld process hanging, pid 2522 - killed > 030125 17:49:36 mysqld restarted > /usr/libexec/mysqld: ready for connections > > > So - its killing the pid, which I assume is my connections. > > Any ideas on what to look for. > > Scott > www.toptravelsites.net > www.myeyes-youreyes.co.uk > > > > - > 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 > - 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
Cannot connect from WInXp > MYSQL server - help
OK, I have a mysql server running on my home server. The main os is Redhat8. I know that Mysql is running on port 3306 as its showing as listening. I ahve opened the tcp port for boh internal and external connections - fione. I ahve also disbaled it to test aswell. Anyway - I have loaded several MYsql clients on my winxp pro pc on my home LAN, eg Dbmanager. I ahve set the settinsg fine, and each time I try and connection I get the error:- Lost connection to mysql durring query. In the loags it says:- Number of processes running now: 1 mysqld process hanging, pid 2522 - killed 030125 17:49:36 mysqld restarted /usr/libexec/mysqld: ready for connections So - its killing the pid, which I assume is my connections. Any ideas on what to look for. Scott www.toptravelsites.net www.myeyes-youreyes.co.uk - 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