on 2017 Dec 18 1:19 PM
I'm using SQL ANywhere 12.
I have set up a mirror DB and I would like to access it by using the server name (primaries) on both Mobilink and Tomcat (jcon 3). I can access the DB by server name no problem when the firewalls are disabled. however as soon as I turn on the firewalls (I already have exclusions for the server/mobilink ports 2638/2439), I can only access my mirror DB by specifying full URLs:
For example, with Firewalls off, I can use: - Tomcat: url="jdbc:sybase:Tds:asdf?ALTERNATE_SERVER_NAME=primaries - Mobilink (ODBC): I just enter user/pass and server name (primaries)
However, if I enabled Firewalls, I have to speficy both DB servers URLs to connect: - Tomcat: url="jdbc:sybase:Tds:DB1_URL:2638,DB2_URL:2638" - Mobilink (ODBC): I have to enter user/pass, host (DB1_URL:2638,DB2_URL:2638)
Generally, I don't mind, however, in the case of Tomcat, I find that if both DBs are up and DB_1 is the mirror, then Tomcat will always connect to it, and since DB_1 is mirror, access is read-only causing issues when I try to do DB updates. Thus, I would like to know why when my firewalls are up, the use of the 'server name' does not work (I presume it is because I'm missing extra ports I have to open).
Thanks.
User | Count |
---|---|
65 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.