dbTalk Databases Forums  

ASA 10.0.1 config mirroring with arbiter

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss ASA 10.0.1 config mirroring with arbiter in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bebob
 
Posts: n/a

Default ASA 10.0.1 config mirroring with arbiter - 08-11-2009 , 05:51 AM






Hello,

I try to config an arbiter, server1 and server2.
When I config all three services on the same system (win vista)
everything works fine.
But when I try to config the server2 service on an other system (win
2k3 server) than the arbiter didnīt find the server2.

Here are my configs:

Server1 (IP: 192.1.99.37):

-n server1
C:\SynchroTest\Server1\WC00_10_1.DB
-x TCPIP{PORT=2641}
-su sql
-xf C:\SynchroTest\Arbiter\server1state.ini
-o C:\SynchroTest\Arbiter\server1.out
-xp partner={ENG=server2;LINKS=tcpip
{HOST=192.1.99.115;PORT=2639;TIMEOUT=1}};arbiter={ ENG=srvar;LINKS=tcpip
{PORT=2640;TIMEOUT=1}};AUTH=bebob;MODE=sync
-sn bp_test

Arbiter (IP: 192.1.99.37):

-n srvar
-x TCPIP{PORT=2640}
-su sql
-xa AUTH=bebob;DBN=WC00_10_1
-xf C:\SynchroTest\arbiter\arbiterstate.txt
-o C:\SynchroTest\arbiter\arbiter.out

Server2 (IP: 192.1.99.115):

-n server2
C:\SynchroTest\Server2\WC00_10_1.DB
-x TCPIP{HOST=192.1.99.115;PORT=2639}
-su sql
-xf C:\SynchroTest\Arbiter\server2state.ini
-o C:\SynchroTest\Arbiter\server2.out
-xp partner={ENG=server1;LINKS=TCPIP
{HOST=192.1.99.37;PORT=2641;TIMEOUT=1}};arbiter={E NG=srvar;LINKS=TCPIP
{HOST=192.1.99.37;PORT=2640;TIMEOUT=1}};AUTH=bebob ;MODE=sync
-sn bp_test

Any ideas or tips?

Kind regards,

Benjamin

Reply With Quote
  #2  
Old   
Graeme Perrow [Sybase iAnywhere]
 
Posts: n/a

Default Re: ASA 10.0.1 config mirroring with arbiter - 08-11-2009 , 08:39 AM






Your -xp switch on server1 is missing the host parameter for the arbiter.

Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
Sybase iAnywhere Engineering

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs


Bebob wrote:
Quote:
Hello,

I try to config an arbiter, server1 and server2.
When I config all three services on the same system (win vista)
everything works fine.
But when I try to config the server2 service on an other system (win
2k3 server) than the arbiter didnīt find the server2.

Here are my configs:

Server1 (IP: 192.1.99.37):

-n server1
C:\SynchroTest\Server1\WC00_10_1.DB
-x TCPIP{PORT=2641}
-su sql
-xf C:\SynchroTest\Arbiter\server1state.ini
-o C:\SynchroTest\Arbiter\server1.out
-xp partner={ENG=server2;LINKS=tcpip
{HOST=192.1.99.115;PORT=2639;TIMEOUT=1}};arbiter={ ENG=srvar;LINKS=tcpip
{PORT=2640;TIMEOUT=1}};AUTH=bebob;MODE=sync
-sn bp_test

Arbiter (IP: 192.1.99.37):

-n srvar
-x TCPIP{PORT=2640}
-su sql
-xa AUTH=bebob;DBN=WC00_10_1
-xf C:\SynchroTest\arbiter\arbiterstate.txt
-o C:\SynchroTest\arbiter\arbiter.out

Server2 (IP: 192.1.99.115):

-n server2
C:\SynchroTest\Server2\WC00_10_1.DB
-x TCPIP{HOST=192.1.99.115;PORT=2639}
-su sql
-xf C:\SynchroTest\Arbiter\server2state.ini
-o C:\SynchroTest\Arbiter\server2.out
-xp partner={ENG=server1;LINKS=TCPIP
{HOST=192.1.99.37;PORT=2641;TIMEOUT=1}};arbiter={E NG=srvar;LINKS=TCPIP
{HOST=192.1.99.37;PORT=2640;TIMEOUT=1}};AUTH=bebob ;MODE=sync
-sn bp_test

Any ideas or tips?

Kind regards,

Benjamin

Reply With Quote
  #3  
Old   
Bebob
 
Posts: n/a

Default Re: ASA 10.0.1 config mirroring with arbiter - 08-12-2009 , 08:24 AM



On 11 Aug., 15:39, "Graeme Perrow [Sybase iAnywhere]"
<ReplyToNewsgroupOnly-gperro... (AT) SPAMianywhere (DOT) PLEASEcom> wrote:
Quote:
Your -xp switch on server1 is missing the host parameter for thearbiter.

Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
Sybase iAnywhere Engineering

SQL Anywhere Developer Community
* *http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
* *http://www.sybase.com/sqlanyblogs

Bebob wrote:
Hello,

I try to config anarbiter, server1 and server2.
When I config all three services on the same system (win vista)
everything works fine.
But when I try to config the server2 service on an other system (win
2k3 server) than thearbiterdidnīt find the server2.

Here are my configs:

Server1 (IP: 192.1.99.37):

-n server1
C:\SynchroTest\Server1\WC00_10_1.DB
-x TCPIP{PORT=2641}
-su sql
-xf C:\SynchroTest\Arbiter\server1state.ini
-o C:\SynchroTest\Arbiter\server1.out
-xp partner={ENG=server2;LINKS=tcpip
{HOST=192.1.99.115;PORT=2639;TIMEOUT=1}};arbiter={ ENG=srvar;LINKS=tcpip
{PORT=2640;TIMEOUT=1}};AUTH=bebob;MODE=sync
-sn bp_test

Arbiter(IP: 192.1.99.37):

-n srvar
-x TCPIP{PORT=2640}
-su sql
-xa AUTH=bebob;DBN=WC00_10_1
-xf C:\SynchroTest\arbiter\arbiterstate.txt
-o C:\SynchroTest\arbiter\arbiter.out

Server2 (IP: 192.1.99.115):

-n server2
C:\SynchroTest\Server2\WC00_10_1.DB
-x TCPIP{HOST=192.1.99.115;PORT=2639}
-su sql
-xf C:\SynchroTest\Arbiter\server2state.ini
-o C:\SynchroTest\Arbiter\server2.out
-xp partner={ENG=server1;LINKS=TCPIP
{HOST=192.1.99.37;PORT=2641;TIMEOUT=1}};arbiter={E NG=srvar;LINKS=TCPIP
{HOST=192.1.99.37;PORT=2640;TIMEOUT=1}};AUTH=bebob ;MODE=sync
-sn bp_test

Any ideas or tips?

Kind regards,

Benjamin
Thanks, but server1 and the arbiter are on the same system so I think
that is not the problem.
Iīve tried with the host paramter for server1 but nothing changed.
Server2 is still waiting for a connection to the arbiter or server1.
FYI: The arbiter didnīt change the primary server to server2 when I
stop server1 (because the arbiter didnīt see server2).

Any ideas?

Reply With Quote
  #4  
Old   
Bebob
 
Posts: n/a

Default Re: ASA 10.0.1 config mirroring with arbiter - 08-12-2009 , 09:00 AM



On 12 Aug., 15:24, Bebob <bpo... (AT) gmx (DOT) de> wrote:
Quote:
On 11 Aug., 15:39, "Graeme Perrow [Sybase iAnywhere]"



ReplyToNewsgroupOnly-gperro... (AT) SPAMianywhere (DOT) PLEASEcom> wrote:
Your -xp switch on server1 is missing the host parameter for thearbiter..

Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
Sybase iAnywhere Engineering

SQL Anywhere Developer Community
* *http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
* *http://www.sybase.com/sqlanyblogs

Bebob wrote:
Hello,

I try to config anarbiter, server1 and server2.
When I config all three services on the same system (win vista)
everything works fine.
But when I try to config the server2 service on an other system (win
2k3 server) than thearbiterdidnīt find the server2.

Here are my configs:

Server1 (IP: 192.1.99.37):

-n server1
C:\SynchroTest\Server1\WC00_10_1.DB
-x TCPIP{PORT=2641}
-su sql
-xf C:\SynchroTest\Arbiter\server1state.ini
-o C:\SynchroTest\Arbiter\server1.out
-xp partner={ENG=server2;LINKS=tcpip
{HOST=192.1.99.115;PORT=2639;TIMEOUT=1}};arbiter={ ENG=srvar;LINKS=tcpip
{PORT=2640;TIMEOUT=1}};AUTH=bebob;MODE=sync
-sn bp_test

Arbiter(IP: 192.1.99.37):

-n srvar
-x TCPIP{PORT=2640}
-su sql
-xa AUTH=bebob;DBN=WC00_10_1
-xf C:\SynchroTest\arbiter\arbiterstate.txt
-o C:\SynchroTest\arbiter\arbiter.out

Server2 (IP: 192.1.99.115):

-n server2
C:\SynchroTest\Server2\WC00_10_1.DB
-x TCPIP{HOST=192.1.99.115;PORT=2639}
-su sql
-xf C:\SynchroTest\Arbiter\server2state.ini
-o C:\SynchroTest\Arbiter\server2.out
-xp partner={ENG=server1;LINKS=TCPIP
{HOST=192.1.99.37;PORT=2641;TIMEOUT=1}};arbiter={E NG=srvar;LINKS=TCPIP
{HOST=192.1.99.37;PORT=2640;TIMEOUT=1}};AUTH=bebob ;MODE=sync
-sn bp_test

Any ideas or tips?

Kind regards,

Benjamin

Thanks, but server1 and thearbiterare on the same system so I think
that is not the problem.
Iīve tried with the host paramter for server1 but nothing changed.
Server2 is still waiting for a connection to thearbiteror server1.
FYI: Thearbiterdidnīt change the primary server to server2 when I
stop server1 (because thearbiterdidnīt see server2).

Any ideas?
Hello again,

even when I start only the arbiter (192.1.99.37 Port 2640) and the
server2 (192.1.99.115 Port 2639) I get no connection.
The state files are empty!

Regards,

Benjamin

Reply With Quote
  #5  
Old   
Bruce Hay
 
Posts: n/a

Default Re: ASA 10.0.1 config mirroring with arbiter - 08-12-2009 , 11:13 AM



The use of
-x TCPIP{HOST=192.1.99.115;PORT=2639}
for the server2 command line seems unusual; HOST= should not be needed here.

I'd suggest adding -z to the command line for each server and examining the resulting console log file to see if that reports
anything useful. Also, double-check that the actual IP address for the server2 machine is correct and matches what is specified
on the server1 command line.

Another thing to try would be to start a non-mirrored server using a specific port on each of the two machines and verify that
you can make a normal database connection between machines using dbping or dbisql.

SQL Anywhere Developer Community:
http://www.sybase.com/developer/libr...ere-techcorner


SQL Anywhere Blog Center: http://www.sybase.com/sqlanyblogs




Bebob wrote:
Quote:
On 12 Aug., 15:24, Bebob <bpo... (AT) gmx (DOT) de> wrote:
On 11 Aug., 15:39, "Graeme Perrow [Sybase iAnywhere]"



ReplyToNewsgroupOnly-gperro... (AT) SPAMianywhere (DOT) PLEASEcom> wrote:
Your -xp switch on server1 is missing the host parameter for thearbiter.
Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
Sybase iAnywhere Engineering
SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs
Bebob wrote:
Hello,
I try to config anarbiter, server1 and server2.
When I config all three services on the same system (win vista)
everything works fine.
But when I try to config the server2 service on an other system (win
2k3 server) than thearbiterdidnīt find the server2.
Here are my configs:
Server1 (IP: 192.1.99.37):
-n server1
C:\SynchroTest\Server1\WC00_10_1.DB
-x TCPIP{PORT=2641}
-su sql
-xf C:\SynchroTest\Arbiter\server1state.ini
-o C:\SynchroTest\Arbiter\server1.out
-xp partner={ENG=server2;LINKS=tcpip
{HOST=192.1.99.115;PORT=2639;TIMEOUT=1}};arbiter={ ENG=srvar;LINKS=tcpip
{PORT=2640;TIMEOUT=1}};AUTH=bebob;MODE=sync
-sn bp_test
Arbiter(IP: 192.1.99.37):
-n srvar
-x TCPIP{PORT=2640}
-su sql
-xa AUTH=bebob;DBN=WC00_10_1
-xf C:\SynchroTest\arbiter\arbiterstate.txt
-o C:\SynchroTest\arbiter\arbiter.out
Server2 (IP: 192.1.99.115):
-n server2
C:\SynchroTest\Server2\WC00_10_1.DB
-x TCPIP{HOST=192.1.99.115;PORT=2639}
-su sql
-xf C:\SynchroTest\Arbiter\server2state.ini
-o C:\SynchroTest\Arbiter\server2.out
-xp partner={ENG=server1;LINKS=TCPIP
{HOST=192.1.99.37;PORT=2641;TIMEOUT=1}};arbiter={E NG=srvar;LINKS=TCPIP
{HOST=192.1.99.37;PORT=2640;TIMEOUT=1}};AUTH=bebob ;MODE=sync
-sn bp_test
Any ideas or tips?
Kind regards,
Benjamin
Thanks, but server1 and thearbiterare on the same system so I think
that is not the problem.
Iīve tried with the host paramter for server1 but nothing changed.
Server2 is still waiting for a connection to thearbiteror server1.
FYI: Thearbiterdidnīt change the primary server to server2 when I
stop server1 (because thearbiterdidnīt see server2).

Any ideas?

Hello again,

even when I start only the arbiter (192.1.99.37 Port 2640) and the
server2 (192.1.99.115 Port 2639) I get no connection.
The state files are empty!

Regards,

Benjamin

Reply With Quote
  #6  
Old   
Bebob
 
Posts: n/a

Default Re: ASA 10.0.1 config mirroring with arbiter - 08-13-2009 , 07:36 AM



On 12 Aug., 18:13, Bruce Hay <h_a_y_@_i_a_n_y_w_h_e_r_e_d_o_t_c_o_m>
wrote:
Quote:
The use of
* * * * -x TCPIP{HOST=192.1.99.115;PORT=2639}
for the server2 command line seems unusual; HOST= should not be needed here.

I'd suggest adding -z to the command line for each server and examining the resulting console log file to see if that reports
anything useful. Also, double-check that the actual IP address for the server2 machine is correct and matches what is specified
on the server1 command line.

Another thing to try would be to start a non-mirrored server using a specific port on each of the two machines and verify that
you can make a normal database connection between machines using dbping or dbisql.

SQL Anywhere Developer Community:http://www.sybase.com/developer/libr...ere-techcorner

SQL Anywhere Blog Center:http://www.sybase.com/sqlanyblogs

Bebob wrote:
On 12 Aug., 15:24, Bebob <bpo... (AT) gmx (DOT) de> wrote:
On 11 Aug., 15:39, "Graeme Perrow [Sybase iAnywhere]"

ReplyToNewsgroupOnly-gperro... (AT) SPAMianywhere (DOT) PLEASEcom> wrote:
Your -xp switch on server1 is missing the host parameter for thearbiter.
Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
Sybase iAnywhere Engineering
SQL Anywhere Developer Community
* *http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
* *http://www.sybase.com/sqlanyblogs
Bebob wrote:
Hello,
I try to config anarbiter, server1 and server2.
When I config all three services on the same system (win vista)
everything works fine.
But when I try to config the server2 service on an other system (win
2k3 server) than thearbiterdidnīt find the server2.
Here are my configs:
Server1 (IP: 192.1.99.37):
-n server1
C:\SynchroTest\Server1\WC00_10_1.DB
-x TCPIP{PORT=2641}
-su sql
-xf C:\SynchroTest\Arbiter\server1state.ini
-o C:\SynchroTest\Arbiter\server1.out
-xp partner={ENG=server2;LINKS=tcpip
{HOST=192.1.99.115;PORT=2639;TIMEOUT=1}};arbiter={ ENG=srvar;LINKS=tcpip
{PORT=2640;TIMEOUT=1}};AUTH=bebob;MODE=sync
-sn bp_test
Arbiter(IP: 192.1.99.37):
-n srvar
-x TCPIP{PORT=2640}
-su sql
-xa AUTH=bebob;DBN=WC00_10_1
-xf C:\SynchroTest\arbiter\arbiterstate.txt
-o C:\SynchroTest\arbiter\arbiter.out
Server2 (IP: 192.1.99.115):
-n server2
C:\SynchroTest\Server2\WC00_10_1.DB
-x TCPIP{HOST=192.1.99.115;PORT=2639}
-su sql
-xf C:\SynchroTest\Arbiter\server2state.ini
-o C:\SynchroTest\Arbiter\server2.out
-xp partner={ENG=server1;LINKS=TCPIP
{HOST=192.1.99.37;PORT=2641;TIMEOUT=1}};arbiter={E NG=srvar;LINKS=TCPIP
{HOST=192.1.99.37;PORT=2640;TIMEOUT=1}};AUTH=bebob ;MODE=sync
-sn bp_test
Any ideas or tips?
Kind regards,
Benjamin
Thanks, but server1 and thearbiterare on the same system so I think
that is not the problem.
Iīve tried with the host paramter for server1 but nothing changed.
Server2 is still waiting for a connection to thearbiteror server1.
FYI: Thearbiterdidnīt change the primary server to server2 when I
stop server1 (because thearbiterdidnīt see server2).

Any ideas?

Hello again,

even when I start only thearbiter(192.1.99.37 Port 2640) and the
server2 (192.1.99.115 Port 2639) I get no connection.
The state files are empty!

Regards,

Benjamin
Well... my windows vista firewall has blocked the server2 connection.
Thanks a lot!!!

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.