| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| WMB 8.0.0.4 broker id ODBCINI write permission issue |
« View previous topic :: View next topic » |
| Author |
Message
|
| rekarm01 |
 Posted: Thu Sep 11, 2014 2:28 pm Post subject: WMB 8.0.0.4 broker id ODBCINI write permission issue |
 |
|
Grand Master
Joined: 25 Jun 2008
Posts: 1415
|
After upgrading from WMB 8.0.0.1 to WMB 8.0.0.4 (on AIX 7.1.0.0), we started getting ODBCINI errors during broker startup, and also with the mqsicvp command:
| Code: |
$ mqsicvp myBROKER -n myDSN -v
BIP8288W: Unable to read ODBCINI file '/.../odbc.ini'. Check that this file exists, and that the broker user ID has permission to read and write the file.
The broker cannot read the file '/.../odbc.ini', which is specified by the ODBCINI environment variable.
Ensure that the ODBCINI environment variable points to an existing file, and that the broker user ID has permission to read and write the file.
BIP8295E: ODBC environment variables have not been set, or are invalid.
The broker 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. |
The $ODBCINI file does exist, currently with owner:group=mqm:mqbrkrs, perm=755. The Knowledge Center instructs to "ensure that the odbc.ini file has file ownership of mqm:mqbrkrs and has the same permissions as the supplied sample file". The sample files do have the same permission (755), but are owned by either root:mqm (v8001) or root:system (v8004). We get this error when the (mqbrkrs group) user has read-only permission for the $ODBCINI file, but the error goes away when we change the permission to read-write.
So it seems that WMBv8001 does not require write permission for the $ODBCINI file, but WMBv8004 does require it. Is this an intentional change in behavior? Why would the broker runtime or mqsicvp command need write permission on this file? Our broker administrators are reluctant to grant group write permission on all of the $ODBCINI files for all of our brokers without a better explanation as to why it's now necessary, or without knowing what else might be necessary.
We are also opening up a PMR about this issue.
Thanks, |
|
| 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
|
|
|
|
