| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MQ Managed File Transfer DB logger |
« View previous topic :: View next topic » |
| Author |
Message
|
| cwekesa |
 Posted: Thu Feb 06, 2014 3:04 am Post subject: MQ Managed File Transfer DB logger |
 |
|
Newbie
Joined: 06 Feb 2014
Posts: 2
|
Hi Guys,
I'm stuck with the DB logger configuration for MQ managed file transfer version 7.5. I have set up MQ managed file transfer on our environment, its working well without any hiccups. I'm trying to connect to a Oracle DB for DB logging. I used the ftelog_tables_oracle.sql to create the tables for the Oracle schema. I have set the below properties in the logger.properties file.
wmqfte.logger.type=DATABASE
wmqfte.database.driver=D\:\\oracle\\ora90\\jdbc\\ojdbc6.jar
wmqfte.database.name=
windowsServiceVersion=2.00
wmqfte.logger.name=DBLOGGER
wmqfte.database.schema=ftelog
wmqfte.oracle.port=1521
wmqfte.oracle.host=x.x.x.x
wmqfte.database.native.library.path=D\:\\oracle\\product\\10.2.0\\client_1\\LIB
I also set properties wmqfte.database.user and wmqfte.database.password and got the errors below.
BFGUB0082E: Unsupported property 'wmqfte.database.password' found in property file 'logger.properties'.
BFGUB0082E: Unsupported property 'wmqfte.database.user' found in property file 'logger.properties'.
I even tried entries wmqfte.oracle.user and wmqfte.oracle.password after inputting these the properties are ignored and MQ still looks for the MQMFTCredentials.xml as shown below
FGDB0066E: The logger encountered a problem accessing its credentials file and will stop. Reported error: BFGNV0139E: GetFileSecurity failed for file C:\Users\xxxx\MQMFTCredentials.xml. Reason: The system cannot find the file specified.
I have enabled the mqmftLoggerDBLOGGER service on windows but the logger always wants to read from the MQMFTCredentials.xml file. I have no idea how to set the configurations on the MQMFTCredentials.xml file I used the edited the sample document but I dont know how to populate the line
tns:mqmftCredentials xmlns:tns="http://wmqfte.ibm.com/MQMFTCredentials" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://wmqfte.ibm.com/MQMFTCredentials MQMFTCredentials.xsd">
How can I disable checking of the MQMFTCredentials.xml file for cretaintails or how do I populate the MQMFTCredentials.xml with my TNS entries from oracle, we dont use xmlns:tns, xmlns:xsi or xsi:schemaLocation in our site.
I really appreciate any help you can give.
Thanks and regards,
Chris |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Thu Feb 06, 2014 6:53 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
This has nothing to do with the DB and is just the way MQFTE uses to pass the credentials to the DB.
You need some XML to specify the username and possibly passwd to MQFTE.
I am sure if you dig deeper in the infocenter you'll find what you need to do.
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri Feb 07, 2014 5:26 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
|
| 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
|
|
|
|
