Connect to Mongo database<\/p>\n
mongo<\/pre>\nConnect to Mongo on a different port (May be needed. Port is for UniFi server)<\/p>\n
mongo -port 27117<\/pre>\nShow Databases<\/p>\n
show dbs<\/pre>\nUse database<\/p>\n
use dbname<\/pre>\nShow tables\/collections<\/p>\n
show collections<\/pre>\nor<\/p>\n
show tables<\/pre>\nList contents of table\/collection<\/p>\n
db.collection.find()<\/pre>\nExample: (This example prints everything in the “admin” collection)<\/p>\n
db.admin.find()<\/pre>\nFind info that line that whose name is admin<\/p>\n
db.admin.find({name : \"admin\" })<\/pre>\nFind everything in a table, but only print columns that are named “name, email, and x_shadow”<\/p>\n
db.admin.find({ }, { name : \"\", email : \"\", \"x_shadow\" : \"\" })<\/pre>\nList users<\/p>\n
show users<\/pre>\nAuthenticate<\/p>\n
db.auth(\"username\",\"password\")<\/pre>\nInsert into table\/collection<\/p>\n
d = {\"data\":\"data\"}\ndb.collection.insert(d)<\/pre>\nUpdate 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.<\/p>\n
db.admin.update({\"_id\" : ObjectId(\"a328bf90547ehc429a03ed85\")}, {$set: { \"x_shadow\" : \"$6$XB32GMXr$8dUt9huJzzL6O.gGZbs7QH1npldbzBzNDt\/uUO1bI3b7Ij3YipgubtVHwincUUZjnDLh.KDI36uh2gUCID9yb1\"}});<\/pre>\nExample:<\/p>\n
d = {\"name\":\"admin\",\"lang\":\"en_US\",\"x_password\":\"password\",\"time_created\":\"\",\"last_site_name\":\"default\"}\ndb.admin.insert(d)<\/pre>\nDelete line from table\/collection<\/p>\n
db.collection.remove()<\/pre>\nExample: (This will look for all the “rows” where the “name” contains “admin” and remove it)<\/p>\n
db.admin.remove({ name: \"admin\"})<\/pre>\n\n\nUniFI Specific <\/strong><\/p>\n\n\n\n
The following commands are specifically for a UniFi server. <\/em><\/p>\n\n\n\n
Show UniFi Sites<\/p>\n\n\n\n
db.site.find().forEach(printjson);<\/pre>\n\n\n\nOr<\/p>\n\n\n\n
mongo --port 27117 ace --eval \"db.site.find().forEach(printjson);\"<\/pre>\n\n\n\nShow UniFi admins<\/p>\n\n\n\n
db.admin.find().forEach(printjson);<\/pre>\n\n\n\nOr<\/p>\n\n\n\n
mongo --port 27117 ace --eval \"db.admin.find().forEach(printjson);\"<\/pre>\n\n\n\n<\/p>\n","protected":false},"excerpt":{"rendered":"
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 … Continue reading