topic Re: Alfresco Installation in Alfresco Archive

Alfresco Installation

dsr471 — Mon, 22 Sep 2014 12:17:22 GMT

Hi,Can we install Alfresco 4.0.x Community versions in Windows 2012 R2 Data Center 64 Bit Version? If NO, can you please share me the draw backs…Thanks,DSR

Re: Alfresco Installation

douglascrp — Mon, 22 Sep 2014 12:45:47 GMT

I think there will be any problem on installiing it, but why are you trying to install such a old version?

I'd recommend to you to install the 4.2.f version, which is the most stable version so far.

Re: Alfresco Installation

daveb01 — Tue, 23 Sep 2014 01:21:28 GMT

Hi,
Sorry if this is the wrong place to post this as I am new to this.

I am trying to install Alfresco on a QNAP NAS and would like some help.

I have been trying to get the following combination to work with the instructions given in this post but Alfresco will not start:

QNAP TS-451 with firmaware version 4.1.1
Tomcat 7.0.5
JRE 8.0.1
The QNAP built-in implementation of MySQL server
Alfresco Community 5.0a
MySQL connector 5.1.32

I have also tried to install Alfresco Community 4.2f but without success.

Should the above combination work?

One other problem I have noticed is that the logs are not being updated each time I try to start Alfresco. There are entries but they only appear to be as a result of the initial installation.

These are the first few lines from the alfresco.log file so there appears to be a problem here:


14:28:11,398 WARN  [org.alfresco.util.RuntimeSystemPropertiesSetter] [localhost-startStop-1] Could not find alfresco-jmxrmi.password on classpath
14:28:12,834 INFO  [org.alfresco.repo.admin] [localhost-startStop-1] Using database URL 'jdbc:mysql://localhost:3306/alfresco' with user 'alfresco'.
14:28:13,570 ERROR [org.springframework.web.context.ContextLoader] [localhost-startStop-1] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authorityBridgeTableCache' defined in class path resource [alfresco/cache-context.xml]: Cannot resolve reference to bean 'tenantService' while setting bean property 'tenantService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tenantService' defined in URL [jar:file:/share/CACHEDEV1_DATA/.qpkg/Tomcat/tomcat/webapps/alfresco/WEB-INF/lib/alfresco-repository-5.0.a.jar!/alfresco/mt/mt-context.xml]: Cannot resolve reference to bean 'tenantAdminDAO' while setting bean property 'tenantAdminDAO'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tenantAdminDAO' defined in class path resource [alfresco/dao/dao-context.xml]: Cannot resolve reference to bean 'repoSqlSessionTemplate' while setting bean property 'sqlSessionTemplate'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'repoSqlSessionTemplate' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Cannot resolve reference to bean 'repoSqlSessionFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'repoSqlSessionFactory' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Cannot resolve reference to bean 'dialectResourceLoader' while setting bean property 'resourceLoader'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectResourceLoader' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Cannot create inner bean 'org.springframework.beans.factory.config.PropertyPathFactoryBean#5eb72a' of type [org.springframework.beans.factory.config.PropertyPathFactoryBean] while setting bean property 'dialectClass'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.beans.factory.config.PropertyPathFactoryBean#5eb72a' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialect' defined in class path resource [alfresco/hibernate-context.xml]: Cannot resolve reference to bean '&sessionFactory' while setting bean property 'localSessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSourceCheck' defined in class path resource [alfresco/core-services-context.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.alfresco.repo.domain.schema.DataSourceCheck]: Constructor threw exception; nested exception is java.lang.RuntimeException: Database connection failed: Cannot create PoolableConnectionFactory (Access denied for user 'alfresco'@'localhost' (using password: YES))
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
‍‍‍‍‍‍‍

Any help would be much appreciated.

Thanks,
Dave

Re: Alfresco Installation

dsr471 — Tue, 23 Sep 2014 06:17:26 GMT

can I know which type of problem will occur while installing it? As we need to install 4.0.x versions, not 4.2.x

Re: Alfresco Installation

mrogers — Tue, 23 Sep 2014 10:29:09 GMT

From your logs…

Access denied for user 'alfresco'@'localhost'

Re: Alfresco Installation

mrogers — Wed, 24 Sep 2014 13:45:27 GMT

It's the db connection that's the problem.

Re: Alfresco Installation

daveb01 — Wed, 24 Sep 2014 14:04:06 GMT

Hi,
Thanks for getting back to me.

Is this the MySQL account or the user account on the NAS?

I have the user 'alfresco' setup in MySQL and I can connect to the DB with this account externally via ODBC on a Win 7 machine but for some reason Alfresco does not appear to be able to log in. I can also create and populate tables manually in the Alfresco database.

I have also tried configuring Alfresco with the default MySQL root/admin account but it still will not login.

I have deleted the database and started again. The Alfresco user has all permissions on the alfresco db.

Also, I have an "alfresco" user account configured on the NAS with R/W permissions to the Alfresco share.

Do I need to change anything in the alfresco-jmxrmi.password file? Where should it be located?

I stated the incorrect JRE version in the above post, this was the QNAP package version. I have now downloaded and installed the headless JRE 7.

When I try to start Alfresco, the alf-data folder is created in the Alfresco share as is the contentstore.deleted folder but they are empty. Nothing is created in the MySQL database.

I have also tried the installation with PostgreSQL but without success.

Although Alfresco is configured to use port 7080, I changed the default port on the NAS to something to eliminate the possibility of a conflict but this made no difference.

I have reverted back to Alfresco 4.2f for as this appears to be a more stable release so once I get it working, hopefully I will not have to upgrade it for a while.

I am obviously missing something.

Would be great if QNAP released an Alfresco package, there appears to be quite a lot of demand for it on the forums.

Thanks,
Dave

Re: Alfresco Installation

daveb01 — Wed, 24 Sep 2014 14:11:44 GMT

Thanks, I have tried various ways of trying to get this to work.

I have the correct username and password with empty schema configured in MySQL.

I have tried various different settings in the alfresco-global properties file to try and get this to work.

I have used the connect that comes with the Alfresco 4.2f package.

What else could I try?

Re: Alfresco Installation

daveb01 — Wed, 24 Sep 2014 14:18:00 GMT

Here are the logs

If there is anything else that would help, please let me know.

Thanks again,
Dave

Re: Alfresco Installation

mrogers — Wed, 24 Sep 2014 14:18:38 GMT

That's a port conflict on 50500. Find out what is already running on 50500 or change alfresco's rmi services port.

Re: Alfresco Installation

daveb01 — Wed, 24 Sep 2014 14:38:00 GMT

netstat does not show anything running on 50500 but it does show localhost 50505 connected to 3310 which is MySQL. Would this cause the problem?

Also, where should I configure the Alfresco rmi services port? I cannot find the custom-repository.properties file. Should I add an entry "alfresco.rmi.services.port=50600" to the alfresco-global.properties file and change the "repo.rmi.service.port=50505" entry?

Re: Alfresco Installation

daveb01 — Wed, 24 Sep 2014 14:53:00 GMT

I've made the changes below to the alfresco-global.properties file in /share/CACHEDEV1_DATA/.qpkg/Tomcat/tomcat/shared/classes but Alfresco still does not start.

alfresco.rmi.services.port=50600
avm.rmi.service.port=50601
avmsync.rmi.service.port=50602
attribute.rmi.service.port=50603
authentication.rmi.service.port=50604
repo.rmi.service.port=50605
action.rmi.service.port=50606
wcm-deployment-receiver.rmi.service.port=50607
monitor.rmi.service.port=50608

Re: Alfresco Installation

jaikisanugale — Tue, 14 Oct 2014 12:02:00 GMT

not able to install alfresco community edition 4.2.f successfully on windows 7 enterprize 32 bit mysql 5.6.19,mysqlconnector 5.1.10
facing error–>error running with an vcredist_x86.exe/qrogram ended with an error exit code

while starting startup.bat tomcat crashes instatntly showing –>Using CATALINA_BASE:   "D:\alfresco\alfresco\tomcat"
Using CATALINA_HOME:   "D:\alfresco\alfresco\tomcat"
Using CATALINA_TMPDIR: "D:\alfresco\alfresco\tomcat\temp"
Using JRE_HOME:        "D:\alfresco\alfresco\java"
Using CLASSPATH:       "D:\alfresco\alfresco\tomcat\bin\bootstrap.jar;D:\alfresc
o\alfresco\tomcat\bin\tomcat-juli.jar"