Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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 [[email protected] ~]$ 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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.