Bug #40405 Remove Mysql-odbc-connector fail
Submitted: 29 Oct 2008 19:24 Modified: 18 Feb 2009 17:29
Reporter: Thomas Lee Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:3.51, 5.1 OS:Linux (ES 4.7)
Assigned to: CPU Architecture:Any
Tags: Remove connector

[29 Oct 2008 19:24] Thomas Lee
Description:
I have downloaded connector 3.51 and 5.1. When installing  3.51 got error message so I installed 5.1 hoping can get rid of error, but then I cant reomove
them out.

[root@mastero2 linux-mysql-rpm-new]# rpm -iv linux-mysql-connector-odbc-3.51.12-1.i586.rpm 
Preparing packages for installation... 
        package mysql-connector-odbc-5.1.5-0 (which is newer than mysql-connector-odbc-3.51.12-1) is already installed 
        package mysql-connector-odbc-3.51.12-1 is already installed 

[root@mastero2 download]# rpm -iv  mysql-connector-odbc-5.1.5-0.i386.rpm 
warning: mysql-connector-odbc-5.1.5-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 
Preparing packages for installation... 
        package mysql-connector-odbc-5.1.5-0 is already installed 

[root@mastero2 download]# rpm -evv mysql-connector-odbc-5.1.5-0.i386.rpm  
D: opening  db environment /var/lib/rpm/Packages joinenv 
D: opening  db index       /var/lib/rpm/Packages rdonly mode=0x0 
D: locked   db index       /var/lib/rpm/Packages 
D: opening  db index       /var/lib/rpm/Name rdonly mode=0x0 
error: package mysql-connector-odbc-5.1.5-0.i386.rpm is not installed 
D: closed   db index       /var/lib/rpm/Name 
D: closed   db index       /var/lib/rpm/Packages 
D: closed   db environment /var/lib/rpm/Packages 
 
[root@mastero2 linux-mysql-rpm-new]# rpm -evv linux-mysql-connector-odbc-3.51.12-1.i586.rpm 
D: opening  db environment /var/lib/rpm/Packages joinenv 
D: opening  db index       /var/lib/rpm/Packages rdonly mode=0x0 
D: locked   db index       /var/lib/rpm/Packages 
D: opening  db index       /var/lib/rpm/Name rdonly mode=0x0 
error: package linux-mysql-connector-odbc-3.51.12-1.i586.rpm is not installed 
D: closed   db index       /var/lib/rpm/Name 
D: closed   db index       /var/lib/rpm/Packages 
D: closed   db environment /var/lib/rpm/Packages 
 

How to repeat:
Just download them from your site will do it.
[4 Nov 2008 10:33] Tonci Grgin
Hi again Thomas.

I can't be 100% sure all rpm version can handle what you write, but I'm pretty sure what you did is wrong. This appears as simple usage error, "rpm -evv mysql-connector-odbc-5.1.5-0.i386.rpm" => "rpm -evv mysql-connector-odbc-5.1.5-0".

Please retest and inform me of results.
[4 Nov 2008 17:40] Thomas Lee
Thank you, that is work but I saw some undefined symbol error still came from 
unixodbc which I already installed successfully before

[root@mastero2 download]# rpm -evv mysql-connector-odbc-5.1.5-0
D: opening  db environment /var/lib/rpm/Packages joinenv
D: opening  db index       /var/lib/rpm/Packages rdonly mode=0x0
D: locked   db index       /var/lib/rpm/Packages
D: opening  db index       /var/lib/rpm/Name rdonly mode=0x0
D:  read h#    1261 Header SHA1 digest: OK (704027e7d4da744d2e2bd5eecd5a217fe1542350)
D: ========== --- mysql-connector-odbc-5.1.5-0 i386/linux 0x1
D: opening  db index       /var/lib/rpm/Requirename rdonly mode=0x0
D: closed   db index       /var/lib/rpm/Requirename
D: closed   db index       /var/lib/rpm/Name
D: closed   db index       /var/lib/rpm/Packages
D: closed   db environment /var/lib/rpm/Packages
D: opening  db environment /var/lib/rpm/Packages joinenv
D: opening  db index       /var/lib/rpm/Packages create mode=0x42
D: mounted filesystems:
D:     i    dev bsize       bavail       iavail mount point
D:     0 0xfd00  4096        10390       121730 /
D:     1 0x0003  4096            0           -1 /proc
D:     2 0x0000  4096            0           -1 /sys
D:     3 0x0009  4096            0           -1 /dev/pts
D:     4 0x000e  4096            0           -1 /proc/bus/usb
D:     5 0x0803  1024        80339        26166 /boot
D:     6 0x0010  4096       129127       129126 /dev/shm
D:     7 0xfd01  1024       467867       129431 /tmp
D:     8 0xfd02  4096     27833748     15194779 /usr
D:     9 0xfd03  1024       328121       127749 /var
D:    10 0xfd05  4096      6196837      3335752 /home
D:    11 0x0011  4096            0           -1 /proc/sys/fs/binfmt_misc
D:    12 0x0012  4096            0           -1 /var/lib/nfs/rpc_pipefs
D: sanity checking 1 elements
D: computing 11 file fingerprints
D: computing file dispositions
D: opening  db index       /var/lib/rpm/Basenames create mode=0x42
D: ========== --- mysql-connector-odbc-5.1.5-0 i386-linux 0x1
D:     erase: mysql-connector-odbc-5.1.5-0 has 11 files, test = 0
D: opening  db index       /var/lib/rpm/Name create mode=0x42
D:  read h#    1261 Header SHA1 digest: OK (704027e7d4da744d2e2bd5eecd5a217fe1542350)
D: opening  db index       /var/lib/rpm/Triggername create mode=0x42
D:     erase: %preun(mysql-connector-odbc-5.1.5-0.i386) asynchronous scriptlet start
D:     erase: %preun(mysql-connector-odbc-5.1.5-0.i386) execv(/bin/sh) pid 24185+
myodbc-installer -r -d -n 'MySQL ODBC 5.1 Driver'
myodbc-installer: symbol lookup error: myodbc-installer: undefined symbol:
SQLRemoveDriverW
D:     erase: waitpid(24185) rc 24185 status 7f00 secs 0.013
error: %preun(mysql-connector-odbc-5.1.5-0.i386) scriptlet failed, exit status 127
D: closed   db index       /var/lib/rpm/Triggername
D: closed   db index       /var/lib/rpm/Basenames
D: closed   db index       /var/lib/rpm/Name
D: closed   db index       /var/lib/rpm/Packages
D: closed   db environment /var/lib/rpm/Packages
[root@mastero2 download]#
[18 Feb 2009 12:22] Tonci Grgin
Thomas, do you by any chance use x64 OS?
[18 Feb 2009 17:29] Tonci Grgin
Apparently, this is due to lack of unicode installer routines in UnixODBC < 2.2.12. See Bug#41833 for details. Now I'm puzzled how you managed to install c/ODBC 5.1 at all.