[RESOLVED] Problem using remote mysql server
Posted: Tue Oct 16, 2012 1:43 pm
Hi,
I just installed openemm 2011 with a remote mysql server. To do this I changed the following parameters :
All works fine except when I click on the Heatmap button, in the mailing statistics, where i get this error :
It seems OpenEMM tries to connect to a local mysql server as it works when I make an ssh tunnel towards my sql server on port 3306
Is there another configuration file I missed to specify my sql server ? I searched within this forum with no luck.
Thanks for your help...
I just installed openemm 2011 with a remote mysql server. To do this I changed the following parameters :
Code: Select all
~/WEB-INF/classes/emm.properties:jdbc.url=jdbc:mysql://auchan-sql02o.vmut93.cvf/openemm?useUnicode=yes&characterEncoding=UTF-8&useOldAliasMetadataBehavior=true
~/WEB-INF/classes/cms.properties:cmsdb.url=jdbc:mysql://auchan-sql02o.vmut93.cvf/openemm_cms?useUnicode=true&characterEncoding=UTF8&jdbcCompliantTruncation=false
Code: Select all
An error occurred
Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
Is there another configuration file I missed to specify my sql server ? I searched within this forum with no luck.
Thanks for your help...