topic Re: Nuxeo Server Cannot Connect to PostgreSQL database in Nuxeo Forum

Nuxeo Server Cannot Connect to PostgreSQL database

BW1982_ — Tue, 12 Mar 2013 19:22:01 GMT

First installation failed to install JDK 7. I downloaded/installed the latest version manually from the Java.com website. Second install returned an error while configuring the PostgreSQL database, but the error message popped up and out too quickly for me to read during installation.

When starting the server, it returns an error (copy/pasted the text that was red in the log):

2013-03-12 14:20:01,527 ERROR [org.nuxeo.launcher.config.ConfigurationGenerator] org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. 2013-03-12 14:20:01,528 ERROR [org.nuxeo.launcher.NuxeoLauncher] Could not run configuration: Failed to connect on database: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

This software could potentially solve a lot of things for my business. Any help would be appreciated.

Re: Nuxeo Server Cannot Connect to PostgreSQL database

bruce_Grant — Tue, 12 Mar 2013 19:28:39 GMT

Would be helpful to know your OS, version of Nuxeo, and in all likelihood the content of nuxeo.conf related to postgresql.

Re: Nuxeo Server Cannot Connect to PostgreSQL database

BW1982_ — Tue, 12 Mar 2013 19:36:35 GMT

Re: Nuxeo Server Cannot Connect to PostgreSQL database

bruce_Grant — Tue, 12 Mar 2013 19:53:39 GMT

First check to make sure that Postgresql is running as a service. If not then try and start it.

Re: Nuxeo Server Cannot Connect to PostgreSQL database

BW1982_ — Tue, 12 Mar 2013 20:01:10 GMT

Strange. No service by the name of PostgreSQL is listed. Even stranger

Re: Nuxeo Server Cannot Connect to PostgreSQL database

bruce_Grant — Tue, 12 Mar 2013 20:14:27 GMT

It's been a while since I installed a Windows copy using the installer, but I recall there was a question to install Postgresql as part of the process (it may have been experimental at the time). Did you see this question and try to install Postgresql?

Re: Nuxeo Server Cannot Connect to PostgreSQL database

BW1982_ — Tue, 12 Mar 2013 20:25:36 GMT

Yes, there was an option to also install PostgreSQL and I opted in.

Re: Nuxeo Server Cannot Connect to PostgreSQL database

bruce_Grant — Tue, 12 Mar 2013 20:27:44 GMT

Probably a good idea since it's clear that there was some hiccup in the original install.

Re: Nuxeo Server Cannot Connect to PostgreSQL database

BW1982_ — Tue, 12 Mar 2013 21:31:16 GMT

Thanks to Bruce for his assistance in helping me identify the issue. Upon reinstalling each package individually, I was able to pinpoint the location of my problem: the default Windows PostgreSQL installation database location.

The PostgreSQL one-click installation pre-packaged with Nuxeo is actually problematic for Windows installs. On the PostgreSQL site I learned that when prompted to point the installation to a database location, you cannot use the default location provided. The default subdirectory name "9.6" within the installation directory (C:\Program Files\PostgreSQL\9.6) causes a conflict with the rest of the installation because of the "." in the subdirectory name. Instead, point the PostgreSQL install when it asks for a database directory location to C:\Data, or something within the proper Windows directory naming conventions for it to work.

When installing on a Windows system for users like me that aren't adept to development, download the JDK7 (Java Development Kit 7) from Java.com, then download the PostgreSQL from PostgreSQL.org and then install Nuxeo. It will already identify the existence of the other two components and will only install the core Nuxeo files.

Re: Nuxeo Server Cannot Connect to PostgreSQL database

bruce_Grant — Tue, 12 Mar 2013 21:33:41 GMT

Good to hear it's resolved!

Re: Nuxeo Server Cannot Connect to PostgreSQL database

Julien_Carsique — Thu, 14 Mar 2013 18:05:38 GMT

Thanks for the feedback.