MSSQL database migration to another database server

When a database is migrated to another server by copying the database file or restoring it from a backup file, the original database user account references are also carried with it. Those accounts contain the account IDs specific to the original database server. To provide access to the restored database on the new database server …

RuntimeError: Volume vol-… attached at xvdf but does not conform to this resource’s specifications

When the Chef aws cookbook’s ebs_volume.rb resource tries to bring a volume online, partition, and format it we get the error message: RuntimeError: Volume vol-… attached at xvdf but does not conform to this resource’s specificationsC:/chef/cache/cookbooks/aws/resources/ebs_volume.rb:46:in `block in class_from_file’ Make sure the “size” attribute value in the aws_ebs_volume resource call matches the actual size of …

The installation of this package failed

When we tried to install the Microsoft Access Database Engine and Office 2007 System Driver on a Windows Server 2016 an error message popped up immediately: The installation of this package failed When we ran the installation with the logging option, we have found a message at the bottom of the file: Will create the …

Invoke-WebRequest : The request was aborted: Could not create SSL/TLS secure channel.

Older PowerShell versions do not use TLS1.2 as the default version during the SSL handshake. When the API requires TLS1.2 the error message appears:  Invoke-WebRequest : The request was aborted: Could not create SSL/TLS secure channel.  To force PowerShell to use TLS1.2 during the SSL handshake, issue this command before executing the Invoke-Webrequest

Extend a Linux partition

When the Linux disk drive is full, first we need to identify the reason for the drive overuse. Many times the drive is filled with one large log file, that can be identified and truncated. To list the directory sizes under the current directory execute To empty a file, overwrite it with nothing, so the …

Blue-green deployment in AWS ECS Fargate with CodeDeploy

We will use CodeDeploy to automate the application deployment in our AWS ECS Fargate cluster. Create an AIM role for CodeDeploy to assume the ECS service role In the AWS console navigate IAM and click the Roles link Click the Create role button Click the CodeDeploy link Select CodeDeploy ECS Keep the default setting Enter …

Host the server container in an AWS ECS Fargate cluster

We have already created a Docker image for the server using Nginx. We will create an AWS ECS Fargate cluster in AWS and host the container there. Create an ECR repository for the image Select the Elastic Container Registry Create a new repository Enter a name, enable Tag immutability and Scan on push Select the repository you just …

Host a static web application in AWS S3

We will host our static website in AWS S3. Install the AWS SDK Node.js module Configure the AWS CLI with the access key and secret key in the ~/.aws/credentials file to access your AWS account. Host the static website of the client in an S3 bucket Create an S3 bucket using the AWS console To be able …

Deploy a new version of a task in an ECS Fargate cluster

To deploy the new version of a Docker container image and launch new tasks with the new version Build and push the new Docker image Build the new Docker container image Push the new image to ECR (Elastic Container Registry) Create a new revision of the ECS Task Definition Open the ECS section of the …

Attach an AWS EBS volume to a Linux server

Format and mount the volume List the available disk devices and their mount points The nvme1n1 volume is not yet mounted Create a partition on the volume List the existing partitions Create a new partition Check the partition list lsblk Detect the new partition with If there is a file system on the partition to …