Installing PHP driver for MongoDB in WAMP

I’ve been getting more curious about MongoDB. The problem is I’ve been struggling trying to create a development environment. I’ve tried OSX, Ubuntu, and Windows. I always get stuck at a step. I think I found the right recipe.

First, I’m running Windows 7 Professional 64 bit virtually. You don’t have to run Windows virtuall. I’m mostly on my Mac and I prefer to use virtual environments for development so it’s okay if I screw around with things. Then I installed Wamp. The key here is to use the 32bit version of Wamp. I’ve tried the 64bit version of Wamp and could not get it to work. Then, you need to download the latest driver from the MongoDB website. You will get a NTS (non-thread safe) and TS (thread safe) driver. The folders are labeled as follows “mongo-[version]-php5.3vc9” and “mongo-[version]-php5.3vc9ts. Remember “ts” = “thread safe”. I used the non-thread safe DLL file. Take that DLL file and copy and paste it in the “ext” folder within the PHP installation directory of Wamp. If you installed using default settings it should be “c:\wamp\bin\php\php5.3.x\ext”. Open the php.ini file and add the php_mongo.dll extension. Restart Apache and it should show up in your phpinfo() page.

I will be using MongoHQ to try things out. I’m not sure why I couldn’t get it to work in a 64bit web server environment. Mongo looks very cool and if it can help me decrease development time, I’m going to build future web apps with it.

How to disable OpenCloud Security Malware/Spyware

My aunt’s PC got infected with a trojan virus. She called me and ask if she should use some kind of antivirus to clean her PC. I remember installing Microsoft Security Essentials and as she is describing the interface it didn’t sound familiar. I told her that the so called antivirus itself could be the problem. I came over to check it out and I was right. Somehow she clicked on something (very common) thinking it was something legit and installed it. I couldn’t get a screenshot right off her laptop coz it the trojan cranked up the resources to a point where it was nearly usable so I searched for a screenshot and here’s a sample.

opencloud_security

opencloud_security

I’m mostly on a Mac and when I’m behind my PC at home I usually am protected so I don’t know how to fix these things as well as I used to when I used only PCs. So I Googled and came up found what I thought to be solutions. The websites that came up gave solutions that involved downloading and installing proprietary tools. They also scare you into believing that you must manually edit your registry and if you screw up, you will mess up Windows… which is true, so you have to use their software to automatically remove it. It just didn’t look right.

So I kept researching about OpenCloud. It turns out it’s a malware/spyware. I figured I can use any free spyware software to try and remove it. The 2 that I remember using awhile back are Adaware and Spybot – Search and Destroy. In order to even do anything, you must boot into safe mode with networking by continuing to press the F8 button after your PC has been turned on. Unfortunately, Adaware will not install in safe mode, at least when I tried to it told me that I needed to boot up in normal mode which is not an option because it will execute the trojan. Spybot on the other hand will install in safe mode.

First thing you need to do after install Spybot is to update it just in case there are newer definitions available. Then back up your registry. Afterwards, you can scan for the malware and it should detect it. Once the scanning is complete, have it fix the problems. I would recommend scanning again. In my aunt’s case, the scanning took 19 minutes. It will vary from system to system.

Check the C:\Users\[username]\AppData\Roaming folder. You will folders that were created by OpenCloud Security that should be deleted. You can tell by the weird names and the date modified. Also, you may not see the AppData folder because it’s hidden. You will have to go in your Folder Options and show the hidden files and folders.

Then run “msconfig” and go to the Startup tab. Search for anything suspicious. I disabled “Spyware Doctor” which runs an executable on the desktop. You may also find a bunch of weird named items similar to the folder names in AppData. I disabled them too. It’s probably better to disable all and go through the ones that look familiar and enable them.

You should be able to reboot to normal mode. There may be some shortcuts left behind that you can delete. Now this method only disables the trojan. I don’t believe it’s completely removed. I have yet to find out how to remove it.

As always, make sure you have a back up of your important files regardless of whether you have a problem with your PC or not. Not all solutions will work and can sometimes make things worse. So proceed with caution and the usual I will not be held responsible for any screw ups.

For those who keep getting viruses, malware/spyware, etc. please consider a different operating system like Linux or switch to a Mac. Unless you like having a broken PC or enjoy paying services like the Geek Squad hundreds of dollars.

No more Hostasp.net

After a few days of playing around with their server and having some difficulties, I decided to cancel their service. I’m new to Windows hosting since I’ve always used Linux hosting, so I’m not that all familiar with it. A lot of my questions can easily be resolved if they had a better FAQ or knowledge base section on their website.

If they had a local US number I can call, it would make getting support a bit easier and faster. I used to complain that Godaddy has phone support but it was long distance, but it’s still a US number. Besides, long distance is a thing of the past within the US since it’s pretty much a local call with most cell phone plans. I just thought it was weird that they didn’t use an 800 number.

Instead, I had to create a ticket in their system, which isn’t bad but the response time averaged over 6 hours. They also had a chat software installed on their website but being located outside the US, the hours were different and most of the time it’s offline. At that rate, I figured a few weeks before I can get settled in and it’s unreasonable. Only solution I had was to cancel the service and find one closer to home or at least easily accessible within the US.

Don’t get me wrong, the features you get for the price they are charging are great. You get an IP address, unlimited databases (MSSQL 2008 and MySQL), remote connection to the database, web deploy compatibility, and refund any time. If my comfort level and knowledge with Windows hosting environment matched with Linux, I wouldn’t need that much support. I think this company is new and has a potential of becoming better. Once I get more familiar with Windows servers, I may look at them again.

Hostasp.net first thoughts

I’ve been looking around for a cheap host for .NET. It’s more expensive than Linux shared hosting. I didn’t want to spend too much being that I just want to play around with it to familiarize myself with the technology – so I’m not asking for much. What I do need is a plan where I can create more than 1 MSSQL database and support .NET framework version 4.

I found Hostasp.net from http://www.microsoft.com/web/Hosting/Home. This page has a large, extensive list but little feedback. I took a chance with that company for its price and features. It’s been a day and here are my first thoughts.

The company is based out of India. There’s a huge time difference so I was concerned about contacting someone via email and getting a response in a reasonable time frame. I sent a question using their ticketing system and the response took a little over 3 hours, not bad. I also found a 15% off coupon so it even made the already low price more appealing. So I figured it was worth a try. Here are my likes and dislikes based on a 24 hour period.

LIKES:

  • The deluxe hosting plan for Windows is $48 annually. This includes unlimited databases (MSSQL and MySQL), up to 5 domains hosted, a dedicated IP address, and a free domain name.
  • The set up took under an hour. I receive emails for every update on my account during the set up.
  • It supports up to .NET framework 4 (but currently have an open ticket regarding this)
  • You can request a month trial for .99 cents. You just have to submit a ticket.
  • You can request to cancel your account and get a refund, anytime.
  • The test pages I have created seem to load quick. Although I haven’t made complex pages yet, just simple ones for testing.

DISLIKES:

  • They have a phone number you can call but it’s long distance (international). There’s many different ways to provide phone support customers in the US even though a company is based elsewhere. VOIP is the number solution. They could at least use Skype to get a US number, whether 800 or any area code, and it would still be a local call since many cell phone plans include free long distance calls to and from the US.
  • There is a way to chat with someone from their website but during the day (my time) it’s usually unavailable or away.
  • The control panel is a little weird but I’ve been using cPanel and probably expect certain things or used to how things are. This might be a bias dislike.

So far I haven’t been able to test what I need to with this host. I checked out Godaddy’s plans. With any purchase of a domain from them, you can get free hosting, supported by ads. This didn’t work since the free hosting doesn’t support .NET framework version 4. So I ended up getting the low plan just to test things.

I’ll continue to play with Hostasp.net for a few more days and see if I can get it to work. We’ll see whether I keep this host or go with Godaddy.

My new Kingston SVP100S2B/96GR SSD drive

Newegg recently had a good deal on the Kings SVP100S2B/96GR SSD drive. It was $160 with a $50 mail in rebate, plus 10% off. So after everything, I would’ve paid about $1 per GB on an SSD. The advertised read speed is 230MB/s and write speed is 1810MB/s. I’ve always wanted to play with SSD drives but found them to be too expensive. So I jumped on this deal considering the price after rebate. Here are some pics I took during the unboxing.

IMG_3333

IMG_3334

The kit comes with a USB 2.0 enclosure, brackets, molex to SATA power cable, SATA cable, USB cable, and Acronis True Image software. This is $10 more than the OEM version and the software alone is worth it.

The software is great and easy to use. You just boot off it and you can clone your existing hard drive. At first, I tried to use a USB 3.0 enclosure with the SSD drive. I figured it might be quicker to do the cloning. I kept getting an error so I figured that the USB 3.0 drivers aren’t available or not compatible with the software. I ended up installing the SSD drive internally. I have a few free SATA ports.

After formatting, you will have 89GB of the 96GB available to you. I had to uninstall a lot of stuff just to get it down to that size before I can clone my old drive. Once finished, I was able to clone 86GB of data from a RAID10 to the SSD using SATA2 connection. This process took only 7 minutes. I got curious so I did the same clone: onto a 2.5” drive, 160GB. I’m not sure what if it was a 5400 or 7200 RPM drive. It’s a Hitachi that came with my old MBP 13”. It could be 5400RPM. This process took around 25 minutes.

Using the SSD, my Windows Experience Index of the hard drive improved from 6.1 (RAID10) to 6.9 (SSD).

WEI_ssd

My boot up time improved from around 68 seconds to 36 seconds. I was left with only 3GB of space left on the hard drive. I ended up using a 1TB drive where I installed applications and stored my documents. Every time I install something or save, I have to remember to do it on the D:\ drive. After a few days of this, I grown tired of it. I really hate it plus because I was installing things on the 1TB drive (non-RAID) it was somewhat slow especially installing more than one software at a time. I’m impatient haha. I missed my RAID10 performance.

So I ended up going back to my old configuration with the RAID10 and installed the 96GB SSD on my MBP 13”. Maybe once the prices have dropped on the larger SSD drives, I can try this again on my desktop and buy 4 of them to set up a RAID 10 or 2 for a RAID0. But right now most of those drives are $2+ per GB.

I don’t regret buying the drive even though I’m not using it on my desktop. The performance of my MBP 13” has improved. So no lost there. Just hope the rebate goes through.

Here some more screen shots doing benchmarks between my RAID10 and the SSD drive. I don’t know what they mean. Hope someone can share some knowledge.

This is for my RAID10.

raid0

SSD benchmark with Windows 7 SP1.

ssd_after_new_os_install5_after_sp1

SSD benchmark before Windows 7 SP1

ssd_after_new_os_install2