No Login, Postgresql not running after fresh bundle install

[fredson]

After fresh bundle install of 4.2.c, I can't login.

<blockcode>
$ uname -a

Linux foo 3.6.6-1-ARCH #1 SMP PREEMPT Mon Nov 5 11:57:22 CET 2012 x86_64 GNU/Linux

$ sudo alfresco.sh restart ; sudo alfresco.sh status


[sudo] password for fredson:
/opt/alfresco-4.2.c/tomcat/scripts/ctl.sh : tomcat not running
/opt/alfresco-4.2.c/postgresql/scripts/ctl.sh : postgresql not running
waiting for server to start………………………………………………………pg_ctl.bin: could not start server
Examine the log output.
/opt/alfresco-4.2.c/postgresql/scripts/ctl.sh : postgresql  could not be started
Using CATALINA_BASE:   /opt/alfresco-4.2.c/tomcat
Using CATALINA_HOME:   /opt/alfresco-4.2.c/tomcat
Using CATALINA_TMPDIR: /opt/alfresco-4.2.c/tomcat/temp
Using JRE_HOME:        /opt/alfresco-4.2.c/java
Using CLASSPATH:       /opt/alfresco-4.2.c/tomcat/bin/bootstrap.jar:/opt/alfresco-4.2.c/tomcat/bin/tomcat-juli.jar
Using CATALINA_PID:    /opt/alfresco-4.2.c/tomcat/temp/catalina.pid
/opt/alfresco-4.2.c/tomcat/scripts/ctl.sh : tomcat started
tomcat already running
postgresql not running


$ less postgresql.log

[empty]
</blockcode>

Here, additionally, the alfresco-Logfile:

http://pastebin.com/p24xNLSG

Any suggestions, where to turn my head for a solution?

[abarisone]

Hi,
it seems that Alfresco doesn't start because PosteGRE is down.
On Windows I installed Alfresco and PostGRE as services and I start them manually.
Try to start PostGRE separately and check out any error coming from log.

Regards,
Andrea

[fredson]

Thank you for your comment, it helped me to tackle the Postgre issue down to:

<blockcode>
$ pg_ctl start -w -D /opt/alfresco-4.2.c/alf_data/postgresql/

waiting for server to start………………….pg_ctl.bin: could not start server
</blockcode>

Well, PostgreSQL isn't very verbose on what it keeps from working properly. The postgresql.log is still empty.

The alfresco-script ist returning an error code 3, but I'm not sure it is very helpful:

<blockcode>
$ sh -x alfresco.sh

+ '[' -f /usr/sbin/getenforce ']'
+ INSTALLDIR=/opt/alfresco-4.2.c
+ '[' -r /opt/alfresco-4.2.c/scripts/setenv.sh ']'
+ . /opt/alfresco-4.2.c/scripts/setenv.sh
++ echo
++ egrep /opt/alfresco-4.2.c/common
++ '[' 1 -ne 0 ']'
++ PATH=/opt/alfresco-4.2.c/java/bin:/opt/alfresco-4.2.c/postgresql/bin:/opt/alfresco-4.2.c/common/bin:/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin:/usr/bin/core_perl:/usr/lib/qt4/bin:/usr/local/texlive/2009/bin/i386-linux:/home/fredson/.scripts::/usr/local/texlive/2009/bin/i386-linux:/home/fredson/.scripts:
++ export PATH
++ LD_LIBRARY_PATH=/opt/alfresco-4.2.c/postgresql/lib:/opt/alfresco-4.2.c/common/lib:
++ export LD_LIBRARY_PATH
++ MAGICK_HOME=/opt/alfresco-4.2.c/common
++ export MAGICK_HOME
++ MAGICK_CONFIGURE_PATH=/opt/alfresco-4.2.c/common/lib/ImageMagick-6.5.6/config:/opt/alfresco-4.2.c/common/share/ImageMagick-6.5.6/config
++ export MAGICK_CONFIGURE_PATH
++ MAGICK_CODER_MODULE_PATH=/opt/alfresco-4.2.c/common/lib/ImageMagick-6.5.6/modules-Q16/coders
++ export MAGICK_CODER_MODULE_PATH
++ GS_LIB=/opt/alfresco-4.2.c/common/share/ghostscript/fonts
++ export GS_LIB
++ GS_LIB=/opt/alfresco-4.2.c/common/share/ghostscript/fonts
++ export GS_LIB
++ JAVA_HOME=/opt/alfresco-4.2.c/java
++ export JAVA_HOME
+ ERROR=0
+ MYSQL_SCRIPT=/opt/alfresco-4.2.c/mysql/scripts/ctl.sh
+ INGRES_SCRIPT=/opt/alfresco-4.2.c/ingres/scripts/ctl.sh
+ APACHE_SCRIPT=/opt/alfresco-4.2.c/apache2/scripts/ctl.sh
+ HYPERSONIC_SCRIPT=/opt/alfresco-4.2.c/hypersonic/scripts/ctl.sh
+ TOMCAT_SCRIPT=/opt/alfresco-4.2.c/tomcat/scripts/ctl.sh
+ RESIN_SCRIPT=/opt/alfresco-4.2.c/resin/scripts/ctl.sh
+ SUBVERSION_SCRIPT=/opt/alfresco-4.2.c/subversion/scripts/ctl.sh
+ OPENOFFICE_SCRIPT=/opt/alfresco-4.2.c/openoffice/scripts/ctl.sh
+ LUCENE_SCRIPT=/opt/alfresco-4.2.c/lucene/scripts/ctl.sh
+ ZOPE_SCRIPT=/opt/alfresco-4.2.c/zope_application/scripts/ctl.sh
+ THIRD_SCRIPT=/opt/alfresco-4.2.c/third_application/scripts/ctl.sh
+ POSTGRESQL_SCRIPT=/opt/alfresco-4.2.c/postgresql/scripts/ctl.sh
+ NAGIOS_SCRIPT=/opt/alfresco-4.2.c/nagios/scripts/ctl.sh
+ JETTY_SCRIPT=/opt/alfresco-4.2.c/jetty/scripts/ctl.sh
+ JBOSS_SCRIPT=/opt/alfresco-4.2.c/jboss/scripts/ctl.sh
+ MEMCACHED_SCRIPT=/opt/alfresco-4.2.c/memcached/scripts/ctl.sh
+ RABBITMQ_SCRIPT=/opt/alfresco-4.2.c/rabbitmq-server/scripts/ctl.sh
+ '[' xstart = xhelp ']'
+ '[' xstart = x ']'
+ '[' xstart = xstart ']'
+ '[' x = xmysql ']'
+ '[' x = xpostgresql ']'
+ '[' x = xingres ']'
+ '[' x = xopenoffice ']'
+ '[' x = xhypersonic ']'
+ '[' x = xmemcached ']'
+ '[' x = xtomcat ']'
+ '[' x = xjboss ']'
+ '[' x = xresin ']'
+ '[' x = xzope_application ']'
+ '[' x = xlucene ']'
+ '[' x = xapache ']'
+ '[' x = xsubversion ']'
+ '[' x = xthird_application ']'
+ '[' x = xnagios ']'
+ '[' x = xrabbitmq ']'
+ '[' x = xjetty ']'
+ test -x /opt/alfresco-4.2.c/mysql/scripts/ctl.sh
+ test -x /opt/alfresco-4.2.c/postgresql/scripts/ctl.sh
+ /opt/alfresco-4.2.c/postgresql/scripts/ctl.sh start
waiting for server to start………………………………………………………pg_ctl.bin: could not start server
Examine the log output.
/opt/alfresco-4.2.c/postgresql/scripts/ctl.sh : postgresql  could not be started
+ POSTGRESQL_ERROR=3
+ sleep 5
+ test -x /opt/alfresco-4.2.c/ingres/scripts/ctl.sh
+ test -x /opt/alfresco-4.2.c/openoffice/scripts/ctl.sh
+ test -x /opt/alfresco-4.2.c/hypersonic/scripts/ctl.sh
+ test -x /opt/alfresco-4.2.c/memcached/scripts/ctl.sh
+ test -x /opt/alfresco-4.2.c/tomcat/scripts/ctl.sh
+ /opt/alfresco-4.2.c/tomcat/scripts/ctl.sh start
Using CATALINA_BASE:   /opt/alfresco-4.2.c/tomcat
Using CATALINA_HOME:   /opt/alfresco-4.2.c/tomcat
Using CATALINA_TMPDIR: /opt/alfresco-4.2.c/tomcat/temp
Using JRE_HOME:        /opt/alfresco-4.2.c/java
Using CLASSPATH:       /opt/alfresco-4.2.c/tomcat/bin/bootstrap.jar:/opt/alfresco-4.2.c/tomcat/bin/tomcat-juli.jar
Using CATALINA_PID:    /opt/alfresco-4.2.c/tomcat/temp/catalina.pid
/opt/alfresco-4.2.c/tomcat/scripts/ctl.sh : tomcat started
+ TOMCAT_ERROR=0
+ test -x /opt/alfresco-4.2.c/jboss/scripts/ctl.sh
+ test -x /opt/alfresco-4.2.c/resin/scripts/ctl.sh
+ test -x /opt/alfresco-4.2.c/zope_application/scripts/ctl.sh
+ test -x /opt/alfresco-4.2.c/lucene/scripts/ctl.sh
+ test -x /opt/alfresco-4.2.c/apache2/scripts/ctl.sh
+ test -x /opt/alfresco-4.2.c/subversion/scripts/ctl.sh
+ test -x /opt/alfresco-4.2.c/third_application/scripts/ctl.sh
+ test -x /opt/alfresco-4.2.c/nagios/scripts/ctl.sh
+ test -x /opt/alfresco-4.2.c/rabbitmq-server/scripts/ctl.sh
+ test -x /opt/alfresco-4.2.c/jetty/scripts/ctl.sh
+ for e in '$APACHE_ERROR' '$MYSQL_ERROR' '$SUBVERSION_ERROR' '$TOMCAT_ERROR' '$RESIN_ERROR' '$MEMCACHED_ERROR' '$INGRES_ERROR' '$OPENOFFICE_ERROR' '$LUCENE_ERROR' '$ZOPE_ERROR' '$POSTGRESQL_ERROR' '$THIRD_ERROR' '$NAGIOS_ERROR' '$RABBITMQ_ERROR' '$JETTY_ERROR' '$JBOSS_ERROR' '$HYPERSONIC_ERROR'
+ '[' 0 -gt 0 ']'
+ for e in '$APACHE_ERROR' '$MYSQL_ERROR' '$SUBVERSION_ERROR' '$TOMCAT_ERROR' '$RESIN_ERROR' '$MEMCACHED_ERROR' '$INGRES_ERROR' '$OPENOFFICE_ERROR' '$LUCENE_ERROR' '$ZOPE_ERROR' '$POSTGRESQL_ERROR' '$THIRD_ERROR' '$NAGIOS_ERROR' '$RABBITMQ_ERROR' '$JETTY_ERROR' '$JBOSS_ERROR' '$HYPERSONIC_ERROR'
+ '[' 3 -gt 0 ']'
+ ERROR=3
+ '[' -f /usr/sbin/getenforce ']'
+ exit 3

</blockcode>

I'm stuck…

[abarisone]

Hi,
did you check there is enough space free on your server (maybe it's a stupid question but you'd better check)
Moreover I found this Step by step installation of Alfresco Community 4.2.c on Ubuntu 12.04 LTS minimal 64bit http://francescocorti.wordpress.com/2013/01/09/installation-alfresco-4-2-c-on-ubuntu/ that may give you some hints.
Please also take a look to Alfresco and Tomcat logs in order to verify if there is something relevant.

Regards,
Andrea

[fredson]

What to say? I did check the volumes size and .. well… it was full indeed. I guess I would have spend some more hours on that without your hint. Big up, Andrea 🙂 ! 

[abarisone]

I'm glad to hear you resolved your problem.
This reminds the importance to contribute to this forum in order to help other people as well as I've been helped many times….

Regards,
Andrea

[ltrent]

Hi there,
I am new to Alfresco and just did the install of 4.2d Community version on SUSE linux.  It looks like all the services are started, tomcat, postgres and of course alfresco but I cannot login using the credentials in the global properties.  During the install, it said the user id was admin and the password was admin however because that didn't work I looked at the global properties and its says the user id is alfresco and the password is admin.  This doesn't work.  I am not familiar with postgres but my next thought is to try to look in the database and see what user is defined but I don't know how to do that.

Any help would be appreciated.  when I look in the logs, it appears the issue is a database connection.

Thanks,
Lorna

[parzgnat]

Are you trying to log into Alfresco Share?  Have you tried logging into Alfresco Explorer

http://<hostname>:port/alfresco‍

with the same credentials?  A login failure in Alfresco Share isn't always indicative of a bad username and password.  If there is a fatal error during the startup of your Alfresco server, then you will get a login failure if you try to log into Share.

I would first suggest that you try to log in to Alfresco Explorer.  If the Alfresco Explorer application doesn't load when you go to the URL, then that's a telltale sign that your server didn't start property.  If that's the case, then you should take a look at the log files in <ALFRESCO_HOME>/tomcat/logs to see why the startup failed.

Hope that helps.