| Author |
Message
|
| EternalLearner |
 Posted: Fri Jul 20, 2012 1:32 am Post subject: mqsisetdbparms with passsword containing special characters |
 |
|
Novice
Joined: 20 Jul 2012
Posts: 16
|
Hi,
I'm trying to connect to an ftp server from File Input Node in Broker 8.I did the following steps.
1. created an identity with mqsisetdbparms command. the passsword looks like this abc12d::er45y)d
2. Created a configurable service.
3. restarted the broker.
How ever getting authorisation error even after trying to put password in single quote and using escape character. i.e ' abc12d\:\:er45y\)d'. Tried different combinations with escape characters and also tried without any escape character or single quote. But nothing seems to be working.
The errors I'm getting are
File node ''File Input'' in message flow ''Test_FTP'' cannot log in to remote ''FTP'' server ''10.1.1.1'' with user name ''abcd''. Reason: ''530 Sorry, Authentication failed.''
File node ''File Input'' in message flow ''Test_FTP'' cannot log in to remote ''FTP'' server ''10.1.1.1'' with user name ''abcd''. Reason: ''PASS =>response: 232 User logged in, authorized by security data exchange''.
Can you please help.
Thanks. |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Fri Jul 20, 2012 2:00 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
What platform is this?
Did you try enclosing the pwd in "" (double quotes)?
_________________
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 |
|
|
| EternalLearner |
| Posted: Fri Jul 20, 2012 2:10 am Post subject: |
|
|
Novice
Joined: 20 Jul 2012
Posts: 16
|
Hi,
This is Unix.
I tasted the password as it is in a windows ftp server and it worked.
Yes I tried enclosing it in double quotes and having same error as before.
File node ''File Input'' in message flow ''Test_FTP'' cannot log in to remote ''FTP'' server ''10.1.1.1'' with user name ''abcd''. Reason: ''PASS =>response: 232 User logged in, authorized by security data exchange''. |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Jul 20, 2012 5:02 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
You will need to specify mqsisetdbparms without a password, i.e. no -p parameter. You'll then get a prompt "Enter password:". At this you can enter the password, special characters and all. You'll then need to re-enter it for verification.
You'd thnink enclosing it in quotes would work. L2 thought (when I raised the PMR) that enclosing it would work. You don't mention which Unix but mine still got confused by the special characters & (in my case) truncated the supplied password at the first special character.
As any added bonus (!) this means I can look virtuous by not having passwords in my set up scripts.... 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| EternalLearner |
| Posted: Fri Jul 20, 2012 6:00 am Post subject: |
|
|
Novice
Joined: 20 Jul 2012
Posts: 16
|
Hi,
Tried it but still getting same error.  . I put the password as it is without any escape character or anything.
Just to know how does it make any difference to put -p parameter in mqsisetdbparms or not putting it and then entering it at the command prompt.
Thanks. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Jul 20, 2012 6:31 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| EternalLearner wrote: |
| Just to know how does it make any difference to put -p parameter in mqsisetdbparms or not putting it and then entering it at the command prompt. |
If you use the -p parameter, the value of the password is processed first by the shell and then by the mqsisetdbparms command.
If you don't use the -p parameter, then it is just the mqsisetdbparms command that reads from the input you enter. |
|
| Back to top |
|
|
| EternalLearner |
| Posted: Fri Jul 20, 2012 6:44 am Post subject: |
|
|
Novice
Joined: 20 Jul 2012
Posts: 16
|
Ok..Thanks for letting me know.
But in this case the the broker is running on windows and trying to connect to the ftp server which is in unix(should be AIX).
So i guess it didn't make any difference in either case.I got the same error in both cases which I think confirms the same.
Thanks. |
|
| Back to top |
|
|
| EternalLearner |
| Posted: Fri Jul 20, 2012 7:17 am Post subject: |
|
|
Novice
Joined: 20 Jul 2012
Posts: 16
|
| Hi just to add the ftp server is Linux and not AIX. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Jul 20, 2012 8:17 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Can you execute a manual ftp to the server from the broker machine? |
|
| Back to top |
|
|
| EternalLearner |
| Posted: Fri Jul 20, 2012 9:28 am Post subject: |
|
|
Novice
Joined: 20 Jul 2012
Posts: 16
|
Yes. It could do it successfully.
Thanks. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Jul 20, 2012 10:02 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
PMR time.
Take a service trace during invocation of the flow. |
|
| Back to top |
|
|
| kevinobyrne |
| Posted: Tue Jul 24, 2012 12:36 am Post subject: |
|
|
Voyager
Joined: 17 Jul 2007
Posts: 83
Location: Ireland
|
Is the password very long?
I encountered an issue a few years ago in 6.1 where a password that was greater than 32 or 64 characters (can't remember exactly) was being truncated. I figured this out by trial and error and ultimately got the admin of the ftp server to give us a new, shorter password. I'm sure I raised a PMR at the time. |
|
| Back to top |
|
|
| EternalLearner |
| Posted: Wed Jul 25, 2012 5:01 am Post subject: |
|
|
Novice
Joined: 20 Jul 2012
Posts: 16
|
No the passsword is 15 character long and it is like 'abc12d::er45y)d' .
I think MB 5.1 had the problem of not accepting a password of more than 12 characters.But as ecxpected resolved in subsequent versions.
I've checked this password in windows ftp server and it can connect.Only problem is while connecting from Windows Broker machine to Unix(Linux) FTP server with special character in password.
I was expecting somebody to come across similar problem but now raised a PMR.
Regards. |
|
| Back to top |
|
|
|
|
