Please help: Zuckerreports error - Connection timed out

[Antanas0001]

When I click "Generate report" in Zuckerreports 1.7 on SugarCRM 4.5 I get a timed out error:

JasperBatchMain :: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection timed out

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection timed out
at com.mysql.jdbc.StandardSocketFactory.connect(Stand ardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:284)


Can anybody tell me how to make this work?

[dpatech]

It sounds like you are getting a standard timeout exception while running the query against the MySQL database. Do you get this error immediately or after a few minutes have passed?

I believe you can adjust the wait_timeout in /etc/my.cnf file for the entire server. You may also be able to adjust the timeout in the JDBC configuration for Zucker/MySQL/JDBC.

[Antanas0001]

This timeout is 5 minutes long, only then error shows up. Also the server gets halted during this period, so I am worried that there is something else going on, but can not figure out from the obscure error message. Do you have any ideas where to look for the error?

[Antanas0001]

When I try to generate reports - for around 5 minutes the whole server gets unresponsive and then I get a timed out error. What might be the cause of this problem?

JasperBatchMain :: Communications link failure due to underlying exception:
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection timed out