How to create dbm_certificate from where we are running the ansible playbook to create SQL database

Open
#1,041 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
3/5
Estimated time
1-2 days
Newbie friendliness
25/100
Issue type
Documentation
Clarity
Needs clarification
Activity status
Stale
Tech stack
ansible, sql, ubuntu
Domain
databases, devops, security

Research direction

Start with play.yml in the linked Linux high-availability Ansible Playbook and identify how the certificate private and public key paths are defined. Determine what guidance is missing for creating or supplying those keys outside SQL Server and fully automating deployment. Done means the playbook documentation clearly explains the certificate inputs and the automated HA setup.

Written by the indexing model from the issue text.

Description

Hi
I am trying to deploy an SQL cluster to a couple of ubuntu machines using the playbook given in the link below
https://github.com/microsoft/sql-server-samples/tree/master/samples/features/high%20availability/Linux/Ansible%20Playbook

In the play.yml, it is mentioned to give the certificates private and public key file paths as variables. I don't know how to create these keys outside of an SQL server. I want to fully automate the cluster's deployment and enable ha to the cluster.

Thank you

Dominant language
PowerShell
Stars
11.2k
Forks
9.1k
Avg merge
2d 7h
Merged PRs (30d)
14

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from microsoft/sql-server-samples

All issues in microsoft/sql-server-samples

Similar issues

More Databases issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.