First time installation on Ubuntu with postgresql problem appearing

maksymkuvyklin — Tue, 14 Jul 2015 15:49:20 GMT

I am not experienced person in this issue, but I will try to show a problem.I am trying to install the alfrecso community 5.0d edition on my Ubuntu 14.04 LTS desktop edition. (do not ask me why not on the server edition).I have downloaded from the alfresco web-site the bin file for Linux and ran it.

Re: First time installation on Ubuntu with postgresql problem appearing

arthurm — Sun, 29 Nov 2015 16:41:49 GMT

Please help me to connect to my Alfresco I'm using Alfresco 5.0d on windows everything worked great with fresh install I was able to join alfresco with my default admin admin acc. But when I installed postgreSQL edited everything step by step like it shows on http://docs.alfresco.com/4.2/tasks/postgresql-config.html Once I Run http://127.0.0.1:8080/share/ and i try to connect with my newly created alfresco alfresco database, superuser alfresco. It says: Your authentication details have not been recognized or Alfresco may not be available at this time. Been strungling few weeks with this problem also I'm new here in this community so any help, ideas would be helpful!
Also I can't log in to my alfresco with my old default account too, says the same thing it feels like it can't find my postgresql database and I don't know why.

I'm using alfresco 5.0d and postgresql 9.3.10

My alfresco-global.properties
dir.root=/srv/alfresco/alf_data
db.name=alfresco
db.username=alfresco
db.password=alfresco
db.host=localhost
db.port=5432
db.pool.max=275
db.driver=org.postgresql.Driver
db.url=jdbcostgresql://localhost:5432/alfresco
alfresco.rmi.services.host=0.0.0.0

Re: First time installation on Ubuntu with postgresql problem appearing

mrogers — Tue, 01 Dec 2015 15:54:00 GMT

There are almost certainly errors in your log file - they will help you identify your problem.

It is probably one of the following
a) your database not running. Use the pgadmin tool to check that you can connect to the alfresco database with your alfresco user.
b) missing the postgresql driver
c) your database not configured correctly, perhaps the schema has not been created, the alfresco user is missing, your alfresco user lacks permissions or a security setting preventing connection.

And are you trying to connect to Alfresco Share with admin/admin ? what does "superuser alfresco" mean?

Re: First time installation on Ubuntu with postgresql problem appearing

arthurm — Sun, 06 Dec 2015 16:28:26 GMT

I can't connect to my alfresco, after I run startup.bat If i try to connect to localhost:8080/alfresco/ I get 404 error and if try to connect to ocalhost:8080/share I cant access it with admin admin it says The remote server may be unavailable or your authentication details have not been recognized.
(I want to connect with postgresql) I have created my database with pgadminIII connected and created alfresco database with user alfresco

alfresco-global.properties file:
dir.root=D:/alfresco/alf_data

db.username=alfresco
db.password=alfresco
db.name=alfresco
db.host=localhost
db.port=5432
db.pool.max=40

db.driver=org.postgresql.Driver
db.url=jdbcostgresql://localhost:5432/alfresco

ftp.enabled=true
ftp.port=1121
ftp.ipv6.enabled=false

Changed catalina.properties
shared.loader=${catalina.home}/shared/classes,${catalina.home}/shared/lib/*.jar

and I pasted jar file there - postgresql-9.0-802.jdbc4.jar

My Alfresco.log :
18:14:37,431 WARN [org.hibernate.cfg.SettingsFactory] Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "alfresco")
   at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
   at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
   at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
   at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
   at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
   at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2079)
   at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1304)
   at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:860)
   F
18:14:37,478 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tenantService' defined in file [C:\apache-tomcat-6.0.37\webapps\alfresco\WEB-INF\classes\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#7e6ef134' 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#7e6ef134' 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 'sessionFactory' defined in class path resource [alfresco/hibernate-context.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
   at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
   at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
   at org.apache.catalina.core.StandardService.start(StandardService.java:525)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:497)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

Re: First time installation on Ubuntu with postgresql problem appearing

arthurm — Mon, 07 Dec 2015 10:11:39 GMT

NeverMind the problem was with dir.root=D:/alfresco/alf_data wrong directory.

Re: First time installation on Ubuntu with postgresql problem appearing

metta — Sat, 12 Dec 2015 22:18:29 GMT

I think it needs ulimit nofile increased.

google to see how to configure:

soft nofile 4096
hard nofile 65536

Then run the installer.

I had the same issue and it worked for me. Too bad preflight checks are not there to detect and report it before trying.

Re: First time installation on Ubuntu with postgresql problem appearing

manjunath — Wed, 21 Aug 2019 04:28:25 GMT

Set password without special characters;like, Password12345

topic Re: First time installation on Ubuntu with postgresql problem appearing in Alfresco Archive

First time installation on Ubuntu with postgresql problem appearing

Re: First time installation on Ubuntu with postgresql problem appearing

Re: First time installation on Ubuntu with postgresql problem appearing

Re: First time installation on Ubuntu with postgresql problem appearing

Re: First time installation on Ubuntu with postgresql problem appearing

Re: First time installation on Ubuntu with postgresql problem appearing

Re: First time installation on Ubuntu with postgresql problem appearing