Pavan Kumar Jadda pavankjadda

Setup Sonarqube with Postgres database using docker

Both Sonarqube and Postgres database should be same network in order communicate with each other. First create docker network using the following commands

Create docker network

Delete existing docker network and create new docker network sonarqube

docker network rm sonarqube_network
docker network create sonarqube_network

Run PostGres DB container

Sql Server with Spring Boot and Spring Data

In order to use SQL server with Spring Boot and Data JPA, we need to do the following

Add SQL server jdbc driver to pom.xml. Change the jre11 value to your JRE version

<dependency>
     <groupId>com.microsoft.sqlserver</groupId>
     <artifactId>mssql-jdbc</artifactId>
     <version>8.2.2.jre11</version>
 </dependency>

Clean uninstall MySql from MacOS

ps -ax | grep mysql
stop and kill any MySQL processes
brew remove mysql
brew cleanup
sudo rm /usr/local/mysql
sudo rm -rf /usr/local/var/mysql
sudo rm -rf /usr/local/mysql*
sudo rm ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

Open Terminal on local machine
Paste the text below, substituting in your email address.

  ssh-keygen -t rsa -b 4096 -C "[email protected]"

Copy the key to remote server using the following command. Enter the password when prompted

  ssh-copy-id username@server_ip_address

How to create Spring Boot app as Ubuntu service?

Create service named employee using vi command

sudo vim /etc/systemd/system/employee.service

Copy paste the following content into the file and make sure to change the ExecStart command arguments
```
[Unit]
Description=Employee Spring Boot application service
```

	<?xml version="1.0" encoding="UTF-8"?>
	<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-starter-parent</artifactId>
	<version>2.3.1.RELEASE</version>
	<relativePath/> <!-- lookup parent from repository -->
	</parent>



	### Server information
	server:
	port: 8080

	### Spring Properties
	spring:
	application:
	name: PRES 2.0

	package com.pj.hazelcastdemo.config;

	import com.hazelcast.config.Config;
	import com.hazelcast.config.NetworkConfig;
	import org.springframework.context.annotation.Bean;
	import org.springframework.context.annotation.Configuration;

	@Configuration
	public class HazelCastConfig
	{

	version: '3'
	services:
	hazelcast1:
	image: hazelcast/hazelcast
	environment:
	- 'JAVA_OPTS=-Dhazelcast.local.publicAddress=192.168.1.157:5701 -Dhazelcast.mancenter.url=http://mancenter:8090/mancenter -Dgroup.name=hz-compose -Dgroup.password=s3crEt'
	ports:
	- '5701:5701'
	links:
	- 'management-center:mancenter'

	singleServerConfig:
	address: "redis://localhost:6379"