Ashesh Saini | Blog

One day my friend came and asked me about the installation of bugzilla, He told me that his company is going to setup the testing infrastructure, so he was asked to set up the a bug tracking tool. As bugzilla was an free, open source tool for bug tracking, he suggested the bugzilla. but nobody in the company was knowing how to install it.  The steps to install involved in installation are not easy and have many configuration, version, os etc issues. I had installed the bugzilla in my laptop around a year ago. So I thought to do it again, and also write a post to help others in bugzilla installation. So dear here are the easy steps to install bugzilla on your system, in windows enviornment..

1. Download and Install Java 1.4 (j2sdk-1_4_2_17-windows-i586-p.exe)

2. Go to “My computer” Icon , Right Click and select properties.

System Properties >> Advanced >> Environment Variables
Add New Variables
“JAVA_HOME ”       C:\j2sdk1.4.2_17            [Or java directory path]

3. Download and Install MySQL Database, MySQL 5.1.22 and client version MySQL 5.1.11 including GUI tools.

Then create Database/catalogue with name “bugs”
Open MySQL Command Line Client From the menu and type the following command

mysql> GRANT SELECT, INSERT,
UPDATE, DELETE, INDEX, ALTER, CREATE, LOCK TABLES,
CREATE TEMPORARY TABLES, DROP, REFERENCES ON bugs.*
TO bugs@localhost IDENTIFIED BY ‘bugs’;
mysql> FLUSH PRIVILEGES;

This will create the User “bugs” with password “bugs”.

4. Now Download Perl (ActivePerl-5.8.8.822-MSWin32-x86-280952.msi) from ActiveState.com and Install It.

Read more…

What is Robots.txt??

The robots.txt file is used to instruct search engine robots about what pages on your website should be crawled and consequently indexed. Most websites have files and folders that are not relevant for search engines (like images or admin files) therefore creating a robots.txt file can actually improve your website indexation. It also provides you a way to hide your content from search engine.

Robots.txt Syntax

# comment
User-agent: [robot-names][(*)Wild card character]
Disallow:[(/)all] [specific directory] [specific file Location]

User-agent

The value of this field is the name of the robot the record is describing access policy for. If more than one User-agent field is present the record describes an identical access policy for more than one robot. At least one field needs to be present per record. You can multiple ( more than 1) User-Agents in one entry.

Disallow

The value of this field specifies a partial URL that is not to be visited. This can be a full path, or a partial path; any URL that starts with this value will not be retrieved. For example, Disallow: /help disallows both /help.html and /help/index.html, whereas Disallow: /help/ would disallow /help/index.html but allow /help.html. Any empty value indicates that all URLs can be retrieved. At least one Disallow field needs to be present in a record.

Things to remember while writing robots.txt:

1. Robots.txt should be written in a plain text editor like Notepad. Do not use MS-Word or any other text editor to create robots.txt. The bottom line is this file should have the extension “”.txt”" else it will be useless.
2. A robots.txt file is always stored in the root of your site, and is always named in lower case. Spiders will always search for it in the root directory (e.g. http://www.example.com/robots.txt)
3. There can only be one instruction per line,
4. You should avoid putting spaces before the instructions (recommended to avoid making mistakes).
5. For security reasons, be aware while preventing spiders from accidentally indexing sensitive and private areas of your site, as anybody at all can view your robots.txt file.

Read more…

A cheat sheet is a concise set of notes used for quick reference. “Cheat sheet”(sometimes also rendered as “cheatsheet” or “cheat-sheet”) can be used like a memory refreshing tool. Cheat sheets are popular in any area where a quick reference is useful, not just for examinations. Like computer industry has many cheat sheets due to the high number of commands, actions, procedures, terms and concepts one must learn to use programming languages and interfaces. In Information Technology, a cheat sheet is a reference tool that provides simple, brief instructions for accomplishing a specific task. Below you will find the Various professionally prepared and Must have cheat sheets on most of topics from computer software and internet world. As you cant remeber the URL of every page which have cheat sheet, So Please feel free to bookmark this post to get all under one umbralla. Now keep all the information at your fingertips. Do you have/know a useful cheat sheet that you’d like me to consider posting? Let me know! Read more…

Usually I never recommend taking shortcuts in life, as it is priceless. But shortcuts can be useful for you, if you are a asp.net, vb, c# programmer or web developer who love to work with visual Studio 2003/2005. It will help you in finishing your work more quickly and the saved time can be enjoyed with your friends. I found these while searching the same for myself, and now would happily like to share with others. So here is the Comprehensive list of keyboard shortcuts of Visual Studio Application Programming and Internet Explorer 7(IE7).

[pdf] [size: 120KB] VisualStudio.NET_2005_Keyboard_Shortcuts.pdf
[pdf] [size:1.5MB] VisualBasic_2005_keyboard_shortcuts.pdf
[pdf] [size:1.4MB] VCSharp_2005_keyboard_shortcuts.pdf
[pdf] [size:41KB] MostUsed_Shortcuts_VisualStudio2003_2005.pdf
[pdf] [size:760KB] InternetExplorer7_shortcutRefrence.pdf

To get Microsoft list of Complete list of default setting Visual Studio shortcuts keys, go to: http://msdn2.microsoft.com/en-us/library/xte2hh6a(vs.71).aspx
All of the download are available in PDF format, just download them and Speed up the growth of Information technology.

References:
www.codinghorror.com
www.microsoft.com