Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Gaia on April 21, 2022, 10:38:13 AM
-
Hi all,
I hope this issue isn't out of scope ???
I am facing a problem connecting to Icon DB
log DB server
"
+0000 Could not connect to SQL Server using SQL Server Native Client 11.0. Attemting default MS SQL Server driver...
+0000 odbcerr: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
+0000 MSG_ERROR status='dbNotOpened' msg='[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified '
"
Log ICON
" Std 04502 Cannot connect to CFG 'DBServer_icon' at host 'S00STE024', port 1436, reason 'DB server is disconnected from the database'"
the interaction concentrator version is 8.1.514.56 on Windows Server 2019 and DB MS SQL Server 2016
I tried with ODBC Driver 11 for SQL Server and ODBC Driver 13 for SQL , the error message is the same on DBServer
I tested the connexion with ODBC Data Source Administator and the connexion was succesful with both version of drivers
What did i miss ?
Br
-
Try to connect from Windows ODBC settings, it is good to discard connectivity/configuration issues
-
Hi,
It's working from Windows ODBC settings , I created DSN and tested the connexion
Br,
-
Can you post DAP and full DBServer log?
-
hi,
this is dbserver log
Genesys Database Server, Version:'8.5.100.12'
Copyright (c) 1997-2021 Genesys Telecommunications Labs, Inc.
Component versions:
Commonlib: 8.5.100.87 C2
Loglib: 8.5.100.56
Gmessagelib: 8.5.100.25
GServicelib: 8.5.100.42
Mngmlib: 8.5.100.10
Confservlib: 8.5.100.45
Lcalib: 8.5.100.38
Build platform: i686-winnt-vs12-64
Application name: DBServer_icon
Application type: RealDBServer (46)
Command line: multiserver.exe -service DBServer64 -app DBServer_icon -host S00STE001 -port 2020 -sstart
Host name: MYHOST
DST: TZ = 1, timeb = 1
Time zone: -3600, Romance Standard Time, Romance Daylight Time
UTC time: 2022-04-22T09:08:28.662
Local time: 2022-04-22T11:08:28.662
Start time (UTC): 2022-04-22T09:08:28
Running time: 0:00:00:00
Host info: Windows Server 2019 Standard (17763.rs5_release.180914-1434.2803)
File: (1) C:\GCTI\Logs\DBServer_icon\DBServer_icon.20220422_110828_663.log
11:08:28.662 Trc 04112 The Log Output of type 'C:\GCTI\Logs\DBServer_icon\DBServer_icon' has been created and opened
11:08:28.662 Trc 04110 Option 'verbose' has been set to the value 'all'
11:08:28.662 Trc 04110 Option 'buffering' has been set to the value 'yes'
11:08:28.662 Trc 04110 Option 'expire' has been set to the value '5 file'
11:08:28.662 Trc 04110 Option 'segment' has been set to the value '2000'
11:08:28.662 Trc 04110 Option 'spool' has been set to the value ''
11:08:28.662 Trc 04110 Option 'snapshot' has been set to the value ''
11:08:28.662 Trc 04110 Option 'recovery-timeout' has been set to the value '30'
11:08:28.662 Trc 04110 Option 'keep-startup-file' has been set to the value 'no'
11:08:28.662 Trc 04110 Option 'MessageFile' has been set to the value 'RealDBServer.lms'
11:08:28.662 Trc 04110 Option 'time-format' has been set to the value 'time'
11:08:28.662 Trc 04110 Option 'time-convert' has been set to the value 'local'
11:08:28.662 Trc 04110 Option 'message-format' has been set to the value 'short'
11:08:28.662 Trc 04110 Option 'memory-storage-size' has been set to the value '2 Mb'
11:08:28.662 Trc 04110 Option 'compatible-output-priority' has been set to the value 'no'
11:08:28.662 Trc 04110 Option 'print-attributes' has been set to the value 'no'
11:08:28.662 Trc 04110 Option 'check-point' has been set to the value '1'
11:08:28.662 Trc 04110 Option 'memory' has been set to the value ''
11:08:28.662 Trc 04113 The Log Output of type 'stderr' has been closed and deleted
11:08:28.662 Trc 04112 The Log Output of type 'C:\GCTI\Logs\DBServer_icon\DBServer_icon' has been created and opened
11:08:28.662 Trc 06084 Configuration option set: 'dbserver':'management-port' = '4041'
11:08:28.662 Trc 06085 Configuration option set to default value: 'dbserver':'dbprocesses_per_client' = '1'
11:08:28.662 Trc 06084 Configuration option set: 'dbserver':'dbprocess_name' = './dbclient_sybase'
11:08:28.662 Trc 06085 Configuration option set to default value: 'dbserver':'oracle_name' = './dbclient_oracle'
11:08:28.662 Trc 06085 Configuration option set to default value: 'dbserver':'informix_name' = './dbclient_informix'
11:08:28.662 Trc 06085 Configuration option set to default value: 'dbserver':'msql_name' = './dbclient_msql'
11:08:28.662 Trc 06085 Configuration option set to default value: 'dbserver':'sybase_name' = './dbclient_sybase'
11:08:28.662 Trc 06085 Configuration option set to default value: 'dbserver':'postgre_name' = './dbclient_postgre'
11:08:28.662 Trc 06085 Configuration option set to default value: 'dbserver':'connect_break_time' = '1200'
11:08:28.662 Trc 06085 Configuration option set to default value: 'dbserver':'tran_batch_mode' = '0'
11:08:28.662 Trc 06085 Configuration option set to default value: 'dbserver':'db2_name' = './dbclient_db2'
Open LCALayer on port=4999
LCA Library version 8.5.100.38
11:08:28.662 Std 05060 Application started
Opening listeners...
Port id 'default':
Open server port: = (
"protocol" = "addp"
"addp-timeout" = "0"
"addp-remote-timeout" = "0"
"addp-trace" = "off"
"name" = "DBServer_icon"
"server-type" = "46"
"backlog" = "5"
"port" = "1436"
)
11:08:29.687 Std 04525 Port 1436 opened for listening
Updating primary/backup config server info 99 0
Primary config server (dbid)(host)(port): (99)(S00STE001)(2020)
Error while retrieving backup config server info.
************************************
LCALayer: REventRegistered on LCA...
************************************
LCALayer: The local host is under control of Management Layer. SCS 'SCS' has connected to the LCA from the host '' on the socket 888.
GServer: new_client: fd=600, found server=596
11:08:43.151 Trc 04521 New client 54141 connected from '192.168.103.99'
11:08:43.167 Dbg 10745 'App: 192.168.103.99:54141' registered; protocol version '1.4' id '1'
11:08:43.167 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App: 1', request id '0'
11:08:43.167 Dbg 10750 Start client request, dbprocesses per client '1'
11:08:43.167 Dbg 10734 Send message 'MSG_CLIENTSTARTED' to 'App: 1', request id '2'
11:08:43.214 Std 05022 Process './dbclient_msql' started
GServer: new_client: fd=624, found server=608
11:08:43.245 Trc 04521 New client 54143 connected from '127.0.0.1'
11:08:43.245 Dbg 10745 './dbclient_msql' registered; protocol version '1.4' id '1.1'
11:08:43.245 Dbg 10734 Send message 'MSG_OPENDB' to 'MS SQL: 1.1', request id '3'
11:08:43.245 Dbg 10734 Send message 'MSG_EXTPACKETS' to 'App (ICON_CFG,MYHOST,4030)', request id '0'
11:08:43.245 Dbg 10734 Send message 'MSG_EXTPACKET' to 'MS SQL: 1.1', request id '0'
11:08:43.245 Dbg 10743 'MS SQL: 1.1' is spare
11:08:43.573 Dbg 10739 ODBC: id='1.1' req='-1'
DBClient ODBC, Copyright (c) 1997-2021 Genesys Telecommunications Labs, Inc.
All Rights Reserved
Db Client version: 8.5.101.44
DB Common part version: 8.5.101.44
Vendor supported versions: "ODBC"
Process ID: 2996
Build on 'i686-winnt-vs12-64'
+0015 Connection to multiserver created, host 'localhost', port '54142', socket '248'
+0015 MSG_STARTDB status='DBM_SUCCESS'
ODBC: id='1.1' req='3' Protocols versions: dbclient='00010004' dbserver='00010004' dblib='00010004'
+0000 Database Access Point in TKVList:
+0000 section "default":
+0000 "dbengine" = "mssql"
+0000 "dbserver" = "DBHOST\SQL014"
+0000 "dbname" = "IDBCFG"
+0000 "username" = "genesys"
+0000 "password" = "***"
+0000 "dbcase" = "any"
+0000 "db-request-timeout" = "10"
+0000 section "dbclient":
+0000 "utf8-ucs2" = "true"
+0000 "max-binding-memory" = 250
+0000 0000023F52989640,hDBC=1388669328,1388669328
+0000 Open DB: username = 'genesys', database = 'IDBCFG', dbserver = 'DBHOST\SQL014'
+0235 Could not connect to SQL Server using SQL Server Native Client 11.0. Attemting default MS SQL Server driver...
+0328 odbcerr: [Microsoft][ODBC SQL Server Driver]Dialog failed
+0328 MSG_ERROR status='dbNotOpened' msg='[Microsoft][ODBC SQL Server Driver]Dialog failed '
11:08:43.573 Dbg 10749 Forwarding response '3.1' from 'MS SQL: 1.1' to 'App (ICON_CFG,MYHOST,4030)'
11:08:43.573 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'App (ICON_CFG,MYHOST,4030)', request id '-1'
11:08:43.573 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'MS SQL: 1.1', request id '-1'
/Statistics
name = MS SQL: 1.1
app_name = App (ICON_CFG,MYHOST,4030)
req_rcvd = 5
req_sent = 3
data_rcvd = 1620
data_sent = 386
msg_error = 1
msg_log = 1
Client MS SQL: 1.1 is being closed. Current numofclients=0
Listener (port id = internal-0-0 fd = 608) is being closed. Checking for clients on listener...
Listener with port id = internal-0-0 has been closed and deleted from list of current ports. Number of db app connections affected: 0
Client App (ICON_CFG,MYHOST,4030) is being closed. Current numofclients=1
br,
-
It seems your MS ODBC Driver configuration is not valid - try to check connectivity via ODBC apart Genesys apps
-
Hi Kubig
Thank you for the rely
I tested with ODBC Data Administrator and the connexion was suucesful.
I don't understand this ==> Could not connect to SQL Server using SQL Server Native Client 11.0. Attemting default MS SQL Server driver...
In my System DNS i specified ODBC driver 17 for SQL Server
Br,
-
Looks like you are using a SQL server instance: dbserver = 'DBHOST\SQL014
Try to modify your DAP, and add ',<portnbr> in the end of option DBMS Name
In you case dbserver = 'DBHOST\SQL014,1433
Or the port you actually are using!
-
:(
+0000 Open DB: username = 'genesys', database = 'DBCFG', dbserver = 'DBHOST\SQL014,1436'
+0062 [b]Could not connect to SQL Server using SQL Server Native Client 11.0. Attemting default MS SQL Server driver...[/b]
+0078 odbcerr: [Microsoft][ODBC SQL Server Driver]Dialog failed
+0078 MSG_ERROR status='dbNotOpened' msg='[Microsoft][ODBC SQL Server Driver]Dialog failed '
-
Is the firewall OK for that port?
Post please you DAP conf
-
I tested 3 configuration
DBHOST\SQL014,1436
DBHOST\SQL014
DBHOST,1436
We have 2 db on server DBHOST one on 1433 , 1436
-
I think that the problem is that I am using the database password and not the password of the schema DBCFG.
I will test this later when our DBA send the password ::) ::)
-
Also check the bit version of running apps and installed/configured ODBC
-
[quote author=Gaia link=topic=12282.msg54793#msg54793 date=1650637793]
I tested 3 configuration
DBHOST\SQL014,1436
DBHOST\SQL014
DBHOST,1436
We have 2 db on server DBHOST one on 1433 , 1436
[/quote]
and on which one is your ICON DB created?
As per your password comment...you already tested ODBC so wouldn't make sense that you are using a new user/password
That is why I am asking your DAP conf, please help us help you by providing info as requested ;)
-
It's working with this configuration
DBMS = DBHOST\SQL014
My DBA send me the right passeword
My test was successful because there was 2 db on the same serveur. and the login was the same.
When I tested connectivity with ODBC data source administrator, I idid'nt change the option "change the default database".