Hi Prashant, Is the database running and listening on port 3306?
> On Oct 29, 2018, at 5:25 PM, Modak, Prashant Kumar <[email protected]> wrote: > > Hi, > I have found the root cause of the issue, > ****************************** > Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to > address=(host=149.165.169.159)(port=3306)(type=master) : Connection timed out > (Connection timed out) > at > org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:156) > at > org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:118) > at > org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.throwException(ExceptionMapper.java:92) > at org.mariadb.jdbc.Driver.connect(Driver.java:111) > at java.sql.DriverManager.getConnection(DriverManager.java:664) > at java.sql.DriverManager.getConnection(DriverManager.java:270) > at > org.apache.airavata.credential.store.store.impl.util.ConnectionPool.makeNewConnection(ConnectionPool.java:188) > at > org.apache.airavata.credential.store.store.impl.util.ConnectionPool.initialize(ConnectionPool.java:125) > at > org.apache.airavata.credential.store.store.impl.util.ConnectionPool.<init>(ConnectionPool.java:88) > at > org.apache.airavata.credential.store.store.impl.util.JdbcStorage.<init>(JdbcStorage.java:39) > ... 6 common frames omitted > Caused by: java.sql.SQLException: Could not connect to > address=(host=149.165.169.159)(port=3306)(type=master) : Connection timed out > (Connection timed out) > at > org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1029) > at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:483) > at org.mariadb.jdbc.Driver.connect(Driver.java:106) > ... 12 common frames omitted > Caused by: java.net.ConnectException: Connection timed out (Connection timed > out) > at java.net.PlainSocketImpl.socketConnect(Native Method) > at > java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) > at > java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) > at > java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) > at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) > at java.net.Socket.connect(Socket.java:589) > at java.net.Socket.connect(Socket.java:538) > at > org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:401) > at > org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1022) > ... 14 common frames omitted > > ****************************** > So to resolve this issue, I tried to open the port 3306 through firewalld, > > [email protected] bin]# sudo firewall-cmd --zone=public > --add-port=3306/tcp --permanent && sudo firewall-cmd --reload > > Status: > sudo firewall-cmd --list-all > > public > target: default > icmp-block-inversion: no > interfaces: > sources: > services: dhcpv6-client ssh http https > ports: 443/tcp 3306/tcp 8008/tcp 8080/tcp 8962/tcp 9930/tcp 22/tcp 2181/tcp > 5672/tcp 15672/tcp 8950/tcp 8930/tcp 8940/tcp 8960/tcp 8970/tcp 8443/tcp > protocols: > masquerade: no > forward-ports: > source-ports: > icmp-blocks: > rich rules: > > > Stopped and re-ran the airavata and gfac server. But still the issue > persists. > > Thanks. > Prashant > ________________________________________ > From: Modak, Prashant Kumar > Sent: Monday, October 29, 2018 3:34 PM > To: [email protected] > Subject: error while trying to run airavata server > > Hi, > While trying to run the airavata server, I have got the following error > message: > > ******************** > [INFO] Server Arguments: > /home/pga/master-deployment/gfac-instance/logs/output.log > [INFO] Starting > [ERROR] Server Start Error: > org.apache.airavata.common.exception.AiravataStartupException: Gfac Server > Initialization error > at > org.apache.airavata.gfac.server.GfacServerHandler.<init>(GfacServerHandler.java:98) > at > org.apache.airavata.gfac.server.GfacServer.start(GfacServer.java:101) > at > org.apache.airavata.server.ServerMain.startAllServers(ServerMain.java:372) > at > org.apache.airavata.server.ServerMain.performServerStart(ServerMain.java:221) > at org.apache.airavata.server.ServerMain.main(ServerMain.java:206) > Caused by: org.apache.zookeeper.KeeperException$ConnectionLossException: > KeeperErrorCode = ConnectionLoss for /servers > at org.apache.zookeeper.KeeperException.create(KeeperException.java:99) > at org.apache.zookeeper.KeeperException.create(KeeperException.java:51) > at org.apache.zookeeper.ZooKeeper.exists(ZooKeeper.java:1003) > at org.apache.zookeeper.ZooKeeper.exists(ZooKeeper.java:1031) > at org.apache.curator.utils.ZKPaths.mkdirs(ZKPaths.java:215) > at org.apache.curator.utils.ZKPaths.mkdirs(ZKPaths.java:164) > at > org.apache.airavata.gfac.server.GfacServerHandler.initZkDataStructure(GfacServerHandler.java:124) > at > org.apache.airavata.gfac.server.GfacServerHandler.<init>(GfacServerHandler.java:94) > ... 4 common frames omitted > > ******************** > > I ran the following two scripts: > go to > > /home/pga/master-deployment/api-orchestrator/apache-airavata-server-<version>-SNAPSHOT/bin > and run ./airavata-server-start.sh -d api-orch > go to > > /home/pga/master-deployment/gfac-instance/apache-airavata-server-<version>-SNAPSHOT/bin > and run ./airavata-server-start.sh -d gfac > > Thanks. > Prashant
