topic Error after switch BD to PostgreSQL in Alfresco Archive

Error after switch BD to PostgreSQL

luizcandido — Fri, 15 May 2009 16:58:29 GMT

Hi!I'm installing Alfresco Labs 3 Stable on Linux Red Hat 5 with jdk 1.6. Tomcat was installed directly from Alfresco package. Initial start-up using Derby default DB works fine. Yet, when I try switch to BD PostgreSQL (version 8.1.11 using postgresql-8.3-604.jdbc4) following the manual "Installin

Re: Error after switch BD to PostgreSQL

rivetlogic — Sun, 17 May 2009 14:36:09 GMT

Hi,

Try "netstat -an | grep 50501"

–Alaaeldin

Re: Error after switch BD to PostgreSQL

luizcandido — Mon, 18 May 2009 18:29:28 GMT

Hi,

Try "netstat -an | grep 50501"

–Alaaeldin

Done! The response was quite meaningless to me, see:

[root@alfresco ~]# netstat -an | grep 50501
tcp 0 0 :::50501 :::* LISTEN
tcp 0 0 ::ffff:127.0.0.1:56341 ::ffff:127.0.0.1:50501 TIME_WAIT

Important: Most of time the response is only the first line. In the second, when it appears, the number (port?) after the first "127.0.0.1:" changes. I've got "55044" and "57269" for instance. Maybe any instability on the network control?

I'm getting sure that the problem isn't the PostgreSQL but some O.S. configuration.

Best regards,

Re: Error after switch BD to PostgreSQL

rivetlogic — Mon, 18 May 2009 19:13:24 GMT

Hi,

tcp 0 0 :::50501 :::* LISTEN, means that some application is listening on port 50501. That's your problem. You need to kill this application and you'll be able to start Alfresco.

Another option would be to change the ports that Alfresco uses by extending the necessary configuration files (http://wiki.alfresco.com/wiki/Port_numbers).

Cheers,

–Alaaeldin