Become SecurityTube Wireless Security Expert and/or Metasploit Framework Expert with Certification by Watching Videos and Practising Online Labs

Hi friends,

From my M.Tech university Cyber Security group, I got an e-mail to learn more about wireless networks and doing penetration testing on it.

I would like to share the links to download the video tutorials.

Please find the links become
http://securitytube-training.com/certifications/

You can enroll to the courses of your choice.

They are providing free video tutorials also.

Wireless Security Expert Course Videos link

All videos in single ISO
http://securitytube.aircrack-ng.org/Wi-Fi-Security-Megaprimer/WLAN-Security-Megaprimer-v1.iso

Individual Videos link
http://securitytube.net/groups?operation=view&groupId=9

Hope some of you can use this facility to learn more.

Please send your feedback and queries to psrdotcom@gmail.com

Excel Macro to Split Cell Data with Delimiter and Copy in other Columns

Hi all,
Today I have written one more small macro in Excel to split the data with the delimiter and copy to the columns which are beside to the data.


Sub splitdata()

Dim data As String
Dim values As Variant
Dim i As Long

    Set DataRange = Range("A1").CurrentRegion
    Range("A1").Select
    For Each cell In Range("A1").CurrentRegion
       
        'Getting text from the cell
        data = cell.Text
       
        'MsgBox ("Data :" & data)
       
        'Gettings Values
        values = split(data, ",")
       
        For i = 0 To UBound(values)
            'MsgBox ("Value is: " & values(i))
            'Splitting to other columns
            cell.Offset(0, i + 1).Value = values(i)
        Next i

    Next cell  
 
'Autofit the content to the column
    Cells.EntireColumn.AutoFit
   
End Sub

Please send your feedback and comments to psrdotcom@gmail.com

Pay AP (Andhra Pradesh) Electricity Bill Online

Hi all,

Due to increase in the service tax the e-seva people are consuming service tax for the electricity bill depending on the electricity slab.

If you are paying the bills online then there won't be service tax on the electricity bill.

APSPDCL (Andhra Pradesh Southern Power Distribution Company Limited) is providing an option to pay the bills online for Krishna, Guntur, Prakasam, Nellore, Kadapa, Chittor, Anantapur and Kurnool districts.

Please follow the procedure to pay the bills online.

• Please click on this link https://www.billdesk.com/pgidsk/pgmerc/spdcl/SPDCLDetails.jsp
• Enter your Service Number
• Select your type of payment (Current/Advanced)
• Click on "Submit" button
  It will go to next page if all the details are correct.
• Verify the "Name" and "Address"
• Enter the "Amount" which you want to pay
• You have different payment options like (Credit Card, Debit Card, Internet Banking)
• Select any one them and proceed to payment
• Like all those online payments, you have to give your card/netbanking details to finish the payment.

Register and Pay Online

• If you register with your "Service Numer" then you can pay online and verify your payment history also. To register with APCPDCL, click on the below link
• SignUp/Login
• Click on the "New User?Sign Up"
• Enter your details
• Click on "Register" to complete the registration.
• By now onwards you can login to your account and pay the bills online.

Pay through ATP (Any Time Payment) Machine

Machine address/location

Other Payment Options

You can pay your bill by any one of these options from Pay Bill section
http://www.apspdcl.in/SPDCL_Home.portal?_nfpb=true&_pageLabel=Login_portal_page_163


You can create an account in APOnline and pay your bills online.
https://secure.aponline.gov.in/CitizenPortal/userinterface/citizen/loginform.aspx?ReturnUrl=/CitizenPortal/UserInterface/Citizen/SPDCLDispatcher.aspx

References:
Southern Power Distribution Company of Andhra Pradesh Limited (APSPDCL)

Simple Steganography to hide file(s) under an image in Windows

Hi all,

Do you want to hide your files under an image to secure important data? That is called Steganography.

In Windows with "copy" command, it is possible.

Pre-Requisites:
An image file with any image file extension .jpg, .png etc
A File to hide in any format
An archive file manager like WinRAR, 7-Zip etc.


Procedure:

We will be explaining with sample example and the following files will be used in the explanation.

cutebaby.jpg -> Cover Image, which hides the data file
topsecret.txt -> file to be hidden
babygirl.jpg -> stego image, which contains hidden data file
E:\PSR\My\Experiments\Steganography -> Working Folder

• After arranging the pre-requisites as above shown, archive your data file (file to hide). In this example, it is "topscret.txt"

• Now you will be getting the archive file named "topscret.zip" in the file explorer
• Open Command Prompt and Navigate to the corresponding folder. In this example
• Delete the "topscret.txt" by using the "del" commad

• Now, run the copy command with the following syntax 
• Syntax: copy /b +  
• Example: copy /b cutebaby.jpg + topsecret.txt babygirl.jpg

 

• It will create an image file which contains hidden data file in it.

• To view the stored data file from the image, open the image file from archive viewer.

• Specify the path to extract

• Click on "Extract" button

• View the file list from Windows explorer and/or command prompt

• Check the data file content

 

Note:

• The stego image file size would be more than the data file + cover image file size
• Any one can view the data file if they know that data file is hidden under the cover image

 

If you have any queries, send mail to psrdotcom@gmail.com

Title Bar Missing Problem When Alt + Space keys pressed in Ubuntu for Window Menu Barwith Solution

Hi friends,

I had been facing an issue in my Ubuntu desktop edition.

The problem is, when I was pressing Alt+Space buttons on keyboard for window menu bar, the window title bar is gone.

I was surprised !!!

This will a big headache till you do any one of the following actions Logout, Restart or Shutdown your system (PC).

Finally after searching in Internet, I found the solution which worked for my Ubuntu desktop.

I would like to share that to all.


Solution 1:

• If you have installed "Compiz" then,
• Please go to "CompizConfig Settings Manager"
• Check whether "Window Decoration" option is checked or not.
• If it is unchecked then "Check" it.

Solution 2:

• In command prompt (Console) window type the following command
• $ unity --reset

If solution 1 is not working for you then please go ahead with solution 2.

If you have any queries, you can reach me by mailing to psrdotcom@gmail.com

Check Website Link (URL) for Safe Browsing to Prevent from Malicious Virus Attacks

Hi friends,

I downloaded a software. In "Readme.txt", I found a link and I would like to check how safe the link. Because, I was worried, what if, if I open the link and some virus installed automatically. So, I was searching for checking website URL (link) for safe browsing. I found that every Anti-Virus company got an option to do that.

Here you go and paste your Website URL (Link) for checking the content for safe browsing.

Online Webpage Virus Scanners:

• AVG Online Webpage Virus Scanner: http://www.avg.com.au/resources/web-page-scanner/
• Trend Micro Site Safety Center: http://global.sitesafety.trendmicro.com/
• Norton Safe Web: http://safeweb.norton.com/
• McAfee SiteAdvisor:  http://www.siteadvisor.com/sites/

Off-line Webpage Virus Scanners:

• McAfee SiteAdvisor: http://www.siteadvisor.com/

How the online webpage scanners works:

You need to copy the URL (Link) which you want to test for safe browsing.

Paste the URL (Link) in any of the online webpage scanners, and click on "Check" button if available or Press "Enter (Return)" button.

You will get the website (page) test report.

In some online webpage scanners, they have categorized the sites into groups and displaying that group.

Test Results:

I have tested one of best webpage in the world google.com and one infected site [1] orgsite.info

You can see the results of different online webpage scanners below

AVG Online Webpage Scanner:

Google Webpage Result

orgsite.info Webpage Result

Norton Online Webpage Scanner:

Google Webpage Result

orgsite.info Webpage Result:

McAfee Online Webpage Scanner:

Google Webpage Result:

orgsite.info Webpage Result:

TrendMicro Online Webpage Scanner:

Google Webpage Result:

orgsite.info Webpage Result:

By these links, whenever you are having a doubt about newly visiting URL (Link), you can always check browse the content

References:

http://googleonlinesecurity.blogspot.in/2009/06/top-10-malware-sites.html

Try day to day useful tools on your Windows/Linux(Ubuntu) operating system

Hi friends,

When I was surfing the internet, I found some useful day to day applications/tools. I thought "let me share these applications", so that atleast someone will get benefit from at least some of the tools which they are looking for.

Let me briefly explain, what it contains. The best applications/tools in 2011 developed in Windows and Ubuntu operating systems.

I personally liked,

Ubuntu Applications

News-RSS Ticker: Place your feed on desktop
Blogilo: Desktop Blogging client
MyPaint: Paint app similar to windows
Cairo-Dock: Mac like dock
Lockit: Take screenshot of app or specific area
Desktop Nova: Wallpaper rotator
Gnome Subtitles: Customize subtitles for a movie or any video
Touchpad Indicator: Automatically disable touchpad when mouse is connected
Live USB Installer: Load operating system to USB and use it anywhere you want (Carry OS with you)

Windows Applications

FTP Scheduler: Schedule your FTP upload/download file times
Tweak IE9: For better security in IE and Groupping Tabs like Firefox
CSVed: Editor to edit CSV like files
DiffPDF: Compare the differences between PDF files
TexMaker: Editor for Latex files
Folder Axe: Split your large files
Mosaic: Windows 8 look in Windows 7
Image Composite Editor: Stich photos to make panorama image
BlueStacks: Run Android apps and Games in windows
Batch Compiler: Compile you batch files and make executable
TyperText: Specify your own keyboard shortcuts to run/launch applications and even website links
KumoSync: Sync your google docs to local computer
Soluto: Remotely manage and fix PC Issues

Lot more tools are available online .. Hope some of the above apps will be useful to you.

References:
www.addictivetips.com/ubuntu-linux-tips/best-60-linux-applications-for-year-2011-editors-pick/
http://www.addictivetips.com/windows-tips/150-best-windows-applications-of-year-2011-editors-pick/