Hi,
Trying to do an install of CNS Server on CentOS 6.6(x86_64). Accepted all the defaults as far as postgres username/port. When i try and login through http/https, no page loads.
Doing a #ps -ax shows something up with postgres i believe.
2060 ? Ss 0:04 /opt/cnsserver/stack/apache2/bin/httpd -f /opt/cnsserver/stack/apache2/conf/httpd.conf
2061 ? S 0:00 /opt/cnsserver/stack/apache2/bin/httpd -f /opt/cnsserver/stack/apache2/conf/httpd.conf
2062 ? S 0:00 /opt/cnsserver/stack/apache2/bin/httpd -f /opt/cnsserver/stack/apache2/conf/httpd.conf
2063 ? S 0:00 /opt/cnsserver/stack/apache2/bin/httpd -f /opt/cnsserver/stack/apache2/conf/httpd.conf
2064 ? S 0:00 /opt/cnsserver/stack/apache2/bin/httpd -f /opt/cnsserver/stack/apache2/conf/httpd.conf
2065 ? S 0:00 /opt/cnsserver/stack/apache2/bin/httpd -f /opt/cnsserver/stack/apache2/conf/httpd.conf
6248 ? Ss 0:00 /usr/sbin/anacron -s
6399 ? S 0:00 pickup -l -t fifo -u
6417 ? S 0:00 /opt/cnsserver/stack/postgresql/bin/postgres -D /opt/cnsserver/stack/postgresql/data
6419 ? Ss 0:00 postgres: checkpointer process
6420 ? Ss 0:00 postgres: writer process
6421 ? Ss 0:00 postgres: wal writer process
6422 ? Ss 0:00 postgres: autovacuum launcher process
6423 ? Ss 0:00 postgres: stats collector process
6462 pts/1 S 0:00 /bin/bash ./start_cnss.sh
6470 pts/1 Sl 0:02 ../jre/bin/java -classpath ../conf:../libs/backend/log4j-1.2.16.jar:../libs/backend/snmp4j-2.2.3.jar:../libs/backend/postgresql-9
6485 ? Ss 0:00 postgres: postgres cnss 127.0.0.1(48691) idle
6486 ? Ss 0:00 postgres: postgres cnss 127.0.0.1(48692) idle
6487 ? Ss 0:00 postgres: postgres cnss 127.0.0.1(48693) idle
6488 ? Ss 0:00 postgres: postgres cnss 127.0.0.1(48694) idle
6489 ? Ss 0:00 postgres: postgres cnss 127.0.0.1(48695) idle
6490 ? Ss 0:00 postgres: postgres cnss 127.0.0.1(48696) idle
6491 ? Ss 0:00 postgres: postgres cnss 127.0.0.1(48697) idle
6492 ? Ss 0:00 postgres: postgres cnss 127.0.0.1(48698) idle
6493 ? Ss 0:00 postgres: postgres cnss 127.0.0.1(48699) idle
6494 ? Rs 0:00 postgres: postgres cnss 127.0.0.1(48700) BIND
I've tried stopping/restarting all the services, rebooting...
When i try and stop or restart the lappstackPostgresSQL service i get:
[root@cnss logs]# /etc/init.d/lappstackPostgreSQL restart waiting for server to shut down............................................................... failed pg_ctl.bin: server does not shut down HINT: The "-m fast" option immediately disconnects sessions rather than waiting for session-initiated disconnection. /opt/cnsserver/stack/postgresql/scripts/ctl.sh : postgresql could not be stopped /opt/cnsserver/stack/postgresql/scripts/ctl.sh : postgresql (pid 1966) already running
So i try a killall postgres && /etc/init.d/lappstackPostgreSQL start
I get:
waiting for server to start.... done server started /opt/cnsserver/stack/postgresql/scripts/ctl.sh : postgresql started at port 5432
but still the same (idle) output from #ps ax
Digging around through the /opt/cnsserver/logs dir all logs are emtpy except utils.log is filled with messages such as:
2014-12-15 08:58:14,836 ERROR ConnectionPool.validateConnection(): Connection to database lost. Attempting to reconnect. 2014-12-15 08:58:14,842 ERROR ConnectionPool.openConnectionToDatabase(): Could not connect to the database: org.postgresql.util.PSQLException: Connection re fused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:138) org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125) org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30) org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22) org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:32) org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) org.postgresql.Driver.makeConnection(Driver.java:393) org.postgresql.Driver.connect(Driver.java:267) java.sql.DriverManager.getConnection(Unknown Source) java.sql.DriverManager.getConnection(Unknown Source) com.cambiumnetworks.cnss.services.utils.database.ConnectionPool.openConnectionToDatabase(ConnectionPool.java:169) com.cambiumnetworks.cnss.services.utils.database.ConnectionPool.validateConnection(ConnectionPool.java:210) com.cambiumnetworks.cnss.services.utils.database.ConnectionPool.getConnection(ConnectionPool.java:105) com.cambiumnetworks.cnss.services.utils.database.ConnectionPool.getConnection(ConnectionPool.java:94) com.cambiumnetworks.cnss.services.utils.dao.GenericConfigurationDAO.getConfigurationData(GenericConfigurationDAO.java:37) com.cambiumnetworks.cnss.services.launcher.ServiceLauncher.main(ServiceLauncher.java:203) 2014-12-15 08:58:14,843 ERROR ConnectionPool.getConnection(): Unable to recover lost database connection. Shutting down server.
Has anyone experienced this or know what direction I should go?
Thanks,
Justin