Options

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