microsoft / microsoft/sql-server-samples
How to create dbm_certificate from where we are running the ansible playbook to create SQL database
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 11.2k
- Forks
- 9.1k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 14
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
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
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.
Assessment
- Tech stack
- ansible, sql, ubuntu
- Domain
- databases, devops, security
- Issue type
- Documentation
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100