Internal / Azure

Deploy new Scifeon Instance to Azure

Last updated on 11-Sep-2017 by Jakob Jakobsen Boysen
Jakob Jakobsen Boysen

Platform Lead
boysen@scifeon.com
On this page

1. Create database

  • Database name: Scifeon_SQL_[customer]_[Prod|Test]_YYYYMMDD
  • Database Server: scirex-customers1-west-europe.database.windows.net

Create new database here: https://portal.azure.com/#blade/HubsExtension/Resources/resourceType/Microsoft.Sql%2Fservers%2Fdatabases

Database Name: Scifeon_SQL_[customer]_[Prod|Test]_YYYYMMDD
Resource Group: Scifeon-Customers-West-Europe
Server: scirex-customers1-west-europe.database.windows.net
Pricing Tier: Basic
Copy

2. Connect to Database Server using SQL Server Management Studio

Database data user

Create a new database data user (save password in deployment_keys.kdbx - use master password from GoogleDrive/KeePass/Scifeon.kdbx/deployment_keys.kdbx):

On master database:

CREATE LOGIN Scifeon_SQL_[customer]_[Prod|Test]_YYYYMMDD WITH PASSWORD = '<strong password>'
GO
Copy

On database Scifeon_SQL_[customer]_[Prod|Test]_YYYYMMDD:

CREATE USER Scifeon_SQL_[customer]_[Prod|Test]_YYYYMMDD
    FOR LOGIN Scifeon_SQL_[customer]_[Prod|Test]_YYYYMMDD
    WITH DEFAULT_SCHEMA = dbo
GO

-- Add user to the database owner role
EXEC sp_addrolemember N'db_datareader', N'Scifeon_SQL_[customer]_[Prod|Test]_YYYYMMDD'
GO
EXEC sp_addrolemember N'db_datawriter', N'Scifeon_SQL_[customer]_[Prod|Test]_YYYYMMDD'
GO
Copy

Database DDL user

Create a new user for updating tables, views, etc. (save password in deployment_keys.kdbx - use master password from GoogleDrive/KeePass/Scifeon.kdbx/deployment_keys.kdbx) - notice the __DDL_-postfix on the username:

On master database:

CREATE LOGIN Scifeon_SQL_[customer]_[Prod|Test]_YYYYMMDD_DDL WITH PASSWORD = '<strong password>'
GO
Copy

On database Scifeon_SQL_[customer]_[Prod|Test]_YYYYMMDD:

CREATE USER Scifeon_SQL_[customer]_[Prod|Test]_YYYYMMDD_DDL
    FOR LOGIN Scifeon_SQL_[customer]_[Prod|Test]_YYYYMMDD_DDL
    WITH DEFAULT_SCHEMA = dbo
GO

-- Add user to the database owner role
EXEC sp_addrolemember N'db_datareader', N'Scifeon_SQL_[customer]_[Prod|Test]_YYYYMMDD_DDL'
GO
EXEC sp_addrolemember N'db_datawriter', N'Scifeon_SQL_[customer]_[Prod|Test]_YYYYMMDD_DDL'
GO
EXEC sp_addrolemember N'db_ddladmin', N'Scifeon_SQL_[customer]_[Prod|Test]_YYYYMMDD_DDL'
GO
Copy

2. App Service

  • [app_service_plan_test1]: Scifeon-Test-West-Europe S1 (max 10 instances)
  • [app_service_plan_prod1]: Scifeon-Prod-West-Europe S1 (max 10 instances)

App services are hosted in App Service Plans. The name of the App Service Plan indicates where the App Service Plan is hosted.

Create App Service

Create new App Service here: https://portal.azure.com/#blade/HubsExtension/Resources/resourceType/Microsoft.Web%2Fsites Choose Web App > Create

App name: Scifeon-[customer]-[Prod|Test]-YYYYMMDD
Resource Group: Scifeon-Customers-West-Europe
App Service Plan/Location: Scifeon-[Prod|Test]-West-Europe
Copy

After creation, open the App Service > Application Settings > Set "Always On" to "On" > Save

3. DNS and SSL

  1. Go to One.com DNS administration: https://www.unoeuro.com/controlpanel/dns.php
  2. Add new DNS CNAME record: [customer]-[test].scirex.cloud > Scifeon-[customer]-[Prod|Test]-YYYYMMDD.azurewebsites.net
  3. Add the hostname to the App Service (Custom Domains > Add hostname)

SSL: See this guide

4. Deploy using VSTS

Go to VSTS: https://scifeon.visualstudio.com/Scifeon/_apps/hub/ms.vss-releaseManagement-web.cd-workflow-hub?definitionId=1&_a=environments-editor-preview

  1. Clone an existing [Customer].[Env] environment:
  2. Name the environment: [Customer].[Env] where [Customer] should match a root group in the deployment_keys.kdbx-file, and [Env] should match a sub-group of the root group.
  3. Make sure the Trigger is Manual Only
  4. Change the App Service in the "Deployment process" (where environment name is set)
  5. Release and Deploy (only the new environment, i.e. deselect automatic deployment of test)
On this page