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:
/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:
/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:
/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