topic Re: Alfresco Community (Build: 6.0.0-ea) doesn't start in Alfresco Forum

Alfresco Community (Build: 6.0.0-ea) doesn't start

giuseppemoglia — Fri, 10 Jul 2020 10:18:02 GMT

Hi Guys

we have Alfresco Community by 2017 and some days ago the website went down. Now I can see this error in Alfresco log:

2020-07-10 11:57:22,449 WARN [org.hibernate.cfg.SettingsFactory] [localhost-startStop-1] Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The connection attempt failed.)
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:83)
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 .....

I tried to connect mself to postgres db but no way

If I restart the server just the mobile application is running....

Anyone of you can give me support please?

Thanks

Re: Alfresco Community (Build: 6.0.0-ea) doesn't start

EddieMay — Fri, 10 Jul 2020 14:01:07 GMT

Hi @giuseppemoglia,

Just to confirm - you have tried and failed to connect to postgres? Can you connect to the database server from a command line?

Take care,

Re: Alfresco Community (Build: 6.0.0-ea) doesn't start

giuseppemoglia — Fri, 10 Jul 2020 14:03:32 GMT

postrgres process is up but I cannot connect neither from command line...

Re: Alfresco Community (Build: 6.0.0-ea) doesn't start

EddieMay — Fri, 10 Jul 2020 16:17:01 GMT

Hi @giuseppemoglia,

Can you check that the ports haven't changed or firewall rules? You can check is postgres is listening on 5432 port using netstat -a command or

sudo netstat -ltnp | grep postgres

on linux.

HTH,

Re: Alfresco Community (Build: 6.0.0-ea) doesn't start

giuseppemoglia — Fri, 10 Jul 2020 16:49:54 GMT

I've disabled the Firewall

The port is open

from ntstat -ano the port is open

The strange issue is at start from mobile app it works.....

Re: Alfresco Community (Build: 6.0.0-ea) doesn't start

giuseppemoglia — Sun, 12 Jul 2020 09:17:21 GMT

Also webdav runs

Just share doesn't works correctly

Any hints?

Thanks

Re: Alfresco Community (Build: 6.0.0-ea) doesn't start

EddieMay — Tue, 14 Jul 2020 13:20:42 GMT

Hi @giuseppemoglia,

It's looking like a database issue - perhaps it's corrupted? Could you try restarting it against a DB backup from before the crash?

Best wishes,