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

[Vic · Accepted 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.

[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 · Accepted 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]

Take a look at this page as well

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

[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?

[abhinavmishra14 · Accepted 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. 

[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