Ireport problem

[Mnf]

Hi all, i have a problem trying to load and run report within Zucker report
I have installed Sugar crm version 5.0.0.e on windows 2003 R2 server, Apache/2.2.6 (Win32) PHP/5.2.4
after that i've installed zucker report 1.8 and want to use it with Ireport 2.05

I've installed Ireport on my workstation, created a data source and a simple test report from a sugar crm tables, then following Zucker report manual have installed ireport jar files in the Zucker folder, created a new zucker report from jrxml file and all seems to be ok but when i try to run report i have this output:

Output

Error while running Report
cmdline: javaw -classpath "modules/ZuckerReports/resources/;modules/ZuckerReports/resources/casi.jasper_files/;modules/ZuckerReports/jasper/antlr-2.7.5.jar;modules/ZuckerReports/jasper/batik-anim.jar
;modules/ZuckerReports/jasper/batik-awt-util.jar;modules/ZuckerReports/jasper/batik-bridge.jar;modules/ZuckerReports/jasper/batik-css.jar;modules/ZuckerReports/jasper/batik-dom.jar;
modules/ZuckerReports/jasper/batik-ext.jar;modules/ZuckerReports/jasper/batik-gvt.jar;modules/ZuckerReports/jasper/batik-parser.jar;modules/ZuckerReports/jasper/batik-script.jar;
modules/ZuckerReports/jasper/batik-svg-dom.jar;modules/ZuckerReports/jasper/batik-svggen.jar;modules/ZuckerReports/jasper/batik-util.jar;modules/ZuckerReports/jasper/batik-xml.jar;
modules/ZuckerReports/jasper/bsh-2.0b4.jar;modules/ZuckerReports/jasper/cglib-2.1.jar;modules/ZuckerReports/jasper/cincom-jr-xmla.jar;modules/ZuckerReports/jasper/commons-beanutils-1.7.jar;
modules/ZuckerReports/jasper/commons-collections-2.1.jar;modules/ZuckerReports/jasper/commons-dbcp-1.2.1.jar;modules/ZuckerReports/jasper/commons-digester-1.7.jar;modules/ZuckerReports/jasper/commons-javaflow-20060411.jar;
modules/ZuckerReports/jasper/commons-logging-1.0.2.jar;modules/ZuckerReports/jasper/commons-logging-api-1.0.2.jar;modules/ZuckerReports/jasper/commons-math-1.0.jar;modules/ZuckerReports/jasper/commons-pool-1.3.jar;
modules/ZuckerReports/jasper/commons-vfs-1.0.jar;modules/ZuckerReports/jasper/dom4j-1.6.jar;modules/ZuckerReports/jasper/ehcache-1.1.jar;modules/ZuckerReports/jasper/eigenbase-properties.jar;modules/ZuckerReports/jasper/eigenbase-resgen.jar;
modules/ZuckerReports/jasper/eigenbase-xom.jar;modules/ZuckerReports/jasper/flexdock-0.4.1.jar;modules/ZuckerReports/jasper/groovy-all-1.0.jar;modules/ZuckerReports/jasper/hibernate3.jar;modules/ZuckerReports/jasper/hsqldb-1.7.1.jar;modules/ZuckerReports/jasper/iReport.jar;
modules/ZuckerReports/jasper/itext-1.3.1.jar;modules/ZuckerReports/jasper/jakarta-bcel-20050813.jar;modules/ZuckerReports/jasper/JasperBabylon-1.0.0.jar;modules/ZuckerReports/jasper/jasperreports-2.0.5.jar;modules/ZuckerReports/jasper/jasperreports-extensions-1.3.1.jar;modules/ZuckerReports/jasper/jasperreports-flash-2.0.5.jar;
modules/ZuckerReports/jasper/javacup.jar;modules/ZuckerReports/jasper/jaxen-1.1.1.jar;modules/ZuckerReports/jasper/jcmdline-1.0.2.jar;modules/ZuckerReports/jasper/jcommon-1.0.0.jar;modules/ZuckerReports/jasper/jdt-compiler-3.1.1.jar;modules/ZuckerReports/jasper/jfreechart-1.0.0.jar;
modules/ZuckerReports/jasper/jpa.jar;modules/ZuckerReports/jasper/jsmoothgen-ant-0.9.7.jar;modules/ZuckerReports/jasper/js_activation-1.1.jar;modules/ZuckerReports/jasper/js_axis-1.4patched.jar;modules/ZuckerReports/jasper/js_commons-discovery-0.2.jar;modules/ZuckerReports/jasper/js_jasperserver-common-ws-2.1.0.jar;
modules/ZuckerReports/jasper/js_jasperserver-ireport-plugin-2.1.0.jar;modules/ZuckerReports/jasper/js_jaxrpc.jar;modules/ZuckerReports/jasper/js_mail-1.4.jar;modules/ZuckerReports/jasper/js_wsdl4j-1.5.1.jar;modules/ZuckerReports/jasper/jta.jar;modules/ZuckerReports/jasper/jxl-2.6.jar;modules/ZuckerReports/jasper/log4j-1.2.8.jar;
modules/ZuckerReports/jasper/log4j-1.2.9.jar;modules/ZuckerReports/jasper/looks-2.0-rc.jar;modules/ZuckerReports/jasper/microba-0.4.1-bin.jar;modules/ZuckerReports/jasper/mondrian-2.3.2.8944.jar;modules/ZuckerReports/jasper/mysql-connector-java-3.1.11-bin.jar;modules/ZuckerReports/jasper/nsisant-1.1.jar;
modules/ZuckerReports/jasper/png-encoder-1.5.jar;modules/ZuckerReports/jasper/poi-3.0.1-FINAL-20070705.jar;modules/ZuckerReports/jasper/rex-20070125.jar;modules/ZuckerReports/jasper/saaj-api-1.3.jar;modules/ZuckerReports/jasper/servlet.jar;
modules/ZuckerReports/jasper/spring-2.0-m2.jar;modules/ZuckerReports/jasper/spring-context-2.0-m2.jar;modules/ZuckerReports/jasper/spring-hibernate3-2.0-m2.jar;
modules/ZuckerReports/jasper/sqleonardo-2007.03.jar;modules/ZuckerReports/jasper/swingx-2007_05_13.jar;modules/ZuckerReports/jasper/tinylaf.jar;modules/ZuckerReports/jasper/toniclf.jar;modules/ZuckerReports/jasper/xalan.jar;
modules/ZuckerReports/jasper/xercesImpl.jar;modules/ZuckerReports/jasper/xml-apis-ext.jar;modules/ZuckerReports/jasper/xml-apis.jar;modules/ZuckerReports/jasper/zuckerreports-1.0.jar" at.go_mobile.zuckerreports.JasperBatchMain modules/ZuckerReports/temp/b6b10381-bd05-e21e-bb97-4833f08b27ab/cmd.properties 2>&1
JasperBatchMain :: Illegal connection port value '3307:3306'
java.sql.SQLException: Illegal connection port value '3307:3306'
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2533)
at com.mysql.jdbc.Connection.(Connection.java:1474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager .java:512)
at java.sql.DriverManager.getConnection(DriverManager .java:171)
at at.go_mobile.zuckerreports.JasperBatchMain.getConn ection(JasperBatchMain.java:216)
at at.go_mobile.zuckerreports.JasperBatchMain.main(Ja sperBatchMain.java:91)

The Mysql instance is on port 3307 but where could i test the connection ?
Thanks

[ptemplin7]

Not sure if this helps,

But check that you have the user/password for accessing the mysql tables set correctly. Also does your workstation have to translate a router or firewall (such and Windows Firewall!) to get to the mysql server? If so you may have a firewall issue and need to open the appropriate ports.

Hope you find a solution soon,
Paris