From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from pigeon.gentoo.org ([208.92.234.80] helo=lists.gentoo.org) by finch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1OquXX-0000Oc-Bp for garchives@archives.gentoo.org; Wed, 01 Sep 2010 21:08:16 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 34C021C003; Wed, 1 Sep 2010 21:08:07 +0000 (UTC) Received: from mail-ew0-f53.google.com (mail-ew0-f53.google.com [209.85.215.53]) by pigeon.gentoo.org (Postfix) with ESMTP id EA08C1C003 for ; Wed, 1 Sep 2010 21:08:06 +0000 (UTC) Received: by ewy3 with SMTP id 3so1876954ewy.40 for ; Wed, 01 Sep 2010 14:08:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:from:to:subject:date :user-agent:references:in-reply-to:mime-version:content-type :content-transfer-encoding:message-id; bh=LwNKTpu7iXwCHJkEW2AW45xCeZVexe4jtXh4dvZlH/w=; b=d0C2imYrQcVafC9vh1FnMT3obufsDdKGZo9IXWmFF15FLYJ0gM5GE7koNkNCBupzVC yi2TvKgMGUd7YUAvDgoQc0KQHdoHK0G94QAlmJmjo6gA6xdfegJp9jtF38Yk02SAyEzF 2YiAFRR4ue2wvC15UnOZATIUR1SMnHMliC6d4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:to:subject:date:user-agent:references:in-reply-to:mime-version :content-type:content-transfer-encoding:message-id; b=C2eUgl1paaUypdbmzWM6mJ2IaNS0vUx2LBZvmtTg29qf5GynGacpVVqGHvXL0YH+Nc 1oEPjwozs0JEbbS06s3CS9iZsZz1/fByocL7Z/3XA+kVJ1uD2ZU+K4LyS9osI0+KEyNW 9lEFoHmpHNgtE7AWEVYVjj10DL6fmSsrAyn9E= Received: by 10.213.48.193 with SMTP id s1mr873654ebf.20.1283375286365; Wed, 01 Sep 2010 14:08:06 -0700 (PDT) Received: from nazgul.localnet (196-210-183-214.dynamic.isadsl.co.za [196.210.183.214]) by mx.google.com with ESMTPS id v8sm16749274eeh.20.2010.09.01.14.08.04 (version=TLSv1/SSLv3 cipher=RC4-MD5); Wed, 01 Sep 2010 14:08:05 -0700 (PDT) From: Alan McKinnon To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] Proper way of updating mysql from 5.0.90-r2 to 5.1.50? Date: Wed, 1 Sep 2010 23:05:05 +0200 User-Agent: KMail/1.13.5 (Linux/2.6.35-ck-r2; KDE/4.4.5; x86_64; ; ) References: <4C7D3C94.2070602@gmail.com> <201009012200.16350.mailingdotlist@gmail.com> In-Reply-To: Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <201009012305.05409.alan.mckinnon@gmail.com> X-Archives-Salt: 9aa15a32-aa47-4b59-a8e7-1a39ec932b71 X-Archives-Hash: c8d4c60352ad6b03f6f1473e26120108 Apparently, though unproven, at 22:15 on Wednesday 01 September 2010, Mick did opine thusly: > 2010/9/1 Aniruddha : > > On Tuesday 31 August 2010 20:30:55 Mick wrote: > >> > But this is apparently not the proper way, because after > >> > restarting the server, apache does not show my web-page > >> > reporting there is no such a database. I checked it with > >> > phpmyadmin, and really, there is absolutely no database > >> > in mysql! > >> > > >> > I quickly restored backup version which I have done just > >> > before trying mysql-update, so my web-site is up and running. > >> > Now I would like to update mysql the right way, I but do not > >> > know how to do it... > >> > >> Hi Jarry, > >> > >> Some years ago I ran into some similar problem, I can't recall exactly > >> what. Lost in folklore (wiki?) were some instructions to first stop > >> mysql before you update it and I have been following them since. > >> > >> I stop apach & mysql, run the update, dispatch-conf and then restart > >> them both. Haven't had problems since. > >> > >> There may be a better way for doing this - in which case others who know > >> better will hopefully chime in. > > > > I'm curious as well. Imo it shouldn't be necessary to stop mysql server > > for each update. > > Actually, this problem may be more sinister ... a bug? > > I also updated to the latest stable and as soon as I tried to restart > apache I got: > ========================================= > # /etc/init.d/apache2 start > * apache2 has detected an error in your setup: > apache2: Syntax error on line 155 of /etc/apache2/httpd.conf: Syntax error > on line 4 of /etc/apache2/modules.d/70_mod_php5.conf: Cannot load > /usr/lib/apache2/modules/libphp5.so into server: libmysqlclient.so.15: > cannot open shared object file: No such file or directory > ========================================= > > What the ... ? > > Line 155 of my /etc/apache2/httpd.conf says: > > Include /etc/apache2/modules.d/*.conf > > Line 4 of /etc/apache2/modules.d/70_mod_php5.conf, says: > > LoadModule php5_module modules/libphp5.so > > Also, I seem to have modules/libphp5.so and is world readable: > > $ ls -la /usr/lib/apache2/modules/libphp5.so > -rw-r--r-- 1 root root 5720576 Aug 13 20:09 > /usr/lib/apache2/modules/libphp5.so > > > I am downgrading now before a lynch mob arrives, but has anyone else > run into this problem? > > PS. I'm running www-servers/apache-2.2.16 You got so close to the real answer, just one more step :-) $ ldd /usr/lib64/apache2/modules/libphp5.so | grep mysql libmysqlclient_r.so.16 => /usr/lib64/mysql/libmysqlclient_r.so.16 (0x00007f185d528000) Think this through: you have a complex piece of software with it's config in memory. A library that uses a library uses a library. Then you remove that last library and replace it with version x+1. How do you expect the library in the middle of the chain to know about that? Via magic? Voodoo? Some automatic-check-if-stuff-changed-cron-job? No, you just simply restart services that use things that changed, especially if they used (then closed) the file you just changed. You might also need revdep-rebuild to get everything back 100%. It's all just situation-normal for a source based distro. Nothing you can, or should, try to "fix". -- alan dot mckinnon at gmail dot com