From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1GcTqm-0007TJ-Tl for garchives@archives.gentoo.org; Tue, 24 Oct 2006 21:30:21 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.8/8.13.6) with SMTP id k9OLRWCJ016394; Tue, 24 Oct 2006 21:27:32 GMT Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171]) by robin.gentoo.org (8.13.8/8.13.6) with ESMTP id k9OLPMTq021190 for ; Tue, 24 Oct 2006 21:25:22 GMT Received: by ug-out-1314.google.com with SMTP id p27so1458108ugc for ; Tue, 24 Oct 2006 14:25:22 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:date:from:to:subject:message-id:mail-followup-to:references:mime-version:content-type:content-disposition:in-reply-to:user-agent; b=Cs8mKyR0I15BD1bchz+RolcyK8u2HMFJ5N6JNV/SKBj+A6qyepdYS+NtuvP1bjSXUs+/+EDPLIY2/YUMz/3Nxz2ch6OS2BgWURuUWcwFhzIVKMgFJnqmVtLpByBdSbF9NkGRcBS94KetfhEYFKZp0wluGzQyyH2HOoetXm7V6zE= Received: by 10.67.89.5 with SMTP id r5mr9635691ugl; Tue, 24 Oct 2006 14:25:21 -0700 (PDT) Received: from gmail.com ( [67.160.57.222]) by mx.google.com with ESMTP id 72sm1082077ugb.2006.10.24.14.25.20; Tue, 24 Oct 2006 14:25:21 -0700 (PDT) Received: by gmail.com (nbSMTP-1.00) for uid 1000 (using TLSv1/SSLv3 with cipher DES-CBC3-SHA (168/168 bits)) kenji.malist@gmail.com; Tue, 24 Oct 2006 14:25:20 -0700 (PDT) Date: Tue, 24 Oct 2006 14:25:17 -0700 From: Neil Hodges To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] Weird mysql problem. Message-ID: <20061024212517.GB11738@hsd1> Mail-Followup-To: gentoo-user@lists.gentoo.org References: <7e7f5e710610241114i31c8af73v22f7c411d4b770b7@mail.gmail.com> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <7e7f5e710610241114i31c8af73v22f7c411d4b770b7@mail.gmail.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Archives-Salt: afafcdbb-fa07-4670-a96c-a5e76de4e0f8 X-Archives-Hash: a24b49cd615ea15757b8c14d189194fa Hello, This problem is well-known, and present in the bugzilla. The problem lies in MySQL 5.0.26-r1, and many threads in the forums have been spawned. - Neil On 14:14 Tue 24 Oct , A. R. wrote: > Hi, > > I am running Gentoo ~amd64 and I recently upgraded MySQL from > 5.0.26 to 5.0.26-r1 and things are not working anymore (for example mythtv). > > After spending a great deal of time looking at logs, changing > configuration files (namely, my.cnf), installing and de-installing > MySQL, I still cannot get any programs to connect to mysql, including > "mysql_secure_installation" which outputs the following error message: > > ERROR 2002 (HY000): Can't connect to local MySQL server through socket > ''/var/run/mysqld/mysqld.sock'' (2) > > But, here is the thing, the socket and pid file values in > /etc/mysql/my.cnf are set to the following: > > [client] > socket = /tmp/mysqld.sock > . > . > [mysqld] > socket = /tmp/mysqld.sock > pid-file = /tmp/mysqld.pid > > > > And, after re-starting the MySQL process (/etc/init.d/mysql restart) I > list the processes and find that the mysqld daemon has indeed been > passed the correct configuration values. > > mysql 24056 1 0 11:20 ? 00:00:00 /usr/sbin/mysqld > --defaults-file=/etc/mysql/my.cnf --basedir=/usr > --datadir=/storage/mysql-db --pid-file=/tmp/mysqld.pid > --socket=/tmp/mysqld.sock > > > Could someone please help? > I know I am running ~arch and that this is perhaps "part of the game" > in doing that, but maybe it can be easily fixed... > > Thank you, > > - AR > > -- > If you stare long enough into an abyss, the abyss will stare back into > you... > -- > gentoo-user@gentoo.org mailing list -- gentoo-user@gentoo.org mailing list