|
Home > Archive > SQL Anywhere Mobile > April 2006 > 2 mobilink server
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]
|
|
|
| Hi,
ASE 12.5
ASA 901
We plan to have 2 mobilink server on the same unix box and
also using the same user to test on both database.
We are concern when we create db and run dbmlsync at the
first time, how dbmlsync know which mobilink server to
connect to ???
Thanks,
Toni
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2006-04-04, 9:32 am |
| The two MobiLink servers on the same box will be listening on two different
ports for incoming connections. When you define the remote, you need to
specify the location (including machine name/IP and port number) of the
MobiLink server you will be connecting to.
CREATE PUBLICATION "DBA"."p1" ( TABLE t1 );
CREATE SYNCHRONIZATION USER "rem1";
CREATE SYNCHRONIZATION SUBSCRIPTION TO "DBA"."p1"
FOR "rem1" TYPE 'TCPIP' ADDRESS 'host=192.168.1.1;port=3000' OPTION
SV='v1';
--
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"
<Toni> wrote in message news:44327d17.7ea4.1681692777@sybase.com...
> Hi,
>
> ASE 12.5
> ASA 901
>
> We plan to have 2 mobilink server on the same unix box and
> also using the same user to test on both database.
> We are concern when we create db and run dbmlsync at the
> first time, how dbmlsync know which mobilink server to
> connect to ???
>
> Thanks,
> Toni
| |
| Breck Carter [Team iAnywhere] 2006-04-04, 9:32 am |
| On 4 Apr 2006 07:05:11 -0800, Toni wrote:
>how dbmlsync know which mobilink server to
>connect to ???
By port number. See dbmlsrv9 -x and dbmlsync -e adr.
Breck
--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/ SQL_Anyw...pers_Guide.html
breck.carter@risingroad.com
| |
|
| Thank you very much a quick respond.
We are having one mobilink server and it works fine without
having port number.
dbmlsr9 -x tcpip
dbmlsync - e adrr "ip address"
Does it mean we need to have 2 port number for unix box ????
I think we have only one port number to connect to unix box.
Thanks,
Toni
> On 4 Apr 2006 07:05:11 -0800, Toni wrote:
>
>
> By port number. See dbmlsrv9 -x and dbmlsync -e adr.
>
> Breck
>
> --
> Breck Carter [Team iAnywhere]
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
> The book:
>
http://www.risingroad.com/ SQL_Anyw...pers_Guide.html
> breck.carter@risingroad.com
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2006-04-04, 9:32 am |
| With only one MobiLink server, it is using the default TCP/IP port of 2439.
If you attempt to start a second server, it will fail because port 2638 is
in use.
dbmlsrv9 -c "dsn=dsn1" --> fine, uses port 2439
dbmlsrv9 -c "dsn=dsn2"
E. 04/04 10:23:31. <Main>: Error: Unable to initialize the 'tcpip' network
layer. Unable to bind a socket to port 2439. The system-specific error code
is 10048 (hex 00002740).
You'll need to start your second MobiLink server on a different port.
dbmlsrv9 -c "dsn=dsn2" -x tcpip(port=9999)
I'd suggest hard coding the port number on both dbmlsrv9 command lines, even
if one is going to be using the default.
dbmlsrv9 -c "dsn=dsn1" -x tcpip(port=2439)
dbmlsrv9 -c "dsn=dsn2" -x tcpip(port=9999)
--
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"
<toni> wrote in message news:4432903e.7f9f.1681692777@sybase.com...[color=darkred]
> Thank you very much a quick respond.
>
> We are having one mobilink server and it works fine without
> having port number.
>
> dbmlsr9 -x tcpip
> dbmlsync - e adrr "ip address"
>
> Does it mean we need to have 2 port number for unix box ????
> I think we have only one port number to connect to unix box.
> Thanks,
> Toni
>
> http://www.risingroad.com/ SQL_Anyw...pers_Guide.html
| |
| Breck Carter [Team iAnywhere] 2006-04-04, 11:33 am |
| On 4 Apr 2006 08:26:54 -0800, toni wrote:
>Thank you very much a quick respond.
>
>We are having one mobilink server and it works fine without
>having port number.
>
>dbmlsr9 -x tcpip
>dbmlsync - e adrr "ip address"
>
>Does it mean we need to have 2 port number for unix box ????
>I think we have only one port number to connect to unix box.
>Thanks,
>Toni
One dbmlsrv9 server can use the default port 2439, but the second will
have to use a different port; e.g., 2440. Just pick one that isn't
used for anything else on *your* computer; here is the official list,
and 2440 looks good: http://www.iana.org/assignments/port-numbers
You may have firewall issues; that's something for you and your
firewall police to discuss. They may tell *you* what port to use, if
they are filtering a list of trojans, etc. (AFAIK nothing evil uses
2440)
Breck
--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/ SQL_Anyw...pers_Guide.html
breck.carter@risingroad.com
| |
| Greg Fenton 2006-04-04, 1:32 pm |
| Reg Domaratzki (iAnywhere Solutions) wrote:
>
> You'll need to start your second MobiLink server on a different port.
>
....or a different IP address on the same machine if it is configured
with multiple interfaces...
>
> dbmlsrv9 -c "dsn=dsn1" -x tcpip(port=2439)
> dbmlsrv9 -c "dsn=dsn2" -x tcpip(port=9999)
>
dbmlsrv9 -c "dsn=dsn1" -x tcpip(MyIP=ip_addres
s_1;port=2439)
dbmlsrv9 -c "dsn=dsn2" -x tcpip(MyIP=ip_addres
s_2;port=2439)
BTW: why are you planning on having two ML servers on the same box? Are
these pointing to different consolidateds? Are they for supporting
different remote applications?
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
|
>
> BTW: why are you planning on having two ML servers on the
> same box? Are these pointing to different consolidateds?
> Are they for supporting different remote applications?
We will have 2 different consolidate db with 2 mobilink
server and 2 remote application
Do We need to have 2 DSN setup in file .odbc.ini ???
thanks,
Toni
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
| |
|
|
| Greg Fenton 2006-04-07, 1:31 pm |
| Greg Fenton wrote:
>
> dbmlsrv9 -c "dsn=dsn1" -x tcpip(MyIP=ip_addres
s_1;port=2439)
> dbmlsrv9 -c "dsn=dsn2" -x tcpip(MyIP=ip_addres
s_2;port=2439)
>
That should be "... -x tcpip(Host=ip_addres
s_1;...)". The MyIP
parameter is a dbeng9/dbsrv9 thing.
I'm told that in Jasper the parameter names will be more inline with
those of the database server.
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
|
|
|
|
|