Port forward for a big list of devices

Below you see a list of routers and firewalls. These are the devices that we have written support documents for. These documents provide step-by-step guides on how to setup port forwarding. Our ultimate goal is to have a write up for every hardware router and firewall available and instructions for every application that Internet users have difficulty getting to work through their router or firewall.

http://www.portforward.com/routers.htm

Display Run on Vista

Displaying Run on the vista Desktop:

You can create a shortcut for the Run command on your desktop. From the Start Menu, go to All Programs / Accessories. Drag a shortcut for Run to the desktop.

Displaying Run on the Start Menu:

By default, Run is not shown when you open the Start Menu. To enable this Right click on the taskbar, Select Properties, Click on the Start Menu tab, Click on the Customize button, Scroll down and check Run (it’s about 2/3’s of the way towards the bottom.

POSSIBLE CAUSES OF SLOW INTERNET UNDER LEOPARD

• Use better faster DNS servers, like OpenDNS.org (208.67.222.222, 208.67.220.220).
• Connect directly to DNS servers to avoid DNS forwarding through your router (acting as a DNS proxy).
• Turn off IPv6 DNS lookups in Firefox/Camino (references: mozilla.org).
• If DNS forwarding is required, change the DNS servers directly on the router.
• Update your router’s firmware (references: jungledisk.com, ubuntu.com) for better SRV and IPv6 handling.
• Below are detailed instructions on applying these fixes to slow dns lookups/slow Internet on Leopard

Copy an existing MySQL table to a new table

This is a great set of two commands that allow the creation and population of a new table with the structure and data of an existing table. This provides a quick means of making a point-in-time copy of a table and is a safe, easy way to make a quick copy of a table for testing an application in development on live data without risking a production environment.

To make a copy of the table mytable which is in a different database called production into a new table called mytable_new in the currently selected database, use these two commands:

CREATE TABLE mytable_new LIKE production.mytable;
INSERT mytable_new SELECT * FROM production.mytable;

The first command creates the new table mytable_new by duplicating the structure of the existing table. The second command copies the data from old to new.

The nomenclature production.mytable is a means of specifying the database and table in the same way that a file can be specified by its directory path. It is optional. If production was left off, MySQL would assume that the mytable table was also in the currently selected database.

Access Denied error in windows vista

When you try to access some windows folder like document and setting you may get error message that “access denied”. you need to change ownership of this folder. So open properties by right click on it. In security button select advance tab and click edit button. Now change ownership to your account by highlighting your account and also select replace ownership to sub containers and apply changes.

Kill Security center notification problem in Windows Vista Basic

Windows vista security center remind you all the time about anti virus. Solution guide:- new easy way to disable the security center messages.Click on the Security Center/Windows Security Alerts logo in the system tray.Click Change the way Security Center alerts me.Select I do not want notification messages from Security Center.

Disable screensaver UBUNTU

Solution 1:

Edit /etc/X11/xorg.conf file using the following command

sudo vi /etc/X11/xorg.conf

and add the following lines

Section “ServerFlags”
#other options can go here
Option “BlankTime” “0″
Option “StandbyTime” “0″
Option “SuspendTime” “0″
Option “OffTime” “0″
EndSection

Save and exit the file

Solution 2

Edit /etc/X11/xorg.conf file using the following command

sudo vi /etc/X11/xorg.conf

This effectively disables power management on your monitor Settings

Section “Monitor”
#other options can go here
Option “DPMS” “false”
EndSection

Save and exit the file and restart your machine

 

Solution 3

gconftool-2  –set “/apps/gnome-screensaver/idle_activation_enabled” –type boolean false

 

Solution 4

gnome-screensaver-command –inhibit


Solution 5

gnome-screensaver-comand –poke

 

One of all the above should work in your UBUNTU (I hope…)

Import CSV file directly into MySQL

Instead of writing a script to pull in information from a CSV file, you can link MYSQL directly to it and upload the information using the following SQL syntax.

To import an Excel file into MySQL, first export it as a CSV file. Remove the CSV headers from the generated CSV file along with empty data that Excel may have put at the end of the CSV file.

You can then import it into a MySQL table by running:

load data local infile 'mine.csv' into table tblUniq
fields terminated by ','
enclosed by '"'
lines terminated by 'n'
(mineName, mineCity, mineComments)

The fields here are the actual tblMine table fields that the data needs to sit in. The enclosed by and lines terminated by are optional and can help if you have columns enclosed with double-quotes such as Excel exports, etc.

How to triple boot

We start by installing Leopard in the whole hard disk.

Then we install rEFIt. To be sure that it was installed roperly and it is activated, we open terminal kai write: cd /efi/refit

./enable.sh

Then Finder –> Applications –> Utilities –> Boot Camp Assistant and we choose the partition for our Windows installation.

Many people say that you shouldn’t use BootCamp for “triple boot” but the whole procedure should be done using terminal and diskutil. If you follow this way, windows will stop before they will be installed because they won’t be able to find a proper partition. Why do you think that Apple spent money for creating BootCamp? Anyway, continue installing Windows after creating the partition from BootCamp. When you finish Bootcamp changes the “startup volume”, so keep pressed the button option (alt) from your keyboard and then choose login to OSX.

Open terminal to make sure that Windows did not do something bad and write:

cd /efi/refit

./enable.sh

Then Finder –> Applications –> Utilities –> Disk Utility.

Click at the main hard disk, not at the partitions and it will show up tab Partition. With mouse we choose the main partition (OSX), and click at the small sign +. Now we define the partitions size by moving our mouse up – down and we name the partition. Disk Utility will create the partition using HFS+ for filesystem. Do not worry, our Linux distribution will reformat it in whatever you choose (ext3).

To see the space for each partition click on it (it is in GB).

After this you can insert in DVD your favourite distro and start installing it. From rEFIt menu choose to boot from Linux CD/DVD. Using the partitioning tool at the time of Linux installation reformat the proper partition to ext3.

If you have followed everything till now properly, now you must have your disk partitions as following: (1st partition: EFI system, 2nd partition: OSX, 3d partition Linux and last but not least 4th partition with Windows).

BE CAREFULL where you are going to install the BootLoader (/dev/sda3).

Then you have to reboot your system and you will see three options: MacOSX, Linux, Windows.

This is it, without using weird commands from terminal.