Categories
Operating System

Windows System Repair

I just install Windows 8.1 on my home PC, installing SQL Server on it and found that activeds.dll file was missing. I haven’t install anything, just regular MS products and updates. So, how can a file is missing. On searching I found that DLL was present, but seems corrupted, maybe some disk writing fails or something. I start thinking to reinstall machine, as it is just been installed and got corrupted. But at last minute I found a command that not only detect all corrupted files in windows system but repair them as well. Here is steps

  1. Open CMD with Admin rights
  2. run sfc /scannow
  3. Enjoy.

It repairs few basic windows DLL that got corrupted maybe for any reason, disk fail, some program change them or whatever. It save me few hours to re-install and then update 4GB on internet again.

Categories
Rants Server Configuration

Plesk: Not Recommended

Lately I got a chance to work on lot of server. Working on 6-7 server in 15 days it not much for a full time server admin, but for a programmer who only manage server to fasten his development process is really long ask. During this process I have 2 encounter with Plesk and unfortunately both time Plesk proves to be a pain in neck.

First encounter was during setup a new Windows machine. My client purchase a Leased Term license of plesk and in return plesk send them 10 days temporary license which is expected to install on server and later plesk will auto update the license from online server. This is what I understand during our communication with plesk. However my client took 15 days to pass me the license and server access or you can say they hire me after 15 days of buying license. When I install plesk and try to upload license it naturally says, it is expired. Then we try to contact Plesk support, we call USA support, India Sales support, email to plesk, but no response and no guidance how we get corrected license. After 7 days of talking with plesk we drop the idea of having plesk on server.

Here comes the second problem with plesk. You just cannot run the “uninstaller” because they never build uninstaller for their PERFECT software. luckily my client get the computer formatted at no additional cost, otherwise I have to search and delete all file manually, which I don’t want for two reason. I hate deletion they always leave traces anyways and it is lot more work then expected.

We later use Microsoft’s Free WebsitePanel. An Awesome software with ease of use for our purpose. We can install any version of SQL Server, MySql, PHP, ASP.NET and configure that easily. Plus we pay nothing to get it.

My second encounter came with a Linux/CentOs Based VPS with Plesk, where I need to upgrade the PHP version from 5.1 to 5.3 on client demand. I search on internet and found that Plesk do not distribute PHP so they do no provide any upgrade method. But there is atomic shell script available to help update. I did that update. PHP was upgraded. We run it, but as you have expected Plesk is broken now. Been on VPS it frequently goes out of memory and create all problems. We ultimately decide to drop that server as it is just test server :).

I got saved both time and will never try a Plesk. Horrible software, powered by horrible support. Plesk is good for non experience, but nightmare for custom requirements. Never use it if you love to configure your server for speed or customization.

Categories
Joyous MySQL Operating System

MySql 5.5 : funny about it

Just saw the release note of MySql 5.5. Looks exciting upgrade, but what looks most funny about the software is the fact that they claim to improve performance by 1500% on windows [some 372% on linux]. Looks great work by them. But I found this information funny, as my some Open source lover friends always claim that because of windows bad structure mysql perform bad on Windows machine as compare to linux. But now my argument to them is if it is bad structure of windows, then how they achieve 1500% improvement by improving their code and not windows ? Often people forgot when comparing software that run on multi platform that the optimization of core software can only be for either OS [if they share same code], and that cause performance issues.

But whatever it is, I am happy to see MySql perform better on windows as I am bound to use windows with kind of resources I can afford for my development and maintainability I can handle.

Good work Team !!!

Categories
Article Operating System Server Configuration

IIRF: URL Rewrite, 64bit resolved

Wow, it was hard 48hrs trying to get URL Rewrite for IIS 6.0. Most of solutions are paid and hence not my piece of cake. Especially when I found a great IIRF which is free. However the developer has problem that he doesn’t have 64bit machine to test and fix. Same is with me, but I manage to get a 64bit version of it from original source with almost no change. Here are steps I used to create my 64bit version.

1. Download Latest PCRE version from http://www.pcre.org

2. Download Cmake from http://www.cmake.org

3. Using CMake, I create a Visual Studio 9 64bit Solution from it.

4. Compile PCRE in 64bit.

5. Now download the Latest Source of IIRF from Codeplex (http://iirf.codeplex.com )

6. Open its solution file, change IIRFConfig.c file to by replacing pcre_free function call to free function call [2 replacements only]. [it was otherwise giving linker error to me]

7. Now replace 3rdParty files from your PCRE version [you need to compile PCRE in Release mode only, and make a STATIC Library [by default it is dynamic library, though you need both static and dynamic]

8. Now compile your IIRF version and Bingo!!! it is done, you will get a IIRF in 64bit machine.

Now some interesting facts

1. I use Windows 7 with Visual Studio 2008 to do all this on my 32bit machine only. So I cannot test my build as it won’t run 64bit stuff.

2. I had a 64bit windows 2003 VPS with IIS 6.0 running in 64bit mode, I test it up there and it works.

3. I did all this because I want to move this blog to Windows 2003 64bit. I will do it soon.

Now, your award for reading it out, you can download that 64bit IIRF Release version here

Categories
Links

Windows 7 USB Installation

If you have ISO of Win 7, but not CD/DVD writer to burn disk or worst case, you don’t have DVD rom to read your disk, then microsoft have a solution for you. Use this tool http://store.microsoft.com/Help/ISO-Tool and get USB Drive converted into bootable Win 7 installation disk and enjoy.

I would say even if you have DVD available still get a USB drive it works much faster then DVD.

Categories
Operating System Server Configuration

Internet Auto Dialer: PPPoE Dialer

I need to configure a autodialer for windows 2008 server. Although the PPPoE dialer within windows have “dial on line drop” but for some unknown reason that function wasn’t working for my cause. Also, if a User through which I start/dial connect gets logout the connection gets disconnect.

Someone suggest to use 3rd party dialer, but I am not very keep to install anything “else” on server and I believe that there should exists some method to do it within available windows resources. But when I read article on “10 default things windows should adopt from Linux” where I read about crone feature I got an idea, that why not schedule the RASPHONE through scheduler ? So here is what I do:
I create a batch script that simply ping google.com, if ping is unsuccessful it call rasphone with “-d” switch and dial the connection. now I schedule it to run every 5 minutes after ssytem startup for indefinate time. Simple 2 line batch script and work is done.

Edit (code of Batch file):

@echo off
ping -n 2 -l 1 google.com
if %errorlevel%==1 rasphone -d "MyDialupConnectionName"

Edit: 01-10-2011

I change the file to use RASDIAL command instead of rasphone, as when my Internet line has disturbance or my ISP is not available then my schedule keep adding rasphone.exe in Active task like which consume 2.5MB per instance and since I schedule it to run every 10 minutes, it keep consume 2.5MB every 10 minutes and finally my server was doomed when my ISP went down for 2 days during weekend. So new file is

 

@echo off
ping -n 2 -l 1 google.com
if %errorlevel%==1 rasdial "MyDialupConnectionName" Username Password
Categories
Blog: My thoughts Operating System

Linux yet again try to gain popularity on MS

I have continously notify how opensource gaints are using microsoft name to get popularity. Today I got a newsletter which says “Linux kicks Microsoft back” . After reading this I follow some links and found some interesting fact. First here is what I understand as summary of article. Microsoft says 93% of mini laptops worldwide runs on Windows Operating system, where as a independent firm research and found that some major laptop gaint sales about 30%-35% of their computer with Linux as their Operating system.

I respect those experince author but as in one of article it says, “Just because you live in the United States, don’t assume that everything is on Windows,” Orr said. I would says, if you take stats from companies sales doesn’t mean user actually are using those Operating system.

When mirosoft launch public Beta review of Windows 7, thousands of Vista /XP notebook user install that Beta and RC versions on their PC. In India, I have see most people to save license cost buy Linux based Netbooks but end up installing Beta or RC version of Win 7, and yes no report can count that as for researcher, piracy is not counted. Netbook sold on Linux means it use Linux.

As a web developer when I see W3schools.com’s stats which is public available and used by every single web developer to take help on HTML and programming about web, it clearly shows linux is used 4.3% in last month less then MAC itself which is 6.7%. Check it yourself (http://www.w3schools.com/browsers/browsers_os.asp). If 30% of computer user are on Linux why w3schools record so low? doesn’t software developer like to use Linux ??? If developer cannot use Linux then how can a normal user does that ? Scary if you are normal user.

Secondly, that Article about microsoft saying 93% of market share was publish based on some research in Feb 2009, where as the “Contradiction” cames in Nov 2009, after 10 months, come on man 10 months are away too much to change market trend, specially in computer fields, Or does the researcher team going per home counting the PC..lol.  But I am sure the truth is not lie in both stats.

But it should be somewhere between Actual SALES of OS on netbook and Actual Usage of OS. Linux does get 30% sales as research says, but Windows got used on 93% of netbooks. ah, that means 23% of linux user are actually using pirated software, and researcher says microsoft is clean after its $10 billion fines. Yeah, that is right no one is good or think of user, but atleast microsoft dare to says “they make something good” rather than saying “We are better than Mr. X, because Mr. X is cheat”.