Page 1 of 1

Can't connect to DB in server project

Posted: Tue Oct 13, 2009 1:46 am
by CiscoChi
Hi,
I am testing a server project configuration, and have not been able to create a valid database connection through Designer. If I try to execute through the server scheduling tool, then it runs the database dependent components, which is evident from the logging, however, I can't get this to work from Eclipse. The error I'm getting when I try to validate the connection is:
2009-10-12 17:07:53,640 ERROR 950275 [WatchDog] Phase initialization failed with reason: DB_EXECUTE0 ...FAILED !
Reason: org.jetel.exception.JetelException: Cannot establish DB connection (cmsg_dw). caused by: org.jetel.exception.JetelException: Can't connect to DB. caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.

Re: Can't connect to DB in server project

Posted: Tue Oct 13, 2009 8:53 am
by jurban
Hi,
this looks like you're not able to connect from your computer to the DB server. DB validation is currently performed from your client computer (running the Designer). You network can be configured so that the server can connect to the DB (i.e. the graphs will run OK) but your client computer cannot.

Jaro

Re: Can't connect to DB in server project

Posted: Tue Oct 13, 2009 6:15 pm
by CiscoChi
I think this was my fault. The db I was trying to connect to seemed to be down. I restarted it, and I was able to connect.

Thanks.