Hey everyone,

I'm attempting to install the updated MySQL package, 4.1.7 and when I do run the RPM installation I get the following message:

warning: /home/adam/MySQL-server-4.1.7-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
MySQL conflicts with mysql-3.23.58-9
MySQL-server conflicts with mysql-server-3.23.58-9

And can't seem to get the install to work, any suggestions as to what I might do to correct this problem would be greatly appreciated.

You should really uninstall the old version first with:
rpm -e packagename

When I attempt the rpm -e command I then get the following error:

error: can't create transaction lock

whatever that might mean

Programmers should start making intelligable error messages.

good grief, never mind that last post.. figured it out.. silly me, however when I do the:

rpm -e mysql-3.23.58-9 i receive:

error: Failed dependencies:
libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.9003-4
libmysqlclient.so.10 is needed by (installed) mod_auth_mysql-20030510-4.1
libmysqlclient.so.10 is needed by (installed) php-mysql-4.3.8-2.1

and does not uninstall. Any suggestions now?

If you remove with --nodeps the package should go but make sure you install the new version so that libmysqlclient is installed again. Alternatively forget the rpms and install from source so that you have more control over the destination of the installed files.

I'm also trying to install MySQL-4.1.7 on a Fedora Core 2 system with MySQL-3.23.58-9 already installed. And I also get

[root@localhost downloads]# rpm -e --test mysql-3.23.58-9
error: Failed dependencies:
libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.9003-4
libmysqlclient.so.10 is needed by (installed) mod_auth_mysql-20030510-4.1
libmysqlclient.so.10 is needed by (installed) php-mysql-4.3.4-11
libmysqlclient.so.10 is needed by (installed) mysql-server-3.23.58-9
mysql = 3.23.58 is needed by (installed) mysql-server-3.23.58-9

My question is: If I erase while ignoring dependencies with:

[root@localhost downloads]# rpm -e --nodeps mysql-3.23.58-9

And then reinstall with:

[root@localhost downloads]# rpm -i MySQL-server-4.1.7-0.i386.rpm
[root@localhost downloads]# rpm -i MySQL-client-4.1.7-0.i386.rpm

Will it automatically put libmysqlclient.so back in the right place, such that the old dependencies will still work? I'm assuming they will, but I'd like to ask you to be on the safe side.

Furthermore, how would I go about testing these dependencies to make sure they still work after the reinstall? Is there any nifty command to test this, or need I whip up some PHP and perl scripts myself?

Thanks!

-david

Update: Turns out it doesn't go in cleanly. MySQL works great, but doing the above steps broke the httpd startup script. Specifically, it failed to load auth_mod_mysql because it couldn't find libmysqlclient.so. I "fixed" it by disabling this module and thus getting httpd to restart, but I don't know why the module broke to begin with. Any ideas what went wrong, and how to fix it?

-david

Does libmysqlclient.so exist?

Try running "ldconfig".