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.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
