Dialect Database MariaDB

[el_stefano]

Hi,
it is the first time I install Alfresco Community and therefore I apologize for my inaccuracies.
The data are Alfresco Community 6.1 on CentOS 7 with MariaDB 10.3 on the same host.
For the installation I followed the documentation, I had some difficulties but I went on until now.
When I start Tomcat, I see in the logs:
Error creating bean with name 'org.springframework.beans.factory.
config.PropertyPathFactoryBean#304879f3' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Initialization of bean failed; neste
d exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialect': FactoryBean threw exception on ob
ject creation; nested exception is java.lang.IllegalArgumentException: Dialect must be explicitly set for database: MariaDB
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:378)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:110)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:401)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:159)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1648)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1400)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:575)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:498)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.context.support.PostProcessorRegistrationDelegate.invokeBeanFactoryPostProcessors(PostProcessorRegistrationDelegate.java:171)
at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:691)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:528)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:400)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:291)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:103)
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:70)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4682)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5150)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:713)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:695)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:978)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1849)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)

In the file tomcat/shared/classes/alfresco-global.properties I also put:

hibernate.dialect=org.hibernate.dialect.MariaDBDialect

but nothing, nothing has changed and I can't overcome this obstacle !!!
Thanks a lot

Best Regards

[el_stefano · Accepted solution]

Hi,
so, the problem with MariaDB I overcame, the problem was that I had installed a too "recent" connector (mariadb-java-client-2.4.1.jar) and the platform didn't support it and so I installed the mariadb-java-client-2.2.5 connector.

Then, I had the problem with Sample Site:

Caused by: org.springframework.beans.TypeMismatchException: Failed to convert property value of type 'java.lang.String' to required type 'boolean' for property 'disabled'; nested exception is java.lang.IllegalArgumentException: Invalid boolean value [${sample.site.disabled}].....

And this too I solved by inserting

sample.site.disabled=true

in the alfresco-global.properties file.

Now, when I restarted everything went ok, the DB was created, I have only a few errors because I still have to install additional software like LibreOffice but when I enter the url http://<hostname_server>:8080/share (or http://<hostname_server>:8080/alfresco), in the browser.... nothing.... the page is waiting but nothing appears !!!
On the log Catalin.out I don't see anything, it doesn't even register browser calls but my pc arrives on the server because if I do:

telnet <hostname_server> 8080
Trying 172.16.100.23...
Connected to prot01prdpom.home.coop.
Escape character is '^]'.

I hope I was clearer !!

Best Regards