topic Re: Alfresco and Mysql in Alfresco Archive

Alfresco and Mysql

nezha — Tue, 11 Mar 2014 15:55:11 GMT

hi;i followed this procedure 1/ Install MySSQL using mysql-installer-community-5.6.10.1.msi> Full install2/ Add environment Variables > Path (C:\Program files\mySQL\MySqlServer 5.6\Bin)3/ Open Cmd.exe and log into MySQL> Mysql –u root –p4/ Create Alfresco database> Create database al

Re: Alfresco and Mysql

mrogers — Tue, 11 Mar 2014 16:06:00 GMT

Cant see anything wrong with that.

Except step 11 which is nothing to do with restore. Or was that the command you typed in which case the password is alfresco not PASSWORD.

Have you then started alfresco at missing stap 12.

And what was in your alfresco.log file?

Re: Alfresco and Mysql

nezha — Tue, 11 Mar 2014 16:17:49 GMT

thinks for your answer ;
yes i restard alfresco but the same error this is my alfresco.log content:
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [alfresco/hibernate-context.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
   at 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)
   at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:860)
   at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:779)
   at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)
   … 95 more
NB:in my mysql database ther'is no table??

Re: Alfresco and Mysql

mrogers — Tue, 11 Mar 2014 16:30:40 GMT

the "dialect" is normally a "red herring" you can set it if you like, but the root cause tends to be an inability to connect to the database. Once the connection is made then the dialect can be determined.

Re: Alfresco and Mysql

nezha — Tue, 11 Mar 2014 16:33:10 GMT

im beginner in this software this is my first time
i installed alfresco.exe community version 32bit
I use the advanced configuration at the begining of the installation and choose MYSQL as my database
i configure the file property
the main question is:
is that ennogh to use alfresco with mysql???
thinks for helping

Re: Alfresco and Mysql

nezha — Tue, 11 Mar 2014 16:36:56 GMT

how the connection will be established