mysql:7810
From: "Shinichi.Izumi" <"Shinichi.Izumi" <izumi@xxxxxxxxxx>>
Date: Fri, 23 May 2003 08:33:30 +0900
Subject: [mysql 07810] Re: MyODBC でのエラー:解決
和泉です。 下記の記事で解決情報がありました。 http://cobalt-forum.sun.com/forum/index.php?t=msg&th=1306&start=0&rid=&S=d2a f3497d5e1221c5a8da63653c4b037 症状は、johnharmanと同じで ----------------------------------------------------------------- [Re: Raq550 :RaQ550-All-Security-0.0.1-15578: Latest update glibc - mysql remote connections fail Wed, 23 April 2003 06:59] I am getting the same thing here, we have a totally stock 550 without anything from pkgmaster or the likes. When I do rpm -qa|grep MySQL I get MySQL-client-3.23.54a-1C1 MySQL-Max-3.23.54a-1C1 MySQL-devel-3.23.54a-1C1 MySQL-shared-3.23.54a-1C1 MySQL-3.23.54a-1C1 It was all working fine until I installed the bluelinq patches released last week (including the glibc one mentioned above). I now also get Error 2013: Lost connection to MySQL server during query whenever I try to connect remotely, yet connections work fine if I use MySQL from an SSH connection. If I have an SSH connection up as root when I try to connect remotely (e.g. from mysql on a win98 box) I see the following message: /usr/bin/safe_mysqld: line 278: 7981 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1 Number of processes running now: 1 mysqld-max process hanging, pid 7984 - killed 030423 11:21:47 mysqld restarted Any help much appreciated ---------------------------------------- のようなメッセージです。 最終的に、 ------------------ I finally got it to work by adding --skip-name-resolve to the startup in /etc/rc.d/init.d/mysql mysql's support site is quite good and I found the answer there. one caveat - you can't use hostname in your mysql Host field - only IP addresses ------------------ との事で、 my.cnfに ------------------ [mysqld] skip-name-resolve ------------------ の一行を付け足すことで動きました。 AKI様ありがとうございました。 解決ソースを発見してくださった管理者の方々にも感謝です。 和泉慎一 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.481 / Virus Database: 277 - Release Date: 2003/05/13
7733 2003-05-17 11:10 [A.K.I. <aki@xxxxxxxx] Re: MyODBC でのエラー 7737 2003-05-18 10:03 ┣["Shinichi.Izumi" <iz] 7766 2003-05-20 14:35 ┗["Shinichi.Izumi" <iz] 7772 2003-05-22 21:34 ┗[A.K.I. <aki@xxxxxxxx] 7774 2003-05-21 00:12 ┗["Shinichi.Izumi" <iz] 7775 2003-05-23 01:05 ┗[A.K.I. <aki@xxxxxxxx] 7780 2003-05-21 11:36 ┣["Shinichi.Izumi" <iz] 7781 2003-05-21 12:29 ┃┗[A.K.I. <aki@xxxxxxxx] 7783 2003-05-21 12:36 ┃ ┗["Shinichi.Izumi" <iz] 7782 2003-05-21 12:32 ┗["Shinichi.Izumi" <iz] 7784 2003-05-21 12:35 ┗[A.K.I. <aki@xxxxxxxx] -> 7810 2003-05-23 08:33 ┗["Shinichi.Izumi" <iz] Re: MyODBC でのエラー:解決