Home > Archive > SQL Anywhere database replication > February 2006 > ASA 7.03 Replication through a firewall









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author ASA 7.03 Replication through a firewall
JJS

2006-02-08, 9:23 am

I'm seting up File based replication and need to do so
through a firewall. One server lies inside the firewall the
other on the outside of the firewall. I know in prior
versions of Sybase you could specify the
ServerPort=XXX.XXX.XXX.XXX. I can not find anything
pertaining to ASA 7.03.

My plan is to have the main site outside of the firewall and
have the remote site grab data off of the main site's db
server and process it, likewise the remote server would drop
off any replication Files on the main server. So the $10.00
question is what port on the remote server do I need to open
up. I assume it is a parameter that is put on the
dbremote.exe (although a review of the available switches
doesn't show one available). Or perhaps it is something in
the ODBC configuration.

Any assistance would be appreciated.
Reg Domaratzki \(iAnywhere Solutions\)

2006-02-08, 11:23 am

The ServerPort parameter you mention is an option on the database engine,
and has nothing to do with dbremote.

When using the FILE based method of replication with dbremote, dbremote is
simply given a directory name where incoming messages are stored, and where
it should write it's messages for other databases. When the two databases
you are replicating are on different machines, one machine typically
contains the message store, and the other accesses the store through a
network share. In other words, dbremote isn't doing anything fancy, it's
just basically doing an fopen(
'\\machine-name\share- name\directory\messa
ge.file', 'r' ). You'll need to
open the port in your firewall that allows network shares from outside the
firewall, which is pretty much equivalent to not using a firewall. You're
likely better off using the FTP based message system when machines are on
different sides of the firewall. You now just need to open the FTP port on
your firewall (port 21) to allow dbremote to exchange messages.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"


<JJS> wrote in message news:43e9f1d3.5c6c.1681692777@sybase.com...
> I'm seting up File based replication and need to do so
> through a firewall. One server lies inside the firewall the
> other on the outside of the firewall. I know in prior
> versions of Sybase you could specify the
> ServerPort=XXX.XXX.XXX.XXX. I can not find anything
> pertaining to ASA 7.03.
>
> My plan is to have the main site outside of the firewall and
> have the remote site grab data off of the main site's db
> server and process it, likewise the remote server would drop
> off any replication Files on the main server. So the $10.00
> question is what port on the remote server do I need to open
> up. I assume it is a parameter that is put on the
> dbremote.exe (although a review of the available switches
> doesn't show one available). Or perhaps it is something in
> the ODBC configuration.
>
> Any assistance would be appreciated.



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com