| Author |
Message
|
| wese345 |
 Posted: Tue Dec 17, 2013 11:58 pm Post subject: Cannot connect to MySQL by unixODBC |
 |
|
Novice
Joined: 05 Aug 2013
Posts: 21
|
Hi , anybody
Our application is based on MySQL database and need to use WMB to expand its ability. So I install MySQL on our Linux Server and follow the instruction by the source bellow.
The website :
http://www.strangeparty.com/2011/12/15/message-broker-v8-with-mysql/
It's wired that I use command
| Quote: |
| mqsicvp broker -n mysql |
It shows that
| Quote: |
| Can't connect to ODBC ... |
Can anyone tell me how to make it work and can be connected by MB compute node?
Many Thanks! |
|
| Back to top |
|
 |
| ajodowd |
| Posted: Wed Dec 18, 2013 12:52 am Post subject: |
|
|
Novice
Joined: 15 Dec 2013
Posts: 13
|
Hi wese345,
Can you post some details from the Windows or Linux logs?
Thanks, Anthony. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Wed Dec 18, 2013 12:53 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Did you use the mqsicvp command exactly as detailed in the website you linked to?
As I read your post and the website, the commands are different.
What version of Broker are you trying to connect to MySQL?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| wese345 |
| Posted: Wed Dec 18, 2013 2:29 am Post subject: |
|
|
Novice
Joined: 05 Aug 2013
Posts: 21
|
| smdavies99 wrote: |
Did you use the mqsicvp command exactly as detailed in the website you linked to?
As I read your post and the website, the commands are different.
What version of Broker are you trying to connect to MySQL? |
My MB version is 8.0.0.1.
The error info is below:
| Code: |
-bash-4.1$ mqsicvp -n esbmysql -u root -p root
BIP2393E: Database error: ODBC return code '-1' from data source ''esbmysql'' using ODBC driver manager ''/opt/ibm/IE02/2.0.0/lib/libodbcinterface.so''.
The broker received an error when processing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database about this error.
Use the following messages to determine the cause of the error. Typical problems are an incorrect data source, or table names. Correct either the database or the broker configuration.
BIP2322E: Database error: SQL State ''08S01''; Native Error Code '2002'; Error Text ''[unixODBC][MySQL][ODBC 3.51 Driver]Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)''.
The error has the following diagnostic information: SQL State ''08S01'' SQL Native Error Code '2002' SQL Error Text ''[unixODBC][MySQL][ODBC 3.51 Driver]Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)''
This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error.
BIP8040E: Unable to connect to the database.
The database cannot be accessed with the specified user Id and password pair.
- Check that the database is running.
- Check that the database has an adequate number of database connections available for use.
- On Windows, check that an ODBC connection has been created.
- On systems that use $ODBCINI, check that the file pointed to by $ODBCINI has been correctly updated.
- On z/OS check the BIPDSNAO member of the component's dataset, and check the DB2 64bit ODBC driver (DSNAO64C) is in the STEPLIB.
- Use mqsisetdbparms to set the password to the correct value and try again.
-bash-4.1$ |
ODBC.ini info is :
| Code: |
[esbmysql]
Driver=/opt/ibm/mqsi/8.0.0.1/ODBC/V6.0/lib/libmyodbc5.so
Setup=/opt/ibm/mqsi/8.0.0.1/ODBC/V6.0/lib/libodbcmyS.la
DATABASE=esbdb
DESCRIPTION=MySQL ODBC 5.2 Unicode Driver test
SERVER=127.0.0.1
UID=root
PASSWORD=root
PORT=3306
socket=/var/lib/mysql/mysql.sock
CPTimeout=10000
User=root
FileUsage=1
Trace=off
UsageCount=50
Option=3 |
Please help me . Thanks. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Wed Dec 18, 2013 3:09 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Strange that the two mqsicvp commands in your posts are different....  The second one is more useful at this stage.
Does executing the command
work correctly?
does doing
| Code: |
ldd -v /opt/ibm/mqsi/8.0.0.1/ODBC/V6.0/lib/libmyodbc5.so
|
show any missing libraries?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
|
|
