Can't install mysql-utilities

[lionelv]

Oh dear, I'm not having much luck with Mageia, this is my first attempt at transitioning from Mandriav 2010.

I've forgotten to mention in all my previous posts that I'm using the 64 bit of Mageia 3 beta3.

I just tried to install mysql-utilities (actually I only want to get the server running for development purposes) and I got this:

Code: Select all

1 installation transactions failed

There was a problem during the installation:

file /usr/lib/python2.7/site-packages/mysql/connector/__init__.py from install of mysql-utilities-1.0.0-0.5.2.45.7.mga3.x86_64 conflicts with file from package mysql-connector-python-1.0.7-2.mga3.noarch

file /usr/lib/python2.7/site-packages/mysql/connector/connection.py from install of mysql-utilities-1.0.0-0.5.2.45.7.mga3.x86_64 conflicts with file from package mysql-connector-python-1.0.7-2.mga3.noarch

file /usr/lib/python2.7/site-packages/mysql/connector/constants.py from install of mysql-utilities-1.0.0-0.5.2.45.7.mga3.x86_64 conflicts with file from package mysql-connector-python-1.0.7-2.mga3.noarch

file /usr/lib/python2.7/site-packages/mysql/connector/conversion.py from install of mysql-utilities-1.0.0-0.5.2.45.7.mga3.x86_64 conflicts with file from package mysql-connector-python-1.0.7-2.mga3.noarch

file /usr/lib/python2.7/site-packages/mysql/connector/cursor.py from install of mysql-utilities-1.0.0-0.5.2.45.7.mga3.x86_64 conflicts with file from package mysql-connector-python-1.0.7-2.mga3.noarch

file /usr/lib/python2.7/site-packages/mysql/connector/dbapi.py from install of mysql-utilities-1.0.0-0.5.2.45.7.mga3.x86_64 conflicts with file from package mysql-connector-python-1.0.7-2.mga3.noarch

file /usr/lib/python2.7/site-packages/mysql/connector/errors.py from install of mysql-utilities-1.0.0-0.5.2.45.7.mga3.x86_64 conflicts with file from package mysql-connector-python-1.0.7-2.mga3.noarch

file /usr/lib/python2.7/site-packages/mysql/connector/protocol.py from install of mysql-utilities-1.0.0-0.5.2.45.7.mga3.x86_64 conflicts with file from package mysql-connector-python-1.0.7-2.mga3.noarch

file /usr/lib/python2.7/site-packages/mysql/connector/utils.py from install of mysql-utilities-1.0.0-0.5.2.45.7.mga3.x86_64 conflicts with file from package mysql-connector-python-1.0.7-2.mga3.noarch

Ok, so I ignored that having installed mysql-workbench and hoping that would have given me the server as I wished, which maybe it did, I'm not sure. I tried to run mysqld but got:

Code: Select all

130310 20:44:07 [ERROR] Can't open shared library '/usr/lib64/mysql/plugin/ha_archive.so' (errno: 17 cannot open shared object file: No such file or directory)
130310 20:44:07 [ERROR] Couldn't load plugin named '(null)' with soname 'ha_archive.so'.
130310 20:44:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130310 20:44:07 [ERROR] mysqld: unknown option '--federated'
130310 20:44:07 [ERROR] Aborting

130310 20:44:07  InnoDB: Starting shutdown...


I might note that MySQL didn't show up in system services either.

So then I googled around and discovered that something called maria has replaced MySQL, well that's no good to me because my project uses MySQL, but anyway, let's see if I can use it. So back at the software manager I attempt to install mysql-mariadb, and guess what, get the same conflict message as above.

So I uninstalled the other MySQL stuff. Then installed Maria. Ok, now the mysql service shows up. Started it and it appears to work. So I'll make do for now. It would be nice if we could offer the choice, I don't know anything about Maria or the reasons for putting it in, but I'm using MySQL and I can't be replacing it for the many users I have.

Thoughts appreciated.

By the way, this started as a post to document the errors but I worked out the sort of solution by the time I had finished.

[Latte]

Oh dear, I'm not having much luck with Mageia, this is my first attempt at transitioning from Mandriav 2010.

I've forgotten to mention in all my previous posts that I'm using the 64 bit of Mageia 3 beta3.

But you know that beta3 is only intended for testing and not supposed to be used as productive system?

I just tried to install mysql-utilities (actually I only want to get the server running for development purposes) and I got this:
[...]
I might note that MySQL didn't show up in system services either.

Did you tried the packages from the repo? If I installed mySQL/MariaDB via urpmi the myslqd is available in the system service settings (in Mageia2)

So then I googled around and discovered that something called maria has replaced MySQL, well that's no good to me because my project uses MySQL, but anyway, let's see if I can use it. So back at the software manager I attempt to install mysql-mariadb, and guess what, get the same conflict message as above.

MariaDB is a fork from mySQL and as far as I know should be almost 100% compatible? (see http://en.wikipedia.org/wiki/MariaDB)

MariaDB's API and protocol are compatible with those used by MySQL, plus some features to support native Non-Blocking operations and Progress Reporting. This means that all connectors, libraries and applications which work with MySQL should also work on MariaDB - whether or not they support its native features.

[lionelv]

But you know that beta3 is only intended for testing and not supposed to be used as productive system?

Yes of course, it is a beta after all. I just didn't expect to have troubles with most of the key things that I do .

Did you tried the packages from the repo? If I installed mySQL/MariaDB via urpmi the myslqd is available in the system service settings (in Mageia2)

Yes, but initially I installed some the MySQL packages but not the MariaDB package. When I couldn't find the MySQL server package that I was searching for I was hoping that these would pull it in as a dependency, however it seems they actually conflict with the MariaDB package. I think I'll raise a bug on this.

MariaDB is a fork from mySQL and as far as I know should be almost 100% compatible?

Yep, I read the MariaDB page in the end. I'm happy to use it for my development but I'll be finding another machine to run my tests on with an original MySQL server.

[Latte]

Yes, but initially I installed some the MySQL packages but not the MariaDB package. When I couldn't find the MySQL server package that I was searching for I was hoping that these would pull it in as a dependency, however it seems they actually conflict with the MariaDB package. I think I'll raise a bug on this.

Sorry, I don't have Cauldron (or beta3) installed here, but if I try to get mysql-utilities from the repos in Mageia2 everything will be installed correctly:

Code: Select all

[root@Rechner marc]# urpmi mysql-utilities
Um die Abhängigkeiten zu erfüllen, werden die folgenden Pakete installiert:
  Paket                          Version      Release       Arch
(Medium »Core Release (distrib1)«)
  mysql-connector-python         0.3.2        4.mga2        noarch
(Medium »Core Updates (distrib3)«)
  mysql-utilities                1.0.0        0.5.2.36.2.1> noarch
640KB zusätzlicher Speicher wird benötigt
154KB an Paketen wird geholt
Fortfahren mit der Installation der 2 Pakete? (J/n) j


    $MIRRORLIST: media/core/release/mysql-connector-python-0.3.2-4.mga2.noarch.rpm
    $MIRRORLIST: media/core/updates/mysql-utilities-1.0.0-0.5.2.36.2.1.mga2.noarch.rpm
mysql-utilities-1.0.0-0.5.2.36.2.1.mga2.noarch.rpm mysql-connector-python-0.3.2-4.mga2.noarch.rpm von /var/cache/urpmi/rpms wird installiert
Vorbereiten …                    #####################################################################
      1/2: mysql-connector-python
                                 #####################################################################
      2/2: mysql-utilities       #####################################################################
[root@Rechner marc]#

I have everything installed (mysql/MariaDB) from the repos.

[alf]

Sorry, I don't have Cauldron (or beta3) installed here

but is installed here

seems to be that mysql-utilities can't be be installed atm. versions missmatch.

Code: Select all

[root@kre010 alfred]# urpmi mysql-utilities


mysql-utilities-1.0.0-0.5.2.45.7.mga3.x86_64.rpm von /var/cache/urpmi/rpms wird installiert
Vorbereiten …                    #############################################################################################################
Installation fehlgeschlagen:    Datei /usr/lib/python2.7/site-packages/mysql/connector/__init__.py aus der Installation von mysql-utilities-1.0.0-0.5.2.45.7.mga3.x86_64 kollidiert mit der Datei aus dem Paket mysql-connector-python-1.0.7-2.mga3.noarch
        Datei /usr/lib/python2.7/site-packages/mysql/connector/connection.py aus der Installation von mysql-utilities-1.0.0-0.5.2.45.7.mga3.x86_64 kollidiert mit der Datei aus dem Paket mysql-connector-python-1.0.7-2.mga3.noarch
        Datei /usr/lib/python2.7/site-packages/mysql/connector/constants.py aus der Installation von mysql-utilities-1.0.0-0.5.2.45.7.mga3.x86_64 kollidiert mit der Datei aus dem Paket mysql-connector-python-1.0.7-2.mga3.noarch
        Datei /usr/lib/python2.7/site-packages/mysql/connector/conversion.py aus der Installation von mysql-utilities-1.0.0-0.5.2.45.7.mga3.x86_64 kollidiert mit der Datei aus dem Paket mysql-connector-python-1.0.7-2.mga3.noarch
        Datei /usr/lib/python2.7/site-packages/mysql/connector/cursor.py aus der Installation von mysql-utilities-1.0.0-0.5.2.45.7.mga3.x86_64 kollidiert mit der Datei aus dem Paket mysql-connector-python-1.0.7-2.mga3.noarch
        Datei /usr/lib/python2.7/site-packages/mysql/connector/dbapi.py aus der Installation von mysql-utilities-1.0.0-0.5.2.45.7.mga3.x86_64 kollidiert mit der Datei aus dem Paket mysql-connector-python-1.0.7-2.mga3.noarch
        Datei /usr/lib/python2.7/site-packages/mysql/connector/errors.py aus der Installation von mysql-utilities-1.0.0-0.5.2.45.7.mga3.x86_64 kollidiert mit der Datei aus dem Paket mysql-connector-python-1.0.7-2.mga3.noarch
        Datei /usr/lib/python2.7/site-packages/mysql/connector/protocol.py aus der Installation von mysql-utilities-1.0.0-0.5.2.45.7.mga3.x86_64 kollidiert mit der Datei aus dem Paket mysql-connector-python-1.0.7-2.mga3.noarch
        Datei /usr/lib/python2.7/site-packages/mysql/connector/utils.py aus der Installation von mysql-utilities-1.0.0-0.5.2.45.7.mga3.x86_64 kollidiert mit der Datei aus dem Paket mysql-connector-python-1.0.7-2.mga3.noarch

[lionelv]

Guess we need to raise a bug on that?

[doktor5000]

Hi, i'm just jumping in here...

I'm the mariadb packager for Mageia.

1) a bug on mysql-utilities would be nice, you can file those at https://bugs.mageia.org/ (be advised, i'm not the mysql-utilities packager).

2) i don't think mdv2010 --> mga3 (let alone beta3) is really supported.

3) you may suffer from having mdv packages still being installed. if i were you i would try to list the mdv packages and find the similar mga packages. that might likely give you a better experience.

4) wrt your clients, you're free to choose whatever you want of course, but in Mageia i didn't see the need to be offering MySQL, when i can offer MariaDB. (we have MariaDB since Mageia 2.)

in case you didn't know, MariaDB is the continuation of mysql by it's founders and due to it being partially closed sourced by Oracle. for your intents and purposes MariaDB is actually the mysql tree, which is patches by the google and facebook patches, which have always been rejected in the past, and extra storage engines. on top of that, mariadb developers pick the usefull MySQL stuff and sometimes reimplement a feature (completely drop-in replacement-wise). if you browse around, you'll note that the unbiased reviews will show that MariaDB is actually a lot faster.

I myself have been forced to switch a client to MariaDB, because of a particularly slow query which ran more than 30seconds, but with mariadb in 0.42seconds... And even MariaDB has support as well, SkySQL is a company that has an agreement with MariaDB and they handle commercial support.

Lastly, you may not be aware that opensuse have switched, fedora too (redhat and all it's derivates will follow that) and that there is a discussion going on in debian.

[lionelv]

Thanks alien. Here's some responses.

1) a bug on mysql-utilities would be nice, you can file those at https://bugs.mageia.org/ (be advised, i'm not the mysql-utilities packager).

Yep, I ended up doing it last night, my sole purposes of installing this beta was to actually give feedback for a change, I just want to make sure I'm not the guy raising bugs that aren't really bugs . You can find it here https://bugs.mageia.org/show_bug.cgi?id=9330

2) i don't think mdv2010 --> mga3 (let alone beta3) is really supported.

Sorry, that was a mis-communication on my behalf, it wasn't an upgrade, it was a fresh install. I meant it in terms of using a more recent distro and I've decided that it's time for me to find a new distro because I'm not sure of the direction or intent of Mandriva anymore. But I found Mandriva the most integrated and polished distro around so Mageia is the logical choice .

3) you may suffer from having mdv packages still being installed. if i were you i would try to list the mdv packages and find the similar mga packages. that might likely give you a better experience.

I think my previous clarification rules this out.

4) wrt your clients, you're free to choose whatever you want of course, but in Mageia i didn't see the need to be offering MySQL, when i can offer MariaDB. (we have MariaDB since Mageia 2.)

Sort of, there's the whole SOE that I need to deal with, and users need to have confidence in the product, no one in the world where my software is released will have heard of MariaDB and that will be a bad choice for the success of the software.

In saying that you make fair points, and with that information I'm quite happy for the distro's to include MariaDB if they wish. If I really want MySQL I can download the RPM anyway.

And the application that I am writing is cross-platform (sort of, it doesn't work on Mac at the moment for some reason) and the majority of users are of course windows users. Well in fact I can state as part of the release that MariaDB is supported given it is a drop-in replacement, so now I have support for 3 DBMS , MySQL, MariaDB and MS SQL (I was forced too ).

Anyway, thanks for the info!