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