Category: Howto

How to find and change Nintendo Wii DNS server IP address

Nintendo Wii is fine game console system. You can find out current DNS server IP address or change them using following method:

  1. Make sure your Wii is connected to the Internet.
  2. Select Wii Options.
  3. Select Wii Settings.
  4. Now click the right arrow once to view the Internet option > Click Internet
  5. Select Connection Settings.
  6. Now select the connection profile you are currently using.
  7. Select Change settings
  8. Select Auto-Obtain DNS settings i.e. click the right arrow three times until you see Auto-Obtain DNS settings.
  9. Click No, then Advanced Settings.
  10. Now click on Primary DNS and Secondary DNS fields and type in your ISP DNS server IP addresses.
  11. Select confirm > Click on Save and Finally click on OK to start the connection test.
  12. Next perform a Wii system update.
  13. And you are done!

Howto Get rid of beliefs that could hold you back in life

Steven has published a nice 10 tips that could hold you back in life:

I have spoken a lot about beliefs and how to change them to make your life better. There are certain beliefs that a lot of people believe and I think it’s time to address these.

We are initially given beliefs from our parents, teachers, peers, TV and media. When we are young we think adults know more than us so we generally trust in what they say. However as we get older we form our own beliefs about the world. However some of the residual beliefs from our childhood can remain. Sometimes they have remained without us knowing about them.

Here are some beliefs that may be residual, see if you recognise any of them and change them.

10 beliefs that could hold you back in life

Howto play, learn and test your piano skills online

The piano is widely used in western music for solo performance, chamber music, and accompaniment. If you missed piano lessons in school, you can try to learn piano online.

According to wikipedia,

The word piano is a shortened form of the word pianoforte, which is seldom used except in formal language and derived from the original Italian name for the instrument, gravicèmbalo col piano e forte (literally harpsichord with soft and loud).

Learning to play the piano is one of the bases for mastering most musical instruments. The piano is a very good primer on identifying, understanding, and playing different notes.
Piano picture / photo - Howto play, learn and test your piano skills online

I’m sure this Virtual Piano will help you to learn Piano. There is also good list of avilable web site to learn to play the Piano online here.

Howto run Firefox inside firefox

Yup you can run Firefox inside firefox just by typing following ulr (good to impress all your friends):

From the article:

How about Opening Firefox inside Firefox? Not bad huh? and its really easy too just type in this url in a new tab in Firefox and there you go! Firefox inside Firefox! (click following url or copy paste in a web browser):

chrome://browser/content/browser.xul

Howto connect MySQL PostgreSQL server to Microsoft Office Application using ODBC

Learn how to connect Microsoft application such as Excel and other to MySQL and PostgreSQL database server running on Linux. This is an excellent information / howto.

In cases where business applications have been built on open source databases, it may be necessary to connect other Windows applications, such as Microsoft Access or Excel, to these databases for reporting or business intelligence purposes.

One potential application of this process is to use Excel as a front-end for data analysis. Data can be pulled from views or tables and then further analyzed, graphed, and the like. Even pivot tables can be used to create even more powerful reporting solutions.

This how-to walks through this process using Excel as an example application. Although in this example, the MySQL and PostgreSQL servers are running on Linux, the steps are no different if the software is running on Windows. These steps are:
1. Setting up authentication
2. Installing the ODBC Drivers
3. Configuring the data source
4. Importing the data.

=> Connecting Office Applications to MySQL and PostgreSQL via ODBC

Howto monitor your web site freely for availability

There is a nice and free website monitoring service available – Pingdom GIGRIB.

This website shows the uptime information for the thousands of websites that have been added by our users. The information is public and searchable.

All you need to do is :

a] Create a Pingdom GIGRIB user.
b] Download and install the GIGRIB client
c] Add the websites you want checked in the Pingdom GIGRIB control panel.

However your web site uptime information remains public. You can try the commercial service has a separate network of monitoring servers, more features, and the information is not public.

=> Pingdom GIGRIB website.

Howto Install MySQL on Windows Vista or Server 2003

This article will help to install MySQL database software on Windows Vista.

This document is written by Chris and focuses on installing MySQL on Windows Vista because its new security features require a few adjustments to allow MySQL to install properly. The general information provided in the paper could also be applied to Windows Server 2003.

From the article:

This week, the lab looks at configuring and installing MySQL – an open source relational database management system which is typically used for web applications.

This paper will provide an overview of configuring & installing this software on Windows. MySQL does not have as many features as PostgreSQL, however, and one would expect it to perform substantially better than PostgreSQL on Windows because of its thread-based architecture (PostgreSQL uses a process-based architecture instead).

MySQL on Windows: Configuration & Install (Download link PDF version)

Terminal or shell command to shutdown or reboot Ubuntu Linux

So how do you shutdown or reboot the Ubuntu Linux server from a terminal or a shell prompt? If GUI is working you can always click on a shutdown button. If GUI is not working or if you are working remotely over ssh type the following commands to shutdown from a terminal:
Continue reading “Terminal or shell command to shutdown or reboot Ubuntu Linux”