How to change Jasper Report Mysql port?

**TiborBiro** · 2006-10-27, 10:52 PM

Hi,

How can I change the mysql port the Jasper Reports templates are using?

I installed Sugar CRM on Windows 2003 with the big windows installer that setup Apache, PHP and Mysql. During setup I put the mysql port to 3307 because the default was taken. All went fine, SugarCRM worked wonderfully and life was good.

Later I installed ZuckerReports and I was able to run reports. There was an option there to upload a Jasper Report template so I setup iReport and created a jrxml file with a sample report. After I uploaded the JasterTemplate and tried to run the report it says Unknown database 'sugarcrm'

I think that the JasperReport thing is going to the default mysql port instead of using the special port I selected during the SugarCRM setup. So I need to change this port, can anyone help me with a pointer to the configuration file?

I found in the documentation pointers to various XML files but I cannot find them

.

Thanks,
Tibor