Gentoo Archives: gentoo-user

From: Mick <michaelkintzios@×××××.com>
To: gentoo-user@l.g.o
Subject: Re: [gentoo-user] Proper way of updating mysql from 5.0.90-r2 to 5.1.50?
Date: Wed, 01 Sep 2010 20:16:33
Message-Id: AANLkTimoL=EPBCNxQCLpyr-fTt9CN1POYuxMpWRke1R_@mail.gmail.com
In Reply to: Re: [gentoo-user] Proper way of updating mysql from 5.0.90-r2 to 5.1.50? by Aniruddha
1 2010/9/1 Aniruddha <mailingdotlist@×××××.com>:
2 > On Tuesday 31 August 2010 20:30:55 Mick wrote:
3 >> > But this is apparently not the proper way, because after
4 >> > restarting the server, apache does not show my web-page
5 >> > reporting there is no such a database. I checked it with
6 >> > phpmyadmin, and really, there is absolutely no database
7 >> > in mysql!
8 >> >
9 >> > I quickly restored backup version which I have done just
10 >> > before trying mysql-update, so my web-site is up and running.
11 >> > Now I would like to update mysql the right way, I but do not
12 >> > know how to do it...
13 >>
14 >> Hi Jarry,
15 >>
16 >> Some years ago I ran into some similar problem, I can't recall exactly
17 >> what. Lost in folklore (wiki?) were some instructions to first stop mysql
18 >> before you update it and I have been following them since.
19 >>
20 >> I stop apach & mysql, run the update,  dispatch-conf and then restart them
21 >> both.  Haven't had problems since.
22 >>
23 >> There may be a better way for doing this - in which case others who know
24 >> better will hopefully chime in.
25 >
26 > I'm curious as well. Imo it shouldn't be necessary to stop mysql server for
27 > each update.
28
29 Actually, this problem may be more sinister ... a bug?
30
31 I also updated to the latest stable and as soon as I tried to restart
32 apache I got:
33 =========================================
34 # /etc/init.d/apache2 start
35 * apache2 has detected an error in your setup:
36 apache2: Syntax error on line 155 of /etc/apache2/httpd.conf: Syntax error on
37 line 4 of /etc/apache2/modules.d/70_mod_php5.conf: Cannot load
38 /usr/lib/apache2/modules/libphp5.so into server: libmysqlclient.so.15: cannot
39 open shared object file: No such file or directory
40 =========================================
41
42 What the ... ?
43
44 Line 155 of my /etc/apache2/httpd.conf says:
45
46 Include /etc/apache2/modules.d/*.conf
47
48 Line 4 of /etc/apache2/modules.d/70_mod_php5.conf, says:
49
50 LoadModule php5_module modules/libphp5.so
51
52 Also, I seem to have modules/libphp5.so and is world readable:
53
54 $ ls -la /usr/lib/apache2/modules/libphp5.so
55 -rw-r--r-- 1 root root 5720576 Aug 13 20:09 /usr/lib/apache2/modules/libphp5.so
56
57
58 I am downgrading now before a lynch mob arrives, but has anyone else
59 run into this problem?
60
61 PS. I'm running www-servers/apache-2.2.16
62 --
63 Regards,
64 Mick

Replies

Subject Author
Re: [gentoo-user] Proper way of updating mysql from 5.0.90-r2 to 5.1.50? Dale <rdalek1967@×××××.com>
Re: [gentoo-user] Proper way of updating mysql from 5.0.90-r2 to 5.1.50? Alan McKinnon <alan.mckinnon@×××××.com>