configuring redundant cfg dbservers

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

Williams,

-cfg option is not needed for primary confserv.
I can see a “Windowns NT service stopped” ; is the image path correct?

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

[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]

1 Like

I’m covered. I do have the ha_redunancy license feature in my license file.

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. :slight_smile:

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. :slight_smile:

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

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?

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

1 Like

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.

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?

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

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.

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.

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.

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

It would be nice to say that SOMEBODY [hint-hint :slight_smile: ] 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…

:stuck_out_tongue:

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

Why is this is getting more common every day?
We the non understood…

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!

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.