Hi Marcus,
I assume mariadb is running and listening to port 3306. While running the
netstat i got the following output:
[centos@airavata-nextcloud ~]$ netstat -anp | grep 3306
(No info could be read for "-p": geteuid()=1000 but you should be root.)
tcp 0 0 127.0.0.1:43418 127.0.0.1:3306
ESTABLISHED -
tcp6 0 0 :::3306 :::*
LISTEN -
tcp6 0 0 127.0.0.1:3306 127.0.0.1:43418 ESTABLISHED
-
Thanks,
Prashant
________________________________________
From: Christie, Marcus Aaron [[email protected]]
Sent: Tuesday, October 30, 2018 7:57 AM
To: Airavata Dev
Subject: Re: error while trying to run airavata server
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
