Support Questions

Find answers, ask questions, and share your expertise

How to solve "Connection refused " errors in HDP

avatar
Expert Contributor

I have been working on Hortonworks Sandbox. The Sandbox is deployed on CentOS 6.7 server. I was, at some point in time, able to access the Web UIs on my browser from remote PC. But most of the services are not accessible except the welcome page on port 8888. When I try to start the services with command line in PuTTY, no success! That is, the services are not running. When I run this command, netstat -nltu , I can't see the service ports in the list of listening ports. How can I make the ports listen for TCP connection. Any walk through on configuration of iptables and port forwarding would also be highly appreciated!

1 ACCEPTED SOLUTION

avatar
Expert Contributor

The problem with PostgreSQL is now solved. error log from /var/lib/pgsql/pgstartup.log says:

"Starting PostgreSQL FATAL: could not create lock file "/tmp/.s.PGSQL.5432.lock": Permission denied"

Resolution:

As root user type "chmod 1777 /tmp"in terminal.

PostgreSQL will now start successfully.

> service postgresql start

Cause:

Postgres cannot write a file to /tmp because of permissions set on /tmp directory.

View solution in original post

22 REPLIES 22

avatar
Expert Contributor

The problem with PostgreSQL is now solved. error log from /var/lib/pgsql/pgstartup.log says:

"Starting PostgreSQL FATAL: could not create lock file "/tmp/.s.PGSQL.5432.lock": Permission denied"

Resolution:

As root user type "chmod 1777 /tmp"in terminal.

PostgreSQL will now start successfully.

> service postgresql start

Cause:

Postgres cannot write a file to /tmp because of permissions set on /tmp directory.

avatar
Contributor

Thanks a lot sir..You saved my day

avatar
New Contributor

Hi everyone,

I getting an issue in starting postgresql.Can anyone help me to solve this

3755-screen-shot-2016-04-28-at-124139-pm.png