ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum IndexWebSphere Message Broker SupportBIP2393E: Database error: ODBC return code '-1'

Post new topicReply to topic
BIP2393E: Database error: ODBC return code '-1' View previous topic :: View next topic
Author Message
petervh1
PostPosted: Thu Sep 17, 2020 3:44 am Post subject: BIP2393E: Database error: ODBC return code '-1' Reply with quote

Acolyte

Joined: 19 Apr 2010
Posts: 64

Hello

I am trying to set up ODBC connectivity from my OpenShift platform to an on-prem database.

I followed the steps in https://www.ibm.com/support/knowledgecenter/SSTTDS_11.0.0/com.ibm.etools.mft.doc/bk58060_.html

(My only concern was the note that the odbc.ini and odbcinst.ini files should be owned by mqbrkrs and have 664 permissions - these 2 files were created when I set up ConfigMaps on the OKD console and they are as follows:


Code:
lrwxrwxrwx. 1 root root 15 Sep 17 10:58 odbc.ini -> ..data/odbc.ini
lrwxrwxrwx. 1 root root 19 Sep 17 10:58 odbcinst.ini -> ..data/odbcinst.ini


I cannot change the permissions because it's a read-only file system.
)

I ran mqsisetdbparms -n datasource -u user -p pwd

When I run mqsicvp -n datasource -u user -p pwd I get:

Code:
sh-4.4$ mqsicvp -n ESBDB -u xxx -p xxx
BIP8288W: Unable to read ODBCINI file '/home/aceuser/ace-server/odbc.ini/odbc.ini'. Check that this file exists, and that the integration node user ID has permission to read and write the file.
The integration node cannot read the file '/home/aceuser/ace-server/odbc.ini/odbc.ini', which is specified by the ODBCINI environment variable.
Ensure that the ODBCINI environment variable points to an existing file, and that the integration node user ID has permission to read and write the file.
BIP8295E: ODBC environment variables have not been set, or are invalid.
The integration node cannot verify user data sources because the ODBCINI, ODBCSYSINI, or IE02_PATH environment variables are not set, or because the ODBCINI environment variable is set incorrectly.
Ensure that the ODBCINI environment variable is set, and see earlier warning messages for further details.
sh-4.4$


In my Environment variables for this container, I have set:

Code:
ODBCINI = /home/aceuser/ace-server/odbc.ini/odbc.ini
ODBCSYSINI = /home/aceuser/ace-server/odbc.ini/odbcinst.ini


Questions:

1 Are the permissions for the odbc.ini and odbcinst.ini files OK as they are?
2 Do I need to set IE02_PATH environment variable? If so, to what?
3 Are my environment variables set correctly?

Thanks in advance
Back to top
View user's profile Send private message
abhi_thri
PostPosted: Thu Sep 17, 2020 5:21 am Post subject: Re: BIP2393E: Database error: ODBC return code '-1' Reply with quote

Partisan

Joined: 17 Jul 2017
Posts: 398
Location: UK

petervh1 wrote:

Code:
lrwxrwxrwx. 1 root root 15 Sep 17 10:58 odbc.ini -> ..data/odbc.ini
lrwxrwxrwx. 1 root root 19 Sep 17 10:58 odbcinst.ini -> ..data/odbcinst.ini


hi...if i read that correctly the odbc.ini and odbcinst.ini are just file shortcuts to ..data/odbc.ini and ..data/odbcinst.ini respectively? If so what are the permissions for those files?
Back to top
View user's profile Send private message
petervh1
PostPosted: Thu Sep 17, 2020 5:46 am Post subject: Reply with quote

Acolyte

Joined: 19 Apr 2010
Posts: 64

I searched for the odbc.ini file. This is what I got:
Code:

sh-4.4$ find / -name odbc.ini
find: '/var/cache/ldconfig': Permission denied
find: '/sys/firmware': Permission denied
find: '/run/secrets/rhsm': Permission denied
find: '/lost+found': Permission denied
find: '/root': Permission denied
/opt/ibm/ace-11/server/ODBC/unixodbc/odbc.ini
find: '/proc/tty/driver': Permission denied
find: '/proc/acpi': Permission denied
find: '/proc/scsi': Permission denied
find: '/proc/1/map_files': Operation not permitted
find: '/proc/32/map_files': Operation not permitted
find: '/proc/155/map_files': Operation not permitted
find: '/proc/201/map_files': Operation not permitted
find: '/proc/245/map_files': Operation not permitted
find: '/proc/258/map_files': Operation not permitted
/home/aceuser/ace-server/odbc.ini
/home/aceuser/ace-server/odbc.ini/..2020_09_17_10_58_25.629061152/odbc.ini
/home/aceuser/ace-server/odbc.ini/odbc.ini


The file in /opt/ibm/ace-11/server/ODBC/unixodbc/odbc.ini is the default supplied odbc.ini fle
Back to top
View user's profile Send private message
rekarm01
PostPosted: Thu Sep 17, 2020 11:45 am Post subject: Re: BIP2393E: Database error: ODBC return code '-1' Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 1396

Most shells can redirect unrelated error messages for "find":

Code:
sh-4.4$ find / -name odbc.ini 2> /dev/null
/opt/ibm/ace-11/server/ODBC/unixodbc/odbc.ini
/home/aceuser/ace-server/odbc.ini
/home/aceuser/ace-server/odbc.ini/..2020_09_17_10_58_25.629061152/odbc.ini
/home/aceuser/ace-server/odbc.ini/odbc.ini

What is that "..2020_09_17_10_58_25.629061152" directory for?

petervh1 wrote:
these 2 files were created when I set up ConfigMaps on the OKD console and they are as follows:

Code:
lrwxrwxrwx. 1 root root 15 Sep 17 10:58 odbc.ini -> ..data/odbc.ini
lrwxrwxrwx. 1 root root 19 Sep 17 10:58 odbcinst.ini -> ..data/odbcinst.ini

The "l" in the first column indicates that these are symbolic links, pointing to where the actual files should be. ".." is often used to indicate the parent directory, followed by "/", to indicate a relative path to a file from there. In this case though, based on the "find" output, neither the "..data" or "../data" directories seem to exist, or else they don't contain the desired ".ini" files.

Try displaying the contents of the files, (with "cat", "more", "view", etc.). What happens?

petervh1 wrote:
In my Environment variables for this container, I have set:

Code:
ODBCINI = /home/aceuser/ace-server/odbc.ini/odbc.ini
ODBCSYSINI = /home/aceuser/ace-server/odbc.ini/odbcinst.ini

$ODBCSYSINI needs to point to the directory containing the odbcinst.ini file.

petervh1 wrote:
1 Are the permissions for the odbc.ini and odbcinst.ini files OK as they are?
2 Do I need to set IE02_PATH environment variable? If so, to what?
3 Are my environment variables set correctly?

1. The permissions for the symbolic links don't matter; what are the permissions for the files that they point to?
2. Look for an "ie02" directory under "/opt/ibm/ace-11/..." directory; IE02_PATH can probably point to that.
3. As mentioned above, $ODBCSYSINI needs to point to a directory. Beyond that, the environment variables need to resolve to files that exist.
Back to top
View user's profile Send private message
gbaddeley
PostPosted: Thu Sep 17, 2020 4:48 pm Post subject: Reply with quote

Jedi

Joined: 25 Mar 2003
Posts: 2195
Location: Melbourne, Australia

Code:
sh-4.4$ mqsicvp -n ESBDB -u xxx -p xxx
BIP8288W: Unable to read ODBCINI file '/home/aceuser/ace-server/odbc.ini/odbc.ini'. Check that this file exists, and that the integration node user ID has permission to read and write the file.
The integration node cannot read the file '/home/aceuser/ace-server/odbc.ini/odbc.ini', which is specified by the ODBCINI environment variable.

"odbc.ini/odbc.ini" That doesn't seem right.
_________________
Glenn
Back to top
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker SupportBIP2393E: Database error: ODBC return code '-1'
Jump to:



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP


Theme by Dustin Baccetti
Powered by phpBB 2001, 2002 phpBB Group

Copyright MQSeries.net. All rights reserved.