DERs/DERS-DB

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