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 IndexIBM MQ Installation/Configuration SupportDB2+MQ; cannot create db2mq.tmp: Permission denied

Post new topicReply to topic
DB2+MQ; cannot create db2mq.tmp: Permission denied View previous topic :: View next topic
Author Message
Peter_MQ
PostPosted: Mon May 20, 2019 1:10 am Post subject: DB2+MQ; cannot create db2mq.tmp: Permission denied Reply with quote

Newbie

Joined: 20 May 2019
Posts: 4

Hello all,

I want create a trigger (in my database DB2) sending message to queue.
I use dockerfile to create build with IBM MQ, IBM DB2express-c and IBM IIB in Docker.
After I used command enable_MQFunctions (It creates DB2MQ tables+configuration, yep?) I got:
sh: 1: cannot create db2mq.tmp: Permission denied
Using command chown I gave my user permission to /tmp and var/tmp but no possitive effect after, but mu user is listed (drwxrwxrwt) after I type ls -ld tmp command.

So after first try enable_MQFunctions I got:
Command crtmqm -lf 1024 DB2MQ_DEFAULT_MQM 2>db2mq.tmp failed, rc=512, errno=0
So, I created manually default MQ and then typed again enable_MQFunctions:

sh: 1: cannot create db2mq.tmp: Permission denied
-- Create MQ Functions ...
SQLExecDirect - SELECT COUNT(*) FROM DB2MQ.MQPOLICY
-- (-1)
SQL error or warning occurred. Processing can continue...
Inspect the SQL error or warning conditions that occurred.


UNEXPECTED FAILURE (SQLSTATE=42S02) (SQLCODE=4294967092)
(errorMsg: [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N "DB2MQ.MQPOLICY" is an undefined name. SQLSTATE=42704
)

An error occurred during a configuration check,
The MQPolicy table does not exist, or the table is empty.
Create the configuration database objects using the script that is provided
before you issue the command again.
Validate MQ Functions ...
SQL error or warning occurred. Processing can continue...

*** Error -- while validating MQ functions using the default configuration.
Please ensure that the following actions are complete:
1. You created the configuration tables and objects in the database.
2. The 'DB2.DEFAULT.SERVICE' entry in the MQService table has the following values: queueMgrName: DB2MQ_DEFAULT_MQM
queueName: DB2MQ_DEFAULT_Q
3. The 'DB2.DEFAULT.POLICY' entry in the MQPolicy table has the following value:
connectionName: connectionDB2MQ
4. Ensure that the MQHost table has an entry for connectionDB2MQ and the queueMgrName is: DB2MQ_DEFAULT_MQM.
5. You enabled federation on DB Manager if '-v 1pc', '-v all', or no -v is specified.
*** enable_MQFunction finished with error


Version usage in Docker build:
DB2express-c: db2exc_970_LNX_x86_64.tar.gz
MQ: mqadv_dev80_linux_x86-64.tar.gz
IIB: 10.0.0.7-IIB-LINUX64-DEVELOPER.tar.gz
Ubuntu 16.04 amd64
Back to top
View user's profile Send private message
Vitor
PostPosted: Mon May 20, 2019 5:13 am Post subject: Re: DB2+MQ; cannot create db2mq.tmp: Permission denied Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 25858
Location: Texas, USA

Peter_MQ wrote:

Using command chown I gave my user permission to /tmp and var/tmp but no possitive effect after, but mu user is listed (drwxrwxrwt) after I type ls -ld tmp command.


Odd choice - it looks to me more like you're missing permissions within DB2 rather than the OS
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
markt
PostPosted: Mon May 20, 2019 5:34 am Post subject: Reply with quote

Chevalier

Joined: 14 May 2002
Posts: 427

And what makes you think it's trying to use /var/tmp or /tmp? Nothing in what you've posted has either of those directories
Back to top
View user's profile Send private message
Peter_MQ
PostPosted: Mon May 20, 2019 5:44 am Post subject: Reply with quote

Newbie

Joined: 20 May 2019
Posts: 4

I logged in root and chmod -R 1777 to all folders and this .tmp file no permission error disappair. But I have new error. DBname=TEST is for sure exist and active instance (db2 list db directory shows it). Pass/user are also good

(IIB_10:)db2inst1@980df9a30c0e:/$ enable_MQFunctions -n TEST -u db2inst1 -p pass

*** Error -- while connecting to TEST
Make sure that user(db2inst1) and password(pass) are valid and that the DB2
instance has started.
*** enable_MQFunction finished with error


Any help?
Back to top
View user's profile Send private message
Vitor
PostPosted: Mon May 20, 2019 5:57 am Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 25858
Location: Texas, USA

Peter_MQ wrote:
I logged in root and chmod -R 1777 to all folders and this .tmp file no permission error disappair.


Well yes, removing all the security on your file system will make any permissions problems disappear. It's also a contact admin of an assumption that a .tmp file is being written to /tmp or /var/tmp.

Peter_MQ wrote:
But I have new error. DBname=TEST is for sure exist and active instance (db2 list db directory shows it). Pass/user are also good


And if you try actually looking at the error, it doesn't say "does not exist" nor does it say 'invalid password". It says "cannot connect"

Peter_MQ wrote:
Any help?


- Don't remove all the security on your OS to fix permissions problems
- Figure out the connection issue.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
Peter_MQ
PostPosted: Mon May 20, 2019 6:25 am Post subject: Reply with quote

Newbie

Joined: 20 May 2019
Posts: 4

Vitor wrote:
And if you try actually looking at the error, it doesn't say "does not exist" nor does it say 'invalid password". It says "cannot connect"

No offence but it says Make sure that user(db2inst1) and password(pass) are valid and that the DB2 instance has started.
And it's a bit strange error(connection issue) because before I manage to save db2mq.tmp file command enable_MQFunctions clearly saw my database...
Back to top
View user's profile Send private message
Vitor
PostPosted: Mon May 20, 2019 6:42 am Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 25858
Location: Texas, USA

Peter_MQ wrote:
No offence but it says Make sure that user(db2inst1) and password(pass) are valid and that the DB2 instance has started.


And you've been very adamant that the credentials are correct.....

Peter_MQ wrote:
And it's a bit strange error(connection issue) because before I manage to save db2mq.tmp file command enable_MQFunctions clearly saw my database...


You were expecting something else?
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
bruce2359
PostPosted: Mon May 20, 2019 7:09 am Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 8534
Location: US: west coast, almost. Otherwise, enroute.

Vitor wrote:

- Don't remove all the security on your OS to fix permissions problems.


MQ and DB2 installation procedures correctly set file system permission bits. Unless specifically directed by IBM, you should never alter o/s file system permission bits.
_________________
There are two types of people in this world:
1) Those that can extrapolate from incomplete data
Back to top
View user's profile Send private message
Peter_MQ
PostPosted: Mon May 20, 2019 11:45 am Post subject: Reply with quote

Newbie

Joined: 20 May 2019
Posts: 4

Vitor wrote:
You were expecting something else?


Yes..before (while geting .tmp permission error) command enable_MQFunctions it's creates connecting to my database but can;t creat DB2MQ tables.
I guees DB2MQ.tmp is preperaing to create all DB2MQ tables (policy, service etc) or I am wrong ?
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Wed May 22, 2019 5:58 am Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20138
Location: LI,NY

Peter_MQ wrote:
Vitor wrote:
You were expecting something else?


Yes..before (while geting .tmp permission error) command enable_MQFunctions it's creates connecting to my database but can;t creat DB2MQ tables.
I guees DB2MQ.tmp is preperaing to create all DB2MQ tables (policy, service etc) or I am wrong ?


It could just be that you are missing DB permissions. If you set yourself as DB owner does that permission problem go away?
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexIBM MQ Installation/Configuration SupportDB2+MQ; cannot create db2mq.tmp: Permission denied
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.