UnixODBC/mysql odbc

kamikaze_df
(usa KUbuntu)

Enviado em 17/10/2011 - 20:26h

Senhores

Gostaria de vossa ajuda para solucionar um probleminha:

[root@servidor home]# yum list installed |grep mysql

mysql-connector-odbc.i386                 5.1.8-1.rhel5                installed

mysql-connector-odbc-setup.i386           3.51.28-1.rhel5              installed

mysql-connector-odbc-setup.i386           5.1.8-1.rhel5                installed

mysql-connector-odbc-setup.x86_64         5.1.8-1.rhel5                installed

[root@servidor home]# yum list installed |grep unix

unixODBC.i386                             2.2.11-7.1                   installed

unixODBC.x86_64                           2.2.11-7.1                   installed

[root@servidor home]# odbc_config --version

2.3.0

[root@servidor home]# yum remove mysql-connector-odbc.i386 -y

Loaded plugins: rhnplugin

Setting up Remove Process

Resolving Dependencies

--> Running transaction check

---> Package mysql-connector-odbc.i386 0:5.1.8-1.rhel5 set to be erased

--> Processing Dependency: mysqlodbcrpmpack for package: mysql-connector-odbc-setup

--> Processing Dependency: mysqlodbcrpmpack for package: mysql-connector-odbc-setup

--> Processing Dependency: mysqlodbcrpmpack for package: mysql-connector-odbc-setup

--> Running transaction check

---> Package mysql-connector-odbc-setup.i386 0:3.51.28-1.rhel5 set to be erased

---> Package mysql-connector-odbc-setup.i386 0:5.1.8-1.rhel5 set to be erased

---> Package mysql-connector-odbc-setup.x86_64 0:5.1.8-1.rhel5 set to be erased

--> Finished Dependency Resolution



Dependencies Resolved



=====================================================================================

 Package                       Arch    Version            Repository      Size

=====================================================================================

Removing:

 mysql-connector-odbc          i386    5.1.8-1.rhel5      installed       3.4 M

Removing for dependencies:

 mysql-connector-odbc-setup    i386    3.51.28-1.rhel5    installed       5.8 M

 mysql-connector-odbc-setup    i386    5.1.8-1.rhel5      installed       6.0 M

 mysql-connector-odbc-setup    x86_64  5.1.8-1.rhel5      installed       6.4 M



Transaction Summary

======================================================================================

Remove        4 Package(s)

Reinstall     0 Package(s)

Downgrade     0 Package(s)



Downloading Packages:

Running rpm_check_debug

Running Transaction Test

Finished Transaction Test

Transaction Test Succeeded

Running Transaction

/var/tmp/rpm-tmp.87108: line 1: myodbc-installer: command not found

/var/tmp/rpm-tmp.87108: line 2: myodbc-installer: command not found

/var/tmp/rpm-tmp.87108: line 1: myodbc-installer: command not found

/var/tmp/rpm-tmp.87108: line 2: myodbc-installer: command not found

/var/tmp/rpm-tmp.87108: line 1: myodbc3i: command not found

/var/tmp/rpm-tmp.87108: line 2: myodbc3i: command not found

/var/tmp/rpm-tmp.87108: line 1: myodbc-installer: command not found



Removed:

  mysql-connector-odbc.i386 0:5.1.8-1.rhel5



Dependency Removed:

  mysql-connector-odbc-setup.i386 0:3.51.28-1.rhel5

  mysql-connector-odbc-setup.i386 0:5.1.8-1.rhel5

  mysql-connector-odbc-setup.x86_64 0:5.1.8-1.rhel5



Complete!

[root@servidor home]# yum remove mysql-connector-odbc-setup.i386 -y

Loaded plugins: rhnplugin

Setting up Remove Process

Resolving Dependencies

--> Running transaction check

---> Package mysql-connector-odbc-setup.i386 0:3.51.28-1.rhel5 set to be erased

---> Package mysql-connector-odbc-setup.i386 0:5.1.8-1.rhel5 set to be erased

--> Finished Dependency Resolution



Dependencies Resolved



===========================================================================

 Package                      Arch    Version            Repository   Size

===========================================================================

Removing:

 mysql-connector-odbc-setup   i386    3.51.28-1.rhel5    installed    5.8 M

 mysql-connector-odbc-setup   i386    5.1.8-1.rhel5      installed    6.0 M



Transaction Summary

===========================================================================

Remove        2 Package(s)

Reinstall     0 Package(s)

Downgrade     0 Package(s)



Downloading Packages:

Running rpm_check_debug

Running Transaction Test

Finished Transaction Test

Transaction Test Succeeded

Running Transaction

/var/tmp/rpm-tmp.10080: line 1: myodbc-installer: command not found

/var/tmp/rpm-tmp.10080: line 2: myodbc-installer: command not found

/var/tmp/rpm-tmp.10080: line 1: myodbc3i: command not found

/var/tmp/rpm-tmp.10080: line 2: myodbc3i: command not found



Removed:

  mysql-connector-odbc-setup.i386 0:3.51.28-1.rhel5  

  mysql-connector-odbc-setup.i386 0:5.1.8-1.rhel5



Complete!

[root@servidor home]# yum list installed |grep mysql

mysql-connector-odbc.i386                 5.1.8-1.rhel5                installed

mysql-connector-odbc-setup.i386           3.51.28-1.rhel5              installed

mysql-connector-odbc-setup.i386           5.1.8-1.rhel5                installed

mysql-connector-odbc-setup.x86_64         5.1.8-1.rhel5                installed



 

Ou seja, não consigo desinstalar nada, não sou exatamente um iniciante, mas esse problema está me tirando o sono, porque para um determinado software necessito instalar a versão 3.51 do driver mysql-odbc, para outro, necessito do 5.1.8. Resultado não consigo tirar nenhum deles, e nenhum deles está funcionando corretamente (usei para instalação rpm -ivh pacote.rpm --force --nodeps), eis aí o resultado.

Há ainda o problema com o unixODBC, a versão instalada é 2.2.11, mas depois compilei uma nova por exigência do mysql-odbc 5.1, compilei o unixODBC 2.3.0 e o mysql não reconheceu mais os libxxxx.so. Esse servidor está em produção, não tenho como reinstalar tudo, então me resta apagar arquivo por arquivo, e depois excluir do database do yum/rpm os pacotes "instalados" ... o que faço?

Ajuda que já não sei mais o que fazer.

Abraço