Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Williams on January 08, 2008, 02:52:51 PM

Title: configuring redundant cfg dbservers
Post by: Williams on January 08, 2008, 02:52:51 PM
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
Title: Re: configuring redundant cfg dbservers
Post by: catanirex on January 08, 2008, 02:57:42 PM
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>
Title: Re: configuring redundant cfg dbservers
Post by: Sylvainsjc on January 08, 2008, 03:29:38 PM
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
Title: Re: configuring redundant cfg dbservers
Post by: Williams on January 08, 2008, 03:47:43 PM
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
Title: Re: configuring redundant cfg dbservers
Post by: catanirex on January 08, 2008, 03:51:00 PM
Hi,

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

Been there - done that.... :-)
Title: Re: configuring redundant cfg dbservers
Post by: René on January 08, 2008, 04:59:05 PM
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é
Title: Re: configuring redundant cfg dbservers
Post by: Williams on January 08, 2008, 05:32:46 PM
Hi Rene,
I followed the steps in the framework pdf to a T, and its still coming up as primary. thanks for the suggestion
Title: Re: configuring redundant cfg dbservers
Post by: Williams on January 08, 2008, 05:44:11 PM
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?
Title: Re: configuring redundant cfg dbservers
Post by: catanirex on January 08, 2008, 06:31:43 PM
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
Title: Re: configuring redundant cfg dbservers
Post by: Williams on January 08, 2008, 08:08:26 PM
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  :-\
Title: Re: configuring redundant cfg dbservers
Post by: Sylvainsjc on January 08, 2008, 08:22:44 PM
Do you see any backup information in the dbserver log files ???
Title: Re: configuring redundant cfg dbservers
Post by: Sylvainsjc on January 08, 2008, 08:45:39 PM
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]
Title: Re: configuring redundant cfg dbservers
Post by: René on January 08, 2008, 08:55:11 PM
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é
Title: Re: configuring redundant cfg dbservers
Post by: Williams on January 08, 2008, 09:40:56 PM
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


Title: Re: configuring redundant cfg dbservers
Post by: Sylvainsjc on January 08, 2008, 09:49:49 PM
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...
Title: Re: configuring redundant cfg dbservers
Post by: Williams on January 08, 2008, 10:15:27 PM
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
Title: Re: configuring redundant cfg dbservers
Post by: René on January 08, 2008, 10:25:25 PM
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.
Title: Re: configuring redundant cfg dbservers
Post by: Sylvainsjc on January 08, 2008, 10:31:08 PM
See Attached snapshoots for cfg dbserver and configserver (primary and backup)

Title: Re: configuring redundant cfg dbservers
Post by: Sylvainsjc on January 08, 2008, 10:33:54 PM
I Agree with René - without lca and SCS running (and HA license...) : redundancy won't work
Title: Re: configuring redundant cfg dbservers
Post by: catanirex on January 09, 2008, 07:26:03 AM
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.
Title: Re: configuring redundant cfg dbservers
Post by: Williams on January 09, 2008, 03:49:15 PM
Hi All,
Renee or someone....can you call me at 704-943-8269. Getting to be a pain. I totally understanding what the recommendations have been....and I have made them...and getting the same thing.

Pretty sure you don't need HA license to run cfg db server in HA mode. SCS and LCA are both running.

I put the -cfg in all places for the backup cfg db server(i.e app template, startserver.bat file and Image path. Far as I can see, all looks well.

Renee- Do I need the -cfg in the Image path for the primary dbserver??

Here is what I saw in the logs after making the above changes:

07:29:12.611 Trc 06084 Configuration option set: 'lca':'lcaport' = '4999'
Open LCALayer on port=4999
LCA Library version 7.5.000.05
07:29:12.611 Std 05060 Application started
Open server port: = (
  "name" = "dbserver"
  "server-type" = "46"
  "port" = "4040"
)
07:29:13.814 Std 04525 Port 4040 opened for listening
************************************
LCALayer: REventRegistered on LCA...
************************************
LCALayer: DBID changed from 0 to 255
Windowns NT service stopped
Listener (port id = dbserver fd = 260) 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
07:31:19.880 Std 01000 DbServer Exiting
  /Process manager statistics
    name                      = ProcessStatistics
    error_start_count        = 0
    successfully_start_count  = 0
    error_stop_count          = 0
    successfully_stop_count  = 0
    unexpected_terminated    = 0
    time_expired_count        = 0
GServer (0xa258c4) is being removed. numofclients = 0,current numofserveritems = 0
07:31:19.880 Trc 04109 Logging service stopped

I must be still missing something.  thanks
Title: Re: configuring redundant cfg dbservers
Post by: Fra on January 09, 2008, 04:52:33 PM
Williams,

-cfg option is not needed for primary confserv.
I can see a "Windowns NT service stopped" ; is the image path correct?
Title: Re: configuring redundant cfg dbservers
Post by: Williams on January 09, 2008, 05:15:22 PM
below is my image path:

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

Below is my startserver.bat

@echo off

rem --------------------------------------------------------------------------------------
rem Copyright (C) 2007 Genesys Telecommunications Laboratories, Inc.
rem
rem startServer.bat file for DB Server, version 7.5.000.07
rem --------------------------------------------------------------------------------------

@TITLE DB Server v. 7.5.000.07 cfg_dbserver
multiserver.exe -host ccagenlab0302 -port 2020 -app cfg_dbserver_b -cfg


Title: Re: configuring redundant cfg dbservers
Post by: Sylvainsjc on January 09, 2008, 05:17:58 PM
[color=blue][b]SURE YOU NEED the license ha_redundancy.

Without, you'll see in SCI the application in "BACKUP" status mode but try to kill the primary application, the status of the backup application won't get "PRIMARY"...[/b][/color]
Title: Re: configuring redundant cfg dbservers
Post by: Williams on January 09, 2008, 06:30:37 PM
I'm covered. I do have the ha_redunancy license feature in my license file.
Title: Re: configuring redundant cfg dbservers
Post by: victor on January 09, 2008, 07:51:15 PM
Ok, while I am researching HA standby for cfg_dbserver, here are some basic things:

-  there is no need to for your cfg_dbserver to be in BACKUP mode.
-  there is a section called [dbserver] in your confserv.conf file that defines your PRIMARY dbserver. inside that section, toward the end, you have "server = " option where you define your backup dbserver you want you config server to switch to, should first go down.  create [dbserver_backup] section right after the last line of [dbserver] section and fill out information on your backup dbserver

I would suggest for your backup configserver to use [dbserver_backup] section as primary access point with [dbserver] as your backup. Of course, this depends on your system layout, but still...

I will try to do some tests with HA dbserver setup, but I do not see the point of having DBSERVER in backup mode. Especially "HA" - it just does not make much sense, since unlike TServer there is nothing to synchronize. DBserver is just a mean of accessing DB.

Oh, yeah, important thing: make sure you have [lca] section in your dbserver.conf file, something like this:

[lca]
lcaport=4999

this actually tells your cfg_dbserver to connect to LCA. :)

As I was looking through the log you have posted, you have this:

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

Looks weird to me. :)

First of all: if you have startServer.bat, why would you not just call it from Path? You do not to specify anything other than that!

In your startServer.bat add "-service DBServer" for your primary DBSErver and "-service DBServer_b" (or whatever the name of your backup DBServer service is for backup server.

You do not need -cfg if the name of your dbserver is cfg_dbserver, BUT you will need it for cfg_dbserver_b. (Genesys knows that dbserver's name if cfg_dbserver, it means it is db server for config server and it needs to read dbserver.cfg file to get all the info.)

For your cfg_dbserver_b, I strongly suggest adding -c inside your batch file and specifying the name of your cfg_dbserver_b's config file just to avoid any potential screw ups in a future. (you DID replace Path Info in CME cfg_dbserver with the path to you batch file, right?)
Vic
Title: Re: configuring redundant cfg dbservers
Post by: cavagnaro on January 09, 2008, 08:05:44 PM
Hi guys,
If I have a HA license, I can have a standby server for each server? TServer? OCS? StatServer? Or do I need a license for each of them?
Title: Re: configuring redundant cfg dbservers
Post by: Daimonas on January 09, 2008, 08:17:28 PM
Here is a listing of the HA licenses, they are specific to the product for most cases:

vendor_info="v7.1- HA - Enterprise Routing"
vendor_info="v7.0 - HA - Call Concentrator"
FEATURE ha_redundancy
FEATURE cti_ha_option

There are some other ones (and newer ones), like for Config server. Currently I have a config proxy license that allows me to use Proxy servers.

For OCS, you may have one or both of the following:
FEATURE ocs
FEATURE occ_full
Title: Re: configuring redundant cfg dbservers
Post by: René on January 09, 2008, 08:21:12 PM
Williams - Could you post here your dbserver.cfg files?

Cavagnaro - There are several license related to HA. The license key we're talking about is "HA_redundancy". That key "allows" SCS to automatically do switchover when primary app fails. The other keys are "cti_ha_option" for TServer and "router_ha_option" for URS.

R.
Title: Re: configuring redundant cfg dbservers
Post by: cavagnaro on January 09, 2008, 08:49:20 PM
Hi René,
Thanks for the answer. I do have:

FEATURE ha_redundancy genesys.d 7.0 1-jan-00 999999 15F1D9CE4DEB \
FEATURE router_ha_option genesys.d 7.0 1-jan-00 999999 5254BBAB01BD \
FEATURE cti_ha_option genesys.d 7.0 1-jan-00 999999 74A7E2E2FF35 \

So i can do all the HA right?

What I do have for OCS is:

FEATURE occ_full genesys.d 7.0 1-jan-00 154 1A98D4683A5B

Does this allow me to have a backup OCS?
Title: Re: configuring redundant cfg dbservers
Post by: Williams on January 09, 2008, 09:08:02 PM
Rene,
below is my dbserver.cfg file for my backup db server:

[dbserver]
host=s-qa-genapp
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 ----------
#
[log]
verbose=all
all=c:\gcti\logs\cfg_dbserver_b\db

[lca]
lcaport=4999
Title: Re: configuring redundant cfg dbservers
Post by: victor on January 09, 2008, 09:15:09 PM
I was able to get PRIMARY/BACKUP:
[attachimg=1]

My suggestion would be the following:

1. remove backup server definition from your cfg_dbserver in CME.
2. press APPLY
3. check that both of them are shown as PRIMARY in SCI
4. select cfg_dbserver_b as BACKUP SERVER for cfg_dbserver in your CME again and select WARM standby
5. press APPLY

it should then show PRIMARY/BACKUP in your SCI.
Title: Re: configuring redundant cfg dbservers
Post by: René on January 09, 2008, 09:18:20 PM
Cavagnaro - The license key "occ_full" means that you can run the campaigns in all supported modes (preview, predictive, progressive). That license has no relation to HA. If you have license "HA_redundancy" for SCS then you can run OCS in HA and SCS will switchover to backup server if the primary fails.

R.
Title: Re: configuring redundant cfg dbservers
Post by: René on January 09, 2008, 09:24:14 PM
Williams,

Maybe the way suggested by Victor would be the best one. Uninstall all cfg_dbserver applications, delete these from CME and start again for scratch. I would say we've checked all configurations and these seem to be correct...

R.
Title: Re: configuring redundant cfg dbservers
Post by: Williams on January 09, 2008, 09:38:24 PM
Rene,Victor,

Many thanks for your help. After taking the backup off of the primary and then applying it again...the backup started up in backup mode. I guess after I made all the to the command line argument in CME, the startserver.bat file and the image path, I needed to do the above.

Here's an excerpt from the log:

13:20:03.223 Trc 06084 Configuration option set: 'lca':'lcaport' = '4999'
Open LCALayer on port=4999
LCA Library version 7.5.000.05
13:20:03.223 Std 05060 Application started
Open server port: = (
  "name" = "dbserver"
  "server-type" = "46"
  "port" = "4040"
)
13:20:04.269 Std 04525 Port 4040 opened for listening
************************************
LCALayer: REventRegistered on LCA...
************************************
LCALayer: DBID changed from 0 to 255
Listener (port id = dbserver fd = 260) 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
13:21:54.588 Std 04560 Warm Standby (backup) mode activated

Title: Re: configuring redundant cfg dbservers
Post by: victor on January 09, 2008, 09:48:54 PM
It would be nice to say that SOMEBODY [hint-hint :) ] called you and SOMEBODY [once again...hint! ] on their vacation took the time out to help you out while having his really upset girlfriend next to him demand to choose between Genesys or her...

:P
Title: Re: configuring redundant cfg dbservers
Post by: Williams on January 09, 2008, 10:08:01 PM
Tell your girlfiend, I am very very sorry.
but seriously, I couldn't even get genesys tech support to help me with this. they had to escalate on their side.

thanks again to everyone that took time out to support and provide specific instructions
Title: Re: configuring redundant cfg dbservers
Post by: cavagnaro on January 10, 2008, 02:35:12 AM
[quote author=victor link=topic=2706.msg10799#msg10799 date=1199915334] while having his really upset girlfriend next to him demand to choose between Genesys or her...
[/quote]
Why is this is getting more common every day?
We the non understood...
Title: Re: configuring redundant cfg dbservers
Post by: SorinM on April 22, 2008, 07:26:18 AM
Hello to all,

I'm realy new with Genesys, i took some courses. We want to find a method to have a backup server for entire Genesys installation. Do you know how i can do this? If i want to use the HA from Genesys, how should the second server be installed? I will install the first server without specifying backup server?Then i will install again Genesys on another server and then i should make the connection between them through the backup server field for every component? How can i ensure the redundancy of Databases? It has to be smth. else independent from Genesys?

Thank you!
Title: Re: configuring redundant cfg dbservers
Post by: cavagnaro on April 22, 2008, 07:45:27 AM
Yes, on the main application you need to define the backup application so when main goes down SCS can send the order to standby server to start.
Usually you have two kinds of HA, Warm and Hot standby, each one of them is specified on the servers deployment guides. Basically on warm standby it will not receive data until SCS tells it to be main, while on hot standby it will be alive and receiving all events so when main goes down it will easily take main, however both has pro/cons like bandwidth consumption on one side and time to be ready on the other hand for example.
About DB it is not a Genesys task, you must talk to your DBAs for that sort of configuration.