JDBC MySQL data connection failing after successful install 4.0.0

[dolm]

My data connection (the same ones used to build and populate the sample data and tables) is failing within Jasper server. I have a teradata jdbc connection that is working fine. The jasperreports server is located on the same machine as the mysql server. I set the script to use the ip address and default port 3306, which worked fine. I've tried editing the connection to use the ip insteadl of localhost and it still fails.

 The sample connection/db is configured as

Driver: com.mysql.jdbc.Driver

URL: jdbc:mysql://localhost:3306/sugarcrm?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&autoReconnectForPools=true

Is there somewhere to view logs to see whats failing, anyone have any idea what to look at?

Post Edited by dolm at 05/20/2011 13:41

[dolm]

I have installed jasper server on a completely different server and as before, the install is successful, yet the sample jdbc datasource is failing to connect.

 

Does anyone have any idea what might be going on?

[dolm]

Anyone at all? Any ideas what to look at?

[ernestoo]

 Why don't you use something like wireshark to sniff packets on port 3306 to see if anything is being sent?

Also, what do you see in WEB-INF/logs/jasperserver.log? 

[dolm]

Ernestoo,

 

I enabled loggingto check as you suggested and nothing is populating in the log file. I'm not sure I'd be able to watch pakets because this db is used for other things and has a constant flux of some 200 users generating traffic on it.