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

cancel
Showing results for 
Search instead for 
Did you mean: 
KnGod
Member II

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

Jump to solution

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

2 Solutions

Accepted Solutions
Vic
Active Member II

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

Jump to solution

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.

View solution in original post

abhinavmishra14
Advanced

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

Jump to solution

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. 

~Abhinav
(ACSCE, AWS SAA, Azure Admin)

View solution in original post

7 Replies
abhinavmishra14
Advanced

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

Jump to solution

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"

~Abhinav
(ACSCE, AWS SAA, Azure Admin)
KnGod
Member II

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

Jump to solution

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
Active Member II

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

Jump to solution

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
Active Member II

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

Jump to solution
calvo
Senior Member

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

Jump to solution

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
Member II

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

Jump to solution

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?

abhinavmishra14
Advanced

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

Jump to solution

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. 

~Abhinav
(ACSCE, AWS SAA, Azure Admin)