Postgresql Not Starting

[harshit192]

Hello,
     I have alfresco 4.0.c setup in my office. Suddenly alfresco stop working. Postgresql not starting. Tomcat is starting. When i open the link it throws me error 404. and /share link is opening.


"/opt/alfresco-4.0.c/postgresql/scripts/ctl.sh : postgresql  could not be started"

Please help me. I got stuck.

[rjohnson]

You need to find your postgresql error log probably in /var/alfresco/postgresql/postgresql.log this will tell you the error. Look at the bottom of the file as this log does not get truncated or rolled over.

Very often it is that permissions are wrong.

[harshit192]

thnx but my postgres.log file is empty and i am using alfresco comunity edition without modified.

[rjohnson]

First look in /opt/alfresco-4.0.c/postgresql/scripts/ctl.sh, find the definition of POSTGRESQL_START and try running that from the command line. You may get a better error. If not, check /opt/alfresco-4.0.c/postgresql/bin/ctl.sh and check where it is writing your error files in case its somewhere else.

fialing that add -d 3 to the POSTGRESQL_START command which should give more extensive debuging.

This is usually a permissions error on the data directory.

[harshit192]

[root@t2 scripts]# /opt/alfresco-4.0.c/postgresql/bin/postgres -d 3 /opt/alfresco-4.0.c/alf_data/postgresql -p 5432
/opt/alfresco-4.0.c/postgresql/bin/postgres: error while loading shared libraries: libssl.so.0.9.8: cannot open shared object file: No such file or directory

error found.

[postgres@tn2 bin]$ ./pg_ctl restart
pg_ctl.bin: PID file "/opt/alfresco-4.0.c/alf_data/postgresql/postmaster.pid" does not exist
Is server running?
starting server anyway
server starting

when i try to run pg_ctl i get the above error.

Please help me !!!

[rjohnson]

What you look to have proved here is that the PATH environment for user root does not have the folder that libssl.so.0.9.8 lives in and the user postgres does.

What user does Alfresco start under? Do you log in & start Alfresco manually or does it start when you boot the machine? If it starts on boot, check the init.d/alfresco file & see what user it starts under.

What you need to make sure is as follows:-

The user that starts alfresco has permissions to read and write alf_data and all files & folders including postgres ones. Do NOT make everything globally writeable, if you do Postgres won't start for other reasons but make sure that user that starts alfresco has read / write (and as appropriate execute) on all of alf_data. Make sure that user has in its path the folder the contains the library.

I suspect that Alfresco does not run as root (it shouldn't) and that the user it does run under now does not have enough permissions to start postgres.

[harshit192]

I am starting alfresco from root user. and from past 1 year its working fine and suddenly its stop working.


Please help me.