| Author |
Message
|
| ydsk |
 Posted: Wed Aug 23, 2006 10:16 am Post subject: URGENT:Which userId needs access to a User database...? |
 |
|
Chevalier
Joined: 23 May 2005
Posts: 410
|
Maybe I am asking a basic question. We have a broker on Solaris and the broker database is all set.
I also have a User database (Oracle9) on a remote Unix box managed by DBAs. My msgflows need to access it to log errors.
We did all the steps( TNS names, ODNC.ini, mqsi_setupdatabase, mqsisetdbparms) on the broker box but I see ODBC errors( invalid username/passwd)in /var/adm/messages on the broker box. Looks like we are missing something.
My question is, which id needs to be granted permission by the DBA to access the User database ? Is it the broker service id or some other id ? With which id does the broker(msgflows) access the user database ?
Can someone pls clarify ?
Thanks. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Aug 23, 2006 10:20 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
| mlafleur |
| Posted: Wed Aug 23, 2006 10:26 am Post subject: |
|
|
Acolyte
Joined: 19 Feb 2004
Posts: 73
|
| Quote: |
| which id needs to be granted permission by the DBA to access the User database ? |
The one you set with mqsisetdbparms |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Aug 23, 2006 10:27 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| mlafleur wrote: |
| Quote: |
| which id needs to be granted permission by the DBA to access the User database ? |
The one you set with mqsisetdbparms |
I view it as actually the other way around.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| ydsk |
| Posted: Wed Aug 23, 2006 10:43 am Post subject: |
|
|
Chevalier
Joined: 23 May 2005
Posts: 410
|
Jeff,
Thanks for the quick response.
But my question is with which id does the broker(msgflows) access the user database ? And does that id need to be part of mqm/mqbrkrs on the broker box ?
Pls clarify. |
|
| Back to top |
|
|
| ydsk |
| Posted: Wed Aug 23, 2006 10:50 am Post subject: |
|
|
Chevalier
Joined: 23 May 2005
Posts: 410
|
sorry guys, I posted before I saw your last posts.
Here is the error I am getting:
BIP2321E: Database error: ODBC return code '-1'. : /build/S600_P/src/DataFlowEngine/ImbOdbc.cpp: 227: ImbOdbcHandle::checkRcInner: : BIP2322E: Database error: SQL State ''28000''; Native Error Code '1017'; Error Text ''[DataDirect][ODBC Oracle driver][Oracle]ORA-01017: invalid username/password; logon denied ''. : /build/S600_P/src/DataFlowEngine/ImbOdbc.cpp: 355: ImbOdbcHandle::checkRcInner: :
The problem is the DSN name I am using ( given by DBA) has a dot , like in 'ABC.XYZ' and when I use it in my compute node like Database.ABC.XYZ.Schema1.Table , I think the broker is treating it differently.
Any ideas what the problem could be ?
thanks. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Aug 23, 2006 11:03 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I would say the problem is that you have named the DSN after the database it is pointed to.
Also that you don't understand ESQL syntax as well as you should, to know how to handle identifiers that have periods in them.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| ydsk |
| Posted: Wed Aug 23, 2006 11:13 am Post subject: |
|
|
Chevalier
Joined: 23 May 2005
Posts: 410
|
Jeff,
Here is my TNS entry:
BSCORADX.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp)
(PROTOCOL = TCP)
(Host =cccun087)
(Port = 1800)
)
)
(CONNECT_DATA =
(SID = BSCORADX)
(GLOBAL_NAME =BSCORADX)
)
)
Can you pls tell me what would be my DNS name here ?
Thanks. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Aug 23, 2006 11:15 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
No, I can't tell you. There is nothing in there that puts any restrictions or requirements on the DSN name that you use.
_________________
I am *not* the model of the modern major general.
Last edited by jefflowrey on Wed Aug 23, 2006 11:26 am; edited 2 times in total |
|
| Back to top |
|
|
| ydsk |
| Posted: Wed Aug 23, 2006 11:15 am Post subject: |
|
|
Chevalier
Joined: 23 May 2005
Posts: 410
|
| It's a Oracle 9 database on a remote unix box. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Aug 23, 2006 11:18 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
What database is being used and what operating system it is running on has nothing to do with the DSN name either.
_________________
I am *not* the model of the modern major general.
Last edited by jefflowrey on Wed Aug 23, 2006 11:26 am; edited 2 times in total |
|
| Back to top |
|
|
| ydsk |
| Posted: Wed Aug 23, 2006 11:19 am Post subject: |
|
|
Chevalier
Joined: 23 May 2005
Posts: 410
|
I know if there is a dot I need to use double quotes like in "ABC.XYZ" but that didn't help either. I am not sure what the DNS name would be in my case based on the DNS entry I gave above.
This is driving me nuts. Appreciate any help in this matter.
Thanks. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Aug 23, 2006 11:21 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
| ydsk |
| Posted: Wed Aug 23, 2006 11:46 am Post subject: |
|
|
Chevalier
Joined: 23 May 2005
Posts: 410
|
And Jeff, we used an id on the mqsisetdbparms command to setup access to user database. Does that id need to be part of mqbrkrs/mqm or other groups ?
thanks. |
|
| Back to top |
|
|
|
|
