configuring redundant cfg dbservers

[Williams]

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

[catanirex]

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>

[Sylvainsjc]

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

[Williams]

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

[catanirex]

Hi,

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

Been there - done that.... :-)

[René]

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é

[Williams]

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

[Williams]

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?

[catanirex]

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

[Williams]

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 

[Sylvainsjc]

Do you see any backup information in the dbserver log files

[Sylvainsjc]

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 [color=red][b]Warm Standby (backup) mode activated [/b] [/color]

[René]

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é

[Williams]

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<app name>. 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

[Sylvainsjc]

Look at the difference between my log and your log

[color=blue]Command line:     C:\GCTI\BackupDBServer\multiserver.exe -service DBServer_9 -host nxo-gexpress -port 2020 -app Backup_DBServer -cfg -c dbserver.cfg [/color]

[color=red]Command line:     C:\GCTI\DBServer\cfg_dbserver_b\multiserver.exe -service DBServer -host ccagenlab0302 -port 2020 -cfg -app cfg_dbserver_b [/color]

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