Login or Register to Ask a Question and Join Our Community


AIX

Install MySQL connector without local SQL database

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems AIX Install MySQL connector without local SQL database
# 1  
Old 09-18-2008
Install MySQL connector without local SQL database
Hello UNIX gurus, I need to install the mysql odbc connector with unixODBC on my AIX 5.3 machine. I have a mySQL database running on another server (Ubuntu 7.04). The SQL database works fine. The problem I am having is when trying to run ./configure for mysql-connector-odbc it seems to be looking for a local SQL installation:
Code:
/y/mysql-connector-odbc-5.1.5r1144 # ./configure --with-unixODBC=/usr/local
configure: error: Can't find mysql_config in /opt/mysql/mysql /usr/local/mysql /usr

Trying to use a precompiled binary:
Code:
/y/mysql-connector-odbc-5.1.5-aix5.2-powerpc-64bit/bin # ./myodbc-installer        
exec(): 0509-036 Cannot load program ./myodbc-installer because of the following errors:
        0509-150   Dependent module libodbc.so could not be loaded.
        0509-022 Cannot load module libodbc.so.
        0509-026 System error: A file or directory in the path name does not exist.

anything with libodbc in its name:
Code:
/y/mysql-connector-odbc-5.1.5r1144 # find / | grep libodbc
/usr/local/lib/libodbcinst.a
/usr/local/lib/libodbcinst.la
/usr/local/lib/libodbc.a
/usr/local/lib/libodbc.la
/usr/local/lib/libodbccr.a
/usr/local/lib/libodbccr.la
/usr/local/lib/libodbcdrvcfg1S.a
/usr/local/lib/libodbcdrvcfg1S.la
/usr/local/lib/libodbcdrvcfg2S.a
/usr/local/lib/libodbcdrvcfg2S.la
/usr/local/lib/libodbcpsqlS.a
/usr/local/lib/libodbcpsqlS.la
/usr/local/lib/libodbcminiS.a
/usr/local/lib/libodbcminiS.la
/usr/local/lib/libodbcmyS.a
/usr/local/lib/libodbcmyS.la
/usr/local/lib/libodbcnnS.a
/usr/local/lib/libodbcnnS.la
/usr/local/lib/libodbctxtS.a
/usr/local/lib/libodbctxtS.la
/usr/local/lib/libodbcpsql.a
/usr/local/lib/libodbcpsql.la
/y/unixODBC-2.2.12/Drivers/PostgreSQL/.libs/libodbcpsql.exp
/y/unixODBC-2.2.12/Drivers/PostgreSQL/.libs/libodbcpsql.lai
/y/unixODBC-2.2.12/Drivers/PostgreSQL/.libs/libodbcpsql.so.1
/y/unixODBC-2.2.12/Drivers/PostgreSQL/.libs/libodbcpsql.a
/y/unixODBC-2.2.12/Drivers/PostgreSQL/.libs/libodbcpsql.la
/y/unixODBC-2.2.12/Drivers/PostgreSQL/libodbcpsql.la
/y/unixODBC-2.2.12/Drivers/Postgre7.1/.libs/libodbcpsql.exp
/y/unixODBC-2.2.12/Drivers/Postgre7.1/.libs/libodbcpsql.lai
/y/unixODBC-2.2.12/Drivers/Postgre7.1/.libs/libodbcpsql.so.2
/y/unixODBC-2.2.12/Drivers/Postgre7.1/.libs/libodbcpsql.a
/y/unixODBC-2.2.12/Drivers/Postgre7.1/.libs/libodbcpsql.la
/y/unixODBC-2.2.12/Drivers/Postgre7.1/libodbcpsql.la
/y/unixODBC-2.2.12/extras/.libs/libodbcextraslc.a
/y/unixODBC-2.2.12/extras/.libs/libodbcextraslc.la
/y/unixODBC-2.2.12/extras/libodbcextraslc.la
/y/unixODBC-2.2.12/odbcinst/.libs/libodbcinst.lai
/y/unixODBC-2.2.12/odbcinst/.libs/libodbcinst.so.1
/y/unixODBC-2.2.12/odbcinst/.libs/libodbcinst.a
/y/unixODBC-2.2.12/odbcinst/.libs/libodbcinst.la
/y/unixODBC-2.2.12/odbcinst/.libs/libodbcinstlc.a
/y/unixODBC-2.2.12/odbcinst/.libs/libodbcinstlc.la
/y/unixODBC-2.2.12/odbcinst/libodbcinst.la
/y/unixODBC-2.2.12/odbcinst/libodbcinstlc.la
/y/unixODBC-2.2.12/DriverManager/.libs/libodbc.lai
/y/unixODBC-2.2.12/DriverManager/.libs/libodbc.so.1
/y/unixODBC-2.2.12/DriverManager/.libs/libodbc.a
/y/unixODBC-2.2.12/DriverManager/.libs/libodbc.la
/y/unixODBC-2.2.12/DriverManager/libodbc.la
/y/unixODBC-2.2.12/cur/.libs/libodbccr.so.1
/y/unixODBC-2.2.12/cur/.libs/libodbccr.a
/y/unixODBC-2.2.12/cur/.libs/libodbccr.lai
/y/unixODBC-2.2.12/cur/.libs/libodbccr.la
/y/unixODBC-2.2.12/cur/libodbccr.la
/y/unixODBC-2.2.12/DRVConfig/drvcfg1/.libs/libodbcdrvcfg1S.exp
/y/unixODBC-2.2.12/DRVConfig/drvcfg1/.libs/libodbcdrvcfg1S.so.1
/y/unixODBC-2.2.12/DRVConfig/drvcfg1/.libs/libodbcdrvcfg1S.a
/y/unixODBC-2.2.12/DRVConfig/drvcfg1/.libs/libodbcdrvcfg1S.lai
/y/unixODBC-2.2.12/DRVConfig/drvcfg1/.libs/libodbcdrvcfg1S.la
/y/unixODBC-2.2.12/DRVConfig/drvcfg1/libodbcdrvcfg1S.la
/y/unixODBC-2.2.12/DRVConfig/drvcfg2/.libs/libodbcdrvcfg2S.exp
/y/unixODBC-2.2.12/DRVConfig/drvcfg2/.libs/libodbcdrvcfg2S.so.1
/y/unixODBC-2.2.12/DRVConfig/drvcfg2/.libs/libodbcdrvcfg2S.a
/y/unixODBC-2.2.12/DRVConfig/drvcfg2/.libs/libodbcdrvcfg2S.lai
/y/unixODBC-2.2.12/DRVConfig/drvcfg2/.libs/libodbcdrvcfg2S.la
/y/unixODBC-2.2.12/DRVConfig/drvcfg2/libodbcdrvcfg2S.la
/y/unixODBC-2.2.12/DRVConfig/PostgreSQL/libodbcpsqlS.la
/y/unixODBC-2.2.12/DRVConfig/PostgreSQL/.libs/libodbcpsqlS.exp
/y/unixODBC-2.2.12/DRVConfig/PostgreSQL/.libs/libodbcpsqlS.so.1
/y/unixODBC-2.2.12/DRVConfig/PostgreSQL/.libs/libodbcpsqlS.a
/y/unixODBC-2.2.12/DRVConfig/PostgreSQL/.libs/libodbcpsqlS.lai
/y/unixODBC-2.2.12/DRVConfig/PostgreSQL/.libs/libodbcpsqlS.la
/y/unixODBC-2.2.12/DRVConfig/MiniSQL/libodbcminiS.la
/y/unixODBC-2.2.12/DRVConfig/MiniSQL/.libs/libodbcminiS.exp
/y/unixODBC-2.2.12/DRVConfig/MiniSQL/.libs/libodbcminiS.so.1
/y/unixODBC-2.2.12/DRVConfig/MiniSQL/.libs/libodbcminiS.a
/y/unixODBC-2.2.12/DRVConfig/MiniSQL/.libs/libodbcminiS.lai
/y/unixODBC-2.2.12/DRVConfig/MiniSQL/.libs/libodbcminiS.la
/y/unixODBC-2.2.12/DRVConfig/MySQL/.libs/libodbcmyS.exp
/y/unixODBC-2.2.12/DRVConfig/MySQL/.libs/libodbcmyS.so.1
/y/unixODBC-2.2.12/DRVConfig/MySQL/.libs/libodbcmyS.a
/y/unixODBC-2.2.12/DRVConfig/MySQL/.libs/libodbcmyS.lai
/y/unixODBC-2.2.12/DRVConfig/MySQL/.libs/libodbcmyS.la
/y/unixODBC-2.2.12/DRVConfig/MySQL/libodbcmyS.la
/y/unixODBC-2.2.12/DRVConfig/nn/.libs/libodbcnnS.exp
/y/unixODBC-2.2.12/DRVConfig/nn/.libs/libodbcnnS.so.1
/y/unixODBC-2.2.12/DRVConfig/nn/.libs/libodbcnnS.a
/y/unixODBC-2.2.12/DRVConfig/nn/.libs/libodbcnnS.lai
/y/unixODBC-2.2.12/DRVConfig/nn/.libs/libodbcnnS.la
/y/unixODBC-2.2.12/DRVConfig/nn/libodbcnnS.la
/y/unixODBC-2.2.12/DRVConfig/txt/.libs/libodbctxtS.exp
/y/unixODBC-2.2.12/DRVConfig/txt/.libs/libodbctxtS.so.1
/y/unixODBC-2.2.12/DRVConfig/txt/.libs/libodbctxtS.a
/y/unixODBC-2.2.12/DRVConfig/txt/.libs/libodbctxtS.lai
/y/unixODBC-2.2.12/DRVConfig/txt/.libs/libodbctxtS.la
/y/unixODBC-2.2.12/DRVConfig/txt/libodbctxtS.la
/y/libiodbc-3.52.6/iodbc/install_libodbc.sh

/y is where I have all the sources and stuff I have downloaded.

unixODBC compiled and installed fine but it is not set up to use any databases yet.

There must be a way to install the connector just to use an external database, surely I do not have to install SQL on the AIX machine only to build the connector to connect to the external database? Thanks
# 2  
Old 09-22-2008
Just an update, maybe it can help somebody out. (this is from memory)
unixodbc created a bunch of .a and .la files. running ar -x libodbc.a produces libodbc.so.1
if you then copy libodbc.so.1 to /usr/lib/libodbc.so and do the same with libodbinst.a the binary mysql connector will install.
note: I tried this on slackware linux and unixodbc created the .so files right off the bat.
Login or Register to Ask a Question

Previous Thread | Next Thread

1 More Discussions You Might Find Interesting

1. Red Hat

Missing dependencies updating unixODBC / MySQL Connector

I have installed mysql-connector-odbc-5.1.5-0.i386.rpm and libtools on my Fedora12 system. Updating with yum says that there is nothing to update. Updating with rpm -Uvh mysql-connector-odbc-5.1.7-0.i386.rpm fails with the same missing dependencies as for the 64-bit version. Should I force... (4 Replies)
Discussion started by: Bengbers
4 Replies
Login or Register to Ask a Question