Python连接Docker部署的Cassandra集群报错求助

Hey there, since your Cassandra node works perfectly with cqlsh but your PyCharm Python code can't connect, let's walk through targeted steps to nail down the problem:

• Verify driver-Cassandra version compatibility
  The cassandra-driver needs to align with your Cassandra server version to work properly. Run these commands to check:

  • For driver version: pip show cassandra-driver
  • For Cassandra version: cqlsh --version
    Double-check the compatibility rules (e.g., Cassandra 4.x requires driver 3.25+, Cassandra 3.x pairs well with driver 3.11+). If versions don't match, adjust the driver with pip install cassandra-driver==<compatible-version>.

• Check Docker port mapping & network access

  • Make sure you mapped Cassandra's default port (9042) to your host when starting the container—your run command should include -p 9042:9042. If not, restart the container with this port mapping.
  • If you're using the container's internal IP as the contact point, confirm it's correct by running docker inspect <your-cassandra-container-id> | grep IPAddress and use that exact IP in your code.
  • Test if your host can reach the Cassandra port: run nc -zv <target-ip> 9042 (or telnet <target-ip> 9042). If this fails, your network setup is the root issue.

• Fix Cassandra's listen/rpc configuration
  By default, Cassandra in Docker might bind only to the container's localhost, blocking external connections. Adjust the cassandra.yaml file:

  1. Set listen_address: 0.0.0.0 (or the container's static IP)
  2. Set rpc_address: 0.0.0.0
  3. Optional: Set broadcast_rpc_address to your host's IP if needed
     You can either edit the file inside the container (use docker exec -it <container-id> bash to access it) or mount a custom cassandra.yaml when starting the container:

  docker run -v /path/to/your/custom-cassandra.yaml:/etc/cassandra/cassandra.yaml -p 9042:9042 cassandra:<version>
  

  Restart the container after making changes.

• Validate your Python code details

  • Ensure your contact point is correctly specified (don't use just localhost unless your Python code runs inside the same container):

    from cassandra.cluster import Cluster
    # Use host IP or container internal IP
    cluster = Cluster(contact_points=['192.168.1.100'], port=9042)
    session = cluster.connect()
    

  • If Cassandra has authentication enabled (you set authenticator: PasswordAuthenticator in cassandra.yaml), add the auth provider to your code:

    from cassandra.auth import PlainTextAuthProvider
    auth_provider = PlainTextAuthProvider(username='cassandra', password='cassandra')
    cluster = Cluster(contact_points=['your-ip'], auth_provider=auth_provider)
    

• Check firewall/security group rules
  Confirm your host's firewall (Linux ufw, Windows Firewall) or any cloud security groups aren't blocking traffic on port 9042. Temporarily disable the firewall to test if that's the blocker (remember to re-enable it afterward!).

• Share the full error traceback
  The exact error message is the most critical clue. Common issues like NoHostAvailable (network problem), AuthenticationFailed (missing credentials), or ProtocolError (version mismatch) will point directly to the fix. Paste the full traceback from PyCharm's console for more targeted help.

内容的提问来源于stack exchange，提问作者user9371612