![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
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 |
#3
| |||
| |||
|
|
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 |
#4
| |||
| |||
|
|
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? |
#5
| |||
| |||
|
|
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 |
#6
| |||
| |||
|
|
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 |
![]() |
| Thread Tools | |
| Display Modes | |
| |