Digicorp

Configuring High Availability of Web Server and Database Server on Amazon EC2

June 22nd, 2011 by bhumish.shah § 0

Amazon Elastic Compute Cloud (Amazon EC2) is a web service that provides resizable compute capacity in the cloud. Amazon Cloud Computing is a good choice if you want to deploy very large scale network on the cloud which requires high availability, auto scaling and load balancing features.

In this article I will explain how you can configure High Availability for Microsoft Sql Server 2005/2008 & Web server (IIS) in Amazon EC2. I am assuming that you have basic idea and knowledge of how Amazon EC2 works.

First of all let’s start with Amazon Load Balancing for Web Server.

Assuming that you have created 2 instances for your web server in Different Availability Zones and deployed your web application on IIS.

Just go to Load Balancer tab in EC2 menu,and then click on Create a New Load Balancer

Select Ping Protocol http, Ping Port 80, ping file name: iisstart.htm

Note: Ping Path file should be there to work load balancer, load balancer will check iisstart.htm file at 0.5 minutes interval.

On next page just select your 2 web server’s instances

Just click on create button in next screen.

Make sure that you’re both web servers instances are on different Availability Zone. For example 1 web Server on US-East-1a and other web server’s instances on US-East-1d as shown in above screenshot.

Different Availability Zones means different data centers of Amazon in same Region.

You can check your Load Balancer’s status on below link . Make sure that your both instances are In Service mode.

That’s it your web server is now configured with load balancer URL which Amazon provides.

Now you can access your web Server from Load Balancer’s URL.

For Sql Server’s High Availability we can’t use load balancer but we have different options like Database Replication, Database Mirroring.

Now let’s see how to configure database mirroring in Sql Server 2005/2008.

For Database mirroring just take full database backup of primary database and restore it on secondary server with no recovery option. You also have to install Sql Server in witness server to have automatic fail over of the database.

Sql Server’s Database mirroring uses port 5222 port number so make sure that you have open 5222 port number in your security group (firewall).

After restoring database on secondary server go to primary server, just right click on your database then click on database mirror wizard and follow the instruction as below

Click yes on do you want to configure security to include witness server roles wizard.

Select primary database instances on below screen.

Select your mirror server instances

Select the Witness Server’s Sql Instances

Click finish button to start the database mirroring .

That’s it. Your Sql server’s high availability setup is completed. If your primary server goes down it will automatically switch connection to mirror server and your mirror server becomes active now. So your clients or you will not have any problems at all to access your application!

Qmail send conflict with google apps SMTP

June 10th, 2011 by sonal.shah § 3

Recently I have faced one issue during server transfer.we needed to transfer server from shared to dedicated.this dedicated server was having parallel plesk control panel,which has by default qmail-send program enabled for mail sending. we choose google apps SMTP server for mail send.

Now Issue we encountered was as below :
In Our Site,Two e-mails are sent when filling out our “Contact Us” form.
(1) One E-mail sent to the person who filled out the form
(2) A copy of the inquiry is sent to [email protected]
1st was working fine,but 2nd was not working..we were not receiving any mails on [email protected]

every time we were getting failure notice,while sending mail to [email protected]

It was like below :

‘Hi. This is the qmail-send program at mysite.com.
I’m afraid I wasn’t able to deliver your message to the following addresses.
This is a permanent error; I’ve given up.
Sorry it didn’t work out. : This address no longer accepts mail. ‘

Solution of this issue is as below :-

For Mail Purpose, we were using google apps SMTP server which means external MX-record was enabled,
while parallel plesk control panel has by default internal MX-record service was enabled.

we can not have 2 MX-records enabled at the same time.
so we need to disable internal MX-record.so we disabled mail service from PPP(parallel plesk panel) and all started to work properly!!!.

Use MySqli Extension Instead of MySql

June 3rd, 2010 by divyang.shah § 2

It is highly recommended that you use MySqli extension of PHP instead MySql as in near future it will be deprecated from PHP. It is more secure, reliable and object oriented.

Following are some useful links which will give you jumpstart on MySqli:

Overview
http://www.php.net/manual/en/mysqli.overview.php

Prepare statement example
http://www.php.net/manual/en/mysqli-stmt.affected-rows.php

Multi-query example
http://www.php.net/manual/en/mysqli.multi-query.php

Enjoy your new DB classes.

How to Install and Configure Visual SVN Server for Windows

May 13th, 2010 by bhumish.shah § 0

This article will describe how you can get started with the subversion server based on Windows.

I’ll use the Visual SVN standard edition. Visual SVN is also available in the enterprise edition but it is not free. The standard edition is free and you can use it in a commercial environment.

Links for the Visual SVN Server : http://www.visualsvn.com/server/

Download links for the Visual SVN standard edition:http://www.visualsvn.com/server/download/

Download it and install with the administrator privileged on the system.

Select VisualSVN Server and Management Console.

Select the location where you want to install VisualSVN Server and store SVN repositories.

You can use 2 types of authentication:

1) Subversion Authentication: The SVN Server uses its own authentication. It will create its own database for users , groups and permission.

2) Windows Authentication : This option will allow you to assign rights to Windows users and groups.

Now, I’ll describe how to use SVN authentication.

After installation open VisualSVN Server Manager. Create a New Repository. You can also use Trunk , Branches and Tags. Here, we are going to create a repository named subversion.

- Create one user for testing purposes and name it digicorp.

- After creating a subversion repository, right click on it and go to the Security tab.

- Remove “Permission to Everyone” or select “No Access to Everyone” and give read/write access to digicorp users.

We are now done with the server aspect of the configuration. A link will be created for the subversion repository like this: https://terminal.digi-corp.com/svn/subversion/

You can also specify the IP address instead of giving a domain name like this: https://192.168.0.204/svn/subversion/

Now I’ll descibe the client aspect of the subversion server.

Download the Tortoise SVN client and install in on a Windows machine. You can not install Tortoise SVN client on a Linux machine. For linux System you can use SmartSvn, KDESvn, etc.

Here is a link to download Tortoise SVN client for Windows: http://sourceforge.net/projects/tortoisesvn/files/Application/1.6.8/TortoiseSVN-1.6.8.19260-win32-svn-1.6.11.msi/download

After installing the Tortoise SVN client, right click on the desktop and select SVN Checkout. Accept Certificate permanently.

URL of Repository : https://terminal.digi-corp.com/svn/subversion

Now we have completed both the server and client aspect of the configuration.

Visual SVN Server has the backup and restore functionality also. But we have to use the command line.

Go to the following location on Server: C:\Program Files\VisualSVN Server\bin\

Execute the following command to Take backup: svnadmin.exe dump subversion

This is a Simple SVN Server solution and is very useful for smaller organizations that want to start or test the Subversion functionality. For use in bigger organizations you can try Linux-based Subversion Server which is very stable and more reliable as well.

SVN Hooks Configuration

May 11th, 2010 by bhumish.shah § 2

Today, I will show you an excellent way of doing a code review of your team.

This article is based on Fedora, Redhat, CentOS distribution.

I’ll talk about how to configure an SVN commit event for email notification on repositories named svnmailtesting.

After installing subversion in Linux you can find the subversion-tool in following location:

/usr/share/doc/subversion-1.4.4/tools

You can find mailer.conf in the following location:

/usr/share/doc/subversion-1.4.4/tools/hook-scripts/mailer/mailer.conf.example/

An example for the Mailer.conf. is the main file for configuration. It looks like this after removing the comments:

[general]
smtp_hostname = 192.168.0.208
[defaults]
diff = /usr/bin/diff -u -L %(label_from)s -L %(label_to)s %(from)s %(to)s
commit_subject_prefix = [SVN-Commit]
propchange_subject_prefix =
lock_subject_prefix =
unlock_subject_prefix =
from_addr = [email protected]
to_addr = [email protected]
reply_to =
generate_diffs = add copy modify
show_nonmatching_paths = yes
[maps]

This is a very simple file . You have to just change the smtp server, “from” address and “to” address according to your environment.

You can either configure mailer.conf.example and rename it to mailer.conf file

Just copy and paste the above code in mailer.conf file

For example :

#vim mailer.conf

Copy the code above and paste it in the mailer.con file and change the smtp server , “from” address and “to” address. After completing these steps, copy mailer.conf file to following location:

cp mailer.conf /var/www/svn/repo/svnmailtesting/conf/

After completing the steps go to the following path:

/var/www/svn/repo/svnmailtesting/hooks/

Rename post-commit.tpl file to post-commit and make it executeable so the apache user can execute this file:

# cd /var/www/svn/repo/svnmailtesting/hooks/
# mv post-commit.tpl post-commit
# chmod 770 post-commit
#vim post-commit

Add the following line at the end of the file:

/usr/share/doc/subversion-1.4.4/tools/hook-scripts/mailer/mailer.py commit “$REPOS” “$REV”

After completing these steps, whenever a user commit in svn repositories (svnmailtesting), one mail will get sent from [email protected] to [email protected] account with the subject: You have configured in mailer.conf file.

Great, so now you have an excellent way of doing code reviews of the developers.

Please write in comment if I have missed anything here.

CO2 Net : A Concept of Future Networking

January 6th, 2010 by Nilesh § 16

It was a nice normal working Tuesday at Digicorp.

We were a bit busy and a bit relaxed as it was nearly end of the day, around 5:15 PM or something. I was digging my mind to crack a complex feature in Unisite calendar module. and suddenly my colleague Vishal Parmar jumped to me and asked me Nilesh what if Internet because usual part and normal part of every computer, just like a disk-drive or any other part. and he was looking at me with his a bit childish face.. and thinking as he has cracked some kinda joke and waiting for the response from me.

…………and kboom I got a small spark in my brain……

and we guyz literally fall in to all new kind of discussion, and I got the idea that vishal was thinking right that Internet should be a part of every computer, or mobile or any device which falls in to digital categories. and it should be also provided free as well, but the problem is its not possible as our current Internet is hanging on a tree of massive cabling of OFC, conductive and satellite etc . and all this costs so Internet too.

but then I came up with an idea a Network using Naturally available and spread resource and I had selected Co2 ( Carbon Dioxide ) as my network resource.

The idea is straight simple using few component

CO2 Net

Build small New gen modem (Device) which will send / receive,
and the device will send / receive using the molecular structure of Co2 of the earth’s atmosphere, and the signals will travel across the atmosphere by riding the Co2 enabling any capable device to reCapture / receive,
A small authentication will be bounded to each packet exhausted in the Co2, so the right candidate can only receive them

That’s it.

I know the idea might look silly at first, but think and you will find possibilities.

waiting to welcome your responses.

cheers

Find HTML Editor in QTP

December 7th, 2009 by mehul.brahmbhatt § 3

Follow below steps to read and write contents from an HTML Editor if you are testing using QTP

Step 1: QTP by default can not find an HTML Editor so you have to add HTML Editor in object repository. It will add HTML Editor as a frame.

See below image for an example

HTML Editor

Step 2: Below is an example of how to write contents in an HTML Editor. Write below line once you have added HTML Editor as an object.

Browser(“NewRelease”).Page(“Registration”).Frame(“Frame_2″).Object.write “Testing of add news page.”

Step 3: Below is an example of how to read contents from an HTML Editor.

fName = browser(” New Release”).Page(“ Registration “).Frame(“Frame_2″).WebElement(“testing”).Object.innerText

Paypal shopping cart integration using HTML for Beginners

November 9th, 2009 by devdatt.mehta § 13

In online payment paradigm Paypal is one of the best and popular online payment services. Through this article I will share my experience with you about integration of online payment services.

Novice developer may find this post very useful.

I have used following methods for the online payment integration in my shopping cart.

In development process you need to create paypal testing account for that create paypal sandbox account for the testing purpose.

Step 1: https://developer.paypal.com/
Step 2: Create new account
Step 3: Paypal will send you activation link in your email inbox.
Step 4: Login in sandbox
Step 5: Create Test Accounts for buyer and seller accounts

Go to the Test Account page in paypal. Basically you need to type of account for your site integration
1.Buyer Account
2.Merchant Account.

Select country “United States”.
If you want to create buyer account choose Account Type: Buyer
Fill the form accordingly. Keep your login and password some where.
Click on “Show Advanced Options”.
Choose what card you want to use when will do online purchase for testing.
Set Account Balance.

Create seller account in same way as above.

Paypal gives you many ways to integrate your site with but here I will explain one method for the integration.

Simple Integration
==================
In simple integration with your site you need to know some predefined html variable created by paypal.

Not all the HTML variables I shown here but some of the important that I showed here out of other it is depend on your merchant account and situation.

Ref: https://cms.paypal.com/us/cgi-bin/?&cmd=_render-content&content_ID=developer/e_howto_html_Appx_websitestandard_htmlvariables

set following html variable as hidden in your Buy Now button page in your shopping cart page.

Replace all the value as per given instructions under the value attribute.
<FORM name=”redirectoPaypal” METHOD=”POST” ACTION=”https://www.sandbox.paypal.com/cgi-bin/webscr” />
<INPUT TYPE=”hidden” name=”CMD” value=”_xclick” />
<INPUT TYPE=”hidden” name=”amount” value=”shopping cart total amount of selected items” />
<INPUT TYPE=”hidden” name=”item_name” value=”shopping cart item description or name” />
<INPUT TYPE=”hidden” name=”item_number” value=”selected item number” />
<INPUT TYPE=”hidden” name=”quantity” value=”selected item quantity” />
<INPUT TYPE=”hidden” name=”currency_ code” value=”USD” />
<INPUT TYPE=”hidden” name=”invoice” value=”invoice number” />
<INPUT TYPE=”hidden” name=”business” value=”your merchant paypal login id” />
<INPUT TYPE=”hidden” name=”return” value=”site url for success page” />
<INPUT TYPE=”hidden” name=”cancel_return” value=”site url for cancel paypal payment page” />
</FORM>

more explanation of html variables.
“CMD” is use for shopping cart do not change it.
“business” in testing set seller account id here after complete testing change to real merchant account id.
“return” is page url of your site paypal will redirect on this page with some extra variable such as transaction id. just debug with var_dump($_GET)
and use.
“cancel_return” is page url of your site. paypal will redirect on this page if user will denied to confirm the payment.

put above code in your page and test it.
when your set-up working successfully. change the action url to “https://www.paypal.com/cgi-bin/webscr” for live.

API Integration
================
coming soon……

Different Type of Monkey Testing

October 23rd, 2009 by jignesh.patel § 3

Monkey Testing

Monkey testing is used with fully automated testing tool. This tool doesn’t know how to use any application, so it performs mouse clicks on the screen or keystrokes on the keyboard randomly. The test monkey is technically known to conduct random testing, which is in the category of black-box testing. Below are different types of monkey testing.

Dumb monkeys
Semi-smart monkeys
Smart monkeys

Dumb Monkey Testing

The initial and the lowest level of testing service is called Dumb Monkey Testing, which is run without specific test in mind and often by a person with no or very limited education in testing.

But Dumb Monkey Tester does not mean a person of no intelligence at all, it rather means absence of any planning in the testing process.

Dumb Monkey software testing services:

Guesstimate about required time and staff
No formal planning and acceptance criteria
Click-through an application or a system
Very fast results from a done work

Semi-Smart Monkey Testing

Having some experience and improved testing skills the Dumb Monkey reaches the next stage in evolution: Semi-Smart Monkey Tester, who is the most effective when working in small groups.

Semi-Smart Monkey software testing services:

Initial level of planning and acceptance criteria
Guesstimate about required time and staff
Reading requirements before test run
Semi-technical bug reports, logs recording
Initial level of regression testing

Smart Monkey Testing

Smart Monkey is a crown of monkeys testing evolution. Having the army of Smart Monkeys it is possible to finalize vast testing projects, use tools and initial testing theory, bug trackers. Usually Smart Monkey area of activity is limited by his/her testing environment.

Smart monkeys are valuable for load and stress testing; they will find a significant number of bugs, but are also very expensive to develop.

Smart Monkey software testing services:

Repetitive planning and estimations
Attempts to analyze requirements before test run
Creating test scenarios
Issues Tracking Systems usage
Initial level of regression testing
Finding memory or resource bugs

Create Virtual Machine in VMware Workstation

October 23rd, 2009 by mehul.brahmbhatt § 0

Vmware Workstation makes it simple to create and run multiple virtual machines on your desktop or laptop computer. You can convert an existing physical PC into a VMware virtual machine, or create a new virtual machine from scratch. Each virtual machine represents a complete PC, including the processor, memory, network connections and peripheral ports. VMware Workstation lets you use your virtual machines to run Windows, Linux and a host of other operating systems side-by-side on the same computer. You can switch between operating systems instantly with a click of a mouse, share files between virtual machines with drag-and-drop functionality and access all the peripheral devices you rely on every day.

Steps to Create a Virtual Machine

Create a Virtual Machine

Open a File menu and select a new Virtual Machine or you can directly click on the virtual machine from home tab of Vmware Workstation.

.Now select a type of the configuration ( Typical )

a) Typical (Recommended): It creates workstation with recommended option. For Example: It will automatically select recommended workstation, memory, processor and network connection.

b) Custom (Advanced): You can manage your custom settings from this type. For example: User can set number of processor, select memory of virtual machine and network connection.

.Guest Operating System Installation

a) Installer disc image file (iso): User needs to select an iso image of the respective operating system which he needs to install on virtual machine. User has to select this option if he wants to install operating system.

b) I will install operating system later: If user do not want to install operating system for now then he can select this option. It will create a blank operating system in virtual machine and user can later install the operating system..

Guest Operating System

User has to select an operating system type from this option. For example User select Microsoft Windows, Linux and Sun Solaris etc. Based on selected operating system type it will display respective version of the operating system. User can also select it and go ahead.

Name the Virtual Machine

User has to enter name of the virtual machine and needs to give location to save the selected operating system image, System will save the image of operating system on the given location.

Specify Disc Space

User has to specify disk space to create a virtual machine. He has to give disc size in GB. Recommended size for Operating System window XP is 9 GB.

Final Step: Ready to Create Virtual Machine

It will display preview of all the details which you had selected. For example Virtual Machine Name, Location, Version, Os, Hard Disk, Memory etc.

Before Finish, You can also customize Hard ware settings if required otherwise you can finish the step. User can customize memory, CD / DVD, Display and Processor etc.

Once all the customization completed then user can finish the step and it will create a virtual machine as per given details.

Categories
- Amazon
- Arabic
- asp.net
- Code
- code review
- Concept/Idea
- coverage
- design
- developer event
- facebook
- Flex
- iPhone
- java
- linux
- php
- project management
- QA
- salesforce
- Security
- SEO
- Software Development Lifecycle
- SQL Server
- SVN
- Uncategorized
- vmware
Archives

Monkey Testing

Categories

Archives