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; } } }

i'm trying to install alfresco comunity from a distribution zip

KnGod

i think i did well mounting the apache tomcat(at least the share page shows in my explorer) the problem is the database integration i don't know what i have to do to configure a database for alfresco or if i have to. At least i want to be able to create an account externally so i can log in and see if i did everything fine during the process. For the database i have postgres and mySQL just don't know what to do with that

Find more posts tagged with

Alfresco Content Services

Accepted answers

Vic

You have to manually create a database (or a scheme, depending on the DBMS you use). I. e. in MySQL something like this:

DROP DATABASE IF EXISTS `alfresco`;
CREATE DATABASE `alfresco` DEFAULT CHARACTER SET utf8;

Next step you'll have to create a database account for Alfresco and grant to it all privileges for the created scheme.

Then, in alfresco-global.properties provide all the required parameters

db.username=${alfresco.db.username}
db.password=${alfresco.db.password}
db.driver=${db.driver}
db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}?useUnicode=yes&characterEncoding=UTF-8

Replace ${} placeholders with actual values.

That is all that you need to do regarding database configuration. When you start Alfresco it will create all the neccesary tables in the specified database.

abhinavmishra14

You can disable CSRF by adding following config in share-config-custom.xml, you need to add the following lines:

<config evaluator="string-compare" condition="CSRFPolicy" replace="true">
   <filter/>
</config>

After restart, the error should go hopefully.

All comments

abhinavmishra14

Which version you are trying to install ? Did you followed the steps documented here: https://docs.alfresco.com/community/concepts/install-community-intro.html

Check if you have correct db configurations in the global properties file, see instructions here: https://docs.alfresco.com/community/tasks/alf-war-install.html

An admin user is by default created. default user name is "admin" and password is : "admin"

KnGod

i´m triyng to install Alfresco comunity 6.1.2 i followed a pdf i downloaded from the official page but the steps didn´t specifyed what i had to do with the database. I start the tomcat and the share page becomes aviliable but the db i´m not too shure what to do with that i already tryed the admin user and password but pretty shure it´s because of me don´t knowing what to do with the database

Vic

You have to manually create a database (or a scheme, depending on the DBMS you use). I. e. in MySQL something like this:

DROP DATABASE IF EXISTS `alfresco`;
CREATE DATABASE `alfresco` DEFAULT CHARACTER SET utf8;

Next step you'll have to create a database account for Alfresco and grant to it all privileges for the created scheme.

Then, in alfresco-global.properties provide all the required parameters

db.username=${alfresco.db.username}
db.password=${alfresco.db.password}
db.driver=${db.driver}
db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}?useUnicode=yes&characterEncoding=UTF-8

Replace ${} placeholders with actual values.

That is all that you need to do regarding database configuration. When you start Alfresco it will create all the neccesary tables in the specified database.

Vic

Take a look at this page as well

https://docs.alfresco.com/6.1/concepts/intro-db-setup.html

calvo

Hi,

In my case, I had some problems to install it because information about some points is too general; so maybe you can take a look to the server logs. It could be useful for you and it will help you to solve problems.

Regards,
clv

KnGod

thanks for the help. I managed to set up my database and alffresco is using it but a new problem apeared: it seems my conection is insecure? the error happens when i try to login and the text in the tomcat window is(ERROR [alfresco.web.site][http-nio-8080-exec-2]javax.servlet.ServletException: Possible CSRF attack noted when asserting referer header 'http://127.0.0.1:8080/share/page/console/admin-console/application'. Request: POST /share/page/dologin, FAILED TEST: Assert referer POST /share/page/dologin :: referer: 'http://127.0.0.1:8080/share/page/console/admin-console/application' vs server & context: https://127.0.0.1:8080/ (string) or (regexp)) seems i don't have permitions to logg in? any idea about that?