FTPS Explicit TLS .NET Libarary

Hello, I'm having an issue connecting to a FTPS site using Explicit TLS encryption through the .Net Library through Powershell.
This is a new problem and first time I've tried using FTPS with Explicit TLS. WHen I use the GUI interface, I am able to connect.
When I go through the powershell code, I get an unable to connect exception.
Here is my code:

    $winSCPathDLL = $global:appSettings["WinSCPDLL"]
    $winSCPDLLPath = $winSCPath + $winSCPathDLL
    [Reflection.Assembly]::LoadFrom($winSCPDLLPATH) #| Out-Null

   # Setup session options
   $sessionOptions = New-Object WinSCP.SessionOptions
   $sessionOptions.Protocol = [WinSCP.Protocol]::ftp
    $sessionOptions.FtpMode = [WinSCP.FtpMode]::passive
    $sessionOptions.FtpSecure = [WinSCP.FtpSecure]::explicittls
   $sessionOptions.HostName = $global:appSettings["FTPHost"]
   $sessionOptions.PortNumber = $global:appSettings["FTPPortNumber"]
   $sessionOptions.UserName = $global:appSettings["FTPUser"]
   $sessionOptions.Password = $global:appSettings["FTPPassword"]

   $session = New-Object WinSCP.Session

        $transferOptions = New-Object WinSCP.TransferOptions
        $transferOptions.TransferMode = [WinSCP.TransferMode]::Binary

   $session.Open($sessionOptions)  #<<< Exception throw here

When I load the assembly, I get this:
GAC Version Location
--- ------- --------
False v2.0.50727 D:\ServiceOrders\Script\WinSCP\WinSCPnet.dll

I downloaded the latest .Net DLL today, so I have version 5.5.1.0

The exception details I can get to :
Connection failed.
At D:\Script.ps1:167 char:3
+ $session.Open($sessionOptions)
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], SessionRemoteException
+ FullyQualifiedErrorId : SessionRemoteException


I'm sure I must be missing something, but I am at a loss for finding it.

Thank you for the help.

John

Silku wrote:

John, have you got any solution for the above ? I am getting same problem.
Thanks.

    # Load WinSCP .NET assembly
    # Use "winscp.dll" for the releases before the latest beta version.
    $winSCPath = $global:appSettings["WinSCPath"]
    $winSCPathDLL = $global:appSettings["WinSCPDLL"]
    $winSCPDLLPath = $winSCPath + $winSCPathDLL
    [Reflection.Assembly]::LoadFrom($winSCPDLLPATH) #| Out-Null

    # Setup session options
    $sessionOptions = New-Object WinSCP.SessionOptions
    $sessionOptions.Protocol = [WinSCP.Protocol]::ftp
    $sessionOptions.FtpMode = [WinSCP.FtpMode]::passive
    $sessionOptions.FtpSecure = [WinSCP.FtpSecure]::explicittls
    $sessionOptions.HostName = $global:appSettings["FTPHost"]
    $sessionOptions.PortNumber = $global:appSettings["FTPPortNumber"]
    $sessionOptions.UserName = $global:appSettings["FTPUser"]
    $sessionOptions.Password = $global:appSettings["FTPPassword"]
    $sessionOptions.SslHostCertificateFingerprint = $global:appSettings["FTPFingerPrintKey"]

   $session = New-Object WinSCP.Session

   try
   {
      # Connect
      $session.Open($sessionOptions)
           $transferOptions = New-Object WinSCP.TransferOptions
           $transferOptions.TransferMode = [WinSCP.TransferMode]::Binary
           $yesterday = (Get-Date).AddDays($yesterdayValue).ToString('yyyyMMdd')

           # List of remote folders to check
           $remoteFolders = $global:appSettings["RemotePaths"]
           foreach ($remoteFolder in $remoteFolders.Split(","))
           {
              $remotePath = "/" + $remoteFolder.Trim() + "/*" + $yesterday + "*"
              $localFolder = $localPath + $remoteFolder + "\"
              $TransferResults = $session.GetFiles($remotePath, $localFolder, $false, $transferOptions)
              try 
              {
                $TransferResults.Check()
              }   
              catch [Exception]
              {        
                    $emailBody += "Error Downloading " + $remotePath + ":" + $_.Exception.Message
              }
        }
        $session.Dispose()

Silku wrote:

Don't know if this allows to authenticate, I copied it from server/protocol info only.

Silku wrote:

Now it is saying "The requested operation requires elevation"...:-((

martin wrote:

Silku wrote:

Now it is saying "The requested operation requires elevation"...:-((

What line of cause is causing this error? It's definitely not a message from WinSCP.

Silku wrote:

Thanks John.

Here it is : I have given write host trap from where it is causing....
Now it is saying "The requested operation requires elevation"...:-((
------------------------------


#----------------------------------------------------------
try
{
# Load WinSCP .NET assembly

write-host "Begin..............." -foregroundcolor yellow;


[Reflection.Assembly]::LoadFrom("C:\Program Files (x86)\WinSCP\WinSCPnet.dll")
write-host "After assembly...." -foregroundcolor yellow;
# Setup session options
$sessionOptions = New-Object WinSCP.SessionOptions
write-host "After Open WinSCP.SessionOptions...." -foregroundcolor yellow;

$sessionOptions.Protocol = [WinSCP.Protocol]::ftp
write-host "After Open WinSCP.prtocol...." -foregroundcolor yellow;
$sessionOptions.FtpMode = [WinSCP.FtpMode]::passive
write-host "After Open WinSCP.ftpmode...." -foregroundcolor yellow;
$sessionOptions.FtpSecure = [WinSCP.FtpSecure]::explicittls

$sessionOptions.PortNumber = "22"


$sessionOptions.HostName = "ftp.zzzz.com"
$sessionOptions.UserName = "zzzz"
$sessionOptions.Password = "*****"
write-host "After password...." -foregroundcolor yellow;
$sessionOptions.SslHostCertificateFingerprint = "xx:e3:74:c5:a7:e3:0f:5b:d3:77:6e:bd:58:19:a6:2c:33:e8:fa:ec"

write-host "After Open SslHostCertificateFingerprint ...." -foregroundcolor yellow;
$session = New-Object WinSCP.Session
write-host "After new session ...." -foregroundcolor yellow;
try
{
# Connect
write-host "Before Opening ...." -foregroundcolor yellow;
$session.Open($sessionOptions)

write-host "After Open Session...." -foregroundcolor yellow;

$localPath = "E:\Apps\"
$remotePath = "/SFTPPourshinsDownload"
$file = "CS_20140703_050427.csv"

# Format timestamp
$stamp = $(Get-Date -f "yyyyMMddHHmmss")

# Download the file and throw on any error
$session.GetFiles(
($remotePath + $file),
($localPath + $stamp + "." + $file)).Check()
}
finally
{
# Disconnect, clean up
$session.Dispose()
}

exit 0
}
catch [Exception]
{
Write-Host $_.Exception.Message -foregroundcolor green
#exit 1
}



$host.enternestedprompt()

write-host "To see the output........." -foregroundcolor yellow;
pause

bgolfer66 wrote:

Nothing looks out of the ordinary to me. I am able to substitute my connection credentials into your code and connect to my server.
whatever is happening is outside my area of expertise. Hopefully a site admin can help you.

Silku wrote:

Thanks John.

Here it is : I have given write host trap from where it is causing....
Now it is saying "The requested operation requires elevation"...:-((
------------------------------


#----------------------------------------------------------
try
{
# Load WinSCP .NET assembly

write-host "Begin..............." -foregroundcolor yellow;


[Reflection.Assembly]::LoadFrom("C:\Program Files (x86)\WinSCP\WinSCPnet.dll")
write-host "After assembly...." -foregroundcolor yellow;
# Setup session options
$sessionOptions = New-Object WinSCP.SessionOptions
write-host "After Open WinSCP.SessionOptions...." -foregroundcolor yellow;

$sessionOptions.Protocol = [WinSCP.Protocol]::ftp
write-host "After Open WinSCP.prtocol...." -foregroundcolor yellow;
$sessionOptions.FtpMode = [WinSCP.FtpMode]::passive
write-host "After Open WinSCP.ftpmode...." -foregroundcolor yellow;
$sessionOptions.FtpSecure = [WinSCP.FtpSecure]::explicittls

$sessionOptions.PortNumber = "22"


$sessionOptions.HostName = "ftp.zzzz.com"
$sessionOptions.UserName = "zzzz"
$sessionOptions.Password = "*****"
write-host "After password...." -foregroundcolor yellow;
$sessionOptions.SslHostCertificateFingerprint = "xx:e3:74:c5:a7:e3:0f:5b:d3:77:6e:bd:58:19:a6:2c:33:e8:fa:ec"

write-host "After Open SslHostCertificateFingerprint ...." -foregroundcolor yellow;
$session = New-Object WinSCP.Session
write-host "After new session ...." -foregroundcolor yellow;
try
{
# Connect
write-host "Before Opening ...." -foregroundcolor yellow;
$session.Open($sessionOptions)

write-host "After Open Session...." -foregroundcolor yellow;

$localPath = "E:\Apps\"
$remotePath = "/SFTPPourshinsDownload"
$file = "CS_20140703_050427.csv"

# Format timestamp
$stamp = $(Get-Date -f "yyyyMMddHHmmss")

# Download the file and throw on any error
$session.GetFiles(
($remotePath + $file),
($localPath + $stamp + "." + $file)).Check()
}
finally
{
# Disconnect, clean up
$session.Dispose()
}

exit 0
}
catch [Exception]
{
Write-Host $_.Exception.Message -foregroundcolor green
#exit 1
}



$host.enternestedprompt()

write-host "To see the output........." -foregroundcolor yellow;
pause

Anonymous wrote:

Thanks John. Waiting to hear from him.

bgolfer66 wrote:

Nothing looks out of the ordinary to me. I am able to substitute my connection credentials into your code and connect to my server.
whatever is happening is outside my area of expertise. Hopefully a site admin can help you.

Silku wrote:

Thanks John.

Here it is : I have given write host trap from where it is causing....
Now it is saying "The requested operation requires elevation"...:-((
------------------------------


#----------------------------------------------------------
try
{
# Load WinSCP .NET assembly

write-host "Begin..............." -foregroundcolor yellow;


[Reflection.Assembly]::LoadFrom("C:\Program Files (x86)\WinSCP\WinSCPnet.dll")
write-host "After assembly...." -foregroundcolor yellow;
# Setup session options
$sessionOptions = New-Object WinSCP.SessionOptions
write-host "After Open WinSCP.SessionOptions...." -foregroundcolor yellow;

$sessionOptions.Protocol = [WinSCP.Protocol]::ftp
write-host "After Open WinSCP.prtocol...." -foregroundcolor yellow;
$sessionOptions.FtpMode = [WinSCP.FtpMode]::passive
write-host "After Open WinSCP.ftpmode...." -foregroundcolor yellow;
$sessionOptions.FtpSecure = [WinSCP.FtpSecure]::explicittls

$sessionOptions.PortNumber = "22"


$sessionOptions.HostName = "ftp.zzzz.com"
$sessionOptions.UserName = "zzzz"
$sessionOptions.Password = "*****"
write-host "After password...." -foregroundcolor yellow;
$sessionOptions.SslHostCertificateFingerprint = "xx:e3:74:c5:a7:e3:0f:5b:d3:77:6e:bd:58:19:a6:2c:33:e8:fa:ec"

write-host "After Open SslHostCertificateFingerprint ...." -foregroundcolor yellow;
$session = New-Object WinSCP.Session
write-host "After new session ...." -foregroundcolor yellow;
try
{
# Connect
write-host "Before Opening ...." -foregroundcolor yellow;
$session.Open($sessionOptions)

write-host "After Open Session...." -foregroundcolor yellow;

$localPath = "E:\Apps\"
$remotePath = "/SFTPPourshinsDownload"
$file = "CS_20140703_050427.csv"

# Format timestamp
$stamp = $(Get-Date -f "yyyyMMddHHmmss")

# Download the file and throw on any error
$session.GetFiles(
($remotePath + $file),
($localPath + $stamp + "." + $file)).Check()
}
finally
{
# Disconnect, clean up
$session.Dispose()
}

exit 0
}
catch [Exception]
{
Write-Host $_.Exception.Message -foregroundcolor green
#exit 1
}



$host.enternestedprompt()

write-host "To see the output........." -foregroundcolor yellow;
pause

Anonymous wrote:

Thanks John. Waiting to hear from him.

Silku wrote:

2014-07-11 10:47:42.098 331 Password required for
> 2014-07-11 10:47:42.098 PASS ********
< 2014-07-11 10:47:42.119 530 User cannot log in.
. 2014-07-11 10:47:42.119 Connection failed.
. 2014-07-11 10:47:42.120 Password prompt (last login attempt failed)

Sriram wrote:

Dear All,

Actually i m using secure ftp, I am using winscp to push the file to sftp, but in session.open i am getting error. i gave ftpurl, hostname, username and password, but i never give sshostFingerprintkey, instead of this i gave sessionOptions.GiveUpSecurityAndAcceptAnySshHostKey = true; .. But not resolved. how i achive that.

Sriram wrote:

i am getting error.