nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Find more posts tagged with

Alfresco Content Services

Accepted answers

el_stefano

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:

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

All comments

angelborroy

Follow these steps:

Using MariaDB instead of PostgreSQL as database · keensoft/docker-alfresco Wiki · GitHub

If you are not using Docker, then just include following values in your alfresco-global.properties

db.driver=org.mariadb.jdbc.Driver
db.username=alfresco
db.password=alfresco
db.url=jdbc:mariadb://db:3306/alfresco?useUnicode=true\&characterEncoding=UTF-8‍‍‍‍

el_stefano

Thanks but nothing !!!
In alfresco-global.properties I have replaced these lines

#db.driver=com.mysql.jdbc.Driver
#db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}?useUnicode=yes&characterEncoding=UTF-8

with

db.driver=org.mariadb.jdbc.Driver
db.url=jdbc:mariadb://${db.host}:${db.port}/${db.name}?useUnicode=true\&characterEncoding=UTF-8

but the error remains the same:

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

Best Regards

angelborroy

Did you copy MariaDB Connector/J library to "tomcat/lib"?

el_stefano

Hi,
yes, I copied MariaDB Connector/J library to tomcat/lib and to tomcat/shared/lib/
I think Alfresco can connect to the DB, because if I mistake the password in the alfresco-global.properties file, the error changes and becomes:

Failed to obtain JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'alfresco'@'localhost' (using password: YES))

Best Regards

angelborroy

So now the problem is that MySQL is not configured to be accessed from "localhost".

Probably this can help: GRANT - MariaDB Knowledge Base

el_stefano

No, no, I had only done a test to mistake the password on purpose to verify that Alfresco arrived, and connected, to the DB !!!
By putting the right password again, the "old" error returns.

Best Regards

el_stefano

Hi,

I overcame the rock, the problem was that I had installed a connector too recent (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. jar.
The problem is that I always have an error even though it has changed, now it is:

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}]
at org.springframework.beans.AbstractNestablePropertyAccessor.convertIfNecessary(AbstractNestablePropertyAccessor.java:595)
at org.springframework.beans.AbstractNestablePropertyAccessor.convertForProperty(AbstractNestablePropertyAccessor.java:604)
at org.springframework.beans.BeanWrapperImpl.convertForProperty(BeanWrapperImpl.java:219)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.convertForProperty(AbstractAutowireCapableBeanFactory.java:1697)

Best Regards

el_stefano

Wow... I didn't believe it but it's really hard !!!
I also passed the second obstacle, inserting it into the file alfresco-global.properties

sample.site.disabled=true

and 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.
All happy, I enter the url http://<hostname_server>:8080/share in the browser.... and anything.... the page is waiting but nothing appears !!!
Before I had blocking errors but at least the http://<hostname_server>:8080/share page appeared to me.
On 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'm going crazy...... help me !!!

angelborroy

I don't understand what the problem is.

The steps to use MariaDB are pretty simple:

1) Create an empty database for Alfresco in MariaDB

2) Include the right settings in "alfresco-global.properties"

3) Copy the JAR file to "tomcat/lib"

And it's done.

The steps are (still) the same described for MySQL: Alfresco – Using MySQL instead of PostgreSQL |

el_stefano

Then, I had the problem with Sample Site:

And this too I solved by inserting

sample.site.disabled=true

in the alfresco-global.properties file.

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

I hope I was clearer !!

Best Regards