Admin: Created page with "== Database Setup == cat < /etc/yum.repos.d/mongodb.repo [mongodb] name=MongoDB Repository baseurl=http://downloads-distro.mongodb.org/repo/redhat/os/x86_64/ gpgcheck=0 enabled=1 EOF yum -y install mongodb-org mongodb-org-server firewall-cmd --add-port 27017/tcp firewall-cmd --add-port 27017/tcp --permanent sed -i 's~bind_ip=127.0.0.1~#bind_ip=127.0.0.1~' /etc/mongod.conf systemctl enable mongod systemctl start mongod systemctl restart mongod == Creat..."

2023-06-02T19:11:53Z

Created page with "== Database Setup == cat <<EOF> /etc/yum.repos.d/mongodb.repo [mongodb] name=MongoDB Repository baseurl=http://downloads-distro.mongodb.org/repo/redhat/os/x86_64/ gpgcheck=0 enabled=1 EOF yum -y install mongodb-org mongodb-org-server firewall-cmd --add-port 27017/tcp firewall-cmd --add-port 27017/tcp --permanent sed -i 's~bind_ip=127.0.0.1~#bind_ip=127.0.0.1~' /etc/mongod.conf systemctl enable mongod systemctl start mongod systemctl restart mongod == Creat..."

New page

== Database Setup ==
cat <<EOF> /etc/yum.repos.d/mongodb.repo
[mongodb]
name=MongoDB Repository
baseurl=http://downloads-distro.mongodb.org/repo/redhat/os/x86_64/
gpgcheck=0
enabled=1
EOF
yum -y install mongodb-org mongodb-org-server
firewall-cmd --add-port 27017/tcp
firewall-cmd --add-port 27017/tcp --permanent
sed -i 's~bind_ip=127.0.0.1~#bind_ip=127.0.0.1~' /etc/mongod.conf
systemctl enable mongod
systemctl start mongod
systemctl restart mongod

== Create Multiple new PB Users ==
sed -i 's~auth=true~#auth=true~' /etc/mongod.conf
systemctl restart mongod
mongo
db.createUser( { "user": "admin", "pwd": "****", "roles": [ "readWrite", "dbAdmin" ] } )
use dersworkout
db.createUser( { "user": "p1user", "pwd": "****", "customData": { "level": "P1" }, "roles": [ "read" ] } )
db.createUser( { "user": "p2user", "pwd": "****", "customData": { "level": "P2" }, "roles": [ "read" ] } )
db.createUser( { "user": "p3user", "pwd": "****", "customData": { "level": "P3" }, "roles": [ "read" ] } )
db.createUser( { "user": "p4user", "pwd": "****", "customData": { "level": "P4" }, "roles": [ "read" ] } )
db.createUser( { "user": "admin", "pwd": "****", "roles": [ "readWrite" ] } )
var users = [ {user: "p1user", level: "P1"},{user: "p2user", level: "P2"},{user: "p3user", level: "P3"},{user: "p4user", level: "P4"},{user: "admin", level: "P4"}];
db.users.insert(users)
quit()
sed -i 's~#auth=true~auth=true~' /etc/mongod.conf
systemctl restart mongod

== Create new PB Users ==
sed -i 's~auth=true~#auth=true~' /etc/mongod.conf
systemctl restart mongod
mongo
use dersworkout
db.createUser( { "user": "pbuser", "pwd": "****", "customData": { "level": "CL" }, "roles": [ "read" ] } )
db.users.insert({user: "pbuser", level: "CL"})
quit()
sed -i 's~#auth=true~auth=true~' /etc/mongod.conf
systemctl restart mongod

== Show list of Collections ==
mongo
use dersworkout
db.auth('admin', '*****')
show collections
quit()

== Display a Collection ==
mongo
use dersworkout
db.auth('admin', '*****')
db.users.find()
db.PB2017Q3.find()
quit()

== Change Users Passwords ==
mongo
use dersworkout
db.auth('admin', '*****')
db.changeUserPassword("p1user", "*****")
quit()

== Drop a Collection ==
sed -i 's~auth=true~#auth=true~' /etc/mongod.conf
systemctl restart mongod
mongo
use dersworkout
db.PB2015Q2.drop()
quit()
sed -i 's~#auth=true~auth=true~' /etc/mongod.conf
systemctl restart mongod

DERs/DERS-DB - Revision history