Thursday 13 December 2012

Downtime Calculation


Downtime Calculation: Ex. A site which has only 2 hours downtime in a 30-days month will have downtime % like the following :-

D = Total downtime (in minutes)
T = Total time in the month (in minutes)

Downtime (in %) = D/T X 100

D = 2 X 60 minutes = 120 minutes
T = 30 days X 24 hours X 60 minutes = 43200 minutes

Downtime (in %)
= [120/43200] X 100
= 0.2777 %

Uptime (in %)
= 100 - 0.2777
= 99.7222 %

In other words, you have 99.722% of uptime throughout the month.

SLA % - usually calculated at 99.90% 
Outage SLA (mins.) - 167 mins. in a year
Calculation Ex: 
From 01-01-2012 to 31-12-2012 Holidays:8holidays+Fri+Sat off days adds upto 112 days holidays. So difference from day 1 of year until last day of year minus holidays = say 112 days
So total working days = 365 - 112 days = 253 working days. You may also calculate with excel formula; NETWORKDAYS.
So, Total number of minutes in working days = 253x11*60=166980
where 11 is the total business hours (may vary from organisation to org'n) in a day and 60 is for 1 hr.
So, 166980-(166980x99.90%) = 166.98 mins. Outage SLA in mins in a year for an org'n. should be around 167mins. Any downtime exceeding beyond 167 mins violates the SLA.

Monday 3 December 2012

Important Vulnerability Basics

Use the vulnerability assessment tools to identify the vulnerabilities you need to repair. This will help protect your website or network against security breaches.

Vulnerabilities
Critical versus informational
Vulnerability assessment
Best practices

A vulnerability is a weakness or flaw in your website or network. Vulnerabilities can be exploited to damage or compromise customer and other sensitive data, or your site. If your site were a house, a vulnerability would be an open window or door. To protect your house, you'd lock that window or door. Websites and networks have analogous entry points, as well as ways to seal off those entry points for greater protection.
  
While not inherently dangerous, a critical vulnerability leaves your site exposed to serious breaches. For example, someone could gain access to sensitive data, alter your site's appearance or function, or infect your visitors' systems. How critical a particular vulnerability is depends on two things:
 
1) How commonly exploited the entry point is, and
2) How much damage a breach to that area could cause.

For example, in a house, doors and windows are more commonly exploited than floorboards and chimneys. Similarly, some parts of a website or network are more commonly exploited than others. Some areas also may contain especially confidential or valuable data, so a breach of those parts would be more critical than a breach of other parts.

When you activate vulnerability assessment, we scan your website or network or both each week for common entry points which, if breached, could threaten your online security. You receive the results of the scan in a downloadable PDF report highlighting the most critical vulnerabilities. Non-critical vulnerabilities are listed in the section labeled "Informational."

You can activate or deactivate vulnerability assessment from within your account. Once you activate vulnerability assessment, your first PDF report should be available for you to download within about 24 hours. After that, we'll run the scan weekly, and generate each new report within about 24 hours of the scan.

Note: Only the presence of critical vulnerabilities (not informational) will trigger an alert in your console. Your report will be available for download each week whether or not you have critical vulnerabilities.

When you are logged into your account, you can set or change your email notification preferences for vulnerability assessment. For example, you can choose to receive notification emails only for critical vulnerabilities, each time a new report is generated, or when we are unable to scan your site.  You can also choose email recipients.
 
To help protect against security breaches, it's recommend that you:
·         Activate the vulnerability assessment service.
·         If you already have a vulnerability scanning service, use vulnerability assessment as a cross-check for your other scan's results. Scan results can differ from company to company.
·         Designate someone in your organization to review each report, and to have any critical vulnerabilities repaired as soon as possible. Set your email preferences to notify your designated person when new reports are available.
·         After making repairs, rescan your site to verify the repairs.
·         Read and follow the suggestions in the Malware Prevention article below—they also apply to vulnerability.

5 Minutes Guide to Malware

Malware is the new computer virus, the new worm, the new spam. In fact, malware is all of those and more. Malware is a genuine threat to your Web site, to your business, and to your customers. Malware leads to:
  • Web site traffic loss – New customers are warned about your site and loyal customers stop coming back.
  • Brand tarnishing – Your company's reputation – not just your Web site – is damaged.
  • Consumer confidence erosion – Consumers will not trust your Web site, your business, or your products and services.
Instead of overt Internet vandalism and mayhem, today's malware criminals stealthily infiltrate Web sites and home computers for devious or illegal profit.
Their mission: Put malware on your site and spread the malware to your visitors for fraud and theft.
Your mission: Keep malware off your site and keep customers on your site!
Why should I care about malware?
Trust. Your customers and business partners trust that your Web site is safe. Malware on your site diminishes or eliminates that trust.
  • Customers who are warned of or infected by malware on your site will no longer trust your site or your business. They may stop doing business with you through any means.
  • If there is malware on your site, Web browsers like Internet Explorer and Firefox and search engines like Yahoo! and Google will show a warning that your site is dangerous when a customer tries to visit it (this is known as "blacklisting").
  • Malware on your site can install malware on your customers' computers (known as "drive-by downloads"). Malware on your customers' computers can steal their personal information, track their keystrokes and activities, and spread viruses and more malware.
What is malware?
Malware is any computer program that is installed on a computer without the owner's knowledge, in order to deliberately damage the computer or perform illegal activities.
  • Malware is short for "malicious software". Malware is related to the more well-known term "computer virus", but they are not exactly the same.
  • Malware is a broad term used to refer to many different forms of hostile, intrusive, or annoying software, such as computer viruses, worms, trojan horses, rootkits, spyware, dishonest adware, and crimeware.
How is malware used?
For illegal profit, consumer deception, Web site vandalism, and other criminal activities.
  • Adware shows pop-up ads on infected computers and the attackers collect payment based on the number of times the ads appear.
  • Spam is the bulk junk mail that everyone gets in their Inbox. Spam can be sent from malware-infected computers. The attackers collect payment based on the number of emails sent or on responses to the sales or information requests in the emails.
  • Identity Theft and Infostealing capture private information, such as usernames and passwords, credit card and banking information, or social security numbers. The attackers can use the stolen data directly to impersonate the theft victim, or sell lists of stolen data within their crime network.
Where does malware come from?
Like a computer virus, malware starts on a few computers and then spreads to many computers.
  • To effectively distribute malware to as many computers as possible, the first goal of a malware attack is to infect your Web site.
  • Unknown to you and the people who visit your site, the malware then installs more malware on the visitors' computers.
  • Installation may be totally invisible to your site visitors – all a visitor needs to do is go to a certain page, and the malware can install on the visitor's computer. Installation may also be disguised as or packaged with a useful plug-in, which the visitor intentionally downloads and installs.
How do I prevent a malware infection? 
Keep your web server secure, clean, and backed up.
  • Maintain an up-to-date backup server.
  • Secure the Web server that hosts your Web site.
  • Secure any applications or other code that is executed or distributed on your Web site.
  • Know and trust the people who manage your Web site.
  • Remove programs that are not needed.
  • Do not use the server for other purposes, especially browsing the Web.
  • Do not rely on commercial, off-the-shelf antivirus services to protect your Web site.
  • See the Malware Best Practices article for more details on these prevention recommendations.
  • also read important vulnerability basics

Malware Prevention - Best Practices


Preventing Malware Infections
Preventing malware on your Web site is easier than you might think. And it doesn't require too much extra time, money, and resources to protect your systems. Following best practices for prevention and using the resources that you already have, you can significantly lessen the chances of having malware on your Web site.
Discuss these tips and guidelines with your developers and server administrators. Find out if and how these best practices are applied in your company. Set administrative and development policies based on these best practices as well as the recommendations of your trusted administrators.
Back up your Web server!
  • Perhaps the most significant preventive measure that you can take is actually preparing for the worst case scenario. What do you do when your Web site is infected and you can't just delete the malware? In that case, you want to make sure that you can recover everything that you use to run your Web site.
  • Maintain a redundant, up-to-date backup Web server. If your active server is infected, you can switch over to the clean backup server. Your customers will not experience any downtime while you clean the infected server.
  • If maintaining a redundant backup is cost- and resource-intensive, make sure that you have backup copies of all operating system and application software, including all patches and maintenance releases.
  • Make especially sure that you regularly back up all of the data. If any business or customer data is compromised or damaged, you can restore the data with minimal downtime for specific features – instead of taking your entire Web site offline.
Secure your Web server.
  • User access must be secure. Your administrators and developers should use strong passwords, change their passwords regularly, or use access credentials that are handed out by a trusted administrator.
  • Follow the "principle of least privileges." Know who has access to your server and make sure that only those who need access have it. Additionally, restrict user privileges person-by-person; give your administrators and developers only the privileges that they need to do their job.
  • File transfers must be encrypted. Use Secure FTP (SFTP) or Secure Copy (SCP) tools to transfer the files. FTP tools are not encrypted.
  • Practice secure application development. In your back-end code, validate user input type and eliminate security holes (known as "vulnerabilities") such as buffer overflow, SQL injection, and cross-site scripting.
  • On your customer-facing Web site, don't give away any information that your customers don't need – the information might be useful for attackers. For example, in error messages, don't show your server type or version or say that "we can't connect to the database". Don't provide specific login errors like "your password is wrong" – this message tells an attacker that an account exists with the username. 
Trust the person at the keyboard.
  • Make sure that everyone with access to your Web server understands and recognizes social engineering methods. Social engineering is convincing someone to do something or reveal confidential information, typically by impersonating a person of authority or influence. A saying goes: "it's easier to hack the person than it is to hack the machine".
  • Through social engineering, a malware attack starts without even touching your Web server. With just a little information about your company, an attacker can impersonate a company executive or external authority (such as the police or a lawyer) over the phone. If the attacker is convincing enough, the attacker might persuade a junior developer to unknowingly install or link to malware.
  • Have confidence in and trust all of the people who have access to your Web server. But regardless of your level of trust, your server should track user logins and all actions while logged in.
  • Trust and accountability are key to preventing the most direct threat – an inside job, a deliberate attack by an employee or colleague. Whether driven by personal reasons or coerced by an outsider, this person already has all of the access and privileges needed to put malware on your Web site.
  • For any changes to your Web site, have a clear sign-off process. You should also have contingency plans if critical people are not available, so that everyone knows what to do when you or your server administrator can't be reached. 
Use your Web server for one thing and one thing only: running your Web site.
  • Do not use the server to browse the Web, check your email, instant message, blog about your vacation, or send your mom photos from last week's family reunion. You have enough to worry about with attackers trying to get in – don't help them out by actively roaming the Internet.
  • Remove all unused programs from your Web server. Popular applications sometimes have known vulnerabilities that attackers can easily exploit. If a program is not being used, remove the program so that it is not a potential point of attack.
  • If possible, remove software documentation from the server and store it elsewhere. Documentation that includes application names, version numbers, and bug fixes can give attackers insight into what's on the server and how to gain access. 
Patch, patch, patch. Keep your server software, operating systems, and applications up to date.
  • Know what software is on your server. Keep a list of all operating system and application software installed on the server, including version numbers.
  • Keep all software on the server up to date and running the current versions. Newer versions often include fixes for known vulnerabilities. Vulnerability fixes close the loopholes that the hacker and malware communities know how to exploit.

Sunday 2 December 2012

TSIS CBSE nextBatch Starting Soon..!


Admission for academic year 2013-2014 - Kindergarten to Grade 5 starts on 15th of Dec 2012.

A glimpse showing all about it.

SSL Certificate Tester and DNSStuff

Reliable tools for verifying secure connection and tracking DNS & Emails

we are subscribed to these tools for our infrastructural support 

Thursday 29 November 2012

Emails Sent by Users are Stuck in Outbox/Draft Folder

ENVIRONMENT:
  • Exchange 2007 with clustered mailbox Server running on Windows 2003 64bit
  • 2 HUB & 2 CAS Servers
  • SMPT gateway (Ironmail from McAfee)   

SYMPTOM:
Emails sent by users were stuck in Outbox/Drafts folder. We had infact asked some of the users to send 5-10 test emails for a couple of days to study the case. Some emails were also sent using iPhones and blackberry handheld. So the ground fact was  that, not all emails were received by the recipients. 2-3 emails were stuck in the Outlook’s Outbox or Draft folder. This was the case when emails were sent using OWA (outlook web access) as well.

CASE IDENTIFICATION DATA:
We escalated this issue with Microsoft and thru’ analysis of server logs confirmed that “MSExchange Store Driver - 1014” warnings were logged for the users who had faced the issue with emails stuck in the Outbox.

Issues encountered during the test case: 
Restarted the Microsoft Exchange Transport service on both HUB servers. Moved the 3 affected Users’ mailboxes to another mailbox database.
During the mailbox move, the operation was canceled manually, and when the problematic users tried to access their mailbox, they received an error stating that there’s currently a move operation running.
We got this sorted by running Clean-MailboxDatabase for the source and the destination mailbox databases. And moved the CCR CMS to the passive node.
All users including the affected users could access their mailbox normally.

ACTION PLAN:
move one of the affected mailbox to another database
The above plan didn't sort the issue though. 

By investigating the logs further we could find something fishy in Monitoring tool “Quest software” which was installed in your Exchange infrastructure. We also noticed that this monitoring tool can cause the generation of similar symptom that we are facing currently. So in order to isolate the issue, we temporarily disable all the Quest related services in the two Hub Servers and two Mailbox Servers for three days and kept the antennas  monitored for “MSExchange Store Driver - 1014” alert was generated repeatedly.

CAUSE:
A third party “Quest service” was installed in Exchange server which caused failure in MSExchange StoreDriver to open the message item and hence resulted in failure for submission.

RESOLUTION:
We had disabled the “Quest services” in Exchange servers and further to this no alerts were logged related to MSExchange Store Driver. Also during this period, users did not face the issue of emails stuck in Outbox/Drafts. We concluded that Quest services are incorrectly handling some emails which make the Emails stuck in Outbox.

*Important* Virus Notification

Latest Virus/ Worm Threat

We have been notified by Antivirus Advisory Labs about a latest Virus threat 'W32/Autorun.worm.aaeb-h' which has the ability to infect removable media device and network shares..!

As an action plan, we have mitigated this risk by patching our systems & desktops with the latest antivirus protection and by adding additional controls. However, the viewers of this blog are requested to:
  i)  exercise caution while opening unsolicited emails and unknown files.
 ii)  refrain from using USB drives.
iii) download and use stinger tool for remediation in case of any suspicious virus message creeps up from your system.

From: McAfee [mailto:sns@snssecure.mcafee.com] 
Sent: Wednesday, 28 November, 2012 22:37

To: Rinith KT
Subject: *URGENT* McAfee SNS ALERT: *UPDATE* Reports of W32/autorun.worm.aaeb-h infections

**Update to original message: Stinger tool now available. See Mitigation section below**
McAfee has received multiple reports of customers who are severely affected by variants of W32/autorun.worm.aaeb-h.

Impact

W32/Autorun.worm.aaeb-h has the ability to infect removable media devices and mounted network shares. It can also copy itself into .zip and .rar archive files.
The infection starts either with manual execution of an infected file or by navigating to a folder that contains infected files. This threat has the ability to download other malware or updates to itself as directed by a Command-and-Control (C&C) server.

Mitigation

McAfee has released an Extra.DAT and Stinger to detect and clean this threat.

To download the Extra.DAT and Stinger, see KB76807


For more information on McAfee product coverage and mitigation for this threat, see PD24169 - Threat Advisory: W32/Autorun.worm.aaeb:

Wednesday 28 November 2012

Real-Time Intranet (SharePoint) Replication: Production Site to Disaster Revovery Site


SharePoint 2010 real-time replication to the Disaster recovery site using third-party tool; DocAve from AvePoint is one among them



We have been using this software for SharePoint replication since last 4+ years. It's a wonderful software designed for MOSS 2007 & SharePoint 2010 environment. Lot of features are embedded to it. We just got replication module licensed as replication from production site to DR Site was our concern. All we have to do is to first restore the destination site using the latest SQL DB site level backups. We used an independent server for the DocAve Enterprise manager. DocAve 6 Client Plug-ins were installed on the below Web Front-End servers of both source and destination site. That's it. The configuration is pretty simple. It does real-time replication instantly in less than a minute.
Real-time SharePoint2010 replication process - Production to DR Site


We had slight issues when we activated real-time replication. However, the issue got stabilized after re-scheduling the replication method to trigger incremental replication after business hours. Accessing database from different process like backup plan and real-time replication plan could have been a conflict.

Check my other postings on:


Scheduled Maintenance Plan for SQL Express DBs

Automate Database backup with SQL Express using scripts and batch schedule

Let us automate database backup in SQL Express with mixed Windows and SQL Authentication running on Windows 2008 Server.   This material was tested with Microsoft SQL Server 2008 R2 Express and SQL server 2005 Express Edn.

SQL Server 2008 Enterprise comes with Maintenance Plan feature.  SQL Express edition lacks this feature.  But you still need a backup.

Backup automation with SQL Express can be carried out by following the steps:
i) Create the script in sql to backup all your databases.
ii) Execute the script by initiating it from a command prompt (SQLCMD command).
iii) Schedule the script using Windows Task Scheduler.

i)
-- script starts here

DECLARE @dbName        VARCHAR(33)    -- database name
DECLARE @path          VARCHAR(99)    -- backup path
DECLARE @fileName      VARCHAR(99)    -- backup file name
DECLARE @fileQuarter   CHAR(1)        -- variable portion of file name

SET @path = '\\192.168.16.193\backup\TestDB\Bkp\' 
-- the above path is a remote location. make sure path is changed according to the environment you may have.

-- Returns a Numeral from 1 to 4
-- Each Quarter you get a new backup file name
SELECT @fileQuarter = CONVERT (char(1),(MONTH(GETDATE())+2)/3, 112)

DECLARE db_cursor CURSOR FOR
SELECT name
FROM master.dbo.sysdatabases
-- Exclude all System Databases, if Needed - 'master','model','msdb'
WHERE name NOT IN ('tempdb') 

OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @dbName  

WHILE @@FETCH_STATUS = 0
BEGIN
       SET @fileName = @path + @dbName + '_' + @fileQuarter + '.BAK'
       -- Use INIT and SKIP to overwrite previous sets
       BACKUP DATABASE @dbName TO DISK = @fileName  WITH INIT, SKIP
       FETCH NEXT FROM db_cursor INTO @dbName
END
CLOSE db_cursor
DEALLOCATE db_cursor

-- script ends here

--save the above script in .sql format (Ex. Bkp.sql)

ii) Create a windows batch file with .bat extension (Ex. bkp.bat) the content of which is as follows:

SQLCMD -E –S TST-APP1\myDB -i "c:\yourlocalfolder\Bkp.sql" -o "c:\yourlocalfolder\Log.txt"

iii) Now create a scheduled task from windows control panel. Make a schedule to run the batch file 'bkp.bat' file on a daily or weekly basis.

It is wise to take the same backup to a tape drive as per the backup plan: daily, weekly and monthly so that you don't leave a question or thought.

Serious security threat at International Airports



Serious security threat at International Airports - Govt. least bothered 

''this is true. I travel 2-3 times in a year to Calicut (my hometown);  and 'am a periodic traveler to other countries. I have noticed the vulnerable gaps and the lapse in many airport procedures'; which the authorities are not even concerned about. Their basic role is to mint money..! Their basic oath to the nation is to: 'live to trouble others' and not 'live to make pride'..! We have to understand the ground facts and needs to look at the big picture; the image of Calicut city as an instance and India as a whole is represented at the entry ports and those who have closer ties with the authorities and with political influences are even exempted. Shame on the fragile policies..! 

Another key note which I would like to put up here is; (which evidently most of you might have noticed) Most of the Customs authorities sit at the check points after consumption of liquors. If the responsible authorities check the airport staff with 'Breathalyzers Screening Devices' to check a person's blood-alcohol content, then we are sure it will be a flash news. 

Another frustration which we normally encounter is that there is no proper system at airports to deliver the baggage to the right individual. Anyone can take any-others baggage if unnoticed. Individuals might take others luggage deliberately or inadvertently as there is no controlled system in the airports. In fact, the airline authorities needs to take certain measures from their end to provide additional luggage security. An additional control could be empowered just by verifying the luggage tag code vs passenger ticket tag code"

In reality, we need to have an action oriented Govt.; who listens to the public. A cell with falcon eye, who monitors the evil factors.

Required Housekeeping on SQL Server after renaming the hostname

SQL Server 2008 – Server Name Change (compiled and written by Rinith)

It might cause serious impact for your business applications running on backend SQL server, if the SQL server hosted server has been renamed without doing a proper housekeeping on the SQL Server itself.

So, in other words, if windows admin changes the server name, the following changes needs to be carried out on a sql server 2005-2008 (tested ok):

 
Changed server name shows 'hrms-app2' so we need to make this effective on the SQL server as well.
1. Open SQL Server Management Studio and click New Query.
2. Type Select @@ServerName to verify that the server name is correct or incorrect. In this example, I changed the Windows 2003 from HRMS-APP1 to HRMS-APP2.
follow the steps:
3. Next, type sp_dropserver 'HRMS-APP1'
syntax:
sp_dropserver <old_name>  (old name is the name you get from the select @@servername)
GO


4. You are now ready to add the correct name by typing sp_addserver 'HRMS-APP2', local

syntax:

sp_addserver <new_name>, local
GO


if you just mention sp_addserver 'newservername' wont show the right result, though the command will executed properly.

Restart sql server and the sql server agent by opening a command prompt and type: net stop mssqlserver and then net start msssqlserver to stop and start the sql server agent, type net stop or start sqlserveragent.

you might see a message with status 'disconnected' when executing sql queries after the above net start commands.
just close the sql management studio and start again, should work

note: A reboot might be required based on various environmental factors like:
even after reconnecting sql server name not displayed properly.. or selecting the statement showed servername as null.
this might have caused coz we executed the command sp_addserver 'HRMS-APP2' instead of sp_addserver 'HRMS-APP2', local


Restart the SQL server services with the above commands (net start...) and then see if the new servername is displayed or not.
check and confirm the server name (Select @@ServerName ) after restarting the server.


Monday 15 October 2012

Outlook 2010: Display reminders from shared calendars by delegating permission

This might be very useful for the company secretary to get email notification to the inbox when a meeting is requested to his/ her Supervisor. Attendees may accept or reject the meeting, that's not our concern. Concern is - your secretary should receive the notification.
 
So it's pretty simple in Outlook 2010; all what you have to do is to delegate the permission to the person from the source email account by following the below displayed steps:

Click Account Settings – Select Delegate Access

Add the person with whom you have to give delegation to your Calendar or Emails or any other Task

Check delegate receives copies of meeting-related message sent to me. that's it.