Installing MyODBC on AIX

I am attempting to install MySQL on an AIX system.  The details are as follows:

Hardware:  IBM RS/6000 43P model 150 (7043-150)
           512Mb Ram
           2 9Gb SCSI disks

Software:  AIX 5.2.0.2
           gcc 3.3.2 for AIX 5.2 (gcc-3.3.2.0.exe)
           MySQL 4.0.18 (mysql-standard-4.0.18-ibm-aix5.2.0.0-powerpc.tar.gz)
           MyODBC 3.51.06 (MyODBC-3.51.06.tar.gz)
           unixODBC 2.2.8 (unixODBC-2.2.8.tar.gz)


The software was installed as follows:

gcc:       Downloaded from www.bullfreeware.com and installed with smit.

MySQL      Downloaded from www.mysql.com as a binary distribution and
           untarred in the directory /opt/mysql-long-ugly-name which was then
           linked as /opt/mysql.  This has been tested, and appears to work
           fine.  I have used the mysql and mysqladmin programs to create
           databases, create tables, add data, extract data, and do the usual
           database kinds of things.

unixODBC   Downloaded the source from www.unixodbc.org and untarred the
           distribution.  I created a small file containing the following
           statements to provide input to the configure program.it was run
           with "sh unixODBC.conf"

               # more unixODBC.conf
               export CC=gcc
               export CXX=g++
               ./configure    --enable-threads=no \
                         --x-includes=/usr/lpp/X11/include \
                         --x-libraries=/usr/lpp/X11/lib

           Next, I did a "make" and a "make install"

           Since I don't have the Qt libraries installed on this machine the
           graphical interface (ODBCConfig) did not build, but everything
           else seemed to build OK.  Following the instruction in README.AIX,
           I changed directory to /usr/local/lib and did the following:

               ar -x libodbcmyS.a

           which created a file libodbcmyS.so.  As near as I can tell, this
           completed the install of unixODBC.

MyODBC     Downloaded the source from www.mysql.com and untarred the
           distribution.  Again, I created a small script to run configure in
           order to get the arguments right.  it looks like this:

           # cat MyODBC.config
           ./configure   --prefix=/usr/local \
                     --with-unixODBC=/usr/local \
                     --with-inixODBC-libs=/usr/local/lib \
                     --with-inixODBC-includes=/usr/local/include \
                     --with-mysql-dirs=/opt/mysql/lib \
                     --with-mysql-includes=/opt/mysql/include \
                     --with-mysql-libs=/opt/mysql/lib \
                     --without-debug \
                     --enable-thread-safe

           I then did a "make" and a "make install" which appeard to run OK.
           I did get a lot of warning messages from gcc, but nothing fatal.

Configuration  Next, I found an IBM RedBook which explains the use of MySQL,
           MyODBC, and unixODBC on Linux.  I used the examples in this book
           to create my /usr/local/etc/odbcinstl.ini and
           /usr/local/etc/odbc.ini files.  The files created by the install
           process were both empty.  My files look like this:

           # cat odbcinst.ini
           [MySQL]
           Description   = ODBC for MySQL
           Driver    = /usr/local/lib/libmyodbc.so
           FileUsage = 1

           # cat odbc.ini
           [adminDB]
           Driver   = /usr/local/lib/libmyodbc.so
           SERVER   = 127.0.0.1
           PORT     = 3306
           Database = ADMINISTRATOR

Testing    Log on as a user with access to the database.  Copy the file
           /etc/odbc.ini to the local user as $HOME/.odbc.ini and use the
           isql command to test the interface.  Command are:

           su - domino
           cp /etc/odbc.ini $HOME/.lodbc.ini
           isql -v adminDB domino password

           and the response is "[ISQL]ERROR: Could not SQLConnect"

           A little googling gives me a possible answer.  It appears that the
           same fix we had to apply before because of the AIX use of .a for
           shared libraries instead of .so is biting us again.  So, we do
           the following:

           cd /usr/local/lib
           ar -x libmyodbc3-3.51.06.a
           ln -s libmyodbc3-3.51.06.so libmyodbc3.so

           and test again.  Same result...

           I remember from somewhere I read earlier that the client is
           looking for the library to be named libmyodbc.so and not
           libmyodbc3.so so lets rename it again.

           mv libmyodbc3.so libmyodbc.so

           test one more time, and now we get the ultimate error...

           $ isql adminDB
           Segmentation fault(coredump)
           $

           OK, I'm officially stumped...  Help!!!

Harold
--
Harold Pritchett
harold@xxxxxxx                                +1.706.546.0692
pgp public key: http://www.arches.uga.edu/~harold/pgpkey.html

"They that can give up essential liberty to obtain a little
temporary safety deserve neither liberty nor safety."
   Benjamin Franklin, Historical Review of Pennsylvania, 1759.

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx