Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: genesysnoob on July 19, 2013, 01:44:55 PM

Title: Cannot connect to DB server!
Post by: genesysnoob on July 19, 2013, 01:44:55 PM
URS is unable to connect to dbserver - where as this db server is connected to a customer database.
URS is on a different host and db server is on the same host as database is resided.

I can ping dbserver host from urs host


the following error message is displayed in the URS logs
Cannot connect to DBServer 'dbserver' at host 'xxxx', port xxxx reason 'unknown'
[01:16] server dbserver is being closed, socket 19
Title: Re: Cannot connect to DB server!
Post by: Fra on July 19, 2013, 02:42:32 PM
Telnet the DB Server port from the URS host. If it fails, then means it's a network issue (such as firewalls).

Fra
Title: Re: Cannot connect to DB server!
Post by: genesysnoob on July 19, 2013, 03:06:55 PM
Thanks for the respo nse
I got a connection refused resposne
Title: Re: Cannot connect to DB server!
Post by: genesysnoob on July 19, 2013, 05:16:40 PM
after the telnet issue fix, the problem still exists
Title: Re: Cannot connect to DB server!
Post by: cavagnaro on July 19, 2013, 06:55:17 PM
Logs sir.
What DB
Your credentials ok?
DBCLient libraries installed?
Can you connect with Windows ODBC?

Magic Crystal balls are out of service
Title: Re: Cannot connect to DB server!
Post by: genesysnoob on July 19, 2013, 07:18:00 PM
Thanks for the Input sir
database is mysql
credential are ok
both urs and its db server are on linux host
the only error/warning message that i am seeing is the one i mentioned above
DBclientlibraries? I am not aware of them
Title: Re: Cannot connect to DB server!
Post by: cavagnaro on July 19, 2013, 08:41:15 PM
Seriously...I just can't find an answer correct for this...
How you ended up installing a Genesys?
MySQL is not supported as DB...only for Genesys Customer Interaction Portal I think...
Read the basic documentation at least please. Will save you many lost of time.
Title: Re: Cannot connect to DB server!
Post by: genesysnoob on July 19, 2013, 08:59:18 PM
Using Wizard i installed the suite, multimedia
mssql is the type
the problem is connection to the dbserver, not the db
i will read more documentation as you said
thank you
Title: Re: Cannot connect to DB server!
Post by: cavagnaro on July 19, 2013, 09:44:35 PM
MSSQL (MicrosoftSQL) is not the same as MySQL
Title: Re: Cannot connect to DB server!
Post by: genesysnoob on July 20, 2013, 07:29:05 PM
Boss,  I came across this thread. at the end of the thread the member was talking about the client that needs to be i nstalled on the host
I will sugges this to the admin guy, lets see what happens

http://www.sggu.com/smf/index.php?topic=1827.0