Friday, 28 June 2013

How to recover your forgotten ISP password from router?

Most of us would like to use Internet on multiple devices at home or office. To use Internet on multiple devices, you need to make use of a router. Certainly you can share Internet connection using computer that is connected to Internet. However there are some limitations associated with that method. You have to keep that computer ON for others to let use Internet that will consume lots of power.

Coming back to our real topic. So you have a router with ISP username and password in it and you don't remember the password. You can either call ISP and ask to reset the password that will take 2-3 days (may be more depends on willingness of ISP provider :)) OR you can follow below steps to recover the password:

  • Make sure that you are connected to the router from which you have to recover ISP password.

  • Login to your router using a web browser. Usually most routers have default IP address http://192.168.1.1 (unless you have changed it) which you have to type it in your browser's address bar and hit enter.

  • Now you will get a prompt to enter username and password to log into router configuration. Again this by default username is "admin" and password is also "admin". (unless you have changed it :)).

  • Navigate to WAN settings page. Now you will see your username and password in the form of stars.

  • If you are using Firefox browser and have firebug add-on installed or chrome browser, right click on password field and from context menu select menu having string "Inspect". Click on the images below to see bigger images.
    Chrome right click Firefox right click

  • A window will open with a highlighted field. You will see something like[html]<input type="password">[/html]

  • Click on "password" word and change that string to "text". Now it should look like[html]<input type="text">[/html]

  • And there you got your ISP password.


See video demo of how to do above steps:

Tuesday, 25 June 2013

How to replace multiple spaces with one space?

I came up with the situation of replacing multiple spaces with single space in SQL. I got the solution from a site but it was very difficult to understand at first look. So I got into deep to find out exactly how it works?

I really liked the trick and it made me write this blog post. This could be useful where regex expressions are not available.

The logic is explained in the video below. For visualization purpose space is represented as ‘@’ character and ‘#’ can be any random character which never occurs in strings as a normal character.

I am repeating again,
Consider
@ = white space
# = any random character that is never used as a normal character in strings.

[sql]
replace(
replace(
replace( trim(‘string’) , ‘@@’,’@#’ )
,’#@’,’’)
,’#’,’’)[/sql]



By the way the editor utility which I am using in this video is Notepad++ which is free and open source editor and a video utility to create video which I used is CamStudio it is also free and open source.

Saturday, 22 June 2013

How to get list of countries using firebug, jQuerify and Firefox

While working on a project I wanted a list of all possible countries for my web application. Of course I wanted to put it into database. The query was as shown below:

INSERT INTO Country VALUES(‘CountryName’,1,NOW(),1,NOW());

I found countries from Yahoo directories from this link.

Now imagine how long it would have taken If I would have copied each country name from that page to write insert queries. Instead I used firebug console. Once you open firebug console click on jQuerify (you have to install this add-on separately.)

In firebug console I typed following command

$('ul li a b').each(function(){
document.write("INSERT INTO Country VALUES('" + $(this).text() + "',1,NOW(),1,NOW());<br>");
});


And it generated following output


INSERT INTO Country VALUES(‘Afghanistan’,1,NOW(),1,NOW());
INSERT INTO Country VALUES(‘Albania’,1,NOW(),1,NOW());
INSERT INTO Country VALUES(‘Algeria’,1,NOW(),1,NOW());
INSERT INTO Country VALUES(‘Andorra’,1,NOW(),1,NOW());
INSERT INTO Country VALUES(‘Angola’,1,NOW(),1,NOW());
INSERT INTO Country VALUES(‘Antigua and Barbuda’,1,NOW(),1,NOW());
INSERT INTO Country VALUES(‘Argentina’,1,NOW(),1,NOW());


So to end, someone said, "Work Smarter, Not Harder…!!!"

Here you can see the video demo.

Thursday, 13 June 2013

System wide equalizer for your Mac, Windows and Ubuntu

As the speed of internet is increasing, most of us prefer to hear songs/music or watch videos online (examples: Spotify, Youtube etc.) than downloading it.  However there are some people who would like to hear every beat of songs/music or while watching educational video preference would be to the vocals. When you hear music offline you can use equalizer available in music applications like Winamp, iTunes etc.

But when you hear music online you don’t have any option to alter equalizer. In this situation you need system wide sound booster or equalizer. I was also searching for the same kind of applications and I found following applications.

For Mac - Boom


Boom-Mac Volume   Boom-Boost File

For Windows - Audio Enhancer Bongiovi DPS Plugin


Bongiovi

For Ubuntu - PulseAudio Equalizer


PulseAudio-Equalizer for Ubuntu

If you know any other applications please do post in comments below.