How to edit an environment variable in Windows:
In this tutorial, I will teach you how to make a remote Mongodb connection on the Google Cloud Platform
1. Edit mongod.conf
vim /etc/mongod.conf
2. Change bindIP to 0.0.0.0 or add your mongo host IP
bindIp: 0.0.0.0
or
bindIp: 127.0.0.1 <your mongodb host IP>
3. Save and restart mongod
sudo systemctl restart mongod
sudo systemctl status mongod
4. After that, go to your Google Cloud Platform console. and type
gcloud compute firewall-rules create allow-mongodb --allow tcp:27017
and the result is
allow-mongodb default INGRESS 1000 tcp:27017 False
Now you can remote you mongodb with mongodb client, try this command on your terminal to test connection.
mongo admin -u <mongo user> -p <mongo password> --host <your mongo host IP> --port 27017
change the tag <text> with your configuration
After you install mongodb and get the warning to enable access control. You can follow this step
1. Start MongoDB without access control. (No need, if service already running)
mongod --port 27017
2. Connect to the instance
mongo --port 27017
3. Create the user administrator
> use admin
switched to db admin
> db.createUser(
... {
... user: "superman",
... pwd: "rahasia",
... roles: [ { role: "root", db: "admin" } ]
... })
4. Re-start the MongoDB instance with access control
sudo service mongod restart
5. Add the security.authorization setting to the config file
sudo vi /etc/mongod.conf
systemLog:
destination: file
path: /usr/local/var/log/mongodb/mongo.log
logAppend: true
storage:
dbPath: /usr/local/var/mongodb
net:
bindIp: 127.0.0.1
security:
authorization: enabled
6. Restart mongodb
sudo service mongod restart
7. Connect to database
mongo --port 27017 -u "superman" -p "rahasia" --authenticationDatabase "admin"
now the warning has disappeared
How to Install MongoDB Community Edition, you can follow the steps in Mongodb documentation.
type this command on your terminal.
1. Import public key
wget -qO - https://www.mongodb.org/static/pgp/server-4.4.asc | sudo apt-key add -
2. create list of mongodb
echo "deb [ arch=amd64,arm64 ] https://repo.mongodb.org/apt/ubuntu bionic/mongodb-org/4.4 multiverse" | sudo tee /etc/apt/sources.list.d/mongodb-org-4.4.list
3. Reload local package
sudo apt-get update
4. Install the mongodb packages
sudo apt-get install -y mongodb-org
5. Start MongoDB
sudo systemctl start mongod
6. Verify the status
sudo systemctl status mongod
7. Using mongodb
mongo
if you got warning "Enable Access Control" when running mongodb. You can follow this step to fix it.
When using ubuntu or ubuntu server in the cloud and want the server time according to your country's time, then you can simply change it using the terminal.
root@ubuntu-server ~# date
Thu Aug 6 06:25:41 UTC 2020
root@ubuntu-server ~# sudo mv /etc/localtime /etc/localtime.orig
root@ubuntu-server ~# sudo ln -sf /usr/share/zoneinfo/Asia/Jakarta /etc/localtime
root@wms-dev ~# date
Thu Aug 6 13:26:28 WIB 2020
this can re-increment value of table on postgre
Example your table like that
UPDATE public.migrations SET id=10000+nextval('public.migrations_id_seq');
ALTER SEQUENCE public.migrations_id_seq RESTART WITH 1;
UPDATE public.migrations SET id=nextval('public.migrations_id_seq');
Run the following commands inside the new virtual private server to update its OS and install Algo VPN core prerequisites:
apt-add-repository -y ppa:ansible/ansible apt-get -y update apt-get -y upgrade apt-get -y install build-essential \ libssl-dev \ libffi-dev \ python-dev \ python-pip \ python-setuptools \ python-virtualenv
git clone https://github.com/trailofbits/algo cd algo python -m virtualenv env source env/bin/activate python -m pip install -U pip python -m pip install -r requirements.txtSet up the username for the people who will be using the VPN. To accomplish this, use your favorite text editor, such as Nano or Vim to edit the config.cfg file in the ~/algo directory:
vim config.cfgremove the lines that represent the default users phone, laptop, and desktop add your own (e.g., john), so that the corresponding section of the file looks like this:
users: - johndoesaving the file and exiting the text editor, execute the following command in the ~/algo directory to install Algo software:
./algoWhen prompted by the installer, select the option to install “to existing Ubuntu 18.04 server”:
mkdir configs
cd configs
sftp deploy@{your-server-ip-address}
cd algo/configs/{your-server-ip-address}
get -r *
exit
