could not send SSL negotiation packet: Connection timed out.

Moderator: NorbertKrupa

Post Reply
Roopalini
Newbie
Newbie
Posts: 13
Joined: Sun Jan 26, 2014 9:40 pm

could not send SSL negotiation packet: Connection timed out.

Post by Roopalini » Tue Jul 22, 2014 6:44 pm

Hi Forum,

When I create the below DSN , without ConnectionLoadBalance=1 , it works fine, however when I add that parameter, it throws the error "[Vertica][VerticaDSII]Connnection attempt failed: could not send SSL negotiation packet: Connection timed out.

[DW_DB]
Description=Vertica driver
Driver=/opt/vertica/lib/libverticaodbc.so
Database=dwdb
Servername=10.1.1.1
BackupServerNode=10.1.1.1,10.1.1.2, 10.1.1.3, 10.1.1.4,10.1.1.5,10.1.1.6,10.1.1.7,10.1.1.8
ConnectionLoadBalance=1
UID=uuuuu
PWD=xxxxxxxx
Port=5433
ResultBufferSize=8000000
ConnSettings=
Locale = en_US
ErrorMessagePath=/opt/vertica/lib/

Tried the below as well

Checked if the load balancing is enabled on the DB

1) SELECT LOAD_BALANCE_POLICY FROM V_CATALOG.DATABASES; It is enabled
2) Added SSL=True in the DSN, however that didn't help either
3) Added SSLMode=Allow or SSLMode = disable. Didn't resolve the issue

The vertica driver version is 7.0.1

Any idea what's going on?

Post Reply

Return to “ODBC”