Sunday, March 06, 2011

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

If you get this error on Ubuntu while connecting to MySQL database (mysql -u root -p)

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Then to get rid of this problem try to connect by specifying localhost as shown below:

mysql -u root -h 127.0.0.1 -p

Labels:

Tuesday, January 25, 2011

Changing the login shell from csh to bash

Often on many Unix like operating systems, the default shell is csh.

But many of us find it convenient to work on bash shell. To make bash as your default login shell, place following line in ~/.login file

exec bash

Thursday, December 30, 2010

Installing Oracle XE on Ubuntu

Came across following links using which I was able to install and configure Oracle XE on Ubuntu within minutes. Hope this helps everyone.

To install: https://help.ubuntu.com/community/Oracle

To configure: https://help.ubuntu.com/community/Oracle10g

And in case you are not being able to login through command line even after following above configuration steps then execute following command:

chmod 6751 $ORACLE_HOME/bin/oracle

Wednesday, December 22, 2010

Using sudo without password

Here is how you need to configure sudo to not prompt for password:

1. Login as root (su – root)

2. Execute: visudo

3. Append following line at the bottom of the file
ALL=(ALL) NOPASSWD:ALL

Labels: , , ,

Tuesday, December 21, 2010

How to display wireless Network icon in top panel of Ubuntu

Few days back all of a sudden my wireless Network icon was not getting displayed under top pannel and it was kinda annoying.

The ugly hack to restore this icon in Ubuntu 10.10 is to execute following command:

gconftool --recursive-unset /apps/panel

And after which I had to reboot my machine.

Labels: , , , ,

Wednesday, December 15, 2010

Installing Mac on Ubuntu

Well I know most of you are looking for a genuine way to install Mac on Ubuntu. Not sure when that would be possible but till that time you can try this

Its really cool...Trust me...

Using Cisco VPN on Ubuntu

Most of us so called Engineers work in some or the other Software Company. Which also means we have to often work from home. :)

Logging into Windoze just because we have to work from home doesn't make sense. You can connect to Office network from Home and Ubuntu.

First install the client:
sudo apt-get install vpnc

Place following entries in the file: /etc/vpnc/default.conf depending on your company specific settings:
IPSec gateway company_host.your_company.com
IPSec ID
IPSec secret
Xauth username foobar
Xauth password NoTrust
Target networks

You are almost there, just need to connect now:
sudo vpnc-connect

Time to disconnect:
sudo vpnc-disconnect

Sharing Desktop on Ubuntu over the Internet

I often need to share the desktop with my brother who lives in India. Before this we used to use CrossLoop (download) since he was a Windoze User.

Now he uses Ubuntu.

I have come across 2 applications using which we can share the desktop on Ubuntu:
Yuuguu (Download it from here )
Skype (Download if from here )

Friday, December 10, 2010

Exporting PATH variable in csh (C shell)

Tried and tested way of exporting Path variable in C Shell (csh)

echo 'setenv PATH "$PATH":/usr/local/test/bin' > ~/.cshrc

or

echo 'set PATH = $PATH\:/usr/local/test/bin' > ~/.cshrc

Sunday, January 25, 2009

Enabling "password-less" login for ssh between 2 Linux machines

1. Generate a dsa or rsa public & private keys:
#ssh-keygen -t dsa
or
#ssh-keygen -t rsa

2. Copy the public key and complete the required formalities on the remote machine:
#ssh-copy-id -i ~/.ssh/id_dsa.pub user@IP-address

or

Manually copy the content of ~/.ssh/id_dsa.pub or ~/.ssh/id_rsa.pub to remote machines's ~/.ssh/authorized_keys

3. Make sure permission of public key on source is moderated to say 600. If all goes well you have successfully enabled password-less communication with the remote machine. Test it using "ssh"
#ssh IP-address

Labels: , , , ,