topic Re: i'm trying to install alfresco comunity from a distribution zip in Alfresco Forum

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

KnGod — Mon, 18 Nov 2019 19:56:11 GMT

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

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

abhinavmishra14 — Mon, 18 Nov 2019 21:43:36 GMT

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"

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

KnGod — Tue, 19 Nov 2019 19:34:09 GMT

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

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

Vic — Wed, 20 Nov 2019 05:33:04 GMT

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.

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

Vic — Wed, 20 Nov 2019 05:34:19 GMT

Take a look at this page as well

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

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

calvo — Wed, 20 Nov 2019 10:02:05 GMT

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

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

KnGod — Wed, 20 Nov 2019 19:15:21 GMT

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?

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

abhinavmishra14 — Wed, 20 Nov 2019 20:29:05 GMT

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.