1 Topic by elliot01 (edited by elliot01 2010-05-16 23:06:43)

  • Registered: 2010-05-16
  • Posts: 5

Topic: 'Transaction Check Error' installing ocsinventory (MySQL)

Hi all,

I am attempting to install OCS Inventory, using the online guide (http://blog.famillecollet.com/pages/OCS-GLPI-en).

My server is a CentOS 5.4 box running various established intranet services on Apache/MySQL/PHP (also has a functioning GLPI facility).

I have added the remi and EPEL repos and enter 'yum install ocsinventory'. All seems to go fine until it reaches this point:

Running rpm_check_debug
Running Transaction Test
Finished Transaction Test


Transaction Check Error:
  file /etc/my.cnf from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/charsets/Index.xml from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/charsets/cp1250.xml from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/czech/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/danish/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/dutch/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/english/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/estonian/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/french/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/german/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/greek/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/hungarian/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/italian/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/japanese/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/korean/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/norwegian-ny/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/norwegian/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/polish/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/portuguese/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/romanian/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/russian/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/serbian/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/slovak/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/spanish/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/swedish/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64
  file /usr/share/mysql/ukrainian/errmsg.sys from install of mysql-libs-5.1.46-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_4.1.x86_64

Error Summary
-------------

The next step in the guide is to run the install.php, but it looks like the YUM install never made it this far as the http://localhost/ocsreports/install.php (equivalent) files or folders are not there.

It looks like the remi/epel install is conflicting with a different version of MySQL to which I have installed?

Bit of a Linux newbie when it comes to repos/yum/packages etc, so any advice would be greatly appreciated.

Thanks for reading.

Elliot

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,834

Re: 'Transaction Check Error' installing ocsinventory (MySQL)

You don't post the full yum command and output, so it's difficult to analyse the issue.

But, the command pull the latest mysql-libs and yum can't handled the (indirect) update of MySQL.

If you want to update the LAMP stack (PHP 5.3, MySQL 5.1), you should update it before 

yum --enablerepo=remi update

If you want to keep the standard LAMP stack (PHP 5.1, MySQL 5.0), don't enable remi repository and install OCS from EPEL.

+

PS : EPEL repo provides version 1.3.1, remi repo provides 1.3.2.
There is a small but annoying bug in the 1.3.2, I'm waiting for a fix for it before pushing it to EPEL.

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website

3 Reply by elliot01 (edited by elliot01 2010-05-17 23:06:49)

  • Registered: 2010-05-16
  • Posts: 5

Re: 'Transaction Check Error' installing ocsinventory (MySQL)

Thank you ever so much for your reply big_smile

I am very weary of borking a production system, so I have gone the safer (well seemingly more easier route to me roll ) of disabling the remi repo for now.

First I did a normal 'yum update mysql', which updated MySQL to 5.0.84-2.el5.centos from the c5-testing repo, just to see what was available via my usual channels.

Next I disabled your remi repo and re-ran 'yum install ocsinventory'.

This has appeared to now install successfully (though I haven't done anything with it yet).

Thanks again for your very helpful response!