Message server to logdb connectivity issue [cannot resolve name 'Host']

[Vikas]

Hi All,

We have a problem connecting message server to logDB server.

> The log DB server is started and listening on the port 5050.
> DAP is configured to communicate with log DB server on same port 5050, as referenced in the doc.
> Message server is configured to use the DAP above
> we can connect to the log database using the SQL* plus with the credentials as per the logs below.
> All genesys component including database is running on same server.

When we start the message server we get the following message and no client request is seen in the logdbserver log/screen

[color=red][GCSDBServer.cpp:126] [CGCSDBServer::connect]  DOpenServerX: login="logdb", password="************", dbname="",server="ctidb"
addp-trace both
(addp_xconfig) local OFF, remote OFF, trace both
error: ConnNS.cpp:193 cannot resolve name 'Host'
[/color]

-------------- message server log snapshot ------------------
[GServerManager.cpp:298] m_DBRangeSize = -1
[GServerManager.cpp:302] m_DBPercentageIncrementValue = -1
[GServerManager.cpp:304] Accept values: m_DBRangeSize = 2500 m_DBPercentageIncrementValue = 10
[GServerManager.cpp:311] Found DBServer: "logdap"
[GApplication.cpp:1453] DB server user properties
[GApplication.cpp:1250] Option 'db-request-timeout'='0'
[GApplication.cpp:1250] Option 'dbcase'='lower'
[GApplication.cpp:1250] Option 'dbengine'='oracle'
[GApplication.cpp:1250] Option 'dbname'=''
[GApplication.cpp:1250] Option 'dbserver'='ctidb'
[GApplication.cpp:1246] Option 'password'='*******'
[GApplication.cpp:1250] Option 'username'='logdb'
[GLMDBStorage.cpp:164] m_RangeSize = 2500 m_PercentageIncrementValue = 10
[GServerManager.cpp:354] Message Server Options:
request_queue_size=300
db_storage=1
[GServerManager.cpp:356] log-queue-size=0
log-queue-exp-time=0
log-queue-response=0
03:12:41.812 Std 05061 Initialization completed
[GServerManager.cpp:364] Starting Message Server: compiled May 28 2010 09:01:00
[GServerManager.cpp:365] Instantiating subsystems:
[GServerManager.cpp:389] Creating distributor [CGMCMessageDistributor]
[GServerManager.cpp:398] Creating dispatcher [MC_MSG_DISPATCHER]
[GServerManager.cpp:407] Creating NetListener [MC_NET_LISTENER]
[GServerManager.cpp:416] Creating subscription manager [MC_MSG_SUBSCRIPTION_MNGR]
[GServerManager.cpp:424] Creating filter manager [MC_MSG_FILTER_MNGR]
[GServerManager.cpp:436] Starting subsystems:
[GServerManager.cpp:438] Starting distributor ...
[GServerManager.cpp:445] Starting dispatcher ...
[GServerManager.cpp:452] Starting NetListener ...
[GServerManager.cpp:459] Startup complete
03:12:41.812 Std 05060 Application started
[CFGLIB]: Processing mode set to ASYNC
[GServerManager.cpp:476] Entering conn_main_loop
addp-trace off
(addp_xconfig) local OFF, remote OFF, trace off
[GMCNetListener.cpp:326] MC_NET_LISTENER: Listening port 5000 has been opened with handle 552
[GMCNetListener.cpp:798] MC_NET_LISTENER: NetListener thread for monitoring successfully registered for monitoring
03:12:41.828 Trc 04500 Connecting to DB Server 'logdbserver' at host 'Host', port 5050
[GCSDBServer.cpp:104] [CGCSDBServer::connect] ASYNC mode
[GCSDBServer.cpp:126] [CGCSDBServer::connect]  DOpenServerX: login="logdb", password="************", dbname="",server="ctidb"
addp-trace both
(addp_xconfig) local OFF, remote OFF, trace both
error: ConnNS.cpp:193 cannot resolve name 'Host'
03:12:44.078 Std 04502 Cannot connect to DB Server 'logdbserver' at host 'Host', port 5050, reason 'DOpenServerX failed'
03:12:44.078 Std 04504 Connection to DB Server 'logdbserver' at host 'Host', port 5050 lost
03:12:44.078 Std 04505 Disconnected from DB Server 'logdbserver'
[GCSDBStorage.cpp:299] [CGCSDBStorage] Connection with DBCluster lost. Reconnect in 1000 ms
03:12:44.078 Std 11051 Connection with DB Cluster lost
03:12:45.078 Trc 04500 Connecting to DB Server 'logdbserver' at host 'Host', port 5050

Thanks,
-Vikas

[bandorka]

Hi.

What are the results the commands below?:

ping ctidb
telnet ctidb 5050

BR,
Bandorka

[Vikas]

ctidb is the listener name as defined in the tnsnames.ora and not the actual host.

the log db server and the oracle database are installed on the same host and we are able to ping the host. and telnet give blank screen when we open start the logdb server and do the telnet to the port 5050

Thanks,
-Vikas

[cmcshane]

Have you checked the hostname in the Host section of the Server Info tab of dbserver to ensure it's correct ?

[Steve]

If ctidb is the tnsnames alias can you tnsping it?

However as you have now got your cfg_dbserver working and this is connecting to the same instance, assuming this is all on the same server, it is unlikely to be an Oracle issue.
Make sure that your log dbserver is configured exactly the same as the cfg_dbserver. Check that your DAP has the correct values to connect to your database.

You could try pointing your DAP to the cfg_dbserver, to try to help decide where the problem is.

The fact that it is looking for "Host", make me think that your DAP is not configured properly. But remember that "Host" and "Port" in Genesys usually refer to the Config Server host and port.

[Vikas]

[RESOLVED]

Thanks guys, that was a silly mistake. The hostname was incorrect and I fixed it after creating correct host and deleting the incorrect one.

Cheers,
-Vikas