IMSMWU/RClickhouse

I met "Error in connect(config[["host"]], strtoi(config[["port"]]), config[["db"]], : closed: No error" when connect CK with RClickhouse

Closed this issue · 3 comments

huangxp12 commented

con <- dbConnect(RClickhouse::clickhouse(), user = '',password ='', host="rnt-ck.bzhan.com",port=80,dbname='min**k')

Error in connect(config[["host"]], strtoi(config[["port"]]), config[["db"]], :
closed: No error

When I reuse con ,I get "couldn't find the object "con""

con
错误: 找不到对象'con'

tridelt commented

Hello!
may I ask what operating system you are using? Also with which version of RClickHouse did you experience the error? Compatibility issues with Windows have previously been resolved with e8d9439 and 0bc1280.

tridelt commented

Due to inactivity, I close this issue for now. If this problem should become relevant again to you, please feel free to leave a comment.

everleazy commented

@tridelt
Hi!

I have the same error.
RClickhouse v0.63
Windows 11.

Im use ssl = 'true' and not, port 9000/9440.

con <- DBI::dbConnect(RClickhouse::clickhouse(),
                      host="host", 
                      port = 9440, # 9000
                      db = "db", 
                      user = "user", 
                      password = "psw", 
                      ssl = "true" # sslmode = "true"

Error:

Error in connect(config[["host"]], strtoi(config[["port"]]), config[["db"]],  : 
  fail to connect to host