4 Paisa

How to do MySQL port forwarding using PuTTY

2011-12-02T12:34:00.000+05:30

1. Go to Session: enter site name, port, etc…
2. Window > Behaviour : Window Title can be set here.
3. Connection > Data: User name should be given Auto-login username.
4. Connection > SSH : check Enable Compression.
5. Connection > SSH > Tunnels: enter local port number in Source Port, the port to be forwarded in Destination in the form : and click on Add to create the tunnel.
For MySQL client, this local port will be the port and localhost will be the machine.
Create windows short cut for this.
1. Create a short cut for PuTTY and change its command like below.
C:\Users\user\Desktop\putty.exe -ssh -pw -load
Source: http://www.jfitz.com/tips/putty_config.html

Find recursively and copy files in Unix

2011-07-07T12:52:00.000+05:30

I was trying to do a recursive search in Unix using find command and then copy all those files to a specific folder.

I found below command does that.

find . -name *2011-03-19* -exec cp {} /home/Reddy/logs/ \;

Important thing is, we need to escape the ending semi-colon.

{} is the place holder for putting the search result, i.e., the file name found.

Enable the tools disabled by virus

2008-10-01T20:16:00.005+05:30

If you got a virus usually it will disable the following things so that you can't be able to delete the virus.

It will disable Folder Options menu item from View menu, disables the Task Manager, and disables the Registry Editor.

You can enable all these from the Group Policy editor by yourself manually.

Go to Windows > Run > gpEdit.msc
Folder Options: Go to User Configuration > Administrative Templates > Windows Components > Windows Explorer > Removes the Folder Options menu item from the Tools menu. Disable this option. Now you should be able to see Folder Options in the View menu of your explorer window.
Task Manager: Go to User Configuration > Administrative Templates > System > Ctrl+Alt+Del Options > Remove Task Manger. Disable this option.
Registry Editor: Go to User Configuration > Administrative Templates > System > Prevent Access to Registry Editing Tools. Disable this option.

But, it is good to have alternatives for these things since viruses usually disables the default tools but not the alternative softwares.

You can use Process Explorer as alternative for Task Manager. Similarly you can use Explorer2 as alternative for default windows explorer. If you don't like Explorer2 many more explorer softwares are available, you can choose from any of those. I don't know alternatives for the Registry Editor. Please feel to share those you know in the comments section below.

Related Posts:
Stop viruses coming from Pen Drives
Remove Amvo.exe virus, Funny UST Scandal, Fun.exe DC.exe SVIQ.exe
Task Manager, Registry Accessing disabled?
Disable Autoplay, Messenger Service
Important steps while cleaning virus
What is this process

Subscribe to my site feed for receiving more tips. You can get more tips in your email for free.

Clean New Folder.exe, RegSvr.exe Virus

2008-05-12T15:15:00.000+05:30

Recently I got infected with this virus. This virus just shows a message when windows started, "Rundll.exe is not found.......", and infecting the pen drives for first few days. Not much harm. But after 4 or 5 days it is starting creating copies of virus file in many folders. The copy will be having the same name as the folder name and it also having folder icon, so that we will think it as another folder.

When I have searched Internet, I got the following link useful Am I Works. I have developed a tool for removing this virus.

Download New Folder virus removal tool, unzip it, and double click on RemoveVirus.bat file. Tell me if you get rid of virus in comments section.

Note: If you are not able to open Registry Editor (Win+R, regedit.exe), See Accessing Registry disabled?

Subscribe to my site feed for receiving more tips. You can get more tips in your email for free.

Related:
Stop Viruses coming from Pen drives
Task Manager Disabled?
Important Steps when cleaning viruses

Stop viruses coming from pen drives

2008-05-04T23:00:00.001+05:30

Now a days pen drives ( or USB drives ) became necessary. But there is a problem with these pen drives. They can be very easily infected by viruses. But we can not live without using pen drives.

You can be a bit more careful and prevent them infecting your system with different types of viruses.

First disable auto play in your system. This prevents viruses in the pen drive from running automatically when pen drives are inserted into the system. (Please note that this will disable auto playing of CDs also).
After inserting pen drive into the system open it in explorer mode only, don't open it in My Computer.

To open Explorer, press Win+E on your keyboard.
Or right click on My Computer, and select explorer.
If My Computer is already opened, click on 'Folders' in the tool bar (or View menu> Explorer Bar> Folders).

Always open pen drive by clicking on the pen drive name from the left pane only. Don't open from right pane.
Don't open the files you don't need. If you find any file suspicious, right click on file name and select properties. It will show complete details about that file. Don't rely on icons. Some viruses use folder icon to make us think that they are folders, and most probably we will double click on that to see what is there in that folder which actually executes the virus.

A little careful handling of pen drives will prevent a lot many viruses.

Related:
Remove Amvo.exe virus, Funny UST Scandal, Fun.exe DC.exe SVIQ.exe
Task Manager, Registry Accessing disabled?
Disable Autoplay, Messenger Service
Important steps while cleaning virus
What is this process

Subscribe to my site feed for receiving more tips. You can get more tips in your email for free.

Blogger plugins, widgets

2008-03-23T16:14:00.000+05:30

Have a look at the following site. It contains lot of tips and plug-ins for the blogger.com.

http://www.bloggerplugins.org

Related:
HTML Parser
Recent Posts widget for new Blogger
Related Posts Plug-in for Wordpress

Subscribe to my site feed to know more cool sites. You can get them in your email for free.

Add recent posts widget in new blogger

2008-03-23T15:26:00.000+05:30

If you don't like blog archive or just want to display simply the latest posts you can do that with the following simple (or silly) trick.

First get your blog's feed URL. This will be usually
http://YOURBLOGNAME.blogspot.com/feeds/posts/default
Ex: http://4paisa.blogspot.com/feeds/posts/default
In my case I am using Feedburner for my feed, so my default feed URL
http://feeds.feedburner.com/4paisa
Go to Layout tab in your blogger dashboard, click on Add a page element.
Select 'Feed' in the list, give your own feed URL here.
Thats it. You can place this widget at the location you like.

You can display the latest comments also using the above tip. To do this use your comments URL instead.
It will be like
http://BLOGNAME.blogspot.com/feeds/comments/default?alt=rss

BTW blogger provides separate feed for every label also. It will be like
http://BLOGNAME.blogspot.com/feeds/posts/default/-/LABELNAME

Subscribe to my site feed for receiving more tips. You can get more tips in your email for free.

Parse HTML for new Blogger

2008-03-23T15:17:00.000+05:30

http://www.blogcrowds.com/resources/parse_html.php

If you want to modify the new blogger template, you need to know XML. If you don't know XML or you have done changes in the old blogger template in HTML and want to use them, go to the above link. You need to paste your HTML code in the form at the above link and click on parse button. It will generate XML source which can be used to change new blogger template.

Subscribe to my site feed for knowing about more cool sites. You can get to know abour more cool sites in your email for free.

How to delete Facebook Account?

2008-03-13T13:15:00.001+05:30

You can deactivate your account, if you want to delete your account only temporarily. When you deactivate your account, you are like deleted from Facebook - no one can find your profile. Except all your data (friends, networks, etc...) will be saved, so that you can reactivate later.

To deactivate, click on 'account' at the top right corner. There will be 'deactivate' link at the bottom right. It will ask a reason when you clicked on the link. Select an option, and click on Deactivate button. If you want to reactivate, just login as usual. When you do that, Facebook sends a confirmation email to you. You can start using Facebook again by clicking on the confirmation link in the email.

If you want to permanently delete Facebook account, click on the following link and fill the form.
Delete Facebook Account

Links:
http://www.facebook.com/help/?faq=224562897555674&ref_query=delete+accou

Read More:
How to delete Gmail, Yahoo mail accounts
Backup dictionary in MS-Word
Backup Mails in Outlook Express
Open Multiple Firefox profiles at the same time
Firefox: View status bar in full screen

Subscribe to my site feed for receiving more tips. You can get more tips in your email for free.

Removed Fun.exe, dc.exe, SVIQ.exe virus

2008-03-09T19:19:00.000+05:30

I have got a virus, which automatically opening the Yahoo messenger. So, when I have looked the processes in the task manager, I have found the following processes Fun.exe, dc.exe, SVIQ.exe.

I killed those processes, by right clicking the process and select "End Process Tree". After I have killed all those processes, I searched Internet and found the following link W32.Imaut.AS (also called Dung Coi). Then I have deleted all the virus files and cleaned the registry.

I am describing the exact steps below:

First go to the task manager (right click on the task bar > task manager) and select the processes tab.
Right click on the Fun.exe, dc.exe, SVIQ.exe and select "End Process Tree". This stops the viruses from interrupting in the cleanup process.
Go to the MSConfig (Win+R, type MSConfig and press enter). Go to the startup tab. Uncheck the dc.exe, fun.exe, SVIQ.exe, Other.exe, Win.exe. This stop the virus processes from starting with the windows.
Next go to the Registry Editor (Win+R, type RegEdit and press enter). Remove the following keys

dc, dc2k5, fun under the key HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Run
load, run under the key HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows
Go to the key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon and Modify Shell's value to "Explorer.exe".
Remove HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\MSConfig\startupreg\dc
Remove HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\MSConfig\startupreg\dc2k5
Remove HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\MSConfig\startupreg\Fun
Remove HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\MSConfig\startupreg\Load
Remove HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\MSConfig\startupreg\Run

Delete the following files.

%Windir%\Help\Other.exe
%Windir%\inf\Other.exe
%Windir%\system\Fun.exe
%Windir%\System32\config\Win.exe
%Windir%\System32\WinSit.exe
%Windir%\dc.exe
%Windir%\SVIQ.exe
%Windir%\System32\NWB.dat
c:\PNga.txt
%Windir%\wininit.ini

I have created two files to automate the process of deleting the Registry keys, and the virus files. Download Fun Virus Removal, unzip it. Double click on the RemoveVirus.bat file.

Thats it. I got rid from the virus. I read in the net that this virus will create a copy of virus file in directories with the same name and uses a folder icon, so that users will click on it thinking it was a folder. But, I dint get any files like that, if you got any files like that, don't click on them, delete them immediately. If you have any doubt, right click on that and select properties, then you can know whether it is a file or folder.

Read More:
Important steps when cleaning virus
Disabling Auto Play in Windows
Task Manager Disabled?
Registry access disabled?
What is this Process?

Subscribe to my site feed for receiving more tips. You can get more tips in your email for free.

Registry Accessing disabled?

2008-03-09T19:12:00.001+05:30

Many viruses disable the access to the registry so that we can't remove the virus entries in the registry. In these cases you can download the following file UnHookExec.inf. After downloaded, right click on the file, and select Install.

You can enable it manually by editing the group policy editor. Go to Windows > Run > gpEdit.msc
Go to User Configuration > Administrative Templates > System > Prevent Access to Registry Editing Tools. Disable it. You should be able to open regedit now.

Source: Tool to reset shell\open\command registry keys

Subscribe to my site feed for receiving more tips. You can get more tips in your email for free.

Firefox: Open search results in new tab

2008-02-23T10:59:00.000+05:30

In Firefox, if you type a query and hit enter in the search box, you will get results in the current tab by replacing the open page. You can open search results page in new tab by hitting alt+enter instead of enter. If you want to open search results page in new tab always, you can do so by changing config entries.

Type about:config, and go to the key browser.search.openintab and change its value to true.

Subscribe to my site feed for receiving more tips. You can get more tips in your email for free.

Firefox: Spell Check Single line text boxes also

2008-02-21T14:50:00.000+05:30

Firefox comes with spell checker which checks for spelling errors in the multi line text boxes. You can make Firefox to spell check single line text boxes also like email subject lines, etc by changing config entry.

Type about:config in a new tab, then go to the key layout.spellcheckDefault. It's value is 1 by default, which means spell check multi line text boxes only.

0 - Disable Spell check.
1 - Check multi line text boxes only.
2 - Check all text boxes, including single line text boxes.

Change the key value to 2. No more spelling errors in the email subject lines.

Please share the tips you know in the comments section.

Subscribe to my site feed for receiving more tips. You can get more tips in your email for free.

Earn money through scribd.com

2008-02-20T21:47:00.000+05:30

scribd.com announces new type of document viewer, iPaper. Now it allows you to earn money through your documents. If you own a document, you can use iPaper to display them on your site or blog, and if you choose to display advertisements in the documents you will get some percentage of money earned by the ads.

Read more at scribd FAQs.

Related:
Download files in many formats
Share files and earn money
FeedBlitz Ad Network

Subscribe to my site feed to receive more news. You can get more news in your email for free.

Firefox: Open Page Source in Notepad

2008-02-20T15:03:00.000+05:30

If you want to view page source of a website, Firefox opens it in the internal viewer. Though this viewer is great with the color coding, you might want to edit the document or want to open it in an external viewer like dreamsweaver, frontpage, etc. For this you have to change the config entries.

Open about:config, go to the key
view_source.editor.external, set it to true.

Next go to the key view_source.editor.path, give your program path there. For notepad, it is C:\Windows\Notepad.exe.

From now it will be opened in your favorite editor.

Subscribe to my site feed for more tips. You can get more tips in your email for free.

Firefox: Search from Address bar

2008-02-19T13:58:00.000+05:30

In firefox, you can search from address bar. When you type your search terms and hit enter, Google's I am Feeling Lucky search will be performed, and it will directly goes to the first site in the search results.

If you are not feeling lucky, you can change it to perform normal search by changing config entries.

Open Configuration editor by typing about:config in a new tab. Go to the key keyword.URL, and change its value to the following

http://www.google.com/search?ie=UTF-8&oe=UTF-8&sourceid=navclient&gfns=0&q=

Or you can change it to completely different search engine als. For example if you want Yahoo search, change it to

http://search.yahoo.com/search?ei=UTF-8&fr=moz2&p=

Subscribe to my site feed for receiving more tips. You can get more tips in your email for free.

Scheduled posts in blogger

2008-02-17T15:16:00.000+05:30

Blogger introduced Scheduled posts feature in the draft version. You can login to draft.blogger.com instead of blogger.com to use draft feature. Soon this will be available in the regular blogger version too.

Now you can write a lot of posts and schedule them to be published in the future. For doing this, expand 'Post Options' in compose window, change the date and time to a future date and publish the post. It will be automatically posted at the specified date. This feature is already available in the wordpress.

Scheduled Posts in Blogger

Download free eBooks

2008-02-16T15:14:00.000+05:30

I have found the following two websites very useful for downloading e-books for free.

http://www.ebookee.com/ This site has very good collection of books, which include tech books, fiction, non-fiction, and magazines too. It's search engine is giving good results too.

http://knowfree.net This site also contains large collection of books. This site is organised in a blog format. You can see particular category by using labels. Every contains introduction to a book, and there is a cover page picture for almost every book.

Want to know more cool sites? Subscribe to my site feed. You can get more cool sites in your email for free.

Firefox: Open bookmarks in new tabs

2008-02-15T15:09:00.000+05:30

In Firefox, you can open a folder of bookmarks at a time by selecting "Open All in Tabs" option. But, then these sites be opened in the existing tabs by replacing the opened sites. If you want to open all bookmarks in a folder at a time and want your opened sites to remain opened, you can achieve that by changing a Firefox option using about:config.

The process is simple. Type "about:config" in a tab, it will show a lot of options you can play with. Search for browser.tabs.loadFolderAndReplace key and change it to false by double clicking on it (or right click>toggle).

Subscribe to my site feed for receiving more tips. You can get more tips in your email for free.

Firefox: Get your old quick find bar back

2008-02-14T15:08:00.000+05:30

One of the good features in Firefox is the quick find feature. As soon as you start typing, Firefox will start searching for the word. ~~But, if you want to go to the next occurrence of the search term, you have to first press Ctrl+F, then either Ctrl+G or Alt+N.~~

By adding a small code snippet to the userChrome.css file (What is userChrome.css?), you can get the full featured find bar. ~~So, you don't need to press extra Ctrl+F before pressing Alt+N. It will save some time.~~

/* Restore quick find bar */
#FindToolbar > * {display: -moz-box; }

Subscribe to my site feed for receiving more tips. You can get more tips in your email for free.

Firefox: view status bar in full screen

2008-02-13T17:22:00.000+05:30

Whenever I am browsing in the full screen mode in Firefox, I miss the status bar. I use status bar extensively, to know page loading status, to know the actual URLs of the links. Whenever I hovered over a link, the URL will be shown on the status bar. But, in full screen mode, the status bar is not available. I have to right click on the link and select properties to view the actual URL.
By changing the userChrome.css file, I now get status bar in full screen mode also.

First read "What is userChrome.css & userContent.css?", if you don't know about them.

It is very simple. Add the following lines into your userChrome.css file.

/* Making status bar visible in full screen */
#status-bar
{
visibility: visible;
}

Stay tuned for more tips.

Subscribe to my site feed for receiving more tips. You can get more tips in your email for free.

Disable Messenger Service

2008-02-12T14:24:00.000+05:30

If you are receiving this type of unwanted messages, take the following steps to disable messenger service.

Open Services window (Win+R and type services.msc or you can go to control panel, Performance and Maintenance, Administrative Tools, Services).
Select Messenger service, right click and select properties. Change startup type to Disabled.
Thats it. You won't get any popups from Internet.

Some spammers use net send utility to send this type of advertisements on the Internet. If you really wants the net send functionality install a firewall or enable the one which comes default with windows. Then you won't get this type of messages.

Read More:
Disable AutoPlay
Important steps to be taken when cleaning viruses
Remove Funny UST Scandal Virus manually

Cleaned amvo.exe virus manually

2008-02-10T21:14:00.001+05:30

Today I got one virus in my system. When I try to login to the Yahoo messenger, it is closing without logging in. I have found a virus (don't know name) and cleaned it manually. I have taken the below steps to remove this virus manually.

First I have checked in task manager, I didn't find any suspicious processes.
Next I opened MSConfig (Go to run, and type msconfig). I have found one process with the name amvo.exe under the startup tab. It is located in Windows\System32 folder.
I unchecked the process, and closed the msconfig window.
Next I open Registry Editor (go to run, and type regedit). I have searched for "amvo.exe" and found one entry. I have deleted the whole key.
Next I have tried to set the option to "show hidden files" (Go to Tools> View in windows explorer), as virus file is hidden. But it is not allowing me. As soon as I set it to show hidden files and clicked on ok, it is changing back to "Don't show hidden files".
Then I have used Bullet Proof FTP software to browse the local disk, because it shows all files even hidden files. (I have already installed FTP software in my system. You can get free trial version from the website.)
Then I have browsed to Windows\System32 folder, and deleted amvo.exe, amvo0.dll, amvo1.dll.
This virus put an Autorun.inf file, and .cmd file in every drive's root. I have removed all those.

Thats it. Virus was cleaned. Now, I am able to use my messenger.

Don't forget to disable system restore before starting the cleaning process, and open windows in safe mode.

Update: I built two files to clean this virus automatically. After downloading the AMVO Cleaner, unzip the file to get a folder. Open that folder, and double click on the file named AMVO_Delete. It should have cleaned the virus. Please let me know whether your problem solved in the comments section below.

If you find this information, please leave a comment below. See the following links for more information:
Important steps when cleaning virus
Disable auto play
Task Manager disabled?
Unable to open Registry?
Know about process?
How I removed Funny UST Scandal virus from my system
Removed fun.exe, dc.exe, SVIQ.exe manually

Subscribe to my site feed for receiving more tips. You can get more tips in your email for free.

Get Firefox, and safely browse the Internet.

Webpage disabled rightclick?

2008-02-09T20:18:00.000+05:30

Some sites will disable right clicking on the page using JavaScript. If you find this annoying there is a solution. In you Firefox, go to Tools > Options > Content. Click on the 'Advanced' button opposite to the 'Enable Java Script'. Then un check the "Disable or replace context menus". Thats it.

Like to read more tips, subscribe to the feed. You can subscribe using email also.

Read more:
How to delete gmail, Y Mail accounts?
How to disable Auto Play in Windows?
Backup MS-Word Dictionary
Backup Outlook Express Mails

Open multiple Firefox profiles at the same time

2008-02-08T17:21:00.000+05:30

Normally you can open one Firefox profile at a time. However you can open multiple profiles at the same time with the following trick.

Go to Run dialog box (Win+R), type firefox -no-remote. It shows the profile manager dialog box. You select a profile. Thats it, you have done.
Otherwise you can create a bat file ( a file with the extension .bat) on desktop, add the following line in the file

start "" "C:\Program Files\Mozilla Firefox\firefox.exe" -no-remote

Whenever you double click on the file, the profile manager will be opened.

If you are using Firefox 1.5, paste the following code in the bat file (Thanks to the edmeister).

@echo off
set MOZ_NO_REMOTE=1
start "" "C:\Program Files\Mozilla Firefox\firefox.exe" -p
set MOZ_NO_REMOTE=0

Related Posts:
What is a Firefox Profile?
What are userChrome.css & userConent.css?
Open IE in Firefox