Installing PostgreSQL in Ubuntu

sudo apt-get install postgresql
sudo apt-get install pgadmin3

Now basic postgres server and gui client tool is installed

Let’s login to default user ‘postgres’ and add a password, Enter this command –

sudo -u postgres psql postgres

You get the psql command prompt and enter this command to add password for user ‘postgres’

postgres=# \password postgres

Then Ctrl + D to exit the postgres console

 

For additional contrib package

sudo apt-get install postgresql-contrib-9.1

Installing RockMongo

RockMongo is a MongoDB GUI tool. It’s freely available to download

http://rockmongo.com/

 

The easiest way to get started is to install Apache and PHP:

$ sudo apt-get install apache2 php5 php-pear

If you need to edit the Apache ports because you already have another server running on port 80 then edit /etc/apache2/ports.conf.

You’ll need to install the PHP Mongo connector:

$ sudo pecl install php_mongo

 

Add the following line to your php.ini file:

extension=mongo.so

If pecl runs out of memory while installing, make sure memory_limit in php.ini is set to at least 32MB.

Add “extension=mongo.so” to the “Dynamic Extensions” section of /etc/php5/apache2/php.ini and restart Apache with

$ sudo service apache2 restart

 

There is a different kind of instruction given under the following page
Link

It suggests to use the below command

$ sudo pecl install mongo

After installation go to
http://localhost/rockmongo/index.php

with username = “admin” and password= “admin” (these are set as default)

PS: I’m yet to get it working. This post is only for documentation purposes.

Delete .svn directories in Linux

If you are using svn in Linux + Eclipse, you might encounter this problem. There will be lot of hidden .svn directories created in each folder. This should be cleaned if you’re going to commit this as a separate project.

Enter this command in the home directory of the project

rm -rf `find . -type d -name .svn`

Or create a bash script as follows and save this as /usr/bin/csvn

#!/bin/sh
echo "recursively removing .svn folders from"
pwd
rm -rf `find . -type d -name .svn`

Now calling csvn command in any project directory will recursively delete the .svn directories under that.

Remember you’ll have to modify file permissions – for the script to become executable.

VirtualBox Failed to access the USB subsystem

I have the virtualbox installed in my Ubuntu and got this problem.

Failed to access the USB subsystem.
VirtualBox is not currently allowed to access USB devices. You can change this by adding your user to the ‘vboxusers’ group. Please see the user manual for a more detailed explanation.

Details say…

Result Code:
NS_ERROR_FAILURE (0x00004005)
Component:
Host
Interface:
IHost {dab4a2b8-c735-4f08-94fc-9bec84182e2f}
Callee:
IMachine {5eaa9319-62fc-4b0a-843c-0cb1940f8a91}

 

Solved by using the following

sudo usermod -aG vboxusers 

Replace <your username> with the name you use to log in. Type your user password when prompted.

Be sure to log off and back in to finalize the change in permissions