topic Tomcat doesn't work properly, alfresco 4 won't start... in Alfresco Archive

Tomcat doesn't work properly, alfresco 4 won't start...

limulus — Sun, 14 Jul 2013 21:37:15 GMT

Hi alli've a serious problem!i've installed Alfresco 4.2.c on Win 7 OS 64bit with Mysql 5.2.47. A new installation - no update - no migration. When I start share an will login - Message: Remote-Server not avaible or login not correct. Database is blank - Alfresco can't connect - I think - but why ?

Re: Tomcat doesn't work properly, alfresco 4 won't start...

bopolissimus — Sun, 14 Jul 2013 21:50:54 GMT

You probably just don't have the mysql jdbc connector in your tomcat/lib directory. In an alfresco instance that uses mysql I have /opt/alfresco/tomcat/lib/mysql-connector-java-5.1.22-bin.jar.

find somewhere to download the mysql jdbc connector, download it, and push it into your tomcat/lib directory. 4.2 comes with postgresql by default, I don't think it comes with a mysql connector by default (I don't see the mysql connector in any of my installed-from-bundle-installer test instances).

Sorry I can't help you find the connector. I don't use windows. Make sure to only use a mysql jdbc connector from a site you trust, otherwise you may get malware on your machine.

Re: Tomcat doesn't work properly, alfresco 4 won't start...

bisana — Mon, 15 Jul 2013 04:27:53 GMT

based on ur error log

 
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
… 88 more
Caused by: org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:67)
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:47)
at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:426)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:128)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2079)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1304
‍‍‍‍‍‍‍‍‍‍‍

it is problem of jdbc driver
place the mysql jdbc connector in tomcat/lib

Re: Tomcat doesn't work properly, alfresco 4 won't start...

vignesh_sabapat — Mon, 15 Jul 2013 07:14:09 GMT

Hi Limulus,

As you already mentioned that you kept the lib file under tomcat/lib. I see there is something wrong with configurations under alfresco-global.properties.

Replace

mysql://localhost:3306/alfresco1?useUnicode=yes&characterEncoding=UTF-8

with

jdbc:mysql://localhost:3306/alfresco1?useUnicode=yes&characterEncoding=UTF-8

Re: Tomcat doesn't work properly, alfresco 4 won't start...

limulus — Wed, 17 Jul 2013 17:00:21 GMT

Hi all

The Problem was a bad instance from SQL. New Installation an all was well.
Thanks for your Help and all the best
Claudio