Attach a sql database running SQL Server on EC2

Here are the steps to attach a SQL db  Copy the database data and log files to /var/opt/mssql/data Run chmod 777 for the data and log file Connect to Sql Server using sqlcmd command line: sq [...]

Mount S3 bucket to EC2 instance

Many systems provide pre-built packages: Amazon Linux via EPEL: sudo amazon-linux-extras install epel sudo yum install s3fs-fuse Enter your credentials in a file ${HOME}/.passwd-s3fs and [...]

How to resize a Linux VM OS disk in Azure

The default OS disk size for most Linux distros in Azure is 30GB. While Linux makes it easy to add other disks as mount points, you may wish to increase the size of the OS disk using the steps in th [...]

Open SSL Commands

## Generate a new private key and Certificate Signing Request openssl req -out CSR.csr -new -newkey rsa:2048 -nodes -keyout privateKey.key ## Generate a self-signed certificate (see How to Create [...]

Install Jenkins in Amazon Linux2

# Step1. Install Java on Amazon Linux sudo amazon-linux-extras install java-openjdk11 # Step 2. Download Jenkins sudo wget -O /etc/yum.repos.d/jenkins.repo [...]

Sample nginx vhsot config file

server{ listen 80; server_name; root /path/to/your/www; index index.php; location / { try_files $uri $uri/ =404; [...]

Uninstall MySql on a Mac OS X

To uninstall MySQL and completely remove it (including all databases) from your Mac do the following: Open a terminal window and use mysqldump to backup your databases.Stop the database server sudo [...]

VMWare shared folder as apache vhost

Step 1. Find the apache user and group id as id -u apache id -g apache Step 2: open vmware-tools files add apache user to the shared folder as sudo vim /etc/init.d/vmware-tools Step 3: Update [...]

Install Redis Server in CentOS

Install necessary packages On CentOS 6: yum install wget make gcc tcl On CentOS 7 yum install wget make gcc Install Redis 3.2 For installing Redis 3.2 you have to download the source file and [...]

How To Repair A Suspect Database In MSSQL

Possible Causes The database could have become corrupted. There is not enough space available for the SQL Server to recover the database during startup. The database cannot be opened due to [...]