MySQL Upgrade error - Conflicts

I m currently working on a Unix server with a fedora 3 as an os

My current version of mysql is 3.23.58. I'd like to upgrade the version
to 5.0.18.
After downloading from MYSQL.COM the package on the site, I made :
rpm -i MySQL-server-5.0.18-0.i386.rpm

then i have errors that relate to many conflicts. I cannot figure out
why -and- cannot upgrade. Please Help !



file /etc/my.cnf from install of MySQL-server-5.0.18-0 conflicts with
file from package mysql-3.23.58-4.7.legacy
file /usr/bin/my_print_defaults from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/bin/myisamchk from install of MySQL-server-5.0.18-0
conflicts with file from package mysql-3.23.58-4.7.legacy
file /usr/bin/myisamlog from install of MySQL-server-5.0.18-0
conflicts with file from package mysql-3.23.58-4.7.legacy
file /usr/bin/myisampack from install of MySQL-server-5.0.18-0
conflicts with file from package mysql-3.23.58-4.7.legacy
file /usr/bin/mysql_fix_privilege_tables from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/bin/mysql_install_db from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/bin/mysql_setpermission from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/bin/mysql_zap from install of MySQL-server-5.0.18-0
conflicts with file from package mysql-3.23.58-4.7.legacy
file /usr/bin/mysqlbug from install of MySQL-server-5.0.18-0
conflicts with file from package mysql-3.23.58-4.7.legacy
file /usr/bin/mysqld_multi from install of MySQL-server-5.0.18-0
conflicts with file from package mysql-3.23.58-4.7.legacy
file /usr/bin/mysqlhotcopy from install of MySQL-server-5.0.18-0
conflicts with file from package mysql-3.23.58-4.7.legacy
file /usr/bin/mysqltest from install of MySQL-server-5.0.18-0
conflicts with file from package mysql-3.23.58-4.7.legacy
file /usr/bin/perror from install of MySQL-server-5.0.18-0
conflicts with file from package mysql-3.23.58-4.7.legacy
file /usr/bin/replace from install of MySQL-server-5.0.18-0
conflicts with file from package mysql-3.23.58-4.7.legacy
file /usr/bin/resolve_stack_dump from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/bin/resolveip from install of MySQL-server-5.0.18-0
conflicts with file from package mysql-3.23.58-4.7.legacy
file /usr/share/info/mysql.info.gz from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/man/man1/mysql_zap.1.gz from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/man/man1/mysqld.1.gz from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/man/man1/mysqld_multi.1.gz from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/man/man1/perror.1.gz from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/man/man1/replace.1.gz from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/man/man1/safe_mysqld.1.gz from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/czech/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/danish/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/dutch/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/english/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/estonian/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/french/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/german/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/greek/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/hungarian/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/italian/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/japanese/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/korean/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/norwegian-ny/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/norwegian/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/polish/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/portuguese/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/romanian/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/russian/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/slovak/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/spanish/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/swedish/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/share/mysql/ukrainian/errmsg.sys from install of
MySQL-server-5.0.18-0 conflicts with file from package
mysql-3.23.58-4.7.legacy
file /usr/bin/safe_mysqld from install of MySQL-server-5.0.18-0
conflicts with file from package mysql-server-3.23.58-4.7.legacy


How can i solve it?

Thanks

Re: MySQL Upgrade error - Conflicts

trihanhcie@gmail.com wrote:
> I m currently working on a Unix server with a fedora 3 as an os
>
> My current version of mysql is 3.23.58. I'd like to upgrade the version
> to 5.0.18.
> After downloading from MYSQL.COM the package on the site, I made :
> rpm -i MySQL-server-5.0.18-0.i386.rpm
>
> then i have errors that relate to many conflicts. I cannot figure out
> why -and- cannot upgrade. Please Help !

RedHat uses package name mysql-server

mysql.com uses package name MySQL-server

as RPM is case sensitive it makes MySQL-server != mysql-server


When upgrading you don't use the '-i' option, this is really for installing
and should be avoided to be used. The option for upgrading and installing is
'-Uvh' (this includes verbose output too).

rpm -Uvh


What you need to do is to uninstall mysql-server (rpm -e mysql-server), before
you can install MySQL-server (rpm -Uvh MySQL-server-5.0.18-0.i386.rpm). When
trying to uninstall mysql-server, you will get a list of packages depending on
mysql-server, most some of them are mysql-devel and mysql, you will need to
uninstall those too and replace with those from mysql.com. You will need the
'--force' option during the uninstall and maybe even during installing.

If you are using mysql together with php and apache, then you need to rebuild
those RPMs or else you break the system.


I do strongly suggest you use the RPMs supplied by Fedora Project, you will
end with a lot less work.

mysql-server:
http://rpmfind.net/linux/rpm2html/search.php?query=mysql-ser ver&submit=Search+...&system=Fedora&arch=

mysql:
http://rpmfind.net/linux/rpm2html/search.php?query=mysql&sub mit=Search+...&system=fedora&arch=

mysql-devel:
http://rpmfind.net/linux/rpm2html/search.php?query=mysql-dev el&submit=Search+...&system=fedora&arch=

apache:
http://rpmfind.net/linux/rpm2html/search.php?query=httpd&sub mit=Search+...&system=fedora&arch=
http://rpmfind.net/linux/rpm2html/search.php?query=httpd-dev el&submit=Search+...&system=fedora&arch=

php:
http://rpmfind.net/linux/rpm2html/search.php?query=php&submi t=Search+...&system=fedora&arch=

php-devel:
http://rpmfind.net/linux/rpm2html/search.php?query=php-devel &submit=Search+...&system=fedora&arch=

php_mysql:
http://rpmfind.net/linux/rpm2html/search.php?query=php_mysql &submit=Search+...&system=fedora&arch=


//Aho

Re: MySQL Upgrade error - Conflicts

Hi

Thanks for the help.

I have a lot of problems...

First, I'd like to ask several things

I installed MySQL-server-5.0.18-0 (it's in the list when I write the
command rpm -qa | grep -i mysql) and MySQL-client-5.0.18-0


I restart httpd and mysql but it still doesn't work. How do I know?
well i try to launch mysql prompt and it doesn't work...

If i try to install the package MySQL-devel-5.0.18-0, i need openssl
and if i try to install openssl, i need :
krb5-devel is needed by openssl-devel-0.9.8a-5.2
openssl = 0.9.8a-5.2 is needed by openssl-devel-0.9.8a-5.2
zlib-devel is needed by openssl-devel-0.9.8a-5.2

Do i have to go on with the installation or I made a mistake?

Please help it's quite urgent !!

Thanks


J.O. Aho wrote:
> trihanhcie@gmail.com wrote:
> > I m currently working on a Unix server with a fedora 3 as an os
> >
> > My current version of mysql is 3.23.58. I'd like to upgrade the version
> > to 5.0.18.
> > After downloading from MYSQL.COM the package on the site, I made :
> > rpm -i MySQL-server-5.0.18-0.i386.rpm
> >
> > then i have errors that relate to many conflicts. I cannot figure out
> > why -and- cannot upgrade. Please Help !
>
> RedHat uses package name mysql-server
>
> mysql.com uses package name MySQL-server
>
> as RPM is case sensitive it makes MySQL-server != mysql-server
>
>
> When upgrading you don't use the '-i' option, this is really for installing
> and should be avoided to be used. The option for upgrading and installing is
> '-Uvh' (this includes verbose output too).
>
> rpm -Uvh
>
>
> What you need to do is to uninstall mysql-server (rpm -e mysql-server), before
> you can install MySQL-server (rpm -Uvh MySQL-server-5.0.18-0.i386.rpm). When
> trying to uninstall mysql-server, you will get a list of packages depending on
> mysql-server, most some of them are mysql-devel and mysql, you will need to
> uninstall those too and replace with those from mysql.com. You will need the
> '--force' option during the uninstall and maybe even during installing.
>
> If you are using mysql together with php and apache, then you need to rebuild
> those RPMs or else you break the system.
>
>
> I do strongly suggest you use the RPMs supplied by Fedora Project, you will
> end with a lot less work.
>
> mysql-server:
> http://rpmfind.net/linux/rpm2html/search.php?query=mysql-ser ver&submit=Search+...&system=Fedora&arch=
>
> mysql:
> http://rpmfind.net/linux/rpm2html/search.php?query=mysql&sub mit=Search+...&system=fedora&arch=
>
> mysql-devel:
> http://rpmfind.net/linux/rpm2html/search.php?query=mysql-dev el&submit=Search+...&system=fedora&arch=
>
> apache:
> http://rpmfind.net/linux/rpm2html/search.php?query=httpd&sub mit=Search+...&system=fedora&arch=
> http://rpmfind.net/linux/rpm2html/search.php?query=httpd-dev el&submit=Search+...&system=fedora&arch=
>
> php:
> http://rpmfind.net/linux/rpm2html/search.php?query=php&submi t=Search+...&system=fedora&arch=
>
> php-devel:
> http://rpmfind.net/linux/rpm2html/search.php?query=php-devel &submit=Search+...&system=fedora&arch=
>
> php_mysql:
> http://rpmfind.net/linux/rpm2html/search.php?query=php_mysql &submit=Search+...&system=fedora&arch=
>
>
> //Aho

Re: MySQL Upgrade error - Conflicts

trihanhcie@gmail.com wrote:
> Hi
>
> Thanks for the help.
>
> I have a lot of problems...
>
> First, I'd like to ask several things
>
> I installed MySQL-server-5.0.18-0 (it's in the list when I write the
> command rpm -qa | grep -i mysql) and MySQL-client-5.0.18-0
>
>
> I restart httpd and mysql but it still doesn't work. How do I know?
> well i try to launch mysql prompt and it doesn't work...
>
> If i try to install the package MySQL-devel-5.0.18-0, i need openssl
> and if i try to install openssl, i need :
> krb5-devel is needed by openssl-devel-0.9.8a-5.2
> openssl = 0.9.8a-5.2 is needed by openssl-devel-0.9.8a-5.2
> zlib-devel is needed by openssl-devel-0.9.8a-5.2
>
> Do i have to go on with the installation or I made a mistake?
>
> Please help it's quite urgent !!

RPM works with dependency checks to keep the system from breaking, you will
need to install packages of the specified version, to keep things working.

I see you went with installing MySQL instead of mysql, you will run into more
problems that way as you will have more trouble to fulfill the dependency.

1. Even if you will get MySQL to work on FC3, it won't work with your
installed PHP.

2. MySQL don't provide RedHat init-scripts, so you need to start the server
manually.

3. MySQL is most likely compiled with gcc 3.3.X or older version, which isn't
compatible with the ABI of newer gcc like 3.4.4 that FC3 uses. (this could
explain why it don't start at all)

IMHO you have made the mistake to install MySQL, you should use the mysql
packages provided by RedHat and you will need to upgrade your PHP and Apache
to versions that are made to work with mySQL5.
Another option is to download the SRPMs for mysql and FC3's php, and then
rebuild them

rpmbuild --rebuild mysql-5.0.18-2.1.src.rpm
< install the new RPMs from /usr/src/redhat/i386 >

rpmbuild --rebuild php-4.3.11-2.8.src.rpm
< --force install the new RPMs from /usr/src/redhat/i386 >


//Aho

Re: MySQL Upgrade error - Conflicts

Sorry...

I thought i update from mysql and not Mysql :(( If i install from mysql
now can I fix the problem? Sorry I should have read your post more
carefully...

Re: MySQL Upgrade error - Conflicts

Oh another thing... If I install Apache and php again, is it going to
keep my old config file?
If I understood you correctly, I have to
1) rpm -Uvh mysql-server-5.0.18-2.1.i386.rpm
2) rpm -Uvh mysql-5.0.18-2.1.src
and so on

However, with mysql-5.0.18-2.1.src, i already miss the following file :

libc.so.6(GLIBC_2.3.4) is needed by mysql-5.0.18-2.1
libc.so.6(GLIBC_2.4) is needed by mysql-5.0.18-2.1
libcrypto.so.6 is needed by mysql-5.0.18-2.1
libssl.so.6 is needed by mysql-5.0.18-2.1
libstdc++.so.6 is needed by mysql-5.0.18-2.1
libstdc++.so.6(CXXABI_1.3) is needed by mysql-5.0.18-2.1

....

Sorry to bother you again and thanks for the help

Re: MySQL Upgrade error - Conflicts

trihanhcie@gmail.com wrote:
> Oh another thing... If I install Apache and php again, is it going to
> keep my old config file?

Your old config files won't be deleted, if your current configuration is
compatible with the new version of the program you install, then the new
configuration files gets the rpmnew

eg: /etc/httpd/conf/httpd.conf.rpmnew

If your old configuration file would not be compatible with the new one, then
it gets rpmsave extention

eg: /etc/httpd/conf/httpd.conf.rpmsave

So it will always be easy to find the config files if you happen to notice
that an application don't use the settings you did set.


> If I understood you correctly, I have to
> 1) rpm -Uvh mysql-server-5.0.18-2.1.i386.rpm
> 2) rpm -Uvh mysql-5.0.18-2.1.src
> and so on
>
> However, with mysql-5.0.18-2.1.src, i already miss the following file :
>
> libc.so.6(GLIBC_2.3.4) is needed by mysql-5.0.18-2.1
> libc.so.6(GLIBC_2.4) is needed by mysql-5.0.18-2.1
> libcrypto.so.6 is needed by mysql-5.0.18-2.1
> libssl.so.6 is needed by mysql-5.0.18-2.1
> libstdc++.so.6 is needed by mysql-5.0.18-2.1
> libstdc++.so.6(CXXABI_1.3) is needed by mysql-5.0.18-2.1

libc.so.6 is part of glibc package
libstdc++ is part of gcc package
libssl.so.6 and libcrypto.so.6 are part of openssl package

You have two options here, install the required RPMs, which would be an
experimental glibc 2.3.999, gcc 4.1.0 and openssl-0.9.8a-5.2.

As there aren't any hard dependency problems here, I think it's better to
recompile/rebuild mysql, this way you won't be forced to update other packages.

eg: rpmbuild --rebuild mysql-5.0.18-2.1.src.rpm

Note that you need the RPM that has the "src" instead of "i386", you will need
to have some devel packages installed too.

As you anyway have to recompile PHP, you can upgrade to PHP5 too

rpmbuild --rebuild php-5.1.2-5.src.rpm

This way you get FC3 native RPMs which makes things a lot more stable, trust
me on this, I have experience of trying to keep a system up and working that
was RH7.3 in the base with RH9 and FC1 packages.


//Aho

Re: MySQL Upgrade error - Conflicts

Hi

I would like to install 2 version of mysql 3.23.58 and 5.0.18 on my
server.
If I understood correctly, i have to create another config file with a
different folder and port compared to my actual installation one.

Here's my question (quite easy I think)
How do I choose where I install the package mysql ? Can I still use rpm
-Uvh or do I have to do something else?

Can anyone tell me the steps i have to do to install 2 versions of
mysql server on the same machine?

Thanks !

J.O. Aho wrote:
> trihanhcie@gmail.com wrote:
> > Oh another thing... If I install Apache and php again, is it going to
> > keep my old config file?
>
> Your old config files won't be deleted, if your current configuration is
> compatible with the new version of the program you install, then the new
> configuration files gets the rpmnew
>
> eg: /etc/httpd/conf/httpd.conf.rpmnew
>
> If your old configuration file would not be compatible with the new one, then
> it gets rpmsave extention
>
> eg: /etc/httpd/conf/httpd.conf.rpmsave
>
> So it will always be easy to find the config files if you happen to notice
> that an application don't use the settings you did set.
>
>
> > If I understood you correctly, I have to
> > 1) rpm -Uvh mysql-server-5.0.18-2.1.i386.rpm
> > 2) rpm -Uvh mysql-5.0.18-2.1.src
> > and so on
> >
> > However, with mysql-5.0.18-2.1.src, i already miss the following file :
> >
> > libc.so.6(GLIBC_2.3.4) is needed by mysql-5.0.18-2.1
> > libc.so.6(GLIBC_2.4) is needed by mysql-5.0.18-2.1
> > libcrypto.so.6 is needed by mysql-5.0.18-2.1
> > libssl.so.6 is needed by mysql-5.0.18-2.1
> > libstdc++.so.6 is needed by mysql-5.0.18-2.1
> > libstdc++.so.6(CXXABI_1.3) is needed by mysql-5.0.18-2.1
>
> libc.so.6 is part of glibc package
> libstdc++ is part of gcc package
> libssl.so.6 and libcrypto.so.6 are part of openssl package
>
> You have two options here, install the required RPMs, which would be an
> experimental glibc 2.3.999, gcc 4.1.0 and openssl-0.9.8a-5.2.
>
> As there aren't any hard dependency problems here, I think it's better to
> recompile/rebuild mysql, this way you won't be forced to update other packages.
>
> eg: rpmbuild --rebuild mysql-5.0.18-2.1.src.rpm
>
> Note that you need the RPM that has the "src" instead of "i386", you will need
> to have some devel packages installed too.
>
> As you anyway have to recompile PHP, you can upgrade to PHP5 too
>
> rpmbuild --rebuild php-5.1.2-5.src.rpm
>
> This way you get FC3 native RPMs which makes things a lot more stable, trust
> me on this, I have experience of trying to keep a system up and working that
> was RH7.3 in the base with RH9 and FC1 packages.
>
>
> //Aho