| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| BIP2393E: Database error: ODBC return code '-1' |
« View previous topic :: View next topic » |
| Author |
Message
|
| petervh1 |
 Posted: Thu Sep 17, 2020 3:44 am Post subject: BIP2393E: Database error: ODBC return code '-1' |
 |
|
Centurion
Joined: 19 Apr 2010
Posts: 135
|
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 |
|
 |
| abhi_thri |
| Posted: Thu Sep 17, 2020 5:21 am Post subject: Re: BIP2393E: Database error: ODBC return code '-1' |
|
|
Knight
Joined: 17 Jul 2017
Posts: 516
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 |
|
|
| petervh1 |
| Posted: Thu Sep 17, 2020 5:46 am Post subject: |
|
|
Centurion
Joined: 19 Apr 2010
Posts: 135
|
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 |
|
|
| rekarm01 |
| Posted: Thu Sep 17, 2020 11:45 am Post subject: Re: BIP2393E: Database error: ODBC return code '-1' |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 1415
|
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 |
|
|
| gbaddeley |
| Posted: Thu Sep 17, 2020 4:48 pm Post subject: |
|
|
Jedi Knight
Joined: 25 Mar 2003
Posts: 2538
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 |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
