11-18-2019 11:56 AM
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
11-19-2019 09:33 PM
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.
11-20-2019 12:29 PM
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.
11-18-2019 01:43 PM
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"
11-19-2019 11:34 AM
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
11-19-2019 09:33 PM
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.
11-19-2019 09:34 PM
Take a look at this page as well
11-20-2019 11:15 AM
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?
11-20-2019 12:29 PM
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.
11-20-2019 02:02 AM
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
Explore our Alfresco products with the links below. Use labels to filter content by product module.