You are not logged in.

#1 2006-01-20 02:40:51

peart
Member
From: Kanuckistan
Registered: 2003-07-28
Posts: 510

My MySQL is borked :(

Hello,

I was wondering if someone with mysql (with TCP enabled) could try this:

mysql --user=user --password=pswd --protocol=TCP --host=192.168.0.2 --port=3306 db_name

Everything was working fine a few weeks ago, and non-TCP connections to the database still work.  I've upgraded mysql to 5.0.18 using pacman, and I assume that's when things stopped working.  But I haven't found the solution yet...

TIA

Edit: When I run the above command, I immediately get this:

ERROR 2013 (HY000): Lost connection to MySQL server during query

Offline

#2 2006-01-20 03:04:50

cactus
Taco Eater
From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰
Registered: 2004-05-25
Posts: 4,622
Website

Re: My MySQL is borked :(

check your /etc/my.cnf
if you have 'skip-networking' in there..it will not listen on any interfaces.


"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

Offline

#3 2006-01-20 03:47:06

peart
Member
From: Kanuckistan
Registered: 2003-07-28
Posts: 510

Re: My MySQL is borked :(

Nope, that's not it.  Skip-networking is commented out, and MySQL is definitely listening on port 3306.

I would appreciate it if someone could run the command in my previous post.  Since TCP connections were working just fine with MySQL 5.0.17, I doubt that the problem is with the config.  I'm under the impression that the newer package has a bug, but I'd like confirmation before filing a bug.

Thanks again

Offline

#4 2006-01-20 03:51:01

elasticdog
Member
From: Washington, USA
Registered: 2005-05-02
Posts: 995
Website

Re: My MySQL is borked :(

Just running the command won't work for other people...if I'm not mistaken, isn't <code>192.168.0.2</code> an IP on your local network?

Offline

#5 2006-01-20 03:56:19

cactus
Taco Eater
From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰
Registered: 2004-05-25
Posts: 4,622
Website

Re: My MySQL is borked :(

it should be. 1918 addresses wont pass an upstream router with a config worth its salt.
wink


"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

Offline

#6 2006-01-20 03:56:48

peart
Member
From: Kanuckistan
Registered: 2003-07-28
Posts: 510

Re: My MySQL is borked :(

Yes, 192.168.0.2 is a non-routable address.  I'd like people to try the same command on their installation of mysql - supplying their IP, user, password and db_name.  I already know my instance is borked, I want to know if it's the same for everybody, or just me.

If several people get the same error message, I'm filing a bug.  If it's just me, I'm tearing my hear out, or jumping off my balcony.

Offline

#7 2006-01-22 03:05:52

tpb
Member
From: Pittsburgh, PA
Registered: 2005-11-27
Posts: 17

Re: My MySQL is borked :(

Don't jump off the balcony just yet...

I've tried the command you've suggested for MythTV application. I am busy creating a second frontend on a separate PC which requires accessing the MythTV master backend and the MySQL database over TCP/IP instead of through a socket on the local machine.

mysql --user=mythtv --password=mythtv --protocol=TCP --host=192.168.1.80 --port=3306 mythconverg

for me gives

ERROR 2013 (HY000): Lost connection to MySQL server during query

I've been browsing the net, mailinglists and the MySQL 5.0 manuals, but cannot find anything on this specific behavior. I've added a bind-address line in /etc/my.cnf in addition to the socket specification, but it does not seem to help. Also, phpMyAdmin keeps insisting MySQL runs on localhost.

mysql 5.0.18-1
kernel26 2.6.15-2

P.S.
With mysql 5.0.17-1 (same kernel package) the command executes just fine.

Offline

#8 2006-01-22 21:37:52

juergen
Developer
From: Frankfurt/Germany
Registered: 2005-04-11
Posts: 48
Website

Re: My MySQL is borked :(

tpb wrote:

ERROR 2013 (HY000): Lost connection to MySQL server during query

This is most likely a tcpwrappers issue. See

http://bugs.archlinux.org/task/3818

Jürgen

Offline

#9 2006-01-23 15:27:06

peart
Member
From: Kanuckistan
Registered: 2003-07-28
Posts: 510

Re: My MySQL is borked :(

Thanks, juergen.  Problem fixed.

Offline

#10 2006-01-24 02:10:30

tpb
Member
From: Pittsburgh, PA
Registered: 2005-11-27
Posts: 17

Re: My MySQL is borked :(

Thank you from me, too. And a lesson in tcpwrappers-use. Ton

Offline

Board footer

Powered by FluxBB