DBServer Config File

Administration
1

Hello,

I am trying to clarify what the DBServer configuration files in a primary/redundancy should consist of.
This is a set up I have and in my opinion the reason why we cant connect to CME or GA after the primary configuration server fails.
I have read on the framework deployment guide that the port value must be unique? Is this the port or management-port, or both? or does it not matter?
The configuration file for the backup DB Server must be the same as that for
the primary DB Server, with the following exceptions:
• The host value can be different if the backup DB Server is installed on a
different host computer other than the primary server.
• The port value must be unique.

Primary DBServer config file:

[dbserver]
host=[localhostA]
port=4040
management-port =4051
dbprocesses_per_client=1
dbprocess_name=dbclient_msql

oracle_name=./dbclient_oracle
informix_name=./dbclient_informix
msql_name=./dbclient_msql
sybase_name=./dbclient_sybase
db2_name=./dbclient_db2

connect_break_time=1200
tran_batch_mode=off

#---------- dbserver log options ----------

[lca]
lcaport=4999

[log]
verbose=all
all=D:\Program Files (x86)\Logs\DBServer\DBServer.log
buffering=true
segment=10000
expire=30
standard=network

Backup DBServer config file:

[dbserver]
host=[localhostB]
port=4040
management-port =4041
dbprocesses_per_client=1
dbprocess_name=dbclient_msql

oracle_name=./dbclient_oracle
informix_name=./dbclient_informix
msql_name=./dbclient_msql
sybase_name=./dbclient_sybase
db2_name=./dbclient_db2

connect_break_time=1200
tran_batch_mode=off

#---------- dbserver log options ----------

[lca]
lcaport=4999

[log]
verbose=all
all=D:\Program Files (x86)\Logs\DBServer\DBServer.log
buffering=true
segment=10000
expire=30
standard=network

thanks.

2

I think the conf files for DBServer are configured properly. If you have registered an issue with cfg read-only mode after master confserv failed, try to check confserv.conf files, where you can find configuration pointing to primary and backup DB server - this configuration must be correct of course. I remember similiar issue and this was the root cause.

3

is the documentation incorrect, where it specifies the ‘port value must be unique’?

4

Ports must be unique only in case when they running on same hosts, in other cases it is not necessary.

5

I think there maybe a misconfiguration on my confserv.cfg files then?
Primary configuration server file:

[confserv]
port=2020
management-port=2021
server=dbserver
encryption=true
encoding=utf-8

[log]
verbose=all
buffering=true
expire=3 day
segment=10000
standard=network
all = D:\Program Files (x86)\Logs\Confserv\ConfServ

[hca]
schema = none

[history-log]
expiration=30
client-expiration=1
active=false
all=histlog

[soap]
port = [ToBeChanged: soap_port]

[dbserver]
host=[hostB]
port=4040
dbengine=mssql
dbserver=[SQLDBServer]
dbname=gcti75
username=sa
password=[password]
server=dbserver1
reconnect-timeout=10
response-timeout=600

[dbserver1]
host=[hostA]
port=4040
dbengine=mssql
dbserver=[SQLDBServer]
dbname=gcti75
username=sa
password=[password]
server=dbserver
reconnect-timeout=10
response-timeout=600

backup configuration server file:

[confserv_backup]
port=2020
management-port=2021
server=dbserver
encryption=true
encoding=utf-8

[log]
verbose=all
buffering=true
expire=3 day
segment=10000
standard=network
all = D:\Program Files (x86)\Logs\ConfServ\ConfServ

[hca]
schema = none

[history-log]
expiration=30
client-expiration=1
active=false
all=histlog

[soap]
port = [ToBeChanged: soap_port]

[dbserver]
host=[hostB]
port=4040
dbengine=mssql
dbserver=[SQLDBServer]
dbname=gcti75
username=sa
password=[password]
server=dbserver1
reconnect-timeout=10
response-timeout=600

[dbserver1]
host=[hostA]
port=4040
dbengine=mssql
dbserver=[SQLDBServer]
dbname=gcti75
username=sa
password=[password]
server=dbserver
reconnect-timeout=10
response-timeout=600

I suspect the dbServer sections are the wrong way round..
thanks..

6

Under “dbserver1” section should be the configuration of backup DB server. So,is your backup DB server at hostA? dbServer option must contain hostname of MSSQL server.