[opensuse] mysql will not start after php upgrade
openSUSE 10.1 x86_64 updated mysql yesterday to mysql-5.0.41-4.1 and php5 today to php5-5.2.2-49.1. Noticed my photo gallery was down and found mysqld not running. Restart attempt yields: 13:20 wahoo:~ # rcmysql start Updating MySQL privilege database... /usr/bin/mysql_upgrade: relocation error: /usr/bin/mysql_upgrade: symbol dynstr_append_os_quoted, version libmysqlclient_15 not defined in file libmysqlclient.so.15 with link time reference failed reverted php5 to earlier version php5-5.1.2-29.25.6.x86_64.rpm and still got same error. reverted mysql to mysql-5.0.18-20.8@x86_64 and still no cigar. can someone explain what I need to do to get mysql daemon up and running? tks, -- Patrick Shanahan Plainfield, Indiana, USA HOG # US1244711 http://wahoo.no-ip.org Photo Album: http://wahoo.no-ip.org/gallery2 OpenSUSE Linux http://en.opensuse.org/ Registered Linux User #207535 @ http://counter.li.org -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
* Patrick Shanahan <ptilopteri@gmail.com> [05-30-07 13:38]:
openSUSE 10.1 x86_64
updated mysql yesterday to mysql-5.0.41-4.1 and php5 today to php5-5.2.2-49.1. Noticed my photo gallery was down and found mysqld not running. Restart attempt yields:
13:20 wahoo:~ # rcmysql start Updating MySQL privilege database... /usr/bin/mysql_upgrade: relocation error: /usr/bin/mysql_upgrade: symbol dynstr_append_os_quoted, version libmysqlclient_15 not defined in file libmysqlclient.so.15 with link time reference failed
reverted php5 to earlier version php5-5.1.2-29.25.6.x86_64.rpm and still got same error. reverted mysql to mysql-5.0.18-20.8@x86_64 and still no cigar.
can someone explain what I need to do to get mysql daemon up and running?
Well, I got it started, but not properly. I started the daemon: mysqld -u mysql and now 'rcmysql status' reports 'running', but has no control. tks, -- Patrick Shanahan Plainfield, Indiana, USA HOG # US1244711 http://wahoo.no-ip.org Photo Album: http://wahoo.no-ip.org/gallery2 OpenSUSE Linux http://en.opensuse.org/ Registered Linux User #207535 @ http://counter.li.org -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Patrick Shanahan wrote:
openSUSE 10.1 x86_64
updated mysql yesterday to mysql-5.0.41-4.1
From server:database buildservice project, right?
and php5 today to php5-5.2.2-49.1. Noticed my photo gallery was down and found mysqld not running. Restart attempt yields:
13:20 wahoo:~ # rcmysql start Updating MySQL privilege database... /usr/bin/mysql_upgrade: relocation error: /usr/bin/mysql_upgrade: symbol dynstr_append_os_quoted, version libmysqlclient_15 not defined in file libmysqlclient.so.15 with link time reference failed
Not good. Did you update all the packages, inc. the client library and the client programs (run rpm -qa '*mysql*'; rpm -q --changelog <package> | head)? The client programs are in mysql-client.rpm, the library used to be in mysql-shared.rpm, now it's in libmysqlclient15.rpm. The current and 10.1 version of the library *should* be compatible, but if you mixed them, then it *could* be the reason. Anyway, on Factory x86_64 it works fine...
reverted php5 to earlier version php5-5.1.2-29.25.6.x86_64.rpm
PHP shouldn't have any influence. Michal -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Michal Marek escribió:
Patrick Shanahan wrote:
openSUSE 10.1 x86_64
updated mysql yesterday to mysql-5.0.41-4.1
From server:database buildservice project, right?
if so, it may not work :( there are multiple providers of libmysqlclient.so.15 in server:database and PHP is NOT building against it because the buildservice aborts on multiple choices... :( have choice for libmysqlclient.so.15 needed by mysql-client: mysql-beta-shared libmysqlclient15, have choice for libmysqlclient.so.15(libmysqlclient_15) needed by mysql-client: mysql-beta-shared libmysqlclient15 for this to work the user should: 1. install mysql from the server:database repo 2. install php5 from the server:php repository target server_database_SUSE_Linux_10.1[1] which does not build because the error above :-( [1]http://software.opensuse.org/download/server:/php/server_database_SUSE_Linux... /me has no idea how to force a "prefer" for a particular target as there is no FM ( a case of WITFM ;) )
Cristian Rodriguez R. wrote:
Michal Marek escribió:
Patrick Shanahan wrote:
openSUSE 10.1 x86_64
updated mysql yesterday to mysql-5.0.41-4.1 From server:database buildservice project, right?
if so, it may not work :(
there are multiple providers of libmysqlclient.so.15 in server:database and PHP is NOT building against it because the buildservice aborts on multiple choices... :(
OK, then I'll simply delete the mysql-beta package (it's not quite maintained anyway ;)) and perhaps put it somewhere else later. I never liked the idea of projects grouping several unrelated (and sometimes conflisting) packages like server:database... Not sure whether this is the cause of Patrick's problem, we'll see. Michal -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
* Cristian Rodriguez R. <judas_iscariote@shorewall.net> [05-31-07 06:40]:
for this to work the user should:
1. install mysql from the server:database repo 2. install php5 from the server:php repository target server_database_SUSE_Linux_10.1[1] which does not build because the error above :-(
[1]http://software.opensuse.org/download/server:/php/server_database_SUSE_Linux...
I have dl'd mysql to local directory and will do a reinstall locally, but the site location you have indicated above does not include php5 base package. Do I misunderstand? Did you intend the pkg from http://software.opensuse.org/download/server:/php/server_apache_SuSE_Linux_1... or http://software.opensuse.org/download/server:/php/SUSE_Linux_10.1/x86_64/ ok, 1. reinstalled mysql from server:database repo rpm -Uvh --replacepkgs ./mysql-5.0.41-4.1.x86_64.rpm 2. reinstalled php5 from server:/php/SUSE_Linux_10.1/x86_64/ rpm -Uvh --replacepkgs ./php5-5.2.2-49.1.x86_64.rpm 3. installed mysql-shared-5.0.18-16 had newer version which apparently was dropped? 4. installed libmysqlclient15-5.0.41.-4.1 required by (3), BUT provides overlapping files ??? 3. did: SuSEconfig ;ldconfig still same problem...... tks, -- Patrick Shanahan Plainfield, Indiana, USA HOG # US1244711 http://wahoo.no-ip.org Photo Album: http://wahoo.no-ip.org/gallery2 OpenSUSE Linux http://en.opensuse.org/ Registered Linux User #207535 @ http://counter.li.org -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Patrick Shanahan wrote:
ok, 1. reinstalled mysql from server:database repo rpm -Uvh --replacepkgs ./mysql-5.0.41-4.1.x86_64.rpm 2. reinstalled php5 from server:/php/SUSE_Linux_10.1/x86_64/ rpm -Uvh --replacepkgs ./php5-5.2.2-49.1.x86_64.rpm 3. installed mysql-shared-5.0.18-16 had newer version which apparently was dropped?
Please do *not* mix different versions. Use only the 5.0.41 packages from the buildservice repository and post the results here.
4. installed libmysqlclient15-5.0.41.-4.1 required by (3), BUT provides overlapping files ???
No, this is a replacement for the old mysql-shared package. Michal -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Michal Marek escribió:
Patrick Shanahan wrote:
ok, 1. reinstalled mysql from server:database repo rpm -Uvh --replacepkgs ./mysql-5.0.41-4.1.x86_64.rpm 2. reinstalled php5 from server:/php/SUSE_Linux_10.1/x86_64/ rpm -Uvh --replacepkgs ./php5-5.2.2-49.1.x86_64.rpm 3. installed mysql-shared-5.0.18-16 had newer version which apparently was dropped?
Please do *not* mix different versions. Use only the 5.0.41 packages from the buildservice repository and post the results here.
4. installed libmysqlclient15-5.0.41.-4.1 required by (3), BUT provides overlapping files ???
No, this is a replacement for the old mysql-shared package.
Still might not work. as PHP does not want to build against server:database_10.1 this is the error now. installing libmysqlclient15-5.0.41-4.1 file /usr/lib/libmysqlclient.so.15.0.0 from install of libmysqlclient15-5.0.41-4.1 conflicts with file from package mysql-shared-5.0.18-16 file /usr/lib/mysql/libmysqlclient.so.15 from install of libmysqlclient15-5.0.41-4.1 conflicts with file from package mysql-shared-5.0.18-16 Patrick : you need mysql from the server:database repository and PHP from **only** this repo http://software.opensuse.org/download/server:/php/server_database_SUSE_Linux... if RPMs are not there that means it is broken and you need to wait for them to be ready to use. do not mix stuff, as that way you will only shoot yourself in the foot.
Cristian Rodriguez R. wrote:
Michal Marek escribió:
Patrick Shanahan wrote:
ok, 1. reinstalled mysql from server:database repo rpm -Uvh --replacepkgs ./mysql-5.0.41-4.1.x86_64.rpm 2. reinstalled php5 from server:/php/SUSE_Linux_10.1/x86_64/ rpm -Uvh --replacepkgs ./php5-5.2.2-49.1.x86_64.rpm 3. installed mysql-shared-5.0.18-16 had newer version which apparently was dropped? Please do *not* mix different versions. Use only the 5.0.41 packages from the buildservice repository and post the results here.
4. installed libmysqlclient15-5.0.41.-4.1 required by (3), BUT provides overlapping files ??? No, this is a replacement for the old mysql-shared package.
Still might not work. as PHP does not want to build against server:database_10.1 this is the error now.
Getting the php5-mysql extension working with the new mysql lib is another story (btw, I removed mysql-beta yesterday, so it's just a question of time until the packages are ready). Let's first focus on the mysql_upgrade failure reported in the original mail.
if RPMs are not there that means it is broken and you need to wait for them to be ready to use. do not mix stuff, as that way you will only shoot yourself in the foot.
Exactly. Michal -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
* Cristian Rodriguez R. <judas_iscariote@shorewall.net> [06-01-07 06:25]:
Patrick : you need mysql from the server:database repository and PHP from **only** this repo
I did for mysql, but there is no php5 available at the url below
http://software.opensuse.org/download/server:/php/server_database_SUSE_Linux...
if RPMs are not there that means it is broken and you need to wait for them to be ready to use. do not mix stuff, as that way you will only shoot yourself in the foot.
this is what is there :^( libedit-2.10.snap20070302-5.1.x86_64.rpm libedit-devel-2.10.snap20070302-5.1.x86_64.rpm ming-0.4.0.beta5.snap20070526-4.1.x86_64.rpm ming-devel-0.4.0.beta5.snap20070526-4.1.x86_64.rpm ming-python-0.4.0.beta5.snap20070526-4.1.x86_64.rpm ming-tcl-0.4.0.beta5.snap20070526-4.1.x86_64.rpm qdbm-1.8.70-2.1.x86_64.rpm qdbm-c++-1.8.70-2.1.x86_64.rpm qdbm-c++-devel-1.8.70-2.1.x86_64.rpm qdbm-c++-test-1.8.70-2.1.x86_64.rpm qdbm-debuginfo-1.8.70-2.1.x86_64.rpm qdbm-devel-1.8.70-2.1.x86_64.rpm qdbm-perl-1.8.70-2.1.x86_64.rpm qdbm-perl-test-1.8.70-2.1.x86_64.rpm qdbm-ruby-1.8.70-2.1.x86_64.rpm qdbm-ruby-test-1.8.70-2.1.x86_64.rpm qdbm-test-1.8.70-2.1.x86_64.rpm suphp-0.6.2-10.1.x86_64.rpm suphp-debuginfo-0.6.2-10.1.x86_64.rpm So I need to wait ?? tks, -- Patrick Shanahan Plainfield, Indiana, USA HOG # US1244711 http://wahoo.no-ip.org Photo Album: http://wahoo.no-ip.org/gallery2 OpenSUSE Linux http://en.opensuse.org/ Registered Linux User #207535 @ http://counter.li.org -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Cristian Rodriguez R. wrote:
Still might not work. as PHP does not want to build against server:database_10.1 this is the error now.
installing libmysqlclient15-5.0.41-4.1 file /usr/lib/libmysqlclient.so.15.0.0 from install of libmysqlclient15-5.0.41-4.1 conflicts with file from package mysql-shared-5.0.18-16 file /usr/lib/mysql/libmysqlclient.so.15 from install of libmysqlclient15-5.0.41-4.1 conflicts with file from package mysql-shared-5.0.18-16
Sorry, I didn't get it in my previous mail :-) I looked into it now and it seems to me that the buildservice ignores the libmysqlclient-devel package, which then causes this failure. I asked on the buildservice ml: http://lists.opensuse.org/opensuse-buildservice/2007-06/msg00007.html Michal -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
* Michal Marek <mmarek@suse.cz> [06-04-07 04:08]: [...]
Sorry, I didn't get it in my previous mail :-) I looked into it now and it seems to me that the buildservice ignores the libmysqlclient-devel package, which then causes this failure. I asked on the buildservice ml: http://lists.opensuse.org/opensuse-buildservice/2007-06/msg00007.html
Thanks, I will follow on the opensuse-buildservice list. I held the kdepim3 group and the rest upgraded successfully. -- Patrick Shanahan Plainfield, Indiana, USA HOG # US1244711 http://wahoo.no-ip.org Photo Album: http://wahoo.no-ip.org/gallery2 OpenSUSE Linux http://en.opensuse.org/ Registered Linux User #207535 @ http://counter.li.org -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
* Patrick Shanahan <ptilopteri@gmail.com> [06-04-07 09:50]:
* Michal Marek <mmarek@suse.cz> [06-04-07 04:08]: [...]
Sorry, I didn't get it in my previous mail :-) I looked into it now and it seems to me that the buildservice ignores the libmysqlclient-devel package, which then causes this failure. I asked on the buildservice ml: http://lists.opensuse.org/opensuse-buildservice/2007-06/msg00007.html
Thanks, I will follow on the opensuse-buildservice list.
I held the kdepim3 group and the rest upgraded successfully.
Disregard this post, answered wrong thread :^( -- Patrick Shanahan Plainfield, Indiana, USA HOG # US1244711 http://wahoo.no-ip.org Photo Album: http://wahoo.no-ip.org/gallery2 OpenSUSE Linux http://en.opensuse.org/ Registered Linux User #207535 @ http://counter.li.org -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Michal Marek wrote:
Sorry, I didn't get it in my previous mail :-) I looked into it now and it seems to me that the buildservice ignores the libmysqlclient-devel package, which then causes this failure. I asked on the buildservice ml: http://lists.opensuse.org/opensuse-buildservice/2007-06/msg00007.html
server_database_* build targets are fixed now. Michal -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (3)
-
Cristian Rodriguez R. -
Michal Marek -
Patrick Shanahan