We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Problems with SSL enabled, password free authentication from ADO.NET driver — Vertica Forum

Problems with SSL enabled, password free authentication from ADO.NET driver

Client side exception message: The message received was unexpected or badly formatted Connection string: "Host=192.168.73.131;Port=5433;Database=dbadmin;User=dbadmin;SSL=True" Here's how I configured it: 1. Generating certifications and keys mkdir ssl cd ssl openssl genrsa -des3 -out rootkey.pem openssl req -new -x509 -key rootkey.pem -out root.crt openssl genrsa -out server.key openssl req -new -out reqout.txt -key server.key openssl x509 -req -in reqout.txt -days 3650 -sha1 -CAcreateserial -CA root.crt -CAkey rootkey.pem -out server.crt openssl genrsa -out client.key openssl req -new -out reqout.txt -key client.key openssl x509 -req -in reqout.txt -days 3650 -sha1 -CAcreateserial -CA root.crt -CAkey rootkey.pem -out client.crt cp ./server.key /home/dbadmin/vertica/catalog/ssltestdb/v_ssltestdb_node0001_catalog cp ./server.crt /home/dbadmin/vertica/catalog/ssltestdb/v_ssltestdb_node0001_catalog cp ./root.crt /home/dbadmin/vertica/catalog/ssltestdb/v_ssltestdb_node0001_catalog chmod 0600 server.key chmod 0600 server.crt chmod 0600 root.crt 2. Distributing certifications and keys 3. Enable SSL SELECT SET_CONFIG_PARAMETER('EnableSSL', '1'); 4. restart database 5. vsql test [dbadmin@vm-vertica ~]$ vsql Password: Welcome to vsql, the Vertica Analytic Database interactive terminal. Type: \h or \? for help with vsql commands \g or terminate with semicolon to execute query \q to quit SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256) dbadmin=> 6.Installing Certificates on Windows copy root.crt,server.crt,client.crt to windows client machine and install them successfully.

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file