Genesys 7.5 - Virtual Environment

[Santi]

Hi,

I'm trying to setup a virtual environment (over VMWARE) Genesys 7.5. I'm trying to set up DBServer over SQL Server 2005 and always I got the same errors (network connection).

My environment is:

- Windows Server 2003 SP2 EE

- SQL Server 2005 EE SP2

- Genesys DB Server, Config Server and Config Manager all in the same virtual machine.

I don't if there is any requeriment to set up SQL Server 2005.

Please any help.

Thanks in advance.

Regards.

Santi

[René]

Hi Santi,

MS SQL Server 2005 doesn't enable TCP/IP connection after installation by default. Please open "SQL Server Configuration Manager" and enable TCP/IP protocol (restart of SQL Server is needed). Genesys DBServer should be able to open a connection after that.

Please post debug log of DBServer here if it won't work even after the change.

René

PS. I've already answered your question/post on Better Interactions Forum

[Santi]

Thanks Rene.

I have seen your answer in the other forum, thank for it.

But I'm still getting the same error after enabled TCP/IP port.

I'm trying to install the DBServer and  Config Server again. And after that I will post debug log of DBServer.

Jus one question, How do I setup SQL server databases with sql authentification or Windows authentication security?

Thanks in advance.
Santi

[René]

Ok. In that case the problem is elsewhere...

You have to use SQL authentication.

Post here debug log of Configuration Server as well. Thanks.

R.

[Santi]

Hi Rene,

Here you have de log of db_server, thaks again

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
Application type: RealDBServer (46)
Command line:    multiserver.exe -host genesyssrv -port 2020 -app cfg_dbserver
Host name:        GENESYSSRV
DST:              TZ = 1, timeb = 1
Time zone:        -3600, Romance Standard Time, Romance Daylight Time
UTC time:        2008-04-18T11:21:58.416
Local time:      2008-04-18T13:21:58.416
Start time (UTC): 2008-04-18T11:21:58
Running time:    0:00:00:00
Host info:        Windows 5.2.3790, 2, Service Pack 2, 2.0, 0112, 3
File:c:\Logs.20080418_132158_416.log
13:21:58.369 Std 04106 Log Messages file 'RealDBServer.lms' successfully loaded
13:21:59.353 Std 10300 Unable to create Management Port
13:21:59.353 Std 05060 Application started
13:21:59.369 Std 04526 Cannot open port 4040 for listening, reason 'port has been already opened'
13:21:59.478 Std 01000 DbServer Exiting

[René]

Hi Santi,

The problem is clear now...

[b]13:21:59.369 Std 04526 Cannot open port 4040 for listening, reason 'port has been already opened'[/b]

Check what application is using port 4040 and change it or change port used by DBServer.

You can use tools like CurrPort (http://www.nirsoft.net/utils/cports.html) or TCPView (http://technet.microsoft.com/en-us/sysinternals/bb897437.aspx) to find out an application using port 4040.

Hope it helps you
R.

[Santi]

Thanks René I changed it.

After I started cfg_DBSERVER and genesys configuration server, I'm getting this error when i try to start Configuation Manager:

SCEE021 - A communication error has ocurred upon sendig a request to Configuration Server. Chech the network connection and try the transaction again.

I'm trying to connect with:
user: default
pss: password
app: default
host: genesyssrv
port: 2020 (I tried various 2021, 4040, ...)

Thanks again.

[cavagnaro]

Is confserv up? What happens if you do a telnet to port 2020?

[René]

Santi,

The most probable reason for your issue is that Configuration Server (CS) has not initialized properly so it doesn't accept any connection. Please post log of Configuration Server here and let me check it.

Note - the fact that Configuration Server Windows service is started doesn't mean that CS is up and running

R.

[Santi]

Hi Rene,

Here is the config server log:

Build information :
  Description : (Content freeze)
  Timestamp  : Feb  9 2007 15:41:40
  Components  :
    Configuration library  v.7.5.000.13
    Common library          v.7.5.000.26 C2
    Service library        v.7.5.000.04 MT
    Message library        v.7.5.000.01
    Log library            v.7.5.000.04 MT
    LCA library            v.7.5.000.05
    Thread library          v.7.5.000.01
    DBServer library        v.7.5.000.02
    Genesys License library v.7.5.000.00 MT
    License library        v.FLEXLm 8.3c
    Stat Script library    v.7.5.000.00

Application name: confserv
Application type: ConfigurationServer (21)
Command line:   
Host name:        GENESYSSRV
DST:              TZ = 1, timeb = 1
Time zone:        -3600, Romance Standard Time, Romance Daylight Time
UTC time:        2008-04-18T12:06:54.681
Local time:      2008-04-18T14:06:54.681
Start time (UTC): 2008-04-18T12:06:54
Running time:    0:00:00:00
Host info:        Windows 5.2.3790, 2, Service Pack 2, 2.0, 0112, 3
File:            (1) c:\Logs\.20080418_140654_682.log

14:06:54.681 Std 22110 Encoding [utf-8] is set successfully.
14:06:54.681 Std 05060 Application started
14:06:54.681 Std 22100 Genesys Configuration Server. Version 7.5.000.11
14:06:54.681 Std 22101 Copyright (c) 1997-2007 Genesys Telecommunications Laboratories, Inc.
14:06:54.697 Std 22102 Server application name is set to [confserv]
14:06:54.697 Std 22915 Server mode is set to [PRIMARY]
14:06:54.697 Std 22900 Objectset [main-cfgset] is being loaded ...
14:06:54.978 Std 22901 Objectset [main-cfgset] : XML schema is loaded
14:06:55.103 Std 04503 Connected to DBServer '' at host 'genesyssrv', port 2020
14:06:55.275 Std 07001 Database 'genesysbbdd' opened
14:06:55.291 Std 22913 Configuration database version is [7.5]
14:06:55.291 Std 22918 Configuration tenancy model is: [SINGLE-TENANT]
14:06:55.369 Std 22910 Database schema [dbschema.xml] is loaded
14:06:55.385 Std 22912 No backup server found in the configuration
14:06:55.385 Std 22902 Objectset [main-cfgset] : read requests sent on DBServer
14:06:55.572 Std 22903 Objectset [main-cfgset] : data is loaded. Now initializing ...
14:07:15.525 Std 22904 Objectset [main-cfgset] is fully loaded
14:07:15.541 Std 22115 History of Changes Adapter (HCA) is activated. Mode is [INACTIVE].
14:07:15.541 Std 22108 Transaction manager is activated
14:07:15.806 Std 04106 Log Messages file 'confserv.lms' successfully loaded
14:07:15.822 Std 04106 Log Messages file 'confserv.lms' successfully loaded
14:07:15.822 Std 22100 Genesys Configuration Server. Version 7.5.000.11
14:07:15.822 Std 22101 Copyright (c) 1997-2007 Genesys Telecommunications Laboratories, Inc.
14:07:15.822 Std 22505 Connection to LCA cannot be established. No data.
14:07:15.822 Std 04526 Cannot open port 2020 for listening, reason 'Unknown'
14:07:15.822 Std 04525 Port 0 opened for listening
14:07:15.822 Std 22800 Extended info : Port [0], protocol [CFGSOAP], mode [REGULAR] opened for listening
14:07:15.822 Std 22915 Server mode is set to [PRIMARY]
14:07:15.822 Std 04562 Warm Standby (Primary) mode activated
14:07:15.822 Std 04526 Cannot open port 2021 for listening, reason 'SNMP port can not be opened.'
14:07:15.822 Std 22128 Authentication type is [internal]
14:07:15.822 Std 22109 Configuration Server is initialized
09:21:01.568 Std 04504 Connection to DBServer '' at host 'genesyssrv', port 2020 lost
09:21:01.568 Std 22915 Server mode is set to [PRIMARY READ-ONLY]
09:21:11.568 Std 04503 Connected to DBServer '' at host 'genesyssrv', port 2020
09:21:12.021 Std 07001 Database 'genesysbbdd' opened
09:21:32.068 Std 22915 Server mode is set to [PRIMARY]

I see that can't open port 2020 and 2021 and I don't know why.

Thanks again.

[cavagnaro]

Is this server new? nothing else installed? do you have some antivirus installed?
I believe you have some other application configured to use port 2020...can you post your confserv and dbserver configuration?

[René]

Santi,

It's quite strange that the ports 2020 and 4040 are used by different application on newly installed system. Never seen that before... Please find out what application uses these ports using the tools I've mentioned before and change configuration of that application or Genesys.

René

[Santi]

Hi cavagnaro,

There is the confserv and dbserver:

[dbserver]
host=genesyssrv
port=2020
management-port =2021
dbprocesses_per_client=1
dbprocess_name=dbclient_sql
#
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 = c:\Logs
buffering = true


[lca]
lcaport=4999

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

[confserv]
port =2020
management-port =2021
server = dbserver
history-log-expiration = 30
history-log-client-expiration = 1
history-log-max-records = 1000
history-log-file-name =histlog
encryption = false
encoding = utf-8

[log]
verbose = standard
all = c:\Logs\
buffering = true


[hca]
schema = none

[soap]
port = [ToBeChanged: soap_port]

[dbserver]
host =genesyssrv
port =2020
dbengine =mssql
dbserver =genesyssrv
dbname =genesysbbdd
username =genesys
password =xxxxxx
server =
reconnect-timeout = 10
response-timeout = 600


This is a new installed in a VWARE environment, Telnet respond to 2020.

Thanks.

[Santi]

Hi Rene,

I used the CurrPort and this is the export:

confserv.exe 3560 TCP 1314  192.168.49.129 2020  192.168.49.129 GENESYSSRV.localdomain Established
confserv.exe 3560 TCP 1318  192.168.49.129 2020  192.168.49.129 GENESYSSRV.localdomain Established
confserv.exe 3560 TCP 1328  0.0.0.0    0.0.0.0  Listening confserv.exe 3560 UDP 1313  0.0.0.0          dbclient_msql.exe 3576 TCP 1317  192.168.49.129 1315  192.168.49.129 GENESYSSRV.localdomain Established
dbclient_msql.exe 3592 TCP 1321  192.168.49.129 1319  192.168.49.129 GENESYSSRV.localdomain Established
dbclient_msql.exe 3592 UDP 1320  0.0.0.0          C:\Program Files\GCTI\DB Server\dbclient_msql.exe Genesys 
dbclient_msql.exe 3576 UDP 1316  0.0.0.0          C:\Program Files\GCTI\DB Server\dbclient_msql.exe Genesys lsass.exe 468 TCP 1032  0.0.0.0    0.0.0.0  Listening C:\WINDOWS\system32\lsass.exe Microsoft® Windows®
lsass.exe 468 UDP 500 isakmp 0.0.0.0          C:\WINDOWS\system32\lsass.exe Microsoft® Windows® Operating lsass.exe 468 UDP 4500 ipsec-msft 0.0.0.0          C:\WINDOWS\system32\lsass.exe Microsoft® Windows® multiserver.exe 3500 TCP 1319  192.168.49.129 1321  192.168.49.129 GENESYSSRV.localdomain Established
multiserver.exe 3500 TCP 1315  192.168.49.129 1317  192.168.49.129 GENESYSSRV.localdomain Established
multiserver.exe 3500 TCP 2020  192.168.49.129 1314  192.168.49.129 GENESYSSRV.localdomain Established
multiserver.exe 3500 TCP 2020  192.168.49.129 1318  192.168.49.129 GENESYSSRV.localdomain Established
multiserver.exe 3500 TCP 2021  0.0.0.0    0.0.0.0  Listening C:\Program Files\GCTI\DB Server\multiserver.exe multiserver.exe 3500 TCP 2020  0.0.0.0    0.0.0.0  Listening C:\Program Files\GCTI\DB Server\multiserver.exe multiserver.exe 3500 TCP 1319  0.0.0.0    0.0.0.0  Listening C:\Program Files\GCTI\DB Server\multiserver.exe multiserver.exe 3500 TCP 1315  0.0.0.0    0.0.0.0  Listening C:\Program Files\GCTI\DB Server\multiserver.exe multiserver.exe 3500 UDP 1301  0.0.0.0          C:\Program Files\GCTI\DB Server\multiserver.exe Genesys DB 
sqlbrowser.exe 1400 UDP 1434 ms-sql-m 0.0.0.0          C:\Program Files\Microsoft SQL Server\90
sqlservr.exe 1292 TCP 1433 ms-sql-s 0.0.0.0    0.0.0.0  Listening C:\Program Files\Microsoft SQL Server\MSSQL.1
sqlservr.exe 1292 TCP 1434 ms-sql-m 127.0.0.1    0.0.0.0  Listening

Thanks again

[René]

Santi,

Your configuration is wrong. You're using the same port 2020 for DBserver and ConfigServer and that won't work

See correct configuration files below...

R.

--- dbserver.cfg
[dbserver]
host=genesyssrv
[b]port=4040[/b]
[b]management-port =4041[/b]
dbprocesses_per_client=1
dbprocess_name=dbclient_sql
#
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 = c:\Logs
buffering = true
#
[lca]
lcaport=4999

--- confserv.cfg
[confserv]
port =2020
management-port =2021
server = dbserver
history-log-expiration = 30
history-log-client-expiration = 1
history-log-max-records = 1000
history-log-file-name =histlog
encryption = false
encoding = utf-8

[log]
verbose = standard
all = c:\Logs\
buffering = true

[hca]
schema = none

[soap]
#port = [ToBeChanged: soap_port]

[dbserver]
host =genesyssrv
[b]port =4040[/b]
dbengine =mssql
dbserver =genesyssrv
dbname =genesysbbdd
username =genesys
password =xxxxxx
server =
reconnect-timeout = 10
response-timeout = 600