| Author |
Message
|
| paustin_ours |
 Posted: Mon Jun 20, 2005 12:58 pm Post subject: broker delete |
 |
|
Yatiri
Joined: 19 May 2004
Posts: 667
Location: columbus,oh
|
I keep getting an error that my user id does not have access to the Broker database. Since this is a test broker that i have on my workstaion
(windows), i decided to delete all the runtime and install them again.
Now when i issue the mqsideltebroker command, it says that the user id does not have access to the broker database.
how can i change the user id and password so i can get access to the broker database?
can i run a mqsichangebroker command to do this? |
|
| Back to top |
|
 |
| vennela |
| Posted: Mon Jun 20, 2005 1:49 pm Post subject: Re: broker delete |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| paustin_ours wrote: |
can i run a mqsichangebroker command to do this? |
It would still give you the authorization error.
What is the userid you are using and under what groups is your user under? |
|
| Back to top |
|
|
| djeripo |
| Posted: Mon Jun 20, 2005 3:29 pm Post subject: |
|
|
Master
Joined: 25 Jan 2004
Posts: 225
|
Do you have your id included in these groups.
mqbrasgn
mqbrdevt
mqbrks
mqbrops
mqbrtpic |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Jun 20, 2005 5:31 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Access to the broker database is strictly controlled by DB2, or whatever database management system you are using.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| paustin_ours |
| Posted: Tue Jun 21, 2005 5:51 am Post subject: |
|
|
Yatiri
Joined: 19 May 2004
Posts: 667
Location: columbus,oh
|
i have my id in all the groups. to make things worse, i issued the mqsideletebroker command and it deleted the qmanager but the broker tables are not cleared yet.
can i use mqsichangebroker command and mqsisetdbparms to reset the service and database user id? when i first created the broker i did not specifically give the database user id, i left it to default to the service id. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Jun 21, 2005 6:09 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Did you grant access to the broker service user in the database?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| paustin_ours |
| Posted: Tue Jun 21, 2005 6:40 am Post subject: |
|
|
Yatiri
Joined: 19 May 2004
Posts: 667
Location: columbus,oh
|
my serive ID is a domain ID domain\userid, when i do a mqsiservice i see the db user id without the domain qualifier.
i checked the database authorizations, i granted full access to both the domain ID and the id itself and also local admin which is me again. |
|
| Back to top |
|
|
| vennela |
| Posted: Tue Jun 21, 2005 7:10 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
To get rid of the domain problem, I though you had to do something like
| Code: |
| mqsichangeconfigmgr -l 0 |
But I don't know whether that is relevant here. |
|
| Back to top |
|
|
| paustin_ours |
| Posted: Tue Jun 21, 2005 10:56 am Post subject: |
|
|
Yatiri
Joined: 19 May 2004
Posts: 667
Location: columbus,oh
|
I ended up re-installing. Now i wanted to just go through the default configuration setup in the welcome page. wheni click that it says
the local user account[userid] has sufficent privileges to run this wizard, but some other problem occured whilst attempting to confirm the given password.
i created a new database and defined a ODBC connection to it. When i tried to logon from the ODBC connection test with the my user ID and password, it says restricted access. dont know if this soemthing to do with db2 instance and schema and stuff. |
|
| Back to top |
|
|
| waugh |
| Posted: Wed Jun 22, 2005 6:17 am Post subject: |
|
|
Master
Joined: 19 Feb 2004
Posts: 225
|
Standalone windows installation:
1)install DB2, it will ask you for user id/password you want to use as part of the installation. choose a userid/password.
2)if u r not already logged in as that user, just go back and login as him.
3)install MQ, MDAC, RAC, WBIMB, apply CSD's to WBIMB, DB2, RAC as required.
4) Create databases, ODBC connections, Broker, COnfig under same user id.
5) at this point, the user should be part of mqm, users+5 groups of broker groups.
This is the standard procedure i have followed on standalone boxes. works great!!! |
|
| Back to top |
|
|
|
|
