Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

HotSync through Proxy Server

8 posts in General Discussion Last posting was on 2008-11-13 16:35:31.0Z
Steve Lanza Posted on 2008-11-10 14:28:34.0Z
Sender: 3db7.49183d5a.1804289383@sybase.com
From: Steve Lanza
Newsgroups: ianywhere.public.general
Subject: HotSync through Proxy Server
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49184512.3f33.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 Nov 2008 06:28:34 -0800
X-Trace: forums-1-dub 1226327314 10.22.241.41 (10 Nov 2008 06:28:34 -0800)
X-Original-Trace: 10 Nov 2008 06:28:34 -0800, 10.22.241.41
Lines: 24
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7142
Article PK: 5366

Hi,

I have a customer that is trying to sync their Palm through
a proxy server and is receiving the error below. Is there a
way of getting around this issue? Do they need to address
the issue on their end by opening a specific port or does it
require a change to the Mobilink server? We are using SQL
Server 9.

Thanks!
Steve

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

FAIL Adaptive Server Anywhere Conduit (SQLCODE = -85)
11/07/08 10:22:24
Communication error 11/07/08 10:22:25
Upload was not received by the MobiLink server. 11/07/08
10:22:25
Unable to open a 'tcpip' network connection. Unable to
connect a socket. The system-specific error code is 10061
(hex 0000274d). 11/07/08 10:22:25

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


Shuchit Posted on 2008-11-10 15:12:37.0Z
Newsgroups: ianywhere.public.general
Subject: Re: HotSync through Proxy Server
From: Shuchit <me@privacy.net>
References: <49184512.3f33.1681692777@sybase.com>
Message-ID: <Xns9B5267A39AD08svelkarprivacynet@127.0.0.1>
User-Agent: Xnews/2006.08.24 Hamster/2.1.0.11
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 10 Nov 2008 07:12:37 -0800
X-Trace: forums-1-dub 1226329957 10.22.241.152 (10 Nov 2008 07:12:37 -0800)
X-Original-Trace: 10 Nov 2008 07:12:37 -0800, vip152.sybase.com
Lines: 34
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7143
Article PK: 5357


> I have a customer that is trying to sync their Palm through
> a proxy server and is receiving the error below. Is there a
> way of getting around this issue? Do they need to address
> the issue on their end by opening a specific port or does it
> require a change to the Mobilink server? We are using SQL
> Server 9.
>
> Thanks!
> Steve
>
> --------------------------------------------------
>
> FAIL Adaptive Server Anywhere Conduit (SQLCODE = -85)
> 11/07/08 10:22:24
> Communication error 11/07/08 10:22:25
> Upload was not received by the MobiLink server. 11/07/08
> 10:22:25
> Unable to open a 'tcpip' network connection. Unable to
> connect a socket. The system-specific error code is 10061
> (hex 0000274d). 11/07/08 10:22:25
>
> --------------------------------------------------
>

Hi,

Is the MobiLink server listening on tcpip or http. Have you tried setting the
proxy_host and proxy_port options so that UltraLite will know how to connect
to the proxy server ?
Does anything show up in the MobiLink server log when they attempt to
synchronize, or is UL not able to connect to the ML server at all.

Shuchit


Jeff Albion (Sybase iAnywhere) Posted on 2008-11-10 16:11:05.0Z
From: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.17 (Windows/20080914)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: HotSync through Proxy Server
References: <49184512.3f33.1681692777@sybase.com>
In-Reply-To: <49184512.3f33.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49185d19$1@forums-1-dub>
Date: 10 Nov 2008 08:11:05 -0800
X-Trace: forums-1-dub 1226333465 10.22.241.152 (10 Nov 2008 08:11:05 -0800)
X-Original-Trace: 10 Nov 2008 08:11:05 -0800, vip152.sybase.com
Lines: 47
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7144
Article PK: 5360

Steve,

1. What's the version and build of ASA? (dbsrv9 -v)

2. You're trying to connect using the TCP/IP protocol according to the
error below. We do not support TCP/IP proxies, nor do we offer options
to configure a proxy on the TCP/IP protocol (See:
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbmnen9/00000336.htm
)

3. We can use HTTP/HTTPS proxies by specifying "CTP=http" (or CTP=https)
and passing the appropriate proxy credentials on the "ADR" options (see:

http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbmnen9/00000337.htm
for HTTP,
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbmnen9/00000338.htm
for HTTPS).

---

For other newsgroup users viewing this thread on version 10 and 11,
please note the following fix for using HTTPS proxies that require
authentication:

http://search.sybase.com/kbx/changerequests?bug_id=544321

Regards,

Steve Lanza wrote:
> FAIL Adaptive Server Anywhere Conduit (SQLCODE = -85)
> 11/07/08 10:22:24
> Communication error 11/07/08 10:22:25
> Upload was not received by the MobiLink server. 11/07/08
> 10:22:25
> Unable to open a 'tcpip' network connection. Unable to
> connect a socket. The system-specific error code is 10061
> (hex 0000274d). 11/07/08 10:22:25

--
Jeff Albion, SQL Anywhere Engineering
Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0


Steve Lanza Posted on 2008-11-10 17:33:27.0Z
Sender: 4359.49185b1e.1804289383@sybase.com
From: Steve Lanza
Newsgroups: ianywhere.public.general
Subject: Re: HotSync through Proxy Server
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49187067.4794.1681692777@sybase.com>
References: <49185d19$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 Nov 2008 09:33:27 -0800
X-Trace: forums-1-dub 1226338407 10.22.241.41 (10 Nov 2008 09:33:27 -0800)
X-Original-Trace: 10 Nov 2008 09:33:27 -0800, 10.22.241.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7145
Article PK: 5365

Thanks for the responses!

Yes, we are currently using TCP/IP.

1. What's the version and build of ASA? (dbsrv9 -v)

9.0.2.2451

We are looking into using HTTP, but my developer has the
following question.

"How do you configure the MobiLink server to use the HTTP
protocol since if we use the default port 80, we would have
a conflict with our IIS server which is currently bound to
this port. Would we have to setup MobiLink on a separate IP
Address or is there a way for both servers to somehow
coexist on port 80 using a single IP Address?"

Thanks!


Jeff Albion (Sybase iAnywhere) Posted on 2008-11-10 18:17:59.0Z
From: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.17 (Windows/20080914)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: HotSync through Proxy Server
References: <49185d19$1@forums-1-dub> <49187067.4794.1681692777@sybase.com>
In-Reply-To: <49187067.4794.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49187ad7$1@forums-1-dub>
Date: 10 Nov 2008 10:17:59 -0800
X-Trace: forums-1-dub 1226341079 10.22.241.152 (10 Nov 2008 10:17:59 -0800)
X-Original-Trace: 10 Nov 2008 10:17:59 -0800, vip152.sybase.com
Lines: 73
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7146
Article PK: 5362

Steve,

Steve Lanza wrote:
> 9.0.2.2451

Note: That's a really old build of 9.0.2 (the first version - a.k.a.
"GA"). If you're still in development, I'd highly recommend moving to a
later version of our software to avoid issues that have already been
fixed. See the link in my signature for the EBF website.

> We are looking into using HTTP, but my developer has the
> following question.
>
> "How do you configure the MobiLink server to use the HTTP
> protocol since if we use the default port 80, we would have
> a conflict with our IIS server which is currently bound to
> this port. Would we have to setup MobiLink on a separate IP
> Address or is there a way for both servers to somehow
> coexist on port 80 using a single IP Address?"

Well, there's two approaches you can generally take here:

1. Use a different port to listen on. You cannot have two separate
services bound to the same TCP port.

To start the MobiLink server on a different port, use the -x switch of
the MobiLink server:

dbmlsrv9 -x http(port=5000)

You will then need to configure your MobiLink clients to connect to that
port:

dbmlsync -c "..." -e "CTP=http;ADR='host=myhost.company.com;port=5000'"

This will require you to open any firewall ports required.


2. Configure IIS to use the MobiLink HTTPS (ISAPI) redirector on the
existing port 80. The MobiLink redirector component is a reverse-proxy
style mechanism where we can use the existing web service to forward
MobiLink client requests on to the MobiLink server. You have to
configure MobiLink clients to use a particular URL to access the HTTP(S)
service:

dbmlsync -c "..." -e
"CTP=http;ADR='host=myhost.company.com;port=80;url_suffix=/iaredirect.dll/ml'"


There's a lot of existing documentation on this topic, so I'll point you
towards the documentation references. If you have any specific
questions, feel free to ask back here.

ASA 9 Redirector documentation:
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbmlen9/00000103.htm

Setting up IIS (using HTTPS) with the Redirector:
http://www.sybase.com/detail?id=1059364

Setting up IIS on Windows Server 2003:
http://www.sybase.com/detail?id=1059516

Cheers,

--
Jeff Albion, SQL Anywhere Engineering
Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0


Steve Lanza Posted on 2008-11-10 19:02:11.0Z
Sender: 4976.49187b8b.1804289383@sybase.com
From: Steve Lanza
Newsgroups: ianywhere.public.general
Subject: Re: HotSync through Proxy Server
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49188533.4a73.1681692777@sybase.com>
References: <49187ad7$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 Nov 2008 11:02:11 -0800
X-Trace: forums-1-dub 1226343731 10.22.241.41 (10 Nov 2008 11:02:11 -0800)
X-Original-Trace: 10 Nov 2008 11:02:11 -0800, 10.22.241.41
Lines: 45
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7147
Article PK: 5364

Jeff,

My developer read your response and thought it might be
helpful to try to further clarify our present situation.

Thanks,
Steve

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

"The main issue here is that one of our new clients are
using a proxy server, and we need to be able to synchronize
from the Palm to the MobiLink server through the proxy
server. We're currently using TCP/IP port 2500 for sync'ing
the Palm to the MobiLink server.

Our understanding is that since our client is using a proxy
server on port 80, we cannot use TCP/IP and need to support
HTTP. The issue here is that our IIS is running on port 80
so we would have to use a different port or IP Address. We
just attempted to start the MobiLink server specifying a
different IP Address in the -x parameter "Ex; -x
http(host-216.48.56.246;port-80)", but this failed with an
error stating that the server is unable to be bound to port
80. It almost seems like it's still attempting to bind to
port 80 for the localhost.

Is it possible to setup MobiLink to listen on any other port
other then 80 and still be able to be configured to use the
proxy server which is on port 80 on the client-side.
Something like setting up the MobiLink server and UltraLite
SyncParams as follows:

MobiLink: -x http(port=8181)

UltraLite:
host=IP_ADDR;port=8181;proxy_host=PROXY_IP_ADDR;proxy_port=80

One question here is that I'm not sure if we need to
possibly also configure the "url_suffix" for both the
MobiLink server and UltraLite client since it almost seems
that they both would use the default "Mobilink". Also, we're
not sure if it's necessary to configure the "client_port"
for UltraLite to use port 80 since the synchronization has
to pass-thru the proxy server."


Jeff Albion (Sybase iAnywhere) Posted on 2008-11-10 19:46:07.0Z
From: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.17 (Windows/20080914)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: HotSync through Proxy Server
References: <49187ad7$1@forums-1-dub> <49188533.4a73.1681692777@sybase.com>
In-Reply-To: <49188533.4a73.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49188f7f$1@forums-1-dub>
Date: 10 Nov 2008 11:46:07 -0800
X-Trace: forums-1-dub 1226346367 10.22.241.152 (10 Nov 2008 11:46:07 -0800)
X-Original-Trace: 10 Nov 2008 11:46:07 -0800, vip152.sybase.com
Lines: 129
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7148
Article PK: 5363

Steve,

My responses are below.

Steve Lanza wrote:
> "The main issue here is that one of our new clients are
> using a proxy server, and we need to be able to synchronize
> from the Palm to the MobiLink server through the proxy
> server. We're currently using TCP/IP port 2500 for sync'ing
> the Palm to the MobiLink server.

So, just for clairfication purposes, your current configuration looks like:

UL App on Palm <-> Conduit <- TCP/IP -> ML Server

And your desired configuration should be:

UL App on Palm <-> Conduit <- HTTP -> Proxy <- HTTP -> ML Server

> Our understanding is that since our client is using a proxy
> server on port 80, we cannot use TCP/IP and need to support
> HTTP.

Yes - we only support HTTP(S) proxy servers; we can't use TCP/IP when a
proxy is involved.

> The issue here is that our IIS is running on port 80 so we would have to use a different port or IP Address.

I take this to mean that IIS is on the machine that you're starting
MobiLink on, and you're getting the error below.

We
> just attempted to start the MobiLink server specifying a
> different IP Address in the -x parameter "Ex; -x
> http(host-216.48.56.246;port-80)", but this failed with an
> error stating that the server is unable to be bound to port
> 80. It almost seems like it's still attempting to bind to
> port 80 for the localhost.

Is the above command line a typo with the hyphens perhaps? Try:

dbmlsrv9 -x (host=216.48.56.246;port=80)

(Assuming that 216.48.56.246 does not already have a service running on
port 80 - use "netstat -a" at the Command Prompt to check).

Using the HOST parameter on the -x switch will bind it to that specific
interface; otherwise, we'll attempt to use all available interfaces.

> Is it possible to setup MobiLink to listen on any other port
> other then 80 and still be able to be configured to use the
> proxy server which is on port 80 on the client-side.

Yes, although the port that proxy is using must be specified with the
"proxy_port" option. When using the proxy configuration for the MobiLink
client, we will first connect to the proxy server using any specified
settings set by the "proxy_*" options in the HTTP sync, then ask the
proxy to connect to the MobiLink server using the usual MobiLink options.

> Something like setting up the MobiLink server and UltraLite
> SyncParams as follows:
> MobiLink: -x http(port=8181)
>
> UltraLite:
> host=IP_ADDR;port=8181;proxy_host=PROXY_IP_ADDR;proxy_port=80
>

In the interest of clearing up any confusion, I will list out a sample
configuration with a proxy server - assuming separate computers for each
of the components. I'll explicitly specify all options so you can modify
it to match your environment.

Assume:

1. UL client is on Palm.
2. The Palm conduit is configured on computer "10.0.0.1"
3. There is a proxy server on "10.0.0.2", on port 80.
4. There is a ML server on "10.0.0.3", on port 5000, listening for HTTP
connections.

Setup:

1. Start MobiLink: dbmlsrv9 -x http(host=10.0.0.3;port=5000) -c
"DSN=cons" ...

2. Set up the sync options in your Palm application* (The C++ API is
listed below...):

=====
ul_synch_info info;
ULInitSynchInfo( &info );
info.stream_parms =
UL_TEXT(
"stream=http;host=10.0.0.3;port=5000;proxy_host=10.0.0.2;proxy_port=80" );
info.user_name = UL_TEXT( "50" );
info.version = UL_TEXT( "custdb" );

ULSetSynchInfo( &sqlca, &info );

if( !db.Close( ) ) {
return( false );
}
=====
*These options can also be specified in the Windows Registry for the
Palm conduit instead if you pass in NULL. See the documentation for more
details.

> One question here is that I'm not sure if we need to possibly also configure the "url_suffix" for both the MobiLink server and UltraLite client since it almost seems that they both would use the default "Mobilink". Also, we're not sure if it's necessary to configure the "client_port" for UltraLite to use port 80 since the synchronization has to pass-thru the proxy server."

No, you don't need "url_suffix" if the MobiLink host is not running the
MobiLink redirector; client_port attempts to set the outgoing port from
the client computer (in this case, on the computer that's hosting the
Palm conduit). It is generally unnecessary to set client_port unless you
have restrictions on outbound interfaces/ports as mandated by your IT
administration.

Hope that helps!

Cheers,

--
Jeff Albion, SQL Anywhere Engineering
Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0


Steve Lanza Posted on 2008-11-13 16:35:31.0Z
Sender: 3112.491c5728.1804289383@sybase.com
From: Steve Lanza
Newsgroups: ianywhere.public.general
Subject: Re: HotSync through Proxy Server
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <491c5753.3117.1681692777@sybase.com>
References: <49188f7f$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 13 Nov 2008 08:35:31 -0800
X-Trace: forums-1-dub 1226594131 10.22.241.41 (13 Nov 2008 08:35:31 -0800)
X-Original-Trace: 13 Nov 2008 08:35:31 -0800, 10.22.241.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7149
Article PK: 5367

Jeff,

Thanks for all the helpful and useful information!

Yes, you are correct with all your assumptions and
clarifications. We're using the Palm conduit and installing
it with dbcond9.exe, and with our current configuration
using TCP/IP, everything is working perfectly.

Now all we have to do is configure another instance of the
MobiLink service in order to utilize HTTP in order to
support the client's proxy server, and thanks to all your
great information, this should hopefully be simple and
straight forward.

Thanks again!
Steve