473,548 Members | 2,759 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

What is the easiest way to query a remote XML file on someone elses Linux box using secure communication?

Situation:
I have to connect with my Windows 2000 server using VS.NET 2003 and C# and
connect to a remote Linux server at another company's office and query their
XML file. Their file may be updated every hour or so. How can I do this
easily? I would like to use secure communication even encryption if
possible. I would query and insert locally only the newest records found in
that XML file to an xml or MS access db.
Jul 21 '05 #1
7 2657
SSH. Otherwise SSL over HTTP, assuming the Leenucks box has Apache and a
certificate.

SSH is just another protocol over TCP, so I suppose you could write your own
implementation, or get a third party component that wraps it for you. You
could also "automate" it with something like putty (which is an SSH client
that runs on Win32).
--
Klaus H. Probst, MVP
http://www.vbbox.com/
"Dan V." <da**@yah.com > wrote in message
news:#4******** ******@TK2MSFTN GP09.phx.gbl...
Situation:
I have to connect with my Windows 2000 server using VS.NET 2003 and C# and
connect to a remote Linux server at another company's office and query their XML file. Their file may be updated every hour or so. How can I do this
easily? I would like to use secure communication even encryption if
possible. I would query and insert locally only the newest records found in that XML file to an xml or MS access db.

Jul 21 '05 #2
What is all involved?
Do I need a shared NTFS partition on their Linux box or a web service? What
kind of security does this support? What is putty I have never heard of
this?

thanks,
Dan
"Klaus H. Probst" <us*******@vbbo x.com> wrote in message
news:et******** ******@TK2MSFTN GP11.phx.gbl...
SSH. Otherwise SSL over HTTP, assuming the Leenucks box has Apache and a
certificate.

SSH is just another protocol over TCP, so I suppose you could write your own implementation, or get a third party component that wraps it for you. You
could also "automate" it with something like putty (which is an SSH client
that runs on Win32).
--
Klaus H. Probst, MVP
http://www.vbbox.com/
"Dan V." <da**@yah.com > wrote in message
news:#4******** ******@TK2MSFTN GP09.phx.gbl...
Situation:
I have to connect with my Windows 2000 server using VS.NET 2003 and C# and connect to a remote Linux server at another company's office and query their
XML file. Their file may be updated every hour or so. How can I do this easily? I would like to use secure communication even encryption if
possible. I would query and insert locally only the newest records

found in
that XML file to an xml or MS access db.


Jul 21 '05 #3
I am also interested in a .NET only solution. I would love having the two
or three easiest solutions so I can pick one that I think I could do.
"Klaus H. Probst" <us*******@vbbo x.com> wrote in message
news:et******** ******@TK2MSFTN GP11.phx.gbl...
SSH. Otherwise SSL over HTTP, assuming the Leenucks box has Apache and a
certificate.

SSH is just another protocol over TCP, so I suppose you could write your own implementation, or get a third party component that wraps it for you. You
could also "automate" it with something like putty (which is an SSH client
that runs on Win32).
--
Klaus H. Probst, MVP
http://www.vbbox.com/
"Dan V." <da**@yah.com > wrote in message
news:#4******** ******@TK2MSFTN GP09.phx.gbl...
Situation:
I have to connect with my Windows 2000 server using VS.NET 2003 and C# and connect to a remote Linux server at another company's office and query their
XML file. Their file may be updated every hour or so. How can I do this easily? I would like to use secure communication even encryption if
possible. I would query and insert locally only the newest records

found in
that XML file to an xml or MS access db.


Jul 21 '05 #4
You can't have an NTFS "share" on a Linux box. No partitions. You can have
an SMB share though. However, if you use SSH then you don't need to muck
with shares, just have the Leenucks box run sshd with the correct
permissions and all that.

Putty is an SSH client that runs on Windows:
http://www.chiark.greenend.org.uk/~sgtatham/putty/

But ultimately, yeah, you can use a share. It's just that it's very tricky
to set up Samba to serve as a file server for Windows clients. It's far
simpler to set up the other way around (Linux reading Windows shares).

But there's a whole bunch of options, really. FTP/SFTP, SSH, shares, HTTP[S]
and so on.

--
Klaus H. Probst, MVP
http://www.vbbox.com/
"Dan V." <da**@yah.com > wrote in message
news:eS******** *****@TK2MSFTNG P11.phx.gbl...
What is all involved?
Do I need a shared NTFS partition on their Linux box or a web service? What kind of security does this support? What is putty I have never heard of
this?

thanks,
Dan
"Klaus H. Probst" <us*******@vbbo x.com> wrote in message
news:et******** ******@TK2MSFTN GP11.phx.gbl...
SSH. Otherwise SSL over HTTP, assuming the Leenucks box has Apache and a
certificate.

SSH is just another protocol over TCP, so I suppose you could write your

own
implementation, or get a third party component that wraps it for you. You
could also "automate" it with something like putty (which is an SSH client that runs on Win32).
--
Klaus H. Probst, MVP
http://www.vbbox.com/
"Dan V." <da**@yah.com > wrote in message
news:#4******** ******@TK2MSFTN GP09.phx.gbl...
Situation:
I have to connect with my Windows 2000 server using VS.NET 2003 and C#

and connect to a remote Linux server at another company's office and query

their
XML file. Their file may be updated every hour or so. How can I do this easily? I would like to use secure communication even encryption if
possible. I would query and insert locally only the newest records

found
in
that XML file to an xml or MS access db.



Jul 21 '05 #5
Thanks for the options, I really appreciate it!

Since we have to connect to Linux, Mac and Windows PC's remotely and
probably just copy the XML file and query it locally (as an easier
solution), I am trying to decide which is easier of the two solutions to
maintain and setup at 60 sites. These remote sites, do not usually have
anyone technical on site.

1) Secure FTP. Either SSH or something. Ideally we install the same
version of the same program on all 3 platforms on everyone's PC. We now
have to find a way to send an xml file every day or so to us. Can SSH auto
send files or run a batch file on a schedule to our ftp site? Is it true,
that SSH will use a different port that may be blocked by firewalls and SSL
over HTTP is better as 'everyone' has port 80 open? But the advantage is
that everyone is guaranteed to have a high level of encryption once
installed - I can choose the level of encryption, so it is more secure it
sounds like?

2) SSL over HTTP. I would have to do a one time buy and setup a certificate
on our server - that is OK with me. The way I understand it is the client
does not have to do anything except go to our https site and then the
encryption starts... But this is dependent on the browser's encryption
level. Clients that do not have high enough encryption will not have any
correct - or does it stop them from accessing the site? And may think they
are protected and this would be bad. Also, how could I automate on all
platforms a file to be sent to us? It would be nice to be able to have the
client get authenticated on our ASP.NET https site and then they click a
button to upload the xml file (and have the option to do this upload
automatically from now on); but does that require web/java script
programming for on the client for every platform - or can the programming be
done from our ASP.NET server and I pull the data? SSL requires cookies,
does it not, so is this is another point of potential failure?

Thanks again,
"Klaus H. Probst" <us*******@vbbo x.com> wrote in message
news:%2******** *******@TK2MSFT NGP10.phx.gbl.. .
You can't have an NTFS "share" on a Linux box. No partitions. You can have
an SMB share though. However, if you use SSH then you don't need to muck
with shares, just have the Leenucks box run sshd with the correct
permissions and all that.

Putty is an SSH client that runs on Windows:
http://www.chiark.greenend.org.uk/~sgtatham/putty/

But ultimately, yeah, you can use a share. It's just that it's very tricky
to set up Samba to serve as a file server for Windows clients. It's far
simpler to set up the other way around (Linux reading Windows shares).

But there's a whole bunch of options, really. FTP/SFTP, SSH, shares, HTTP[S] and so on.

--
Klaus H. Probst, MVP
http://www.vbbox.com/
"Dan V." <da**@yah.com > wrote in message
news:eS******** *****@TK2MSFTNG P11.phx.gbl...
What is all involved?
Do I need a shared NTFS partition on their Linux box or a web service?

What
kind of security does this support? What is putty I have never heard of
this?

thanks,
Dan
"Klaus H. Probst" <us*******@vbbo x.com> wrote in message
news:et******** ******@TK2MSFTN GP11.phx.gbl...
SSH. Otherwise SSL over HTTP, assuming the Leenucks box has Apache and a certificate.

SSH is just another protocol over TCP, so I suppose you could write your
own
implementation, or get a third party component that wraps it for you. You could also "automate" it with something like putty (which is an SSH client that runs on Win32).
--
Klaus H. Probst, MVP
http://www.vbbox.com/
"Dan V." <da**@yah.com > wrote in message
news:#4******** ******@TK2MSFTN GP09.phx.gbl...
> Situation:
> I have to connect with my Windows 2000 server using VS.NET 2003 and
C# and
> connect to a remote Linux server at another company's office and

query their
> XML file. Their file may be updated every hour or so. How can I do

this
> easily? I would like to use secure communication even encryption if
> possible. I would query and insert locally only the newest records

found
in
> that XML file to an xml or MS access db.
>
>



Jul 21 '05 #6
I'd recommend HTTPS then. It's fairly simple to set up with IIS, but yes,
you'll need a certificate. That will run you about $400, depending who you
get it from. But now we're talking about clients uploading files, not your
code going out to another machine and reading the file, correct?

The encryption strength depends on the browser. Normally for people running
fairly modern OS you can get up to 128 bits. Mozilla variants and IE support
this. But you can set up IIS to fall back to a lower bit strength if the
client does not support 128 (usually 56 bits or so).

The code would reside on your Windows server; all the clients need is a
browser. It's fairly easy to create the upload functionality using ASP.NET.
There are a lot of examples out there that show how to do this.

SSL does not require cookies, but it supports them.

--
Klaus H. Probst, MVP
http://www.vbbox.com/
"Dan V." <da**@yah.com > wrote in message
news:en******** *****@TK2MSFTNG P09.phx.gbl...
Thanks for the options, I really appreciate it!

Since we have to connect to Linux, Mac and Windows PC's remotely and
probably just copy the XML file and query it locally (as an easier
solution), I am trying to decide which is easier of the two solutions to
maintain and setup at 60 sites. These remote sites, do not usually have
anyone technical on site.

1) Secure FTP. Either SSH or something. Ideally we install the same
version of the same program on all 3 platforms on everyone's PC. We now
have to find a way to send an xml file every day or so to us. Can SSH auto send files or run a batch file on a schedule to our ftp site? Is it true,
that SSH will use a different port that may be blocked by firewalls and SSL over HTTP is better as 'everyone' has port 80 open? But the advantage is
that everyone is guaranteed to have a high level of encryption once
installed - I can choose the level of encryption, so it is more secure it
sounds like?

2) SSL over HTTP. I would have to do a one time buy and setup a certificate on our server - that is OK with me. The way I understand it is the client
does not have to do anything except go to our https site and then the
encryption starts... But this is dependent on the browser's encryption
level. Clients that do not have high enough encryption will not have any
correct - or does it stop them from accessing the site? And may think they
are protected and this would be bad. Also, how could I automate on all
platforms a file to be sent to us? It would be nice to be able to have the client get authenticated on our ASP.NET https site and then they click a
button to upload the xml file (and have the option to do this upload
automatically from now on); but does that require web/java script
programming for on the client for every platform - or can the programming be done from our ASP.NET server and I pull the data? SSL requires cookies,
does it not, so is this is another point of potential failure?

Thanks again,
"Klaus H. Probst" <us*******@vbbo x.com> wrote in message
news:%2******** *******@TK2MSFT NGP10.phx.gbl.. .
You can't have an NTFS "share" on a Linux box. No partitions. You can have
an SMB share though. However, if you use SSH then you don't need to muck
with shares, just have the Leenucks box run sshd with the correct
permissions and all that.

Putty is an SSH client that runs on Windows:
http://www.chiark.greenend.org.uk/~sgtatham/putty/

But ultimately, yeah, you can use a share. It's just that it's very tricky to set up Samba to serve as a file server for Windows clients. It's far
simpler to set up the other way around (Linux reading Windows shares).

But there's a whole bunch of options, really. FTP/SFTP, SSH, shares, HTTP[S]
and so on.

--
Klaus H. Probst, MVP
http://www.vbbox.com/
"Dan V." <da**@yah.com > wrote in message
news:eS******** *****@TK2MSFTNG P11.phx.gbl...
What is all involved?
Do I need a shared NTFS partition on their Linux box or a web service?

What
kind of security does this support? What is putty I have never heard of this?

thanks,
Dan
"Klaus H. Probst" <us*******@vbbo x.com> wrote in message
news:et******** ******@TK2MSFTN GP11.phx.gbl...
> SSH. Otherwise SSL over HTTP, assuming the Leenucks box has Apache and a > certificate.
>
> SSH is just another protocol over TCP, so I suppose you could write your own
> implementation, or get a third party component that wraps it for
you.
You
> could also "automate" it with something like putty (which is an SSH client
> that runs on Win32).
>
>
> --
> Klaus H. Probst, MVP
> http://www.vbbox.com/
>
>
> "Dan V." <da**@yah.com > wrote in message
> news:#4******** ******@TK2MSFTN GP09.phx.gbl...
> > Situation:
> > I have to connect with my Windows 2000 server using VS.NET 2003

and C# and
> > connect to a remote Linux server at another company's office and query > their
> > XML file. Their file may be updated every hour or so. How can I

do this
> > easily? I would like to use secure communication even encryption if > > possible. I would query and insert locally only the newest records found
> in
> > that XML file to an xml or MS access db.
> >
> >
>
>



Jul 21 '05 #7
Thanks for the great reply!

What ever is easiest, either they upload or my code going out and copying
/querying the file. I have an example where someone manually uploads a file
by pressing a button: <input type=file id=myFile runat=server />.

Whatever is the most secure and easiest for the many remote sites, I would
think automating by me getting their data would be best, but then would
their browser have to stay open? Or do you not have to use a browser and
still get encryption with SSL?

Also this may have to be done every day.

"Klaus H. Probst" <us*******@vbbo x.com> wrote in message
news:uw******** *****@tk2msftng p13.phx.gbl...
I'd recommend HTTPS then. It's fairly simple to set up with IIS, but yes,
you'll need a certificate. That will run you about $400, depending who you
get it from. But now we're talking about clients uploading files, not your
code going out to another machine and reading the file, correct?

The encryption strength depends on the browser. Normally for people running fairly modern OS you can get up to 128 bits. Mozilla variants and IE support this. But you can set up IIS to fall back to a lower bit strength if the
client does not support 128 (usually 56 bits or so).

The code would reside on your Windows server; all the clients need is a
browser. It's fairly easy to create the upload functionality using ASP.NET. There are a lot of examples out there that show how to do this.

SSL does not require cookies, but it supports them.

--
Klaus H. Probst, MVP
http://www.vbbox.com/
"Dan V." <da**@yah.com > wrote in message
news:en******** *****@TK2MSFTNG P09.phx.gbl...
Thanks for the options, I really appreciate it!

Since we have to connect to Linux, Mac and Windows PC's remotely and
probably just copy the XML file and query it locally (as an easier
solution), I am trying to decide which is easier of the two solutions to
maintain and setup at 60 sites. These remote sites, do not usually have
anyone technical on site.

1) Secure FTP. Either SSH or something. Ideally we install the same
version of the same program on all 3 platforms on everyone's PC. We now
have to find a way to send an xml file every day or so to us. Can SSH auto
send files or run a batch file on a schedule to our ftp site? Is it true, that SSH will use a different port that may be blocked by firewalls and

SSL
over HTTP is better as 'everyone' has port 80 open? But the advantage is that everyone is guaranteed to have a high level of encryption once
installed - I can choose the level of encryption, so it is more secure it sounds like?

2) SSL over HTTP. I would have to do a one time buy and setup a

certificate
on our server - that is OK with me. The way I understand it is the client does not have to do anything except go to our https site and then the
encryption starts... But this is dependent on the browser's encryption
level. Clients that do not have high enough encryption will not have any correct - or does it stop them from accessing the site? And may think they are protected and this would be bad. Also, how could I automate on all
platforms a file to be sent to us? It would be nice to be able to have

the
client get authenticated on our ASP.NET https site and then they click a
button to upload the xml file (and have the option to do this upload
automatically from now on); but does that require web/java script
programming for on the client for every platform - or can the programming be
done from our ASP.NET server and I pull the data? SSL requires cookies,
does it not, so is this is another point of potential failure?

Thanks again,
"Klaus H. Probst" <us*******@vbbo x.com> wrote in message
news:%2******** *******@TK2MSFT NGP10.phx.gbl.. .
You can't have an NTFS "share" on a Linux box. No partitions. You can
have an SMB share though. However, if you use SSH then you don't need to muck with shares, just have the Leenucks box run sshd with the correct
permissions and all that.

Putty is an SSH client that runs on Windows:
http://www.chiark.greenend.org.uk/~sgtatham/putty/

But ultimately, yeah, you can use a share. It's just that it's very tricky to set up Samba to serve as a file server for Windows clients. It's far simpler to set up the other way around (Linux reading Windows shares).

But there's a whole bunch of options, really. FTP/SFTP, SSH, shares,

HTTP[S]
and so on.

--
Klaus H. Probst, MVP
http://www.vbbox.com/
"Dan V." <da**@yah.com > wrote in message
news:eS******** *****@TK2MSFTNG P11.phx.gbl...
> What is all involved?
> Do I need a shared NTFS partition on their Linux box or a web service? What
> kind of security does this support? What is putty I have never heard of
> this?
>
> thanks,
> Dan
>
>
> "Klaus H. Probst" <us*******@vbbo x.com> wrote in message
> news:et******** ******@TK2MSFTN GP11.phx.gbl...
> > SSH. Otherwise SSL over HTTP, assuming the Leenucks box has Apache and
a
> > certificate.
> >
> > SSH is just another protocol over TCP, so I suppose you could
write your
> own
> > implementation, or get a third party component that wraps it for

you. You
> > could also "automate" it with something like putty (which is an
SSH client
> > that runs on Win32).
> >
> >
> > --
> > Klaus H. Probst, MVP
> > http://www.vbbox.com/
> >
> >
> > "Dan V." <da**@yah.com > wrote in message
> > news:#4******** ******@TK2MSFTN GP09.phx.gbl...
> > > Situation:
> > > I have to connect with my Windows 2000 server using VS.NET 2003

and
C#
> and
> > > connect to a remote Linux server at another company's office and

query
> > their
> > > XML file. Their file may be updated every hour or so. How can

I do > this
> > > easily? I would like to use secure communication even
encryption
if > > > possible. I would query and insert locally only the newest records > found
> > in
> > > that XML file to an xml or MS access db.
> > >
> > >
> >
> >
>
>



Jul 21 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

125
14579
by: Sarah Tanembaum | last post by:
Beside its an opensource and supported by community, what's the fundamental differences between PostgreSQL and those high-price commercial database (and some are bloated such as Oracle) from software giant such as Microsoft SQL Server, Oracle, and Sybase? Is PostgreSQL reliable enough to be used for high-end commercial application? Thanks
2
1677
by: jake | last post by:
How can I copy a file securely (encryption) from remote computers easily (Mac and Linux) to my Win 2000 Server once a day?
1
1730
by: dtblankenship | last post by:
Hello all, I am creating an application which must send an email once all has been submitted to the user with a confirmation. In my workplace, we're required to use a remote SSL SMTP server to send all email. I searched the net for a while and could not find a non-third party way to accomplish this. I found many sites telling how to use...
121
9933
by: typingcat | last post by:
First of all, I'm an Asian and I need to input Japanese, Korean and so on. I've tried many PHP IDEs today, but almost non of them supported Unicode (UTF-8) file. I've found that the only Unicode support IDEs are DreamWeaver 8 and Zend PHP Studio. DreamWeaver provides full support for Unicode. However, DreamWeaver is a web editor rather...
3
7204
by: Harlin | last post by:
Hi, I installed the admin client on my WebSphere box. I am now attempting to connect to my DB2 server (on another box). I have been able to find the DB2 server, instance and needed databases. These auto-register themselves in the admin client. However, when I try to connect to the db's to look at the Table details I get the following...
6
1809
by: Dan V. | last post by:
Is there a way to query a remote xml file periodically by not using web services? For Windows and Unix platforms. Is there a cheap software product that I can install on each client and my Windows 2000 server and have 'secure' network access? I would love to use VS.NET to access both windows and Unix/Linux xml files.
13
5420
by: Kyle Adams | last post by:
I don't know where is the right place to ask this so I will start here. Can someone explain to me what these represent? I think they all have to do with the middleware level, but I really don't understand what a DCOM Server is or a Microsoft Transaction Server, etc. I have no idea.... Kyle
7
362
by: Dan V. | last post by:
Situation: I have to connect with my Windows 2000 server using VS.NET 2003 and C# and connect to a remote Linux server at another company's office and query their XML file. Their file may be updated every hour or so. How can I do this easily? I would like to use secure communication even encryption if possible. I would query and insert...
2
5171
by: thilandeneth | last post by:
i need to do telnet via a web server please give me a idia to initiate the project following requirements are needed 1 Create web based custom telnet client to communicate with remote destinations. must provide login security before make communication 2 telnet communication should not be a direct 1 to 1 communication and that must be as...
0
7518
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7954
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7467
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7805
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5085
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3497
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3478
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1932
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
755
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.