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?
could not send SSL negotiation packet: Connection timed out.
Moderator: NorbertKrupa
Jump to
- General
- ↳ Welcome to vertica-forums.com!
- ↳ Board Announcements
- ↳ Request for New Forums Categories
- ↳ Announcements, Events and Activities
- ↳ Vertica Links
- ↳ General
- ↳ Employment
- ↳ Vertica Certification
- Newbie
- ↳ New to Vertica
- ↳ New to Vertica Database Administration
- ↳ New to Vertica Database Development
- ↳ New to Vertica SQL
- Using Vertica
- ↳ Vertica Database Administration
- ↳ Vertica Database Development
- ↳ Vertica SQL
- ↳ Vertica SQL Functions
- ↳ Vertica Database Designer (DBD)
- ↳ Vertica User Defined Functions (UDFs)
- ↳ Vertica External Procedures
- ↳ Vertica Analytics
- ↳ Vertica Management Console
- ↳ Vertica Error Codes
- ↳ Vertica Backup & Recovery
- ↳ Vertica Installation
- ↳ Vertica Security
- ↳ Vertica Performance Tuning
- ↳ Vertica Administration Tools
- ↳ Vertica Upgrade
- ↳ Vertica Migration
- ↳ Vertica and the Operating System
- ↳ Vertica Data Load
- ↳ Vertica Tips, Lessons and Examples
- ↳ Vertica "How to..."
- Connecting to Vertica
- ↳ ADO.NET
- ↳ Cognos
- ↳ DBeaver
- ↳ dbVisualizer
- ↳ HDFS Connector
- ↳ Hadoop Connector
- ↳ HCatalog Connector
- ↳ Informatica PowerCenter
- ↳ JDBC
- ↳ Microsoft SQL Server Analysis Services (SSAS)
- ↳ MicroStrategy
- ↳ Microsoft SQL Server Integration Services (SSIS)
- ↳ ODBC
- ↳ Perl
- ↳ PHP
- ↳ Python
- ↳ R Language Integration
- ↳ Rhapsody Interface Engine
- ↳ SQL Workbench/J
- ↳ SQuirreL SQL Client
- ↳ Talend
- ↳ Tableau
- ↳ Toad for Data Analysts
- ↳ Vertica SDK API
- ↳ VoltDB
- ↳ vSQL
- Vertica Portfolio
- ↳ Vertica Premium Edition
- ↳ Vertica Express Edition
- ↳ Vertica Community Edition
- ↳ Vertica SQL on Hadoop
- ↳ Vertica in the AWS Cloud
- ↳ Vertica on Microsoft Azure
- All times are UTC+01:00
- Top
- Delete all board cookies
Powered by phpBB ® | phpBB3 theme by KomiDesign