Genesys CTI User Forum

Joseph,

there are quite a few reasons why it does work.

first and most importantly, check your properties settings for dbserver.
Since this is cfg_dbserver, you will need to set dbserver.cfg file - is it set?
Post it here if you can.

To cover all basis, post your confserv.conf here as well. (feel free to remove the password from it)

Check if the account the cfg_dbserver is running on has sufficient privileges to use ODBC.

Here is a sample of dbserver.cfg:

[color=Green][dbserver]
host=hostname_where_dbserveris_running
port=4040
management-port = 4581
dbprocesses_per_client=1
dbprocess_name=./dbclient_msql
#
oracle_name=./dbclient_oracle
informix_name=./dbclient_informix
sybase_name=./dbclient_sybase
db2_name=./dbclient_db2
#
connect_break_time=1200
tran_batch_mode=off
#
#---------- dbserver log options ----------
#
[log]
verbose=all
all=stderr
#[/color]


Some people have reported that with W2003 you need to set "hostname" parameter in dbserver.cfg to machine name and make sure that the name is identical to host name you put in "host" under [dbserver] section in confserv.

Last but important make sure you have dbclient_msql in your directory.

Jesse

Hi Jesse,

Thanks for your help. Here are dbserver.cfg and confserv.cfg:

------------------------
[b]dbserver.cfg:[/b]

[color=Blue][dbserver]
host=fortran-qepg4es
hostname=fortran-qepg4es
port=4040
management-port =4581
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=standard
all=standard, stderr[/color]

==============
[u][b]confserv.cfg:[/b][/u]

[color=Blue]
[confserv]
port =2020
management-port =2021
server = dbserver
history-log-keep =7200
history-log-scan = 600
history-log-save = file
history-log-file-size =512000
history-log-file-name =histlog
encryption = false
encoding = utf-8

[log]
verbose = standard
all = stderr, standard

[hca]
schema = none

[soap]
port = [ToBeChanged: soap_port]

[dbserver]
host =fortran-qepg4es
port =4040
dbengine =mssql
dbserver =fortran-mwpmyos
dbname =config
username =fortran
password =password
server =
reconnect-timeout = 10
response-timeout = 600[/color]

----------------------------------------------------

I can ping the SQL database server "fortran-mwpmyos" from the dbserver (win2003).  I tried to add the postname parameter into dbserver.cfg and it made no difference after restarting the services. "dbclient_msql.exe" is in the directory but I don't know if there's a way to run it with parameters. At the dbserver(win2003) I created a new User DSN(data source) with the SQL server name "fortran-mwpmyos", database name "config" and the same username/password in the confserv.cfg. I can test the data source successfully, which means all the db parameters are correct. I really have no clues what is wrong.

dbserver and confserver are the only two components I've installed. I got the errors right after the services started. Here's the log files:

[u][b]dbserver log:[/b][/u]
[color=Blue]
Genesys Database Server, Version:'7.2.000.03'
Copyright (c) 1997-2006 Genesys Telecommunications Labs, Inc.
Component versions:
Commonlib:        7.2.000.03
Loglib:          7.1.000.04
Gmessagelib:      7.1.000.00
GServicelib:      7.2.000.03
Mngmlib:          7.1.000.02
Confservlib:      7.2.000.04
Lcalib:          7.1.100.00
Build platform:  i686-winnt
Application name: cfg_dbserver
Application type: RealDBServer (46)
Command line:    D:\Program Files\GCTI\Conf DB Server\multiserver.exe -service DBServer -host fortran-qepg4es -port 2020 -app cfg_dbserver
Host name:        fortran-qepg4es
DST:              TZ = 1, timeb = 1
Time zone:        21600, Central Standard Time, Central Daylight Time
UTC time:        2006-09-13T16:30:17.593
Local time:      2006-09-13T11:30:17.593
Start time (UTC): 2006-09-13T16:30:17
Running time:    0:00:00:00
Host info:        Windows 5.2.3790, 2, Service Pack 1, 1.0, 0110, 3
File:            (1) standard.20060913_113017_593.log

11:30:17.578 Std 04106 Log Messages file 'RealDBServer.lms' successfully loaded
11:30:17.593 Std 05060 Application started
11:30:18.500 Std 04525 Port 4040 opened for listening
11:30:19.421 Std 05022 Process './dbclient_msql' started
11:30:19.484 Std 05020 Cannot start process './dbclient_msql', error code 128
11:30:29.500 Std 05022 Process './dbclient_msql' started
11:30:29.546 Std 05020 Cannot start process './dbclient_msql', error code 128
11:30:39.546 Std 05022 Process './dbclient_msql' started
11:30:39.609 Std 05020 Cannot start process './dbclient_msql', error code 128[/color]
.........



-------------------------------------
[i][b]confserver log:[/b][/i]
[color=Blue]
Build information :
  Description : (Content freeze)
  Timestamp  : Jan 18 2006 15:44:33
  Components  :
    Configuration library  v.7.2.000.03
    Common library          v.7.2.000.03
    Service library        v.7.2.000.03 MT
    Message library        v.7.1.000.00
    Log library            v.7.1.000.04 MT
    LCA library            v.7.1.100.00
    Thread library          v.7.1.000.00
    DBServer library        v.7.1.100.00
    Genesys License library v.7.1.000.01 MT
    License library        v.FLEXLm 8.3c
    Stat Script library    v.7.1.000.02

Application name: confserv
Application type: ConfigurationServer (21)
Command line:    d:\Program Files\GCTI\Singletenant Configuration Server\confserv.exe -service ConfigServerST
Host name:        fortran-qepg4es
DST:              TZ = 1, timeb = 1
Time zone:        21600, Central Standard Time, Central Daylight Time
UTC time:        2006-09-13T16:40:52.781
Local time:      2006-09-13T11:40:52.781
Start time (UTC): 2006-09-13T16:40:52
Running time:    0:00:00:00
Host info:        Windows 5.2.3790, 2, Service Pack 1, 1.0, 0110, 3
File:            (1) standard.20060913_114052_782.log

11:40:52.781 Std 22110 Encoding [utf-8] is set successfully.
11:40:52.781 Std 05060 Application started
11:40:52.781 Std 22100 Genesys Configuration Server. Version 7.2.000.05
11:40:52.781 Std 22101 Copyright (c) 1997-2005 Genesys Telecommunications Laboratories, Inc.
11:40:52.781 Std 22102 Server application name is set to [confserv]
11:40:52.781 Std 22915 Server mode is set to [PRIMARY]
11:40:52.781 Std 22900 Objectset [main-cfgset] is being loaded ...
11:40:53.078 Std 22901 Objectset [main-cfgset] : XML schema is loaded
11:40:53.171 Std 04503 Connected to DBServer '' at host 'fortran-qepg4es', port 4040
11:40:53.218 Std 04504 Connection to DBServer '' at host 'fortran-qepg4es', port 4040 lost
11:41:03.234 Std 04503 Connected to DBServer '' at host 'fortran-qepg4es', port 4040
11:41:03.281 Std 04504 Connection to DBServer '' at host 'fortran-qepg4es', port 4040 lost
11:41:13.296 Std 04503 Connected to DBServer '' at host 'fortran-qepg4es', port 4040
11:41:13.343 Std 04504 Connection to DBServer '' at host 'fortran-qepg4es', port 4040 lost
.....[/color]



Thanks again for your help.
Joseph

Hi Joseph,

I would suggest you to increase the log level for DBServer and then you should see in the log file what's wrong. Here is the modified config file for DBServer:

[color=Blue][dbserver]
host=fortran-qepg4es
hostname=fortran-qepg4es
port=4040
management-port =4581
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
verbose=3     <--- new parameter - maximum info incl. SQL statements are written to the log
#
#---------- dbserver log options ----------
#
[log]
verbose=debug     <--- increased log level to DEBUG
all=standard, stderr     <--- parameter "all" is used to specify destination (file, logdb etc.) for log storage. Value "standard" is not valid.
[/color]

If you put the new log file here I can check it for you.

René

Hi René,

Thanks for your help. Here's the new dbserver log file after I changed the cfg file as you suggested. The ip "172.16.50.200" belongs to the win2003 server where dbserver and confserver are running. Can you see anything wrong?

Thanks a lot.
Joseph

=============================================================

[color=Blue]Genesys Database Server, Version:'7.2.000.03'
Copyright (c) 1997-2006 Genesys Telecommunications Labs, Inc.
Component versions:
Commonlib:        7.2.000.03
Loglib:          7.1.000.04
Gmessagelib:      7.1.000.00
GServicelib:      7.2.000.03
Mngmlib:          7.1.000.02
Confservlib:      7.2.000.04
Lcalib:          7.1.100.00
Build platform:  i686-winnt
Application name: cfg_dbserver
Application type: RealDBServer (46)
Command line:    D:\Program Files\GCTI\Conf DB Server\multiserver.exe -service DBServer -host fortran-qepg4es -port 2020 -app cfg_dbserver
Host name:        fortran-qepg4es
DST:              TZ = 1, timeb = 1
Time zone:        21600, Central Standard Time, Central Daylight Time
UTC time:        2006-09-15T13:27:20.937
Local time:      2006-09-15T08:27:20.937
Start time (UTC): 2006-09-15T13:27:20
Running time:    0:00:00:00
Host info:        Windows 5.2.3790, 2, Service Pack 1, 1.0, 0110, 3
File:            (1) standard.20060915_082720_922.log

08:27:20.937 Trc 04112 The Log Output of type 'standard' has been created and opened
08:27:20.921 Trc 04110 Option 'buffering' has been set to the value 'yes'
08:27:20.921 Trc 04110 Option 'spool' has been set to the value ''
08:27:20.921 Trc 04110 Option 'keep-startup-file' has been set to the value 'no'
08:27:20.921 Trc 04110 Option 'MessageFile' has been set to the value 'RealDBServer.lms'
08:27:20.921 Trc 04110 Option 'time-format' has been set to the value 'time'
08:27:20.921 Trc 04110 Option 'time-convert' has been set to the value 'local'
08:27:20.921 Trc 04110 Option 'message-format' has been set to the value 'short'
08:27:20.921 Trc 04110 Option 'memory-storage-size' has been set to the value '2 Mb'
08:27:20.921 Trc 04110 Option 'compatible-output-priority' has been set to the value 'no'
08:27:20.921 Trc 04110 Option 'print-attributes' has been set to the value 'no'
08:27:20.921 Trc 04110 Option 'check-point' has been set to the value '1'
08:27:20.921 Std 04106 Log Messages file 'RealDBServer.lms' successfully loaded
08:27:20.921 Trc 04112 The Log Output of type 'stderr' has been created and opened
08:27:20.937 Trc 04112 The Log Output of type 'standard' has been created and opened
08:27:20.937 Trc 04100 Logging service started
08:27:20.937 Trc 06084 Configuration option set: 'dbserver':'port' = '4040'
08:27:20.937 Trc 06084 Configuration option set: 'dbserver':'host' = 'fortran-qepg4es'
08:27:20.937 Trc 06084 Configuration option set: 'dbserver':'management-port' = '4581'
08:27:20.937 Trc 06085 Configuration option set to default value: 'dbserver':'verbose' = '3'
08:27:20.937 Trc 06085 Configuration option set to default value: 'dbserver':'dbprocesses_per_client' = '1'
08:27:20.937 Trc 06085 Configuration option set to default value: 'dbserver':'dbprocess_number' = '255'
08:27:20.937 Trc 06085 Configuration option set to default value: 'dbserver':'dbprocess_name' = './dbclient_msql'
08:27:20.937 Trc 06085 Configuration option set to default value: 'dbserver':'oracle_name' = './dbclient_oracle'
08:27:20.937 Trc 06085 Configuration option set to default value: 'dbserver':'informix_name' = './dbclient_informix'
08:27:20.937 Trc 06085 Configuration option set to default value: 'dbserver':'sybase_name' = './dbclient_sybase'
08:27:20.937 Trc 06085 Configuration option set to default value: 'dbserver':'db2_name' = './dbclient_db2'
08:27:20.937 Trc 06085 Configuration option set to default value: 'dbserver':'msql_name' = './dbclient_msql'
08:27:20.937 Trc 06085 Configuration option set to default value: 'dbserver':'stored_proc_result_table' = '0'
08:27:20.937 Trc 06085 Configuration option set to default value: 'dbserver':'connect_break_time' = '1200'
08:27:20.937 Trc 06085 Configuration option set to default value: 'dbserver':'tran_batch_mode' = '0'
08:27:20.937 Trc 06085 Configuration option set to default value: 'dbserver':'reconnect_timeout' = '3600'
08:27:20.937 Trc 06085 Configuration option set to default value: 'dbserver':'client_stop_timeout' = '30'
08:27:20.937 Trc 06085 Configuration option set to default value: 'lca':'lcaport' = '0'
08:27:20.937 Std 05060 Application started
conn: send-timeout set to 1200
(conn_adjust_rlimit) get_sbh_threshold=1016
08:27:21.859 Std 04525 Port 4040 opened for listening
08:27:27.718 Trc 04521 New client 1078 connected from '172.16.50.200'
08:27:27.718 Dbg 10745 'App: 172.16.50.200:1078' registered; protocol version '1.3' id '1'
08:27:27.718 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 1', request id '0'
(conn_adjust_rlimit) get_sbh_threshold=1016
08:27:27.718 Dbg 10750 Start client request, dbprocesses per client '1'
08:27:27.718 Dbg 10734 Send message 'MSG_CLIENTSTARTED' to 'App: 1', request id '50'
08:27:27.718 Std 05022 Process './dbclient_msql' started
08:27:27.718 Dbg 10741 'App: 1' has put request id='52' into queue
08:27:27.765 Std 05020 Cannot start process './dbclient_msql', error code 128
08:27:27.765 Dbg 10734 Send message 'MSG_CONNLOST' to 'App: 1', request id '52'
08:27:27.765 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'App: 1', request id '-1'
  /./dbclient_msql         
    pid                      = 508
    id                        = 0
    expiration_time          = 2006-09-15T08:27:57
    client copy              = 0
  /Statistics             
    name                      = App: 1
    req_rcvd                  = 4
    req_sent                  = 4
    data_rcvd                = 183
    data_send                = 83
    invalid_params            = 0
    abandoned_req            = 0
    abandon_req_fail          = 0
    error_start_client        = 0
    invalid_register_req      = 0
    msg_error                = 0
    pending_requests          = 0
    pending_queue_size        = 0
    max_pending_requests      = 1
    max_pending_queue_size    = 23
08:27:37.781 Trc 04521 New client 1081 connected from '172.16.50.200'
08:27:37.781 Dbg 10745 'App: 172.16.50.200:1081' registered; protocol version '1.3' id '2'
08:27:37.781 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 2', request id '0'
(conn_adjust_rlimit) get_sbh_threshold=1016
08:27:37.781 Dbg 10750 Start client request, dbprocesses per client '1'
08:27:37.781 Dbg 10734 Send message 'MSG_CLIENTSTARTED' to 'App: 2', request id '54'
08:27:37.781 Std 05022 Process './dbclient_msql' started
08:27:37.781 Dbg 10741 'App: 2' has put request id='56' into queue
08:27:37.859 Std 05020 Cannot start process './dbclient_msql', error code 128
08:27:37.859 Dbg 10734 Send message 'MSG_CONNLOST' to 'App: 2', request id '56'
08:27:37.859 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'App: 2', request id '-1'
  /./dbclient_msql         
    pid                      = 2128
    id                        = 1
    expiration_time          = 2006-09-15T08:28:07
    client copy              = 0
  /Statistics             
    name                      = App: 2
    req_rcvd                  = 4
    req_sent                  = 4
    data_rcvd                = 183
    data_send                = 83
    invalid_params            = 0
    abandoned_req            = 0
    abandon_req_fail          = 0
    error_start_client        = 0
    invalid_register_req      = 0
    msg_error                = 0
    pending_requests          = 0
    pending_queue_size        = 0
    max_pending_requests      = 1
    max_pending_queue_size    = 23[/color]

Typically if you have confirmed no issue with network connectivity / resolution and verified actual database account connectivity, dbclient_msql is either encountering a permission or proper SQL driver issue.

While you tested connectivity via the common ODBC driver from the server, you should install the SQL client driver. This ensures that the Genesys dbclient_sql calles the right driver and the SQL client provides the proper connectivity (including credientials) to the proper port on the SQL server. (Same would apply if this were an Oracle server, install an Oracle client)

If you can connect to the database from the server using the SQL client, your configserver via cfg_dbserver should start properly.

While recommended you use both scripts to initialize the config database, cfg_locale is not always needed and dependant on your location, gloabally. As previously posted, always recommended none the less. It's run second! after you run the init script.

[color=Green]All,

Thanks for you help very much. After I installed the SQL Server client (Just the "connectivity" part), DBserver started working fine, with no error. It surprised me that this is not mentioned in the Genesys documents. So this is something has to be done for all the other databases then.

All your help and information are helpful and highly appreciated!!! I learned a lot from you guys, this forum is very cool.

Have a good day.
Joseph[/color]