When using code to connect Clickhouse, you encounter an error connection reference, the following solutions are available.
Method 1: close the firewall
#Stop firewall
systemctl stop firewalld.service
#Stop firewall start
systemctl disable firewalld.service
Method 2: modify the configuration file config.xml
Edit the configuration file /etc/Clickhouse server/config.XML, open the comment on line 156
<listen_host>::1</listen_host>
Method 3: there is a problem with the port number
Read More:
- How to Solve Clickhouse restart error: Cannot obtain value of path from config file…
- [Solved] ClickHouse Start Error: Run under ‘sudo -u clickhouse‘
- [Solved] dbeaver Connect clickhouse Error: Unexpected driver error occurred while connecting to the database
- [Solved] Clickhouse Error: DB::Exception: Cannot lock file /var/lib/clickhouse/status
- zabbix-Get value from agent failed: cannot connect to [[127.0.0.1]:10050]: [111] Connection refused
- How to Solve Error: could not read ok from ADB Server.failed to start daemon error: cannot connect to daemon
- [Solved] Error:couldn‘t connect to server 127.0.0.1:27017, connection attempt failed: SocketException: …
- [Solved] AndroidStudio Error: Connect to 127.0.0.1:10887 [/127.0.0.1] failed: Connection refused…
- Connection refused: connect; nested exception is java.net.ConnectException: Connection refused: [How to Solve]
- [Solved] Error occurred during connect to primary: exception 3000301: Connection could not be established
- [Solved] waterdrop Import hive to clickhouse Error: Too many partitions for single INSERT block (more than 100).
- [Solved] LibreSSL SSL_connect: SSL_ERROR_SYSCALL in connection to github.com:443
- [Solved] Connection error with cocoapods. Proxy CONNECT aborted
- [Solved] LibreSSL SSL_connect: SSL_ERROR_SYSCALL in connection to github.com:443
- [Solved] jedis Connect redis Error: connect timed out
- [Solved] AmqpConnectException: java.net.ConnectException: Connection refused: connect
- How to Solve Pycharm SQL Union Error
- How to Solve Rabbitmq Error: Failed to start RabbitMQ broker
- How to Solve elasticsearch and logstash Install Error
- How to Fix ERROR Couldn’t connect to Docker daemon at http+docker://localunixsocket