Excel opens blank spread sheet

Excel-icon

This happens when something dealing with the file associations with excel stop working correctly. I am not sure what the exact cause is but I have only seen this in Citrix environments with Office 2007 installed. Opening spreadsheets through the excel program itself works correctly but trying to open a spreadsheet by opening the file through explorer or though a shortcut wont work.

To fix the problem…

1. Go to the folder options in control panel and select the “File Types” tab.

2. Navigate to the “xlsx” extension and click advanced. Under actions highlight “Open” and click “Edit”.

3. In the “Application used to perform action” box verify that the path to the excel executable is correct and then remove any switches that come after it. You will probably have to remove something like “/dde” or “/n” for example.

4. Once removed add /e “%1″ so that the box should read something like what you see below:
“C:\Program Files\Microsoft Office\Office12\EXCEL.EXE” /e “%1″
NOTE: the “” around %1 are important.

5. Now uncheck “Use DDE”. Click OK and close out of all windows.
NOTE: if you reopen the advanced settings for the “open” action you will see that the DDE option has been re-checked off even though you un-checked it. This is ok.

If this works you will need to repeat this process for all of excels extensions that are affected like “csv” and “xls”.



Infected with net.net virus

virus_alert

It has finally happened, last night I was infected with the net.net virus. I was searching some forums, not sure which ones, and out of no where java errors started exploding on my screen while images were loading. That is usually never a good sign and I knew something was up. I closed my browsers and opened task manager and saw some oddly named processes. Then a popup notice appeared saying “Windows defender” was deactivated… also not a good sign. I then turned to “msconfig” to see if any new items have been added to my startup. I saw “net” was now in my startup programs. I than went into my “system32″ folder and sorted by date to look for any files that have been created with the past few minutes. I saw a program by the name of “net.net” along with a dll file named “ernal32.dll” (notice the missing “k”) plus an executable file that’s name appeared to be random generated and all were created with in the same time frame, a minute apart, and very recently. I immediately moved the files to a different location and renamed them, just in case by some chance they were system files I didnt just want to delete them. I then removed the “net” from startup and rebooted. After reboot no new files were created.

Now before I go any further let me explain that I did not have a anti virus installed… I know… I know. Even my wife gave me crap about it. I did have trend installed at one point but then it expired and I upgraded my laptop to win7 and just never got around to it, and again I know, not an excuse. Well so I then proceeded to attempt to go and download “Microsoft Security Essentials”, I have heard actually some pretty decent things about it and thought I would give it a try but when going to the down load page I would get an II7 error saying the file did not exist. Umm… ok, that wouldnt be the first time I had problems downloading something from Microsoft so I went to Trend Micro and tried to use there online scan tool called Housecall. After downloading I tried to install it but then received some odd errors. I tried to then install spybot and that to failed saying that the site could not be contacted. At this point I knew something was very wrong and even though I removed the virus, at least I thought so, something was still not right. I checked my host file to see if any changes were made and found that in tact but saw a new ICS file has been created. Because I was short on time and didn’t want to deal with it all that point I did a system restore because I had no idea what else could have been changed in my system files. Luckily I had a restore point from the night before and I made no changes since then so I knew it would be ok to restore to that point. After the restore I was “mgically” able to download and install “Microsoft Security Essentials”. I scanned my laptop and found one virus and cleaned it out. I did also run “Housecall” from Trendmicro which showed no infections.

What was probably the most disturbing about this was that besides going to a webpage (a legit web dev forum) there was no other interaction needed for this virus to do its work. Most of the time I see people with popups or some other request for interaction. This required none of that. Even though I have seen it before his is the first time I have had this happen to me so my lesson has been learned. It doesnt matter if your vigilant and careful when surfing the web or not, if you dont have an antivirus installed your at risk.

If you need more detail then what I provide on removing “net.net” you can find them every where… just Google it. But if you have a restore point then use that followed by a full system scan with a reputable antivirus. I chose “Microsoft Security Essentials” simply because it is free and even MS critics have nothing bad to say about it. Additionally you may want to use a free scanning service like Trends “Housecall” for a second opinion. I have always been a big fan of Spybot as well, for spyware though, not viruses.



Backup Exec 12 Stays Queued

symantec_logo



Now there are MANY reasons why Backup Exec will go into a “queued” status but in this case I was running a SQL backup job that was backing up to a “Backup-to-Disk” folder located on a external (My World) WD harddrive. In an attempt to resolve the issue I tried restarting the services, reinstalling the agents, and rebooting the server itself, formatting the external drive. One if not all of these normally does help but sometimes they will not and the job will go back (and stay in) a queued state when the job is ran. For some reason from time to time this will happen when ever attempting to backup to external drives using “Backup-to-Disk” folder.



The only fix I have been able to find that actually works is creating a new “Backup-to-Disk” folder and then reconfiguring the job to use the new folder.

I still have not figured out why this happens (yes I looked at events) and if anyone has any insight on possible reason please share them with me because, to put it bluntly, its annoying.

When I have time to look further into this I will update the post with my findings.



Start, Stop, Restart Linux Services

tux

Starting, stopping, and restarting services varies depending on the distro to some degree But the general concept is the same.

One way to list the services is to run “ls” on the “init.d” directory.
# ls /etc/init.d

I will use “restart” for the examples but this can be replaced with “start” or “stop”. And because the networking service is a fairly common service to restart I will also use that in the following examples. Also, depending on disto and user rights “sudo” may be required.

Ubuntu/debian
# sudo /etc/init.d/networking restart

Redhat
# service network restart
or
# /etc/init.d/network restart




List Physical Memory in ESX (Linux)

term_icon

To do this use the “dmidecode” command. This command has many more functions which you can read more  HERE .

But for the task at hand… listing the physical memory issue the following command:
dmidecode -t memory







HP GbE2 Interconnect Switch Password Reset

The password to reset the admin password is “2wGDEp|B” (no qoutes and no user name) This must be done through the local consol/managment port via serial cable. After reseting the password immediatly “apply” and then “save” for the new password take take effect and to stick.

The reset procedure may need to done more then once to be able to login via the web interface… no idea why, thats what it took for me.



Linux Directory Structure (Visual FHS)

This structure could vary from distro to distro but this is a very generic linux directory structure taken from Ubuntu.The directory structure in Linux can be confusing for new users of Linux and even some experienced users tend to forget what is what from time to time. Most distributions have the same general structure of the base directory system.

Ubuntu File/Folder structure



Autorun.inf info

Good info…

The autorun.inf file is the key to getting your USB drive (or CD-ROM drive, for that matter) to perform certain actions automatically and customize it’s look in My Computer. The purpose of this article is to shed some light on how this can be done. Read More



Assign Drive Letters to USB Automatically (USBDLM)

I had a situation in where I have to store some very large backups on USB drives and they are rotated daily. If I wanted to use backup Exec but run more than one concurrent job at a time I could not put the drives in a pool and instead just assign a new “backup to disk” device. For example, one backup to disk device I have assigned to a folder on drive letter F. The problem came when switching the drives the next day. Windows would see the new drive but would not assign it the drive letter F because it just had a drive with the same drive letter attached even though it has been removed. This forced me to have to go in to device manager and manually change the drive letters…. annoying. to get around this I resorted to righting a few scripts which worked for the most part unless a volume name changed or or volume number was changed to something unpredictable. But than I came across a program that solved the problem. USBDLM has the ability to look at the Device ID which is much more reliable than volume names or numbers and then based your the setting provided will assign the drive letter when detected.

Here is the discription that the website provides…
USBDLM” is a Windows service that gives control over Window’s drive letter assignment for USB drives. Running as service makes it independent of the logged on user’s privileges, so there is no need to give the users the privilege to change drive letters.
It automatically solves conflicts between USB drives and network or subst drives of the currently logged on user.
Furthermore you can define new default letters for USB drives and much more.”

Try it out



Add Back Track 4 Repo to Ubuntu



First you need to add the repo to the source list. Either do this through Synaptic or manually editing the file at “/etc/apt/sources.list”

deb http://archive.offensive-security.com pwnsauce main microverse macroverse restricted universe multiverse

Now that the source is added you need to import the archive gpg key.

wget -q http://archive.offensive-security.com/backtrack.gpg -O- | sudo apt-key add -

Thats basically it. Now the Back Track software should show in the Synaptic Package Manager.

For more info on menu’s and structure Click Here

Updated instructions and repo’s can be found HERE










Twitter Delicious Facebook Digg Stumbleupon Favorites More
314 queries in 23.079 seconds.