This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

postgresql failed

chipwoods over 4 years ago

I did a reboot of WHD this afternoon and the reboot failed. This is on a virtual appliance. The initial screen is asking me to create new databases. I logged onto the console and when I attempt to start WHD I get "Starting postgresql-9.2 service: [FAILED]". I have plenty of drive space. Any ideas?

Output of startup:

Web Help Desk 12.6.0.738
Copyright (c) SolarWinds Worldwide, LLC


Web Help Desk 12.6.0.738
Copyright (c) SolarWinds Worldwide, LLC

Using XX:MaxPermSize=256

Using additional JVM options: -XX:+DisableAttachMechanism -Dsun.rmi.transport.tcp.maxConnectionThreads=0
Checking if port 80 is available
Port 80 is already in use by ::ffff:172.19.138.163:55007 ::ffff:127.0.0.1:47404.
Checking if port 443 is available
Port 443 is already in use by ::ffff:127.0.0.1:49392.
Starting postgresql-9.2 service:                           [FAILED]
Starting the Web Help Desk on port 80...

Starting an SSL connection to the Web Help Desk on port 443...
(See README.txt for information regarding SSL connections.)

Using CATALINA_BASE:   /usr/local/webhelpdesk/bin/tomcat
Using CATALINA_HOME:   /usr/local/webhelpdesk/bin/tomcat
Using CATALINA_TMPDIR: /usr/local/webhelpdesk/bin/tomcat/temp
Using JRE_HOME:        /usr/local/webhelpdesk/bin/jre
Using CLASSPATH:       /usr/local/webhelpdesk/bin/tomcat/bin/bootstrap.jar:/usr/local/webhelpdesk/bin/tomcat/bin/tomcat-juli.jar
Using CATALINA_PID:    /usr/local/webhelpdesk/log/.whd.pid
Tomcat started.

0 chipwoods over 4 years ago

when I attempted to start it manually, I got :
"usr/local/webhelpdesk/bin/pgsql/var/lib/pgsql/9.2/data is missing. Use "service postgresql-9.2 initdb" to initialize the cluster first."
The data directory is not missing. it seems to be a symlink to /data1/data which is there but admin did not have permissions. it was owned by postgres user. when I went in as root, there was stuff in there but I wasn't sure what to look for.
I'm just trying to not lose my data.
Cancel
Vote Up 0 Vote Down

Cancel
0 libit over 2 years ago

Hi chipwoods,

I ran into this symptom, too. (WebHelpDesk 12.7.2.39, CentOS 7)

When starting webhelpdesk, postgresql-9.2 fails to start, so webhelpdesk cannot be accessed:

Starting postgresql-9.2 service: [FAILED]

Verify that the following directory exists, has contents, and the contents are owned by the postgres user:

ls -la /usr/local/webhelpdesk/bin/pgsql/var/lib/pgsql/9.2/data

View the contents of the embedded postgres startup log:

tail -20 /usr/local/webhelpdesk/bin/pgsql/var/lib/pgsql/9.2/pgstartup.log

You should see startup messages that end in "ok." Instead, I saw this message:

LOG: could not bind IPv4 socket: Address already in use
HINT: Is another postmaster already running on port 20293? If not, wait a few seconds and retry.

Check to see if an instance of webhelpdesk's embedded postgres is already running:

ps aux | grep postgres

It was. Identify the PID, and kill the outstanding process:

kill -9 <PID>

Restart webhelpdesk:

service webhelpdesk start

Starting postgresql-9.2 service: [ OK ]

WebHelpDesk now starts, and the web component can be accessed.

Two years later - hope your instance got resolved!
Cancel
Vote Up 0 Vote Down

Cancel

0 wfire over 2 years ago in reply to libit

Hello

i have a similar problem

I am in the 1st centos + whd installation

1) after installatio there is no connection to create the embedded database (connection refused)
2) after restart here is the error

ble.
Checking if port 8443 is available
Port 8443 is available.

/usr/local/webhelpdesk/bin/pgsql/var/lib/pgsql/9.2/data is missing. Use "service postgresql-9.2 initdb" to initialize the cluster first.
 [ÉCHOUÉ]
Starting the Web Help Desk on port 8081...

Starting an SSL connection to the Web Help Desk on port 8443...
(See README.txt for information regarding SSL connections.)

Using CATALINA_BASE: /usr/local/webhelpdesk/bin/tomcat
Using CATALINA_HOME: /usr/local/webhelpdesk/bin/tomcat
Using CATALINA_TMPDIR: /usr/local/webhelpdesk/bin/tomcat/temp
Using JRE_HOME: /usr/local/webhelpdesk/bin/jre
Using CLASSPATH: /usr/local/webhelpdesk/bin/tomcat/bin/bootstrap.jar:/usr/local/webhelpdesk/bin/tomcat/bin/tomcat-juli.jar

3) I think there is a permission problem for the database

[web@Host-002 ~]$ sudo ls -la /usr/local/webhelpdesk/bin/pgsql/var/lib/pgsql/9.2/data
total 4
drwx------. 3 postgres postgres 39 8 nov. 20:02 .
drwxr-xr-x. 3 root root 39 8 nov. 20:02 ..
-rw-r--r--. 1 root root 130 8 nov. 20:02 pg_hba.conf
drwx------. 2 postgres postgres 6 8 nov. 20:02 pg_log

4) when i want to do initdb i have an error> progstl is not in the same folder when yes. I have no idea what to do thank you