You are not logged in.
Pages: 1
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
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
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
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
it should be. 1918 addresses wont pass an upstream router with a config worth its salt.
"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
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
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
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
Thanks, juergen. Problem fixed.
Offline
Thank you from me, too. And a lesson in tcpwrappers-use. Ton
Offline
Pages: 1