[前][次][番号順一覧][スレッド一覧]

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 でのエラー:解決