Subject: mysql-client: network connection from localhost Package: mysql-client Version: 3.23.38-4 Severity: normal We maintain several servers with multiple IPs on each system as eth0:X. When connecting to "localhost" or to the main IP of the system (eth0) all operates okay, but if we connect to a virtual IP we get following error message: s-s6:~# mysql -h212.172.193.115 -uusername -p dbname Enter password: ERROR 2013: Lost connection to MySQL server during query What may be wrong? Connection from outside of other hosts in the network is okay again, only from localhost to virtual IPs do not work. # ifconfig eth0:5 eth0:5 inet addr:212.172.193.115 Bcast:212.172.193.255 Mask:255.255.255.0 mysql> select * from user; | Host | User | privs | s-s6 | root | all Y | localhost | root | all Y | % | username | all N mysql> select * from host; | Host | Db | privs | % | dbname | all Y mysql> select * from db; | Host | Db | User | privs | % | dbname | username | all Y Shalom! Andreas Edler -- System Information Debian Release: testing/unstable Kernel Version: Linux s-s6 2.2.17 #1 Sun Jun 25 09:24:41 EST 2000 i686 unknown Versions of the packages mysql-client depends on: ii debianutils 1.15 Miscellaneous utilities specific to Debian. ii libc6 2.2.3-6 GNU C Library: Shared libraries and Timezone ii libdbd-mysql-p 1.2216-1 mySQL database interface for Perl ii libdbi-perl 1.15-1 The Perl5 Database Interface by Tim Bunce ii libmysqlclient 3.23.38-4 mysql database client library ii libncurses5 5.2.20010318-2 Shared libraries for terminal handling ii libreadline4 4.2-3 GNU readline and history libraries, run-time ii libstdc++2.10- 2.95.4-0.01060 The GNU stdc++ library ii perl 5.6.1-3 Larry Wall's Practical Extracting and Report ii zlib1g 1.1.3-15 compression library - runtime --------------------------------------------------------------------- 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
