cassandra本地连接失败_无法从远程计算机连接到Cassandra服务器

最新推荐文章于 2024-08-08 17:11:01 发布

原创最新推荐文章于 2024-08-08 17:11:01 发布 · 706 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#cassandra本地连接失败

博主将Cassandra部署在amazon lux ec2实例上，在该实例能成功运行相关python文件。但在另一个EC2实例安装python cassandra驱动程序，替换IP地址后运行失败，给出了错误信息，还提到安全组中多个入站端口已打开，最后寻求解决方法。

我已经将Cassandra部署在默认公共子网的amazonluxec2实例上，并安装了python驱动程序。然后我就可以在那个EC2实例上成功地运行-https://github.com/datastax/python-driver/blob/master/example_core.py。效果很好。在

现在，我在默认的公网子网中又产生了一个EC2实例，在上面安装了python cassandra驱动程序，并尝试执行上面提到的python文件，将第33行的127.0.0.1替换为第一个EC2实例的公共IP地址，在这个EC2实例中完成了单节点的cassandra安装，但是它失败了，错误如下-[ec2-user@ip-172-31-43-142 ~]$ python example.py

2018-05-02 09:50:23,061 [WARNING] cassandra.cluster: Cluster.__init__ called

with contact_points specified, but no load_balancing_policy. In the next

major version, this will raise an error; please specify a load-balancing

policy. (contact_points = ['54.244.59.178'], lbp = None)

2018-05-02 09:50:23,064 [DEBUG] cassandra.cluster: Connecting to cluster,

contact points: ['54.244.59.178']; protocol version: 4

2018-05-02 09:50:23,064 [DEBUG] cassandra.io.asyncorereactor: Validated loop

dispatch with cassandra.io.asyncorereactor._AsyncorePipeDispatcher

2018-05-02 09:50:23,064 [DEBUG] cassandra.pool: Host 54.244.59.178 is now

marked up

2018-05-02 09:50:23,067 [DEBUG] cassandra.cluster: [control connection]

Opening new connection to 54.244.59.178

2018-05-02 09:50:23,073 [WARNING] cassandra.cluster: [control connection]

Error connecting to 54.244.59.178:

Traceback (most recent call last):

File "cassandra/cluster.py", line 2798, in

cassandra.cluster.ControlConnection._reconnect_internal

return self._try_connect(host)

File "cassandra/cluster.py", line 2820, in

cassandra.cluster.ControlConnection._try_connect

connection = self._cluster.connection_factory(host.address,

is_control_connection=True)

File "cassandra/cluster.py", line 1205, in

cassandra.cluster.Cluster.connection_factory

return self.connection_class.factory(address, self.connect_timeout,

*args, **kwargs)

File "cassandra/connection.py", line 332, in

cassandra.connection.Connection.factory

conn = cls(host, *args, **kwargs)

File "/usr/local/lib64/python2.7/site-

packages/cassandra/io/asyncorereactor.py", line 344, in __init__

self._connect_socket()

File "cassandra/connection.py", line 371, in

cassandra.connection.Connection._connect_socket

raise socket.error(sockerr.errno, "Tried connecting to %s. Last error: %s" %

([a[4] for a in addresses], sockerr.strerror or sockerr))

error: [Errno 111] Tried connecting to [('54.244.59.178', 9042)]. Last

error:

Connection refused

2018-05-02 09:50:23,079 [ERROR] cassandra.cluster: Control connection failed

to connect, shutting down Cluster:

Traceback (most recent call last):

File "cassandra/cluster.py", line 1270, in

cassandra.cluster.Cluster.connect

self.control_connection.connect()

File "cassandra/cluster.py", line 2766, in

cassandra.cluster.ControlConnection.connect

self._set_new_connection(self._reconnect_internal())

File "cassandra/cluster.py", line 2809, in

cassandra.cluster.ControlConnection._reconnect_internal

raise NoHostAvailable("Unable to connect to any servers", errors)

NoHostAvailable: ('Unable to connect to any servers', {'54.244.59.178':

error(111, "Tried connecting to [('54.244.59.178', 9042)]. Last error:

Connection refused")})

2018-05-02 09:50:23,082 [DEBUG] cassandra.cluster: Shutting down Cluster

Scheduler

2018-05-02 09:50:23,082 [DEBUG] cassandra.cluster: Shutting down control

connection

Traceback (most recent call last):

File "example.py", line 73, in

main()

File "example.py", line 22, in main

session = cluster.connect()

File "cassandra/cluster.py", line 1247, in

cassandra.cluster.Cluster.connect

File "cassandra/cluster.py", line 1283, in

cassandra.cluster.Cluster.connect

File "cassandra/cluster.py", line 1270, in

cassandra.cluster.Cluster.connect

File "cassandra/cluster.py", line 2766, in

cassandra.cluster.ControlConnection.connect

File "cassandra/cluster.py", line 2809, in

cassandra.cluster.ControlConnection._reconnect_internal

cassandra.cluster.NoHostAvailable: ('Unable to connect to any servers',

{'54.244.59.178': error(111, "Tried connecting to [('54.244.59.178', 9042)].

Last error: Connection refused")})

[ec2-user@ip-172-31-43-142 ~]$

你能提供一些解决方法吗？在

请注意，以下入站端口在我的安全组中处于打开状态-9142个

9042个

9160个

7000-7001号

8182个

10000个

7199个

7437个

61621号

80个