| Author |
Message
|
| akmar2k |
 Posted: Mon Jan 25, 2010 12:13 pm Post subject: mqsicreateconfigurableservice for securityIdentity |
 |
|
Novice
Joined: 01 Jun 2006
Posts: 22
|
I am trying to setup the EmailOutput node with the SMTP server and securityIdentity. I have followed the documentation to setup the same
http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r1m0/index.jsp?topic=/com.ibm.etools.mft.doc/ac66310_.htm
The following are the commands that I should be using as per the above link:
mqsicreateconfigurableservice BROKER -c SMTP -o MYSERVER
mqsichangeproperties BROKER -c SMTP -o MYSERVER -n serverName -v smtp.hursley.ibm.com:25
mqsisetdbparms -n smtp::MyIdentity -u userName -p password
mqsichangeproperties BROKER -c SMTP -o MYSERVER -n securityIdentity -v MyIdentity
I used the following commands to do the setup:
mqsicreateconfigurableservice <mybroker> -c SMTP -o MYSERVER
mqsichangeproperties <mybroker> -c SMTP -o MYSERVER -n serverName -v <mymailserver>:<port>
mqsisetdbparms <mybroker> -n smtp::MyIdentity -u <myuser> -p <mypasswd>
mqsichangeproperties <mybroker> -c SMTP -o MYSERVER -n securityIdentity -v MyIdentity
Note : mqsisetdbparms did not work without broker name - as mentioned in the instructions.
With these settings, I tried sending an email. But it errored out with the following exception:
com.ibm.broker.emailnodes.EmailOutputNode : Security identity specified but no userid or password has been declared using mqsisetdbparms
I checked the regedit and verified that the values are set for smtp::MyIdentity
Any comments? Am I missing anything here?
Has anyone faced this issue? |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Mon Jan 25, 2010 12:50 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Did you restart broker after mqsisetdbparms? |
|
| Back to top |
|
|
| akmar2k |
| Posted: Mon Jan 25, 2010 1:26 pm Post subject: |
|
|
Novice
Joined: 01 Jun 2006
Posts: 22
|
| Yes. I did restart the broker. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Jan 25, 2010 1:36 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Upgrade to 6.1.0.5.
There are some bugs in this area that I believe are fixed in FP5. |
|
| Back to top |
|
|
| akmar2k |
| Posted: Mon Jan 25, 2010 1:47 pm Post subject: Resolved |
|
|
Novice
Joined: 01 Jun 2006
Posts: 22
|
The issue is resolved.
I was using
SET OutputLocalEnvironment.Destination.Email.SecurityIdentity = 'smtp::MyIdentity';
instead of
SET OutputLocalEnvironment.Destination.Email.SecurityIdentity = 'MyIdentity';
Thanks |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Jan 25, 2010 2:11 pm Post subject: Re: Resolved |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| akmar2k wrote: |
The issue is resolved.
I was using
SET OutputLocalEnvironment.Destination.Email.SecurityIdentity = 'smtp::MyIdentity';
instead of
SET OutputLocalEnvironment.Destination.Email.SecurityIdentity = 'MyIdentity';
Thanks |
Oh, yeah, that'd do it too. |
|
| Back to top |
|
|
| akkypaul |
| Posted: Thu Feb 16, 2017 3:08 am Post subject: I am still facing this same error. |
|
|
Apprentice
Joined: 30 Jun 2014
Posts: 44
Location: India
|
I included the SET statement in the ESQL file but got no relief from the error:-
Caught exception and rethrowing : poc.email.output.Email_POC.Compute Error detected, rethrowing : poc.email.output.Email_POC_Compute.Main 5.3 PROPAGATE TO TERMINAL 'out' FINALIZE DEFAULT DELETE DEFAULT; Caught exception and rethrowing : poc.email.output.Email_POC.Email Output mqsisetdbparms value missing : com.ibm.broker.emailnodes.EmailOutputNode : Security identity specified but no userid or password has been declared using mqsisetdbparms for MyIdentity : Flow (poc.email.output.Email_POC) Node (Email Output)
Although I have specified the username and the password while setting mqsi properties.
Following are the commands that I executed:-
| Code: |
mqsicreateconfigurableservice <BRK_NAME> -c SMTP -o SMTP_MyIdentity
mqsichangeproperties <BRK_NAME> -c SMTP -o SMTP_MyIdentity -n serverName -v <IP_ADDRESS>:<PORT>
mqsisetdbparms <BRK_NAME> -n smpt::MyIdentity -u <USER_NAME> -p <PASSWORD>
mqsichangeproperties <BRK_NAME> -c SMTP -o SMTP_MyIdentity -n securityIdentity -v MyIdentity |
I have tried using the maneuvers like restarting the Broker and I am using IIB 10
Do I need to explicitly specify the username and password in the code too using ESQL Statements?
Or is there something else that I am missing? |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Feb 16, 2017 5:01 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
I *think* you need to set the identity as a property of the EmailOutput node... In the security context field
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| joebuckeye |
| Posted: Thu Feb 16, 2017 6:27 am Post subject: Re: I am still facing this same error. |
|
|
Partisan
Joined: 24 Aug 2007
Posts: 364
Location: Columbus, OH
|
| akkypaul wrote: |
Although I have specified the username and the password while setting mqsi properties.
Following are the commands that I executed:-
...snip...
mqsisetdbparms <BRK_NAME> -n smpt::MyIdentity -u <USER_NAME> -p <PASSWORD>
...snip...
I have tried using the maneuvers like restarting the Broker and I am using IIB 10
Do I need to explicitly specify the username and password in the code too using ESQL Statements?
Or is there something else that I am missing? |
Looks like a typo in your mqsisetdbparms command. You need smtp, not smpt there. |
|
| Back to top |
|
|
| akkypaul |
| Posted: Mon Feb 20, 2017 12:30 am Post subject: Still not working. |
|
|
Apprentice
Joined: 30 Jun 2014
Posts: 44
Location: India
|
Thank you for pointing out the typo great masters.
I deleted the old objects and created new ones with the correct spelling.
And I even restarted the Integration Node but I am still getting the same error that:-
| Code: |
Could not connect to SMTP host: XXX.XX.XXX.XXX, port: XXX
Permission denied: connect
: Flow (poc.email.output.Email_POC) Node (Email Output) |
Please advice! |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Feb 20, 2017 4:52 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Maybe you need to use a different port.
Maybe you need to use SSL.
Maybe you need to use a different port AND SSL.
Probably you should talk to your mailserver admins... or at least check the config of whatever email client you have that works.
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| akkypaul |
| Posted: Mon Feb 20, 2017 5:12 am Post subject: Thank you mqjeff |
|
|
Apprentice
Joined: 30 Jun 2014
Posts: 44
Location: India
|
Thank you for your inputs mqjeff.
You are right to say that there is some authentication i.e. required.
I must add that I was able to connect to the mail server from the command prompt using telnet. I was able to get the authentication done in telnet using the username and password that I have entered as the parameters to property of smtp::MyIdentity.
I also tried to send a mail using the telnet and I was able to do that successfully.
Does that proves that there is no problem with the connectivity of my local machine to the mail server? |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Mon Feb 20, 2017 5:25 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Perhaps you need to look at exactly what is sent over the wire when BOTH types of connection are made.
Something like wireshark is a useful tool to know.
Also what do the email system logs show about your connection? Does they tell you why it failed to connect?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
|
|
