I trying to use FTP Advanced with chmod to change file permission on a remote machine.  I have tried chmod with both "Site Command" and "User Defined".  Automate is showing the command as completing normally, without error, but the file permisions on the unix machine are not changing.  What is the proper way to use chmod with FTP Advanced?  Every other part of the task is working correctly.

Automate 7.1.0.0 (Build 208261)

OS: Windows Server 2008 service pack 2

Examples below did not work:

<AMFTPADVANCED FTPCOMMAND="user_defined" PARAMETER="chmod 700 /c/CreateDailyJournal.scr" AM_ONERROR="CONTINUE" AM_SETVAR="ErrMsg;%ErrMsg% %vbCrLf% %sUnit% (%sIP%): Failed CHMOD 700 CreateDailyJournal.scr" />

<AMFTPADVANCED FTPCOMMAND="site" PARAMETER="chmod 700 /c/CreateDailyJournal.scr" AM_ONERROR="CONTINUE" AM_SETVAR="ErrMsg;%ErrMsg% %vbCrLf% %sUnit% (%sIP%): Failed CHMOD 700 CreateDailyJournal.scr" />

Category Survey

Stephen,

Try setting your task to log to a separate file (in the Advanced tab of the FTP Logon action). The log should provide more information regarding any data returned by your server. Another option is to populate a variable with the return data (in the Data tab of the FTP Advanced action).

Category Survey

-------------------------
Thank you for choosing AutoMate.

Marjo

<a class="ftalternatingbarlinklarge" href="http://www.networkautomation.com" target="_blank">Network Automation, Inc. - No Code, No Limits Business Process Automation</A>

<!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:1; mso-generic-font-family:roman; mso-font-formatther; mso-font-pitch:variable; mso-font-signature:0 0 0 0 0 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} @font-face {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:modern; mso-font-pitch:fixed; mso-font-signature:-1610611985 1073750091 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} p.MsoPlainText, li.MsoPlainText, div.MsoPlainText {mso-style-noshow:yes; mso-style-priority:99; mso-style-link:"Plain Text Char"; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.5pt; font-family:Consolas; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-bidi-font-family:"Times New Roman";} span.PlainTextChar {mso-style-name:"Plain Text Char"; mso-style-noshow:yes; mso-style-priority:99; mso-style-unhide:no; mso-style-locked:yes; mso-style-link:"Plain Text"; mso-ansi-font-size:10.5pt; mso-bidi-font-size:10.5pt; font-family:Consolas; mso-ascii-font-family:Consolas; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Consolas; mso-bidi-font-family:"Times New Roman";} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} -->

Below is the value of the result variable used in both a User Defined and Site commands.

 

User Defined:

<AMFTPADVANCED FTPCOMMAND="user_defined" PARAMETER="chmod 700 /c/CreateDailyJournal.scr" RESULTVARIABLE="FTPADV" AM_ONERROR="CONTINUE" AM_SETVAR="ErrMsg;%ErrMsg% %vbCrLf% %sUnit% (%sIP%): Failed CHMOD 700 CreateDailyJournal.scr" />

Value of FTPADV variable

/c/

 

Site Command:

<AMFTPADVANCED FTPCOMMAND="site" PARAMETER="chmod 700 /c/CreateDailyJournal.scr" RESULTVARIABLE="FTPADV" AM_ONERROR="CONTINUE" AM_SETVAR="ErrMsg;%ErrMsg% %vbCrLf% %sUnit% (%sIP%): Failed CHMOD 700 CreateDailyJournal.scr" />

Value of FTPADV variable

/c/

 

Category Survey

Stephen,

What is your Server Connection Type (FTP Logon -> Advanced -> Server Connection Type). Did you receive the same return data when setting a separate log file? If possible, please attach your task steps as well as the generated log.

Category Survey

-------------------------
Thank you for choosing AutoMate.

Marjo

<a class="ftalternatingbarlinklarge" href="http://www.networkautomation.com" target="_blank">Network Automation, Inc. - No Code, No Limits Business Process Automation</A>

I am using SFTP connection.  The log file does not contian data from the FTP Advanced command, and this is the same for both user defined and site commands.  Many steps are dissabled to make the testing easier.

Data written to log file:

------------------------------------------------------------------------
Date : 2/9/2010 2:16:45 PM
------------------------------------------------------------------------
Connecting to [IP Address] connection type is sftp
Server key [d139ea8a4b464e7f0db4b3be09761ce9] received
Authentication type [16] failed
Authentication succeeded

Change to this Directory : /c/
Is directory exist : /c/


Disconnecting from [IP Address]
SFTP connection closed

Category Survey

Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<AMMANAGEDTASKFILE> <TASK ID="{91F94499-DD20-46A4-8ADC-0164EDD21A4B}" NAME="Upload Files" FILENAME="C:\ProgramData\Network Automation\AutoMate 7\Tasks\Upload Files.aml" LASTRUN="40189.6060001273" LASTRUNRESULT="OKAY" DETAILS="Upload files to POS at all stores" LOGOFFACTION="USERNOINTERACTIVE" RUNAS="BACKGROUNDUSER" ONERROREMAILTO="" ONERROREMAILFROM="" WHENLOCKED="RUN" RUNASELEVATED="NO" USELOGONDEFAULT="NO" LOGONUSERNAME="" LOGONPASSWORD="" LOGONDOMAIN=""> <TRIGGERS> </TRIGGERS> </TASK> <AMTASK> <AMTASKHEAD> <TASKINFO TASKVERSION="7100" /> </AMTASKHEAD> <STEPS> <AMVARIABLE NAME="ErrMsg" TYPE="TEXT">%Format(Now(), "mm/dd/yy hh:nn")%</AMVARIABLE> <AMVARIABLE NAME="sUnit" TYPE="TEXT"></AMVARIABLE> <AMVARIABLE NAME="sIP" TYPE="TEXT" DESCRIPTION="Store Server IP"></AMVARIABLE> <AMVARIABLE NAME="FTPADV" TYPE="TEXT"></AMVARIABLE> <AMIF FILE="C:\AutomateLogs\UploadFiles\FTPUploadAllStores.log"> <AMFILEDELETE SOURCE="C:\AutomateLogs\UploadFiles\FTPUploadAllStores.log" AM_ONERROR="GOTOLABEL" AM_GOTOLABEL="EndStore" /> </AMIF> <AMSQLOPENCONNECTION CONNECTIONSTRING="AM19y9I4LjuL6UnML2p7IZIAivW6j6JnAfKNzNyU8ZQjKG9U9xVGPwPAKoQ1wG0x5saFfwO7caO8VxQKlRZwBO0uqtrO67HIAGj/b98W/Zb1X+Uuby3w+shEJ+c2JJTChJC2/OMwuCix0KHBzu0mz4u9w==aME" /> <AMSQLQUERY RESULTDATASET="dsStoreIP">SELECT Store# As Unit, PartIP FROM MNLIBR.StoreIP where not GROUP=0 and not GROUP=99 order by store#</AMSQLQUERY> <!-- <AMLOOP TYPE="DATASET" DATASET="dsStoreIP"> --> <AMSET VARIABLENAME="sUnit" AM_ONERROR="GOTOLABEL" AM_GOTOLABEL="EndStore">%TRIM(dsStoreIP.Unit)%</AMSET> <AMSET VARIABLENAME="sIP" AM_ONERROR="GOTOLABEL" AM_GOTOLABEL="EndStore">[IP Address]</AMSET> <AMFTPLOGIN SERVER="%sIP%" USERNAME="" PASSWORD="" PORT="22" TYPE="sftp" LOGFILE="C:\AutomateLogs\UploadFiles\FTPUpload.log" AM_ONERROR="GOTOLABEL" AM_GOTOLABEL="EndStore" AM_SETVAR="ErrMsg;%ErrMsg% %vbCrLf% %sUnit% (%sIP%): Failed logon" /> <!-- <AMFTPUPLOAD SOURCE="C:\Downloads\CreateDailyJournal.scr" DEST="/c/CreateDailyJournal.scr" OVERWRITE="YES" AM_ONERROR="GOTOLABEL" AM_GOTOLABEL="EndStore" AM_SETVAR="ErrMsg;%ErrMsg% %vbCrLf% %sUnit% (%sIP%): Failed CreateDailyJournal.scr Upload" /> --> <AMFTPCHANGEFOLDER FOLDER="/c/" /> <AMFTPADVANCED FTPCOMMAND="site" PARAMETER="chmod 700 /c/CreateDailyJournal.scr" RESULTVARIABLE="FTPADV" AM_ONERROR="CONTINUE" AM_SETVAR="ErrMsg;%ErrMsg% %vbCrLf% %sUnit% (%sIP%): Failed CHMOD 700 CreateDailyJournal.scr" /> <AMLABEL LABELNAME="EndStore" /> <AMFTPLOGOFF AM_ONERROR="CONTINUE" /> <AMCONCATENATEFILE FILEA="C:\AutomateLogs\UploadFiles\FTPUpload.log" FILEB="C:\AutomateLogs\UploadFiles\FTPUploadAllStores.log" CONCATENATEDFILE="C:\AutomateLogs\UploadFiles\FTPUploadAllStoresTMP.log" AM_ONERROR="CONTINUE" /> <AMIF FILE="C:\AutomateLogs\UploadFiles\FTPUploadAllStores.log" AM_ONERROR="CONTINUE"> <AMFILEDELETE SOURCE="C:\AutomateLogs\UploadFiles\FTPUploadAllStores.log" AM_ONERROR="CONTINUE" /> </AMIF AM_ONERROR="CONTINUE"> <AMFILERENAME SOURCE="C:\AutomateLogs\UploadFiles\FTPUploadAllStoresTMP.log" DEST="C:\AutomateLogs\UploadFiles\FTPUploadAllStores.log" AM_ONERROR="CONTINUE" /> <!-- </AMLOOP> --> <AMSQLCLOSECONNECTION AM_ONERROR="CONTINUE" /> <!-- <AMIF EXPRESSION="%Len(ErrMsg)% > 20"> <AMSET VARIABLENAME="ErrMsg">%ErrMsg & vbCrLf & Format(Now(), "mm/dd/yy hh:nn")%</AMSET> <AMFILEWRITE FILE="C:\AutomateLogs\UploadFiles\UploadFilesErr_%Format(Now(), "mmddyy-hhnn")%.log" APPEND="NO">%ErrMsg%</AMFILEWRITE> <AMSENDEMAIL TO="" SUBJECT="POS updates" FROM="">%ErrMsg%</AMSENDEMAIL> <AMELSE /> <AMSENDEMAIL TO="" SUBJECT="POS Updates" FROM="">Ran without error</AMSENDEMAIL> --> <AMSENDEMAIL TO="" SUBJECT="POS Updates" FROM="">%FTPADV%</AMSENDEMAIL> <!-- </AMIF> --> </STEPS> </AMTASK> </AMMANAGEDTASKFILE>

Edited: 02/09/2010 at 12:58 PM by StephenMorgan

Stephen,

Unfortunately, CHMOD is not supported under SFTP connection types at this time. However, I will add this to our ITS (Issue Tracking System) as a feature request to be added in AM8. We apologize for any inconvenience this may have caused.

 

Category Survey

-------------------------
Thank you for choosing AutoMate.

Marjo

<a class="ftalternatingbarlinklarge" href="http://www.networkautomation.com" target="_blank">Network Automation, Inc. - No Code, No Limits Business Process Automation</A>

I use the FTP Log On command to connect to external servers and send/receive files. a week ago, production flipped us from one external server to another (different IP addresses) ,,, we got them to switch up back, but have received this error ever since when trying to connect:

Authentication type [16] failed
Error 114

We have been able to telnet out thru port 22 and the client can see us connect, but when we try to execute the command in script, the client does not see us at all and we get the error. We have thought ,,, maybe a certificate has been corrupted but cannot verify that.

Any help will be greatly appreciated.

Category Survey

-------------------------
Paulo Monaco - Fiserv
AM6E, AM7E, BPA7E - W2K3 Servers, XP Clients

Hi Ron,

Would it be possible to post the FTP log or send it over to support@networkautomation.com? If it was working, something may have changed on the server end?

Category Survey

-------------------------

Ricardo Castaneda | Principal Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700