Since from the first time to use MongoDB in my own project, more than one month has passed. During this last month, I have to say MongoDB is powerful, and suit my project well, but it is hard to manage/admin the database. and the way of display json data is ugly by the build-in mongo commomd. For instance,
> db.User.find()
{ "_id" : ObjectId("4f657b5e6803fa511a000000"), "about" : "Change the way people learn", "blackListCreateTime" : "2012-03-16 13:00", "createTime" : "2012-03-16 13:00", "email" : "admin@stdtlk.com", "fanCreateTime" : "2012-03-16 13:00", "fanId" : [ ObjectId("4f657b5e6803fa511a000000"), ObjectId("4f657b5e6803fa511a000000") ], "firstName" : "chan", "lastName" : "chen", "levle" : "0", "password" : "admin", "photoURL" : "img/admin.jpg", "school" : "Stdtlk University", "title" : "starter" }
{ "_id" : ObjectId("4f6582986803fa3d1a000000"), "about" : "I like the way to learn", "blackListCreateTime" : "2012-03-16 13:00", "createTime" : "2012-03-16 13:00", "email" : "google@stdtlk.com", "fanCreateTime" : "2012-03-16 13:00", "fanId" : [ ObjectId("4f657b5e6803fa511a000000"), ObjectId("4f657b5e6803fa511a000000") ], "firstName" : "google", "lastName" : "google", "levle" : "0", "password" : "google", "photoURL" : "img/google.jpg", "school" : "AAA University", "title" : "starter" }
{ "_id" : ObjectId("4f6582cc6803fa501a000003"), "about" : "Apple is greate", "blackListCreateTime" : "2012-03-16 13:00", "createTime" : "2012-03-16 13:00", "email" : "apple@stdtlk.com", "fanCreateTime" : "2012-03-16 13:00", "fanId" : [ ObjectId("4f657b5e6803fa511a000000"), ObjectId("4f657b5e6803fa511a000000") ], "firstName" : "apple", "lastName" : "apple", "levle" : "0", "password" : "apple", "photoURL" : "img/apple.jpg", "school" : "BBB University", "title" : "starter" }
{ "_id" : ObjectId("4f6582ec6803faa91c000000"), "about" : "microsoft is old", "blackListCreateTime" : "2012-03-16 13:00", "createTime" : "2012-03-16 13:00", "email" : "microsoft@stdtlk.com", "fanCreateTime" : "2012-03-16 13:00", "fanId" : [ ObjectId("4f657b5e6803fa511a000000"), ObjectId("4f657b5e6803fa511a000000") ], "firstName" : "microsoft", "lastName" : "microsoft", "levle" : "0", "password" : "microsoft", "photoURL" : "img/microsoft.jpg", "school" : "CCC University", "title" : "starter" }
All documents are outputted in one line, if the document has a field which have huge length of characters, it is not easy to find out and read what we look for. So I look around on the internet, and read the
MongoDB Admin UI, it recommend some useful tools to admin the database. RockMongo is tool that catch my eyes, and many folks on stack overflow also put some positive feedback on this tool, hence I decide to try it out. Here are the steps to install Rockmongo on Ubuntu.
1. Install apache2, php5
sudo apt-get install apache2 php5 php5-dev php5-cli
2. Install php mongo driver
pecl install mongo
3. Config php.ini
root@ubuntu:~# find / -name php.ini
/etc/php5/apache2/php.ini
/etc/php5/cli/php.ini
root@ubuntu:~# echo "extension=mongo.so" >> /etc/php5/apache2/php.ini
4.check php install successfully
root@ubuntu:~# sudo find / -name www
/var/www
root@ubuntu:~# sudo echo "<? phpinfo() ?>" >> /var/www/info.php
open
http://localhost/info.php
if everything goes ok, this page will display
5. download rockmongo from
rockmongo
root@ubuntu:/var/www# cd /var/www
root@ubuntu:/var/www# wget http://rock-php.googlecode.com/files/rockmongo-v1.1.0.zip
root@ubuntu:/var/www# unzip rockmongo-v1.1.0.zip -d rockmongo
6. lunch mongod
7. restart apache server
root@ubuntu
: /etc/init.d/apache2 restart
8. open http://localhost/rockmongo/index.php by default, username and password are both admin.
-----------------------------------------------------
Silence, the way to avoid many problems;
Smile, the way to solve many problems;