While trying to install and run mongo on Kali Linux, I encountered the following error.
zsh: illegal hardware instruction mongo
Using a Bash shell it returns the following instead.
Illegal instruction
It appears that the issue is from running mongo in a virtual machine.
Resolution? Run on bare metal or find a way to enable avx2 in the virtual machine.
While the UniFi controller is nice and everything, it does make it hard to see if a device is already adopted. At least if you have a ton of sites. Fortunately, we can search the database directly to find out if a UniFi is already adopted and which site it is assigned to.
First we need to connect to MongoDB. And then we need to use the ace database.
mongo -port 27117
use ace
This command will list all the devices on the controller. Regardless of which site they are assigned to.
db.device.find({}, { site_id:"", ip : "", name :"", mac:""})
Example output
{ "_id" : ObjectId("563a4d94e4b054e5376fc600"), "mac" : { "_id" : ObjectId("563a4d94e4b054e5376fc600"), "mac" : "44:d9:e7:34:d1:08", "ip" : "192.168.1.200", "name" : "Main_WiFi", "site_id" : "39485e9abf0e9a047bcded96" }
{ "_id" : ObjectId("9873b39ed1f5d30a6738abe"), "mac" : "44:d9:e7:01:a3:d4", "ip" : "192.168.1.201", "name" : "Testing_Wifi", "site_id" : "39485e9abf0e9a047bcded96" }
Each UniFi will have a “site_id”. You can use that ID to figure out which site it is assigned to.
db.site.find()
Example output
{ "_id" : ObjectId("39485e9abf0e9a047bcded96"), "name" : "default", "desc" : "Testing Site", "attr_hidden_id" : "default", "attr_no_delete" : true, "anonymous_id" : "83ae20ba-2948-458e-fd0a-1320583ecb04" }
Using our “site_id” from above, we see that the Testing_Wifi device is assigned to the “Testing Site” on the controller.
Something else to look at would be to use the UniFi controller API.
Ran into an issue when trying to figure out some problems with UniFi and UniFi-Video. Upgrading both to the latest version was causing problems, because they both needed different versions of MongoDB.
Was getting the following error when trying to install MongoDB. Think I was trying to install Mongo following the instructions on their site and then it caused issues with apt.
dpkg: error processing archive /var/cache/apt/archives/mongodb-org-server_4.2.5_amd64.deb (--unpack):
trying to overwrite '/usr/bin/mongod', which is also in package mongodb-server-core 1:3.6.3-0ubuntu1.1
dpkg-deb: error: paste subprocess was killed by signal (Broken pipe)
Removed the following file
rm /etc/apt/sources.list.d/mongodb-org-4.2.list
and was able to use apt again to install MongoDB. Didn’t end up solving my problem because I technically needed two versions, but at least apt was being nice again. Ended up installing the UniFi controller docker container and can run both on the same server that way.
Looks like the issue is that the UniFi server can’t be installed with a version of MongoDB newer then 3.6.0
Fix the issue by installing an older version of MongoDB
wget -qO - https://www.mongodb.org/static/pgp/server-3.4.asc | sudo apt-key add - echo "deb https://repo.mongodb.org/apt/ubuntu xenial/mongodb-org/3.4 multiverse" | sudo tee /etc/apt/sources.list.d/mongodb-org-3.4.list sudo apt-get update
Then install MongoDB with
apt install mongodb-org-server
You may run into issues if you already have a version of Mongo installed. Uninstall it and then rerun the above install command.
Connect to Mongo database
mongo
Connect to Mongo on a different port (May be needed. Port is for UniFi server)
mongo -port 27117
Show Databases
show dbs
Use database
use dbname
Show tables/collections
show collections
or
show tables
List contents of table/collection
db.collection.find()
Example: (This example prints everything in the “admin” collection)
db.admin.find()
Find info that line that whose name is admin
db.admin.find({name : "admin" })
Find everything in a table, but only print columns that are named “name, email, and x_shadow”
db.admin.find({ }, { name : "", email : "", "x_shadow" : "" })
List users
show users
Authenticate
db.auth("username","password")
Insert into table/collection
d = {"data":"data"}
db.collection.insert(d)
Update a line, for example a users password. Swap out the ObjectId for the ID that mongo gives you when you list the admins or users. You will need to swap out the hash for the hash of the password you want.
db.admin.update({"_id" : ObjectId("a328bf90547ehc429a03ed85")}, {$set: { "x_shadow" : "$6$XB32GMXr$8dUt9huJzzL6O.gGZbs7QH1npldbzBzNDt/uUO1bI3b7Ij3YipgubtVHwincUUZjnDLh.KDI36uh2gUCID9yb1"}});
Example:
d = {"name":"admin","lang":"en_US","x_password":"password","time_created":"","last_site_name":"default"}
db.admin.insert(d)
Delete line from table/collection
db.collection.remove()
Example: (This will look for all the “rows” where the “name” contains “admin” and remove it)
db.admin.remove({ name: "admin"})
UniFI Specific
The following commands are specifically for a UniFi server.
Show UniFi Sites
db.site.find().forEach(printjson);
Or
mongo --port 27117 ace --eval "db.site.find().forEach(printjson);"
Show UniFi admins
db.admin.find().forEach(printjson);
Or
mongo --port 27117 ace --eval "db.admin.find().forEach(printjson);"