Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: PFCCWA on January 22, 2014, 09:19:27 AM

Title: DBServer Config File
Post by: PFCCWA on January 22, 2014, 09:19:27 AM
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?
[b][i]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.[/I][/b]

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.
Title: Re: DBServer Config File
Post by: Kubig on January 22, 2014, 01:12:10 PM
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.
Title: Re: DBServer Config File
Post by: PFCCWA on January 23, 2014, 12:06:45 PM
is the documentation incorrect, where it specifies the 'port value must be unique'?
Title: Re: DBServer Config File
Post by: Kubig on January 23, 2014, 12:11:27 PM
Ports must be unique only in case when they running on same hosts, in other cases it is not necessary.
Title: Re: DBServer Config File
Post by: PFCCWA on January 23, 2014, 01:10:22 PM
I think there maybe a misconfiguration on my confserv.cfg files then?
[u]Primary configuration server file:[/u]

[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

[u]backup configuration server file:[/u]

[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..
Title: Re: DBServer Config File
Post by: Kubig on January 23, 2014, 01:56:53 PM
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.