June 2018
M T W T F S S
 123
45678910
11121314151617
18192021222324
252627282930  

Categories

June 2018
M T W T F S S
 123
45678910
11121314151617
18192021222324
252627282930  

How to reset your root MySQL password

Stop the MySQL process # service mysqld stop Once MySQL has stopped, restart it with the –skip-grant-tables option # mysqld_safe –skip-grant-tables & or edit your /etc/my.cnf file to add the line skip-grant-tables Connect to MySQL using the root user. mysql -u root Once logged in, you should see the following prompt: mysql> Enter the following […]

Reset SonarQube Admin User Password

Reset SonarQube Admin User Password

by default sonar creates admin account : user: admin, password : admin

Start root access to mysql database

mysql -uroot -p Copy Bash

Check if sonar database exists.

show databases; Copy SQL use sonar; Copy SQL

Reset admin user to admin password.

update users set crypted_password = ’88c991e39bb88b94178123a849606905ebf440f5′, salt=’6522f3c5007ae910ad690bb1bdbf264a34884c6d’ […]

git cmd

git pull # will get you repo updates git add . # will add files in your dir git add [dirname]/* # will add files under a new dir git commit -m “your comment“ # will commit your code to your changes git push # will push your code to a reposatory git pull […]

Git Fundamentals

Git Fundamentals

 

Topics To be Covered

Installation

2. Setup

3. Creating a Project

4. Checking the status of the repository

5. Making changes

6. Staging the changes

June 25th, 2018 | Category: GIT | Leave a comment

Setup and Run Jenkins

Installing Jenkins:

Download latest or specific version you want to install from here.

For example:

$ wget https://updates.jenkins-ci.org/download/war/2.123/jenkins.war Starting Jenkins

The easiest way to execute Jenkins is through the built in Jetty servlet container. You can execute Jenkins like this:

June 25th, 2018 | Category: Centos RHEL 7 | Leave a comment

How Remove Files completely from git repository history

It is straight forward to remove a file from the current commit or HEAD but if you want remove entirely from the repository’s history then you need to run couple of commands.

It took some trial and error for me to find something that worked for me

[…]

Create a HTTPS proxy for jenkins using NGINX

Create a HTTPS proxy for jenkins using NGINX

In situations where you have existing web sites on your server, you may find it useful to run Jenkins (or the servlet container that Jenkins runs in) behind Nginx, so that you can bind Jenkins to the part of a bigger website that […]

ssh tunnel for RDS AWS

ssh tunnel for RDS via bastion host

Our RDS db is hosted on Amazon. Our Bastion(Jumphost) can connect to the db. Connections to the db are not allowed outside of the internet.

 

 

Run ssh tunnel locally:

This creates a tunnel from my local machine to […]

Adding SMS Notifications to Your Bash Scripts

Cost Note: The first 100 text messages / month are free. After that, you may start incurring charges.

Step 1: Create an Appropriate AWS User

Start by creating a new User or Group in AWS with the appropriate privileges. You do NOT want to use your root account in production, for security reasons. I would […]

oracle databases server

oracle databases server

create database TEST MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 ‘C:\oraclexe\app\oracle\oradata\TEST\REDO01.LOG’ SIZE 50M BLOCKSIZE 512, GROUP 2 ‘C:\oraclexe\app\oracle\oradata\TEST\REDO02.LOG’ SIZE 50M BLOCKSIZE 512 DATAFILE’C:\oraclexe\app\oracle\oradata\TEST\SYSTEM.DBF’ size 100m autoextend on sysaux datafile ‘C:\oraclexe\app\oracle\oradata\TEST\SYSAUX.DBF’ size 100m autoextend on undo tablespace undotbs1 datafile ‘C:\oraclexe\app\oracle\oradata\TEST\UNDOTBS1.DBF’ size 100m autoextend on CHARACTER SET […]