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 empty 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.
I've installed CNS Server on CentOS before without any issues, not sure why this time it's fighting me. Not sure what direction to take from here. Anyone have any ideas? Thanks, Justin just...@pdmnet.net<mailto:just...@pdmnet.net>
