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.

HTTPS Synchronisation error

10 posts in General Discussion Last posting was on 2008-10-02 10:50:45.0Z
Gerard Henry Posted on 2008-09-25 11:13:34.0Z
Sender: 766a.48da575a.1804289383@sybase.com
From: Gerard Henry
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: HTTPS Synchronisation error
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48db725e.2571.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 25 Sep 2008 04:13:34 -0700
X-Trace: forums-1-dub 1222341214 10.22.241.41 (25 Sep 2008 04:13:34 -0700)
X-Original-Trace: 25 Sep 2008 04:13:34 -0700, 10.22.241.41
Lines: 38
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:1240
Article PK: 9326

How can I resolve following error on MBusiness client
application when using HTTPS sync. protocol :-

SQLE_SYNC_INFO_INVALID:stream
Some details of our configuration and setup :-
MOBILINK SERVER DETAILS Mobilink server 9.0.2 EBF 3687 with
"RSA Encryption Add-On Licence 32-bit"

USM SCHEMA ulinit" -q -f SERVITOR -c
"eng=RAC_iany01_DEV_UL_ULREF;uid=dba;pwd=sql" -s SERVITOR -n
SERVITOR -t "C:\iAnywhere Mobile\rac\ul\bin\remote.crt"

MOBILINK CLIENT
ULPOD9.dll 9.0.2.3687 (UltraLite for M-Business Server
(TLS_ECC CE_300_ARM))
HTTPS Stream
Parms:host=iany01;port=7050;trusted_certificates=C:\iAnywhere
Mobile\rac\ul\bin\server.crt;certificate_name=Mobile

HTML/JavaScript code for preparing sync is; error occurs at
CONN.SYNCHRONIZE() :-

streamParms = hostString + portString +
";trusted_certificates=C:\\iAnywhere
Mobile\\rac\\ul\\bin\\server.crt;certificate_name=Mobile";
sync_parms.setStream(sync_parms.STREAM_TYPE_HTTPS);
sync_parms.setStreamParms(streamParms);
sync_parms.setDownloadOnly(false); //this was true, but
could cause problems in the future

var db_schema = conn.databaseSchema;
var pub_schema =
db_schema.getPublicationSchema("SERVITOR");
var SERVITOR_MASK = pub_schema.getMask();
sync_parms.setPublicationMask(SERVITOR_MASK);

conn.saveSyncParms();
conn.synchronize();


Jeff Albion (Sybase iAnywhere) Posted on 2008-09-25 15:25:03.0Z
From: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: Re: HTTPS Synchronisation error
References: <48db725e.2571.1681692777@sybase.com>
In-Reply-To: <48db725e.2571.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: <48dbad4f$1@forums-1-dub>
Date: 25 Sep 2008 08:25:03 -0700
X-Trace: forums-1-dub 1222356303 10.22.241.152 (25 Sep 2008 08:25:03 -0700)
X-Original-Trace: 25 Sep 2008 08:25:03 -0700, vip152.sybase.com
Lines: 89
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:1242
Article PK: 9328

Gerard,

1) C:\iAnywhere Mobile\rac\ul\bin\remote.crt / C:\iAnywhere
Mobile\rac\ul\bin\server.crt

Which one is your true "client" certificate? Only one of the
certificates should be deployed to your remotes (I assume
"client.crt"?), the other needs to kept secure and specified on the
MobiLink start line:

dbmlsrv9 -x https(certificate=server.crt;certificate_password=password) ...

You can either embed the client certificate in the UltraLite DB
generation (as you've done) or override it with the trusted_certificates
parameter in your JavaScript code (as you've also done. :)

2) SQLE_SYNC_INFO_INVALID

... means that your configuration of the stream parameters is incorrect.

Specifically, the parameters are stored in the property
Connection.syncParms, which from the code snippet below, I don't see
being assigned. (conn.saveSynchParms() allows the parameters to be
available during a HotSync or "One-Button" sync).

You also need to set a script version.

So, the fix should be:

sync_parms.version = "MyVersion";
conn.syncParms = sync_parms;
conn.saveSynchParms();
conn.synchronize();

You can also check the example at
%ASANY9%\Samples\UltraLiteForMBusinessAnywhere\CustDB\sync.htm for more
details.

Cheers,

Gerard Henry wrote:
> How can I resolve following error on MBusiness client
> application when using HTTPS sync. protocol :-
>
> SQLE_SYNC_INFO_INVALID:stream
> Some details of our configuration and setup :-
> MOBILINK SERVER DETAILS Mobilink server 9.0.2 EBF 3687 with
> "RSA Encryption Add-On Licence 32-bit"
>
> USM SCHEMA ulinit" -q -f SERVITOR -c
> "eng=RAC_iany01_DEV_UL_ULREF;uid=dba;pwd=sql" -s SERVITOR -n
> SERVITOR -t "C:\iAnywhere Mobile\rac\ul\bin\remote.crt"
>
> MOBILINK CLIENT
> ULPOD9.dll 9.0.2.3687 (UltraLite for M-Business Server
> (TLS_ECC CE_300_ARM))
> HTTPS Stream
> Parms:host=iany01;port=7050;trusted_certificates=C:\iAnywhere
> Mobile\rac\ul\bin\server.crt;certificate_name=Mobile
>
> HTML/JavaScript code for preparing sync is; error occurs at
> CONN.SYNCHRONIZE() :-
>
> streamParms = hostString + portString +
> ";trusted_certificates=C:\\iAnywhere
> Mobile\\rac\\ul\\bin\\server.crt;certificate_name=Mobile";
> sync_parms.setStream(sync_parms.STREAM_TYPE_HTTPS);
> sync_parms.setStreamParms(streamParms);
> sync_parms.setDownloadOnly(false); //this was true, but
> could cause problems in the future
>
> var db_schema = conn.databaseSchema;
> var pub_schema =
> db_schema.getPublicationSchema("SERVITOR");
> var SERVITOR_MASK = pub_schema.getMask();
> sync_parms.setPublicationMask(SERVITOR_MASK);
>
> conn.saveSyncParms();
> conn.synchronize();

--
Jeff Albion, 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


Gerard Henry Posted on 2008-09-26 10:58:21.0Z
Sender: 766a.48da575a.1804289383@sybase.com
From: Gerard Henry
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: Re: HTTPS Synchronisation error
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48dcc04d.4bc7.1681692777@sybase.com>
References: <48dbad4f$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 26 Sep 2008 03:58:21 -0700
X-Trace: forums-1-dub 1222426701 10.22.241.41 (26 Sep 2008 03:58:21 -0700)
X-Original-Trace: 26 Sep 2008 03:58:21 -0700, 10.22.241.41
Lines: 39
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:1244
Article PK: 9330

Jeff

Still get the error. See Client Code below (I took out
redundant use of trusted certificate; as its in the USM) :-

SERVER :-
C:\iAnywhere Mobile\rac\ul\bin>start dbmlsrv9 -c
dsn=RAC_iany01_DEV_UL_CONS;UID=dba;pwd=sql -x
"https(port=7050;certificate=C:\iAnywhere
Mobile\RAC\ul\bin\server.crt;certificate_password=18092008RSA)"
-fr -zp -v+ -dl -o "C:\iAnywhere
Mobile\RAC\ul\logs\ml_server.log" -os 4M -zu+ -zs


CLIENT CODE :-

var sync_parms = conn.syncParms;
sync_parms.setUserName(system + username + ":");
sync_parms.setVersion(mlversion);
var streamParms;
streamParms = hostString + portString +
";network_connect_timeout=10;network_name=" + networkName;

sync_parms.setStream(sync_parms.STREAM_TYPE_HTTPS);
sync_parms.setStreamParms(streamParms);
sync_parms.setDownloadOnly(false); //this was true, but
could cause problems in the future

var db_schema = conn.databaseSchema;
var pub_schema = db_schema.getPublicationSchema("SERVITOR");
var SERVITOR_MASK = pub_schema.getMask();
sync_parms.setPublicationMask(SERVITOR_MASK);

conn.saveSyncParms();
conn.synchronize();

Thanks.

Gerard.


Jeff Albion (Sybase iAnywhere) Posted on 2008-09-26 17:29:17.0Z
From: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: Re: HTTPS Synchronisation error
References: <48dbad4f$1@forums-1-dub> <48dcc04d.4bc7.1681692777@sybase.com>
In-Reply-To: <48dcc04d.4bc7.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: <48dd1bed@forums-1-dub>
Date: 26 Sep 2008 10:29:17 -0700
X-Trace: forums-1-dub 1222450157 10.22.241.152 (26 Sep 2008 10:29:17 -0700)
X-Original-Trace: 26 Sep 2008 10:29:17 -0700, vip152.sybase.com
Lines: 60
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:1245
Article PK: 17924

Gerard,

Everything looks okay in the new code snippet - although it's not clear
if you have the encryption libraries properly installed on your client.
It may be tripping over trying to set the sync stream to be HTTPS.

What files are installed in \Program Files\AvantGo\pods ?

Regards,

Gerard Henry wrote:
> Jeff
>
> Still get the error. See Client Code below (I took out
> redundant use of trusted certificate; as its in the USM) :-
>
> SERVER :-
> C:\iAnywhere Mobile\rac\ul\bin>start dbmlsrv9 -c
> dsn=RAC_iany01_DEV_UL_CONS;UID=dba;pwd=sql -x
> "https(port=7050;certificate=C:\iAnywhere
> Mobile\RAC\ul\bin\server.crt;certificate_password=18092008RSA)"
> -fr -zp -v+ -dl -o "C:\iAnywhere
> Mobile\RAC\ul\logs\ml_server.log" -os 4M -zu+ -zs
>
>
> CLIENT CODE :-
>
> var sync_parms = conn.syncParms;
> sync_parms.setUserName(system + username + ":");
> sync_parms.setVersion(mlversion);
> var streamParms;
> streamParms = hostString + portString +
> ";network_connect_timeout=10;network_name=" + networkName;
>
> sync_parms.setStream(sync_parms.STREAM_TYPE_HTTPS);
> sync_parms.setStreamParms(streamParms);
> sync_parms.setDownloadOnly(false); //this was true, but
> could cause problems in the future
>
> var db_schema = conn.databaseSchema;
> var pub_schema = db_schema.getPublicationSchema("SERVITOR");
> var SERVITOR_MASK = pub_schema.getMask();
> sync_parms.setPublicationMask(SERVITOR_MASK);
>
> conn.saveSyncParms();
> conn.synchronize();
>
> Thanks.
>
> Gerard.

--
Jeff Albion, 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


David Fishburn Posted on 2008-09-27 00:38:28.0Z
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: Re: HTTPS Synchronisation error
From: David Fishburn <fishburn_spam_off@ianywhere.com>
References: <48dd1bed@forums-1-dub> <48dd51f2.604e.1681692777@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns9B25D1F965819fishburnsybasecom@10.22.241.106>
User-Agent: Xnews/2005.10.18
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 26 Sep 2008 17:38:28 -0700
X-Trace: forums-1-dub 1222475908 10.22.241.152 (26 Sep 2008 17:38:28 -0700)
X-Original-Trace: 26 Sep 2008 17:38:28 -0700, vip152.sybase.com
Lines: 29
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:1247
Article PK: 17925

Gerard Henry wrote in news:48dd51f2.604e.1681692777@sybase.com
of ianywhere.public.mbusinessanywhere.general:

...
GH> Ultralite Pod 9.0.2.3687

What is the exact (in bytes) file size?

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng10 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList


Jeff Albion (Sybase iAnywhere) Posted on 2008-10-01 16:33:04.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.mbusinessanywhere.general
Subject: Re: HTTPS Synchronisation error
References: <Xns9B25D1F965819fishburnsybasecom@10.22.241.106> <48e32d72.2961.1681692777@sybase.com>
In-Reply-To: <48e32d72.2961.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: <48e3a640$1@forums-1-dub>
Date: 1 Oct 2008 09:33:04 -0700
X-Trace: forums-1-dub 1222878784 10.22.241.152 (1 Oct 2008 09:33:04 -0700)
X-Original-Trace: 1 Oct 2008 09:33:04 -0700, vip152.sybase.com
Lines: 49
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:1250
Article PK: 17926

Gerard,

If you are working with support, we generally will encourage you to work
with the technical support rep directly. We are all working together
behind the scenes and frequently involve different expertises on cases.
From what I've heard back from the technical support representative, we
correctly identified a missing .DLL on your client device?

---

The SQLE_SYNC_INFO_INVALID:stream error indicates that the Ultralite
runtime cannot use the stream you have specified (HTTPS) for an unknown
reason. This is generally an unhelpful message, but likely candidates
usually are:

- Code issue (bad reference, bad invocation, typo...)
- Deployment / .DLL issue

Checking both the .syncStream and .syncParms settings are the important
things to investigate. (SQLE_SYNC_INFO_INVALID also happens when
conflicting sync flags are set)

---

For encryption deployments on M-Business, we recommend deploying the
.cab file (which contains the encryption DLLs) found at:

%ASANY9%\ultralite\UltraLiteForMBusinessAnywhere\ce\arm\ulpod.cab

This deploys ulrt9.dll and ulrsa9.dll/ulecc9.dll to \Windows. You may
have to deploy these files manually if one file is not included in the CAB.

Cheers,

Gerard Henry wrote:
> Any thoughts since my response on 26th ? I'm struggling
> badly with this so any help would be appreciated; previously
> raised a support case with iAnywhere but still waiting for a
> resolution.

--
Jeff Albion, 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