Setup DB Access in GCP Instance

PHOTO

Wed May 15 2024 05:33:48 GMT+0000 (Coordinated Universal Time)

Saved by @hardikraja #commandline #linux

#COMPLETE
#!/bin/bash

if ! grep -q 'REQUESTS_CA_BUNDLE=/etc/ssl/certs/ca-certificates.crt' ~/.bashrc; then \
	wget http://pki.bonprix.de/aia/bpRootCA01.crt; \
	openssl x509 -inform der -outform pem -in bpRootCA01.crt -out bpRootCA01-pem.crt; \
	sudo cp bpRootCA01-pem.crt /usr/local/share/ca-certificates/bpRootCA01.crt; \
	sudo update-ca-certificates --fresh; \
	if [ -x "$(command -v python)" ]; then
		python -m pip config set global.cert /etc/ssl/certs/ca-certificates.crt; \
	fi;
	echo 'export REQUESTS_CA_BUNDLE=/etc/ssl/certs/ca-certificates.crt' >> ~/.bashrc; \
	source ~/.bashrc; \
	export REQUESTS_CA_BUNDLE=/etc/ssl/certs/ca-certificates.crt; \
fi;
if [ ! -L /opt/oracle/instantclient ]; then \
	sudo rm -f /etc/profile.d/bp_envs.sh; \
	echo 'export ORACLE_HOME="/opt/oracle/instantclient"' | sudo tee /etc/profile.d/bp_envs.sh; \
	echo 'export TNS_ADMIN="/etc/oracle"' | sudo tee -a /etc/profile.d/bp_envs.sh; \
	echo 'export DYLD_LIBRARY_PATH="/opt/oracle/instantclient"' | sudo tee -a /etc/profile.d/bp_envs.sh; \
	echo 'export LD_LIBRARY_PATH="/opt/oracle/instantclient"' | sudo tee -a /etc/profile.d/bp_envs.sh; \
	echo 'export SQLPATH="/opt/oracle/instantclient"' | sudo tee -a /etc/profile.d/bp_envs.sh; \
	echo 'export PATH=$PATH:"/opt/oracle/instantclient"' | sudo tee -a /etc/profile.d/bp_envs.sh; \
	sh /etc/profile.d/bp_envs.sh; \
	sudo apt-get update && sudo apt-get install -q -y libaio1 gcc libc-dev; \
	cd /opt; \
	sudo curl -o oracle.tgz https://digistyle.bonprix.net/artifactory/docker-external/oracle/instantclient/19.3.0.0.0/instantclient-19.3.0.0.0.tar.gz; \
	sudo tar -xf oracle.tgz; \
	sudo rm -f oracle.tgz; \
	cd; \
	if [ ! -x "$(command -v git)" ]; then
		sudo apt-get update && sudo apt-get install git -y -q; \
	fi;
 	git clone https://ai-squad-fetch-token:glpat-H8y665Wgn9vhYuRE-eMG@gitlab-es.bonprix.work/em-ps-admin/tnsnames; \
	sudo mkdir -p /etc/oracle; \
	sudo mv tnsnames/tnsnames.ora /etc/oracle/; \
	sudo rm -r tnsnames; \
	sudo reboot; \
fi;

COPY

Save snippets that work from anywhere online with our extensions

Comments

Bonprix_Office

@hardikraja

Get latest tnsnames.ora and copy to instance /etc/oracle Setup DB Access in GCP Instance

#javascript #nodejs #commandline

HTTPS Redirect in Nodejs

npm install heroku-ssl-redirect

> More steps

#commandline #interesting #windows #ubuntu #linux

Useful snippet to easily access Ubuntu from Windows (in WSL2)

ip addr | grep eth0 | grep inet | awk '{print $2}' | awk -F '/' '{print $1}' | awk '{printf "%s:3000", $0}' | clip.exe

#commandline #interesting #cyberattacks #security #unix

The Fork-bomb: the One-Line Virus of colons and brackets that would crash a Unix system

: ( ) { : | : & } ; :

#commandline #git #github #howto

Cloning a Github Repository with git

$ git clone https://github.com/YOUR-USERNAME/YOUR-REPOSITORY

#mbpfan #ubuntu20.04 #commandline #macbookpro #terminal #fanspeed

A beginner's tutorial for mbpfan under Ubuntu - I need coffee ☕️

https://ineed.coffee/Old+Posts/A+beginner's+tutorial+for+mbpfan+under+Ubuntu

#installation #linux #bash #wsl #github #cli

Install gh-cli (Linux)

#!/usr/bin/env bash

# install github-cli
VERSION=`curl  "https://api.github.com/repos/cli/cli/releases/latest" | grep '"tag_name"' | sed -E 's/.*"([^"]+)".*/\1/' | cut -c2-`
echo $VERSION
mkdir ~/downloads
curl -sSL https://github.com/cli/cli/releases/download/v${VERSION}/gh_${VERSION}_linux_amd64.tar.gz -o ~/downloads/gh_${VERSION}_linux_amd64.tar.gz
cd ~/downloads
tar xvf gh_${VERSION}_linux_amd64.tar.gz
sudo cp gh_${VERSION}_linux_amd64/bin/gh /usr/local/bin/
gh version
sudo cp -r ~/downloads/gh_${VERSION}_linux_amd64/share/man/man1/* /usr/share/man/man1/
# man gh
gh auth login

rm -r ~/downloads

#commandline #git

How to Discard all Unstaged Local Changes in git

git checkout -- .

#python #commandline

Download playlist from youtube

pip install youtube-dl
youtube-dl --yes-playlist --write-auto-sub https://www.youtube.com/playlist?list=PLJ8cMiYb3G5czofUrrizDiyC_yNLOe_CF

#commandline #javascript #tutorial #react

Creating a CLI to Automate File Creation

https://dev.to/m0nica/automating-file-creation-with-javascript-8j5

#commandline

Useful Git Commands - DEV Community

https://dev.to/lydiahallie/cs-visualized-useful-git-commands-37p1

#commandline

server - Reset default permissions for /var/www - Ask Ubuntu

sudo find /var/www/ -type d -exec chmod 755 {} \;
sudo find /var/www/ -type f -exec chmod 644 {} \;

#commandline

REACTEUSE

(REACT JS)
npx create-react-app <app>
-npm run start , build ...
-yarn start , build ...

(REACT NATIVE CLI)
npx react-native init <app>
-npx react-native start
-npx react-native run-android (run_ios)

(REACT NATIVE EXPO CLI)
expo init <app>
-npm start

#commandline

Copy from child to parent

cd /path/to/child/directory
cp ./* ../ -R

#terminal #commandline

PYTHON

python@3.8 is keg-only, which means it was not symlinked into /usr/local,
because this is an alternate version of another formula.

If you need to have python@3.8 first in your PATH run:
  echo 'export PATH="/usr/local/opt/python@3.8/bin:$PATH"' >> ~/.zshrc

For compilers to find python@3.8 you may need to set:
  export LDFLAGS="-L/usr/local/opt/python@3.8/lib"

For pkg-config to find python@3.8 you may need to set:
  export PKG_CONFIG_PATH="/usr/local/opt/python@3.8/lib/pkgconfig"

➜  ~ python --version
zsh: command not found: python3.8
➜  ~ vim .zshrc
➜  ~ source .zshrc
➜  ~ echo 'export PATH="/usr/local/opt/python@3.8/bin:$PATH"' >> ~/.zshrc
➜  ~ source .zshrc

#commandline

Creating a github repository out of a local folder

git init
git add .
git commit -m "Message"

(Manually create a github repository without a readme file)
git remote add origin https://github.com/hassanms/typescript-practice.git
git branch -M main
git push -u origin main

Setup DB Access in GCP Instance

Save snippets that work from anywhere online with our extensions

Comments

More like this

Bonprix_Office

Browse more snippets >>

Setup DB Access in GCP Instance

Save snippets that work from anywhere online with our extensions

Comments

More like this

Bonprix_Office

Browse more snippets >>

Embed code snippet