Also turn down Selinux Josh Luthman Office: 937-552-2340 Direct: 937-552-2343 1100 Wayne St Suite 1337 Troy, OH 45373 On Dec 16, 2014 9:57 AM, "Josh Luthman" <j...@imaginenetworksllc.com> wrote:
> Did you open the firewall? Do a netstat to see if it is running and > telnet to see if you can connect to the ports. > > Josh Luthman > Office: 937-552-2340 > Direct: 937-552-2343 > 1100 Wayne St > Suite 1337 > Troy, OH 45373 > On Dec 16, 2014 9:52 AM, "Justin Marshall via Af" <af@afmug.com> wrote: > >> 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 >> >> >> >
