The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Operating Systems > AIX
Install MySQL connector without local SQL database Install MySQL connector without local SQL database
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read


AIX AIX is IBM's industry-leading UNIX operating system that meets the demands of applications that businesses rely upon in today's marketplace.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
MySQL Connector/ODBC 5.1.5 (Production (5.1.x) branch) iBot Software Releases - RSS News 0 08-20-2008 04:40 AM
MySQL Connector/ODBC 3.51.26 (Old Production branch) iBot Software Releases - RSS News 0 07-15-2008 07:50 PM
MySQL Connector/ODBC 3.51.25 (Old Production branch) iBot Software Releases - RSS News 0 04-17-2008 02:10 AM
MySQL Connector/ODBC 5.1.3 (Development branch) iBot Software Releases - RSS News 0 03-28-2008 10:10 AM
MySQL Connector/ODBC 3.51.24 (Production branch) iBot Software Releases - RSS News 0 03-21-2008 08:40 AM

Closed Thread
English Japanese Spanish French German Portuguese Italian Dutch Swedish Russian Norwegian Hungarian Hebrew Danish Bulgarian Greek Powered by Powered by Google
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 09-18-2008
raidzero's Avatar
raidzero raidzero is offline
Registered User
  
 

Join Date: Jun 2008
Posts: 60
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 (permalink)  
Old 09-22-2008
raidzero's Avatar
raidzero raidzero is offline
Registered User
  
 

Join Date: Jun 2008
Posts: 60
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.
Closed Thread

Bookmarks

« AIX and TCB | HACMP and Filesystems question »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Hybrid Mode Hybrid Mode
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 11:16 PM.

The UNIX and Linux Forums - Learn UNIX and UNIX Commands RSS Feeds - Contact Us - The UNIX and Linux Forums - Learn UNIX and UNIX Commands - Archive - Top

Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited. Language Translations Powered by .
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
The UNIX and Linux Forums Content Copyright ©1993-2009. All Rights Reserved.Ad Management by RedTyger

Content Relevant URLs by vBSEO 3.2.0