Set up Azure SQL in Certificate Manager using Podman
This article is new for Certificate Manager 8.10.4.
This article describes how to install and set up the Azure SQL database, used in Smart ID Certificate Manager (CM).
For detailed information about how to install Azure SQL, see the documentation available at https://azure.microsoft.com/en-us/products/azure-sql/database/.
Prerequisites
Install the Azure SQL database according to the instructions for the downloaded Azure SQL installation package.
Extract the Azure SQL database scripts create_login.sql, create_cmdb.sql, add_bootca.sql, located at certificate-manager-8.X.Y-Z.zip\cmdb-install-tool-8.X.Y.zip\install\AzureSQL, from the server containerization zip file.
Step-by-step instruction
Edit settings on the Azure SQL server
Change the password for the
lcmreq
user, that will be created by the script below. The default password is REQreq01.Login as a user with administrative rights. It will be used to execute the scripts.
On the master database, run the script that creates the
lcmreq
login:CODEcreate_login.sql
Check the log file and verify that the script was successful.
On the CMDB database, run the script for creating the CMDB tables:
CODEcreate_cmdb.sql
Check the log file and verify that the script was successful.
On the CMDB database, Run the script for adding the bootca:
> add_bootca.sql
Check the log file.
Edit settings on the CM server
Navigate to the volume hosting the cm server config directory and update the database parameters in cm.conf
Database.name
Database.user
Database.password