configuring redundant cfg dbservers

Administration
1

We are a multi site, single tenant environment. We have offices on east and west coast. On the east coast we have the primary config server and primary config db server. On the west coast we are configuring backups configuration server and backup configuration db server. The backup configuration server, once started, is coming up in the correct backup mode. However the backup configuration db server is not. It is coming up in a primary mode. On the primary configuration db server, I have assigned the backup. Our applications run on windows 2000. The versions are 7.5. Has anyone experienced this before? I’m trying to get the backup configuration db server to start up in a backup mode. But for unknown reasons its starting up in primary. Any help would be appreciated.

thanks

2

Have you started installed it as an independent applications?
In that case you need to change the following in the Registry and in CME, in order for it NOT to start as cfg_dbserver. Add the name you have for the backup

-cfg –app <cfg_dbserver_bu>

3

You can keep both cfgdbserver in primary mode : it works fine like this.

In conferv.conf and confservBackup.conf, you configure corresponding sections for each dbserver so config server will try his first cfgdbserver and if not available the other cfgdbserver.

Try this, it’s in production in one of our big customer

4

Yes. i did install it as a independant server.
Oh ok. so if my backup config db server is named, cfg_dbserver_b
I need to put this into the command line argument of the application template in cme. so it would look like “-cfg -app cfg_dbserver_b” Please confirm.

Thanks

5

Hi,

Yes, both in command line and also in the registry if it is installed as a service.

Been there - done that
 :slight_smile:

1 Like
6

Hi Williams,

You can step-by-step description in “Framework 7.5 Deployment Guide”, chapter “Configuring redundant DB Servers”. It describes the steps how to configure backup dbserver. If you follow it your backup dbserver will start in backup mode.

Briefly - you have to create the applications in CME for both dbservers and setup stand-by mode between these.

René

7

Hi Rene,
I followed the steps in the framework pdf to a T, and its still coming up as primary. thanks for the suggestion

8

catanirex,
I made the changes in my cme application for my backup config db server. command line argument looks like this:
-cfg -app cfg_dbserver_b

I also went to the startserver.bat file for the backup db server. Made the change from this:
multiserver.exe -host ccagenlab0302 -port 2020 -app cfg_dbserver_b

To this:
multiserver.exe -cfg -app cfg_dbserver_b

Also, changed it in different places in the registries. Now, I can’t start the service on the box :).
I get an error saying" the service did not respond to the start or control request in a timely fashion.

I’m thinking I need to modify the above and put back the ccagenlab0302 in it. this is the server that has the configuration server. What do you think?

9

Hi

it should be:
multiserver.exe -host ccagenlab0302 -port 2020 -cfcg -app cfg_dbserver_b

And the only place in the Registry should be
the Image Path unde Services.

change to something like
“C:\Program\GCTI75\DBServer\multiserver.exe” -service DBServer_1 -host localhost -port 2020 -cfg -app cfg_dbserver_b

10

I made the changes. good news is that I can start the application now. No so good news, is that in SCI, it shows up a primary also. I stopped both the cfg dbservers for grins
started the primary, then this one. so both are in primary mode :-\

11

Do you see any backup information in the dbserver log files ???

12

I’ve managed my lab to have cfgdbserver primary and backup

Here’s the logs from cfgdbserver backup :

Genesys Database Server, Version:‘7.5.000.07’
Copyright (c) 1997-2006 Genesys Telecommunications Labs, Inc.
Component versions:
Commonlib: 7.5.000.24 C2
Loglib: 7.5.000.04
Gmessagelib: 7.5.000.01
GServicelib: 7.5.000.04
Mngmlib: 7.5.000.00
Confservlib: 7.5.000.11
Lcalib: 7.5.000.05
Build platform: i686-winnt
Application name: Backup_DBServer
Application type: RealDBServer (46)
Command line: C:\GCTI\BackupDBServer\multiserver.exe -service DBServer_9 -host nxo-gexpress -port 2020 -app Backup_DBServer -cfg -c dbserver.cfg
Host name: nxo-gexpress
DST: TZ = 1, timeb = 0
Time zone: -3600, Paris, Madrid, Paris, Madrid (heure d’étĂ©)
UTC time: 2008-01-08T20:41:41.171
Local time: 2008-01-08T21:41:41.171
Start time (UTC): 2008-01-08T20:41:41
Running time: 0:00:00:00
Host info: Windows 5.2.3790, 2, Service Pack 2, 2.0, 0110, 3
File: (1) C:\ExpressLogs\Backup_CfgDBServer\Bck_Cfg_DB.20080108_214141_171.log

21:41:41.171 Trc 04112 The Log Output of type ‘C:\ExpressLogs\Backup_CfgDBServer\Bck_Cfg_DB’ has been created and opened
21:41:41.156 Trc 04110 Option ‘buffering’ has been set to the value ‘yes’
21:41:41.156 Trc 04110 Option ‘spool’ has been set to the value ‘’
21:41:41.156 Trc 04110 Option ‘keep-startup-file’ has been set to the value ‘no’
21:41:41.156 Trc 04110 Option ‘MessageFile’ has been set to the value ‘RealDBServer.lms’
21:41:41.156 Trc 04110 Option ‘time-format’ has been set to the value ‘time’
21:41:41.156 Trc 04110 Option ‘time-convert’ has been set to the value ‘local’
21:41:41.156 Trc 04110 Option ‘message-format’ has been set to the value ‘short’
21:41:41.156 Trc 04110 Option ‘memory-storage-size’ has been set to the value ‘2 Mb’
21:41:41.156 Trc 04110 Option ‘compatible-output-priority’ has been set to the value ‘no’
21:41:41.156 Trc 04110 Option ‘print-attributes’ has been set to the value ‘no’
21:41:41.156 Trc 04110 Option ‘check-point’ has been set to the value ‘1’
21:41:41.156 Std 04106 Log Messages file ‘RealDBServer.lms’ successfully loaded
21:41:41.156 Trc 04112 The Log Output of type ‘stdout’ has been created and opened
21:41:41.171 Trc 04112 The Log Output of type ‘C:\ExpressLogs\Backup_CfgDBServer\Bck_Cfg_DB’ has been created and opened
21:41:41.171 Trc 04100 Logging service started
21:41:41.171 Trc 06084 Configuration option set: ‘dbserver’:‘port’ = ‘4060’
21:41:41.171 Trc 06084 Configuration option set: ‘dbserver’:‘host’ = ‘nxo-gexpress’
21:41:41.171 Trc 06084 Configuration option set: ‘dbserver’:‘management-port’ = ‘4061’
21:41:41.171 Trc 06085 Configuration option set to default value: ‘dbserver’:‘verbose’ = ‘3’
21:41:41.171 Trc 06085 Configuration option set to default value: ‘dbserver’:‘dbprocesses_per_client’ = ‘1’
21:41:41.171 Trc 06085 Configuration option set to default value: ‘dbserver’:‘dbprocess_number’ = ‘255’
21:41:41.171 Trc 06085 Configuration option set to default value: ‘dbserver’:‘dbprocess_name’ = ‘./dbclient_msql’
21:41:41.171 Trc 06085 Configuration option set to default value: ‘dbserver’:‘oracle_name’ = ‘./dbclient_oracle’
21:41:41.171 Trc 06085 Configuration option set to default value: ‘dbserver’:‘informix_name’ = ‘./dbclient_informix’
21:41:41.171 Trc 06085 Configuration option set to default value: ‘dbserver’:‘sybase_name’ = ‘./dbclient_sybase’
21:41:41.171 Trc 06085 Configuration option set to default value: ‘dbserver’:‘db2_name’ = ‘./dbclient_db2’
21:41:41.171 Trc 06085 Configuration option set to default value: ‘dbserver’:‘msql_name’ = ‘./dbclient_msql’
21:41:41.171 Trc 06085 Configuration option set to default value: ‘dbserver’:‘stored_proc_result_table’ = ‘0’
21:41:41.171 Trc 06085 Configuration option set to default value: ‘dbserver’:‘connect_break_time’ = ‘1200’
21:41:41.171 Trc 06085 Configuration option set to default value: ‘dbserver’:‘tran_batch_mode’ = ‘0’
21:41:41.171 Trc 06085 Configuration option set to default value: ‘dbserver’:‘reconnect_timeout’ = ‘3600’
21:41:41.171 Trc 06085 Configuration option set to default value: ‘dbserver’:‘client_stop_timeout’ = ‘30’
21:41:41.171 Trc 06084 Configuration option set: ‘lca’:‘lcaport’ = ‘4999’
Open LCALayer on port=4999
LCA Library version 7.5.000.05
21:41:41.203 Std 05060 Application started
Open server port: = (
“name” = “dbserver”
“server-type” = “46”
“port” = “4060”
)
21:41:42.171 Std 04525 Port 4060 opened for listening

LCALayer: REventRegistered on LCA


Listener (port id = dbserver fd = 232) is being closed. Checking for clients on listener

Listener with port id = dbserver has been closed and deleted from list of current ports. Number of db app connections affected: 0
21:41:42.171 Std 04560 Warm Standby (backup) mode activated

13

Williams,

Your issue is caused by wrong configuration because I was able to make it running in my lab in 20 minutes incl. installation.

Please check following:

  • there are two applications of type DBServer in CME. One is called “cfg_dbserver” and the second one “cfg_dbserver_b” (you can change that name if you want)
  • the application “cfg_dbserver” has configured the backup application on tab “Server Info” - Backup Server = cfg_dbserver_b, Redundancy Type = Warm Standby
  • the option “Redundancy type” of the application “cfg_dbserver_b” is set to “Warm standby”. The option “Backup Server” isn’t configured - set to “[None]”
  • the image path of DBServer service is “<
path to multiserver.exe
> -service <
name of service
> -host <
host name
> -port 2020 -app cfg_dbserver -cfg”
  • the image path of backup DBServer service is “<
path to multiserver.exe
> -service <
name of service
> -host <
host name
> -port 2020 -app cfg_dbserver_b -cfg”

Run the primary DBServer and after its initialization start the backup. If you configured logging level to “debug” you should see this messages in backup DBServer log:

2008-01-08T21:49:53.484 Std 04525 Port 4045 opened for listening

LCALayer: REventRegistered on LCA


Listener (port id = dbserver fd = 264) is being closed. Checking for clients on listener

Listener with port id = dbserver has been closed and deleted from list of current ports. Number of db app connections affected: 0
2008-01-08T21:49:53.484 Std 04560 Warm Standby (backup) mode activated

René

1 Like
14

Hi All,

Rene
 I will put the -cfg to the back of the app name as opposed to the front
currently I have it as -cfg. Everything else is good to go. Logging is setup to debug. will make the change and pass the word. Below is the startup log from the backup db server currently

Genesys Database Server, Version:‘7.5.000.07’
Copyright (c) 1997-2006 Genesys Telecommunications Labs, Inc.
Component versions:
Commonlib: 7.5.000.24 C2
Loglib: 7.5.000.04
Gmessagelib: 7.5.000.01
GServicelib: 7.5.000.04
Mngmlib: 7.5.000.00
Confservlib: 7.5.000.11
Lcalib: 7.5.000.05
Build platform: i686-winnt
Application name: cfg_dbserver_b
Application type: RealDBServer (46)
Command line: C:\GCTI\DBServer\cfg_dbserver_b\multiserver.exe -service DBServer -host ccagenlab0302 -port 2020 -cfg -app cfg_dbserver_b
Host name: s-qa-genapp
DST: TZ = 1, timeb = 0
Time zone: 28800, Pacific Standard Time, Pacific Daylight Time
UTC time: 2008-01-08T19:53:03.530
Local time: 2008-01-08T11:53:03.530
Start time (UTC): 2008-01-08T19:53:03
Running time: 0:00:00:00
Host info: Windows 5.2.3790, 2, Service Pack 2, 2.0, 0110, 3
File: (1) c:\gcti\logs\cfg_dbserver_b\db.20080108_115303_531.log

11:53:03.530 Trc 04112 The Log Output of type ‘c:\gcti\logs\cfg_dbserver_b\db’ has been created and opened
11:53:03.530 Trc 04110 Option ‘buffering’ has been set to the value ‘yes’
11:53:03.530 Trc 04110 Option ‘spool’ has been set to the value ‘’
11:53:03.530 Trc 04110 Option ‘keep-startup-file’ has been set to the value ‘no’
11:53:03.530 Trc 04110 Option ‘MessageFile’ has been set to the value ‘RealDBServer.lms’
11:53:03.530 Trc 04110 Option ‘time-format’ has been set to the value ‘time’
11:53:03.530 Trc 04110 Option ‘time-convert’ has been set to the value ‘local’
11:53:03.530 Trc 04110 Option ‘message-format’ has been set to the value ‘short’
11:53:03.530 Trc 04110 Option ‘memory-storage-size’ has been set to the value ‘2 Mb’
11:53:03.530 Trc 04110 Option ‘compatible-output-priority’ has been set to the value ‘no’
11:53:03.530 Trc 04110 Option ‘print-attributes’ has been set to the value ‘no’
11:53:03.530 Trc 04110 Option ‘check-point’ has been set to the value ‘1’
11:53:03.530 Std 04106 Log Messages file ‘RealDBServer.lms’ successfully loaded
11:53:03.530 Trc 04112 The Log Output of type ‘c:\gcti\logs\cfg_dbserver_b\db’ has been created and opened
11:53:03.530 Trc 04100 Logging service started
11:53:03.530 Trc 06084 Configuration option set: ‘dbserver’:‘port’ = ‘4040’
11:53:03.530 Trc 06084 Configuration option set: ‘dbserver’:‘host’ = ‘s-qa-genapp’
11:53:03.530 Trc 06084 Configuration option set: ‘dbserver’:‘management-port’ = ‘4041’
11:53:03.530 Trc 06085 Configuration option set to default value: ‘dbserver’:‘verbose’ = ‘3’
11:53:03.530 Trc 06085 Configuration option set to default value: ‘dbserver’:‘dbprocesses_per_client’ = ‘1’
11:53:03.530 Trc 06085 Configuration option set to default value: ‘dbserver’:‘dbprocess_number’ = ‘255’
11:53:03.530 Trc 06085 Configuration option set to default value: ‘dbserver’:‘dbprocess_name’ = ‘./dbclient_msql’
11:53:03.530 Trc 06085 Configuration option set to default value: ‘dbserver’:‘oracle_name’ = ‘./dbclient_oracle’
11:53:03.530 Trc 06085 Configuration option set to default value: ‘dbserver’:‘informix_name’ = ‘./dbclient_informix’
11:53:03.530 Trc 06085 Configuration option set to default value: ‘dbserver’:‘sybase_name’ = ‘./dbclient_sybase’
11:53:03.530 Trc 06085 Configuration option set to default value: ‘dbserver’:‘db2_name’ = ‘./dbclient_db2’
11:53:03.530 Trc 06085 Configuration option set to default value: ‘dbserver’:‘msql_name’ = ‘./dbclient_msql’
11:53:03.530 Trc 06085 Configuration option set to default value: ‘dbserver’:‘stored_proc_result_table’ = ‘0’
11:53:03.530 Trc 06085 Configuration option set to default value: ‘dbserver’:‘connect_break_time’ = ‘1200’
11:53:03.530 Trc 06085 Configuration option set to default value: ‘dbserver’:‘tran_batch_mode’ = ‘0’
11:53:03.530 Trc 06085 Configuration option set to default value: ‘dbserver’:‘reconnect_timeout’ = ‘3600’
11:53:03.530 Trc 06085 Configuration option set to default value: ‘dbserver’:‘client_stop_timeout’ = ‘30’
11:53:03.530 Trc 06084 Configuration option set: ‘lca’:‘lcaport’ = ‘4999’
Open LCALayer on port=4999
LCA Library version 7.5.000.05
11:53:03.530 Std 05060 Application started
Open server port: = (
“name” = “dbserver”
“server-type” = “46”
“port” = “4040”
)
11:53:04.452 Std 04525 Port 4040 opened for listening

LCALayer: REventRegistered on LCA


12:53:03.536 Trc 04120 Check point 2008-01-08T12:53:03

15

Look at the difference between my log and your log

Command line: C:\GCTI\BackupDBServer\multiserver.exe -service DBServer_9 -host nxo-gexpress -port 2020 -app Backup_DBServer -cfg -c dbserver.cfg

Command line: C:\GCTI\DBServer\cfg_dbserver_b\multiserver.exe -service DBServer -host ccagenlab0302 -port 2020 -cfg -app cfg_dbserver_b

Missing the “-c” option to take in account the dbserver.cfg configuration file


16

Absolutely
I noticed that. Question, in your dbserver.cfg for the backup
if you open the file, the very first line is[dbserver]. Is this what you have for your backup
or did you change the name to what your configure the backup app template to be?..for example cfg_dbserver_b

thanks

17

to Sylvainsjc: It isn’t necessary to use the option “-c” as long as the name of the file is “dbserver.cfg”.

to Williams:
The name of main section in the config file “dbserver” has to be “dbserver”.

Do you have installed and running Solution Control Server? SCS is “manager” of the redundancy so it won’t work without it.

R.

18

See Attached snapshoots for cfg dbserver and configserver (primary and backup)

19

I Agree with RenĂ© - without lca and SCS running (and HA license
) : redundancy won’t work

20

Hi,

For a confserver dbserver you chould use -cfg option.

Cut from support site:

-c
DB Server reads its configuration settings from a configuration file with the specified name.
If this parameter is set, its value overrides the default name of the configuration file (dbserver.conf on Unix or dbserver.cfg on Windows).
-cfg
DB Server for the Configuration Database starts with an application name other that cfg_dbserver, but still reads its configuration from a configuration file. When this parameter is specified, the Management Layer can restart DB Server that is configured as an application even when Configuration Server is not available. Use this parameter for starting a backup DB Server for the Configuration Database. This parameter does not require any value.

1 Like