techwebdev

## mysql_remote.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                techwebdev
                / mysql_remote.md
            
            
              Last active
              August 12, 2023 06:50
            
              
                My sql allow for remote
              
          
    Allow Mysql For Remote in Ubuntu

check this blog link for more info blog
Access Mysql


Above 14.0 ubuntu version
edit this file nano /etc/mysql/mysql.conf.d/mysqld.cnf
14 or below ubuntu version
edit this file nano /etc/mysql/my.cnf
Under the [mysqld] block Locate the Line,


## export_and_upload_to_s3.sh
#!/bin/bash

# Written 2018-11-15 by 4410287
# This script will create a backup file of a postgres database and compress it.  It is capable of access a local or remote server to pull the backup.  After creating a new backup, it will delete backups that are older than 15 days, with the exception of backups created the first of every month.  It is recommended to create a seperate database user specifically for backup purposes, and to set the permissions of this script to prevent access to the login details.  Backup scripts for different databases should be run in seperate folders or they will overwrite each other.

HOSTNAME=
USERNAME=
PASSWORD=
DATABASE=
FILENAME=$(date +%Y-%m-%d).backup.sql

## PaytmChecksum.py
import base64
import string
import random
import hashlib
import sys

from Crypto.Cipher import AES


iv = '@@@@&&&&####$$$$'

## run_storefront.sh
export APP_MOUNT_URI=/dashboard/
export API_URI=http://3.6.136.178:8000/graphql/
cd /home/ubuntu/codes/backend/storefront && npm start

## run_dashboard.sh
export APP_MOUNT_URI=/dashboard/
export API_URI=http://3.6.136.178:8000/graphql/

cd /home/ubuntu/codes/backend/saleor-dashboard && npm start

## saleor_bash_rc_updates.txt
# Update below variables in ~/.bashrc file.
# change below x.x.x.x to your server ip or 127.0.0.1 for localhost
export ALLOWED_HOSTS=x.x.x.x
export ALLOWED_CLIENT_HOSTS=x.x.x.x
export DEBUG=True
export SECRET_KEY=123456
export INTERNAL_IPS=127.0.0.1,x.x.x.x,
export DEFAULT_COUNTRY=IN
export DEFAULT_CURRENCY=INR
export APP_MOUNT_URI=/dashboard/

## saleor_storefront_install.txt
# setup storefront
git clone https://github.com/mirumee/saleor-storefront.git
cd saleor-storefront
git checkout 2.10.1
npm i
  vim package.json : --host 0.0.0.0
npm start

## cloudSettings
{"lastUpload":"2021-06-20T11:08:47.616Z","extensionVersion":"v3.4.3"}

## node_nginx_ssl.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                techwebdev
                / node_nginx_ssl.md
            
            
              Created
              November 6, 2020 18:51
                — forked from bradtraversy/node_nginx_ssl.md
            
              
                Node app deploy with nginx & SSL
              
          
    Node.js Deployment


Steps to deploy a Node.js app to DigitalOcean using PM2, NGINX as a reverse proxy and an SSL from LetsEncrypt

1. Sign up for Digital Ocean

If you use the referal link below, you get $10 free (1 or 2 months)
https://m.do.co/c/5424d440c63a
2. Create a droplet and log in via ssh

I will be using the root user, but would suggest creating a new user
	#!/bin/bash

	# Written 2018-11-15 by 4410287
	# This script will create a backup file of a postgres database and compress it. It is capable of access a local or remote server to pull the backup. After creating a new backup, it will delete backups that are older than 15 days, with the exception of backups created the first of every month. It is recommended to create a seperate database user specifically for backup purposes, and to set the permissions of this script to prevent access to the login details. Backup scripts for different databases should be run in seperate folders or they will overwrite each other.

	HOSTNAME=
	USERNAME=
	PASSWORD=
	DATABASE=
	FILENAME=$(date +%Y-%m-%d).backup.sql
	import base64
	import string
	import random
	import hashlib
	import sys

	from Crypto.Cipher import AES


	iv = '@@@@&&&&####$$$$'
	export APP_MOUNT_URI=/dashboard/
	export API_URI=http://3.6.136.178:8000/graphql/
	cd /home/ubuntu/codes/backend/storefront && npm start
	export APP_MOUNT_URI=/dashboard/
	export API_URI=http://3.6.136.178:8000/graphql/

	cd /home/ubuntu/codes/backend/saleor-dashboard && npm start
	# Update below variables in ~/.bashrc file.
	# change below x.x.x.x to your server ip or 127.0.0.1 for localhost
	export ALLOWED_HOSTS=x.x.x.x
	export ALLOWED_CLIENT_HOSTS=x.x.x.x
	export DEBUG=True
	export SECRET_KEY=123456
	export INTERNAL_IPS=127.0.0.1,x.x.x.x,
	export DEFAULT_COUNTRY=IN
	export DEFAULT_CURRENCY=INR
	export APP_MOUNT_URI=/dashboard/
	# setup storefront
	git clone https://github.com/mirumee/saleor-storefront.git
	cd saleor-storefront
	git checkout 2.10.1
	npm i
	vim package.json : --host 0.0.0.0
	npm start