| Author |
Message
|
| MaheshPN |
 Posted: Wed Apr 19, 2006 2:27 pm Post subject: RTDatabasePassword not required if db is local? |
 |
|
Master
Joined: 21 May 2003
Posts: 245
Location: Charlotte, NC
|
Hi Guys,
I am wondering, whether we need to have the entry 'RTDatabasePassword' in fmcrc file and userId and password entries in the qm.ini, if the database and the WF server are configured on the same box with the default userId 'fmc'.
Let me know.
Thanks,
-Mahesh |
|
| Back to top |
|
 |
| vennela |
| Posted: Thu Apr 20, 2006 4:06 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| I think you need it even if the DB is local |
|
| Back to top |
|
|
| jmac |
| Posted: Thu Apr 20, 2006 5:16 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
I think so too. But you could just try and remove it 
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| MaheshPN |
| Posted: Thu Apr 20, 2006 5:45 am Post subject: |
|
|
Master
Joined: 21 May 2003
Posts: 245
Location: Charlotte, NC
|
I have one configuration up and running which was created back in 2002. It does not have any password entry in fmcrc and as well as qm.ini.
I am curious, how it is working? The only difference btn my this configuration and the rest are DB is local . Can somebody explain how it is working with the password entry?
Thanks,
-Mahesh |
|
| Back to top |
|
|
| hos |
| Posted: Thu Apr 20, 2006 6:21 am Post subject: |
|
|
Chevalier
Joined: 03 Feb 2002
Posts: 470
|
Hi,
my best guess is that it is never used
javascript:emoticon(' ')
Keep in mind that it is the MQWF server that needs to use this configurationID - not the client. Usually the servers start with the default configuration. |
|
| Back to top |
|
|
| MaheshPN |
| Posted: Thu Apr 20, 2006 6:32 am Post subject: |
|
|
Master
Joined: 21 May 2003
Posts: 245
Location: Charlotte, NC
|
Hi Hos,
That configuration is used everyday!!. One more additional variable is,
Client application, WAS/Webclient is also running on the same box.
All servers(DB2,WF,MQ,WAS) are all running on the single box.
Hope this will help to explain the missing password ....
thanks,
-Mahesh |
|
| Back to top |
|
|
| jmac |
| Posted: Thu Apr 20, 2006 6:41 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Mahesh:
I interpreted Volker's response to be that the password is never used in this case. Hopefully, he can clarify this.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| MaheshPN |
| Posted: Thu Apr 20, 2006 8:14 am Post subject: |
|
|
Master
Joined: 21 May 2003
Posts: 245
Location: Charlotte, NC
|
Thanks for clarifying that Mac.
Hos, can you please explain how the communication between the db2/WF and mq works without using a password?
We know, the fmc user needs to be exist in both aix and db2 userID list.
It looks like, it works even if the fmc (AIX) user's password changes.
Since, password in the db2 remains unchanged. Am I lost? 
-Mahesh |
|
| Back to top |
|
|
| latelatif |
| Posted: Thu Apr 20, 2006 1:04 pm Post subject: |
|
|
Novice
Joined: 08 Feb 2006
Posts: 21
|
| MaheshPN wrote: |
I have one configuration up and running which was created back in 2002. It does not have any password entry in fmcrc and as well as qm.ini.
I am curious, how it is working? The only difference btn my this configuration and the rest are DB is local . Can somebody explain how it is working with the password entry?
Thanks,
-Mahesh |
RTDatabasePassword is only needed when you have RTDatabaseAdministratorUserID in your fmcrc which is only in a 3 Tier config.
Since your database is local, it doesnt need a database client and hence those entries as well. Additionally in your Workflow Database, under "users and groups" the workflow config admin must have full access, or, it must be the instance owner under which the database was created. since that id is local, DB2 doesnt need to be updated after a password change as its authentication is just fine at the OS level. |
|
| Back to top |
|
|
|
|
