Kaspersky : How to do offline update

With current technology, internet can be access almost every where. From most basic narrowband dial-up connection to super fast broadband wi-fi connection, most users don't have problem updating their anti-virus database by online. But a few weeks ago I stumbled into a handful of computers with no internet connection. No cable connection and far away from each other. Like normal desktop, no wireless adapter installed. So how to update the database? I tried to use an USB wi-fi dongle but one computer already take almost half an hour, so to update all by the same method, is too time consuming.

So, like always, Uncle Google has the solution. I just need to update one computer and the rest by copying database.

What you need:
1) At least 2 PCs, one must have internet connection.
2) Recommended to have same Kaspersky anti-virus version.

What to do:
1st computer (with internet connection)
1) Open your Kaspersky.
2) Click Settings.

3) Select Update Center
4) Tick "Copy update to folder".
5) Browse to the folder you want to copy all database.
6) Click "OK".
7) Select "Update Center".
8) Run Update.
9) Wait till the update finish.
10) After all update finished, go to your save database folder from Step 5.
11) Copy all the folder and save it into your usb drive.

2nd computer (without internet)
1) Copy previous folder into 2nd computer.
2) Open Kaspersky antivirus.
3) Select Setting
4) Select "Update Center ".
5) Click "Update Source"
6) Click "+ Add".
7) Browse to the copied database folder.
8) Click "OK".
9) Go to Update Center.
10) Run Update.

The update will take only a few minutes. With this method, I can update multiple computer within shorter time. I guess if all computers have an intranet connection, probably can fasten up all update process by sharing the database folder.

TMPoint : Worst customer service ever.

I already reapply my streamyx account transfer and upgrade on 7th June 2010, the day I wrote previous post. My nightmare doesn't end there.

1 week later
No internet connection on 14th June 2009. I went to TmPoint (how much car petrol I waste for this problem). Luckily the staff I met in previous week remember me so no need to queue. Now they ask me to wait for another week. I told him I already wait for 1 week, why I need to wait another week? After meeting with his manager, they agreed to solve the problem within 2 days and I had to fill up another form.

I just realize now that they have specific form for account transfer for both streamyx and telephone line. So, what all those forms I filled up for the last 6 months? And now I know that I even can actually transfer my old telephone line account to a new address with only RM20 fees. So why I need to terminate and subscribe new account in the first place? Now I need to pay RM75 deposit. What a **** up service center. Or they don't understand my problem? I want to transfer both my telephone and streamyx account to a new address? Tak faham soalan ker?

I bought a phone for RM8 with RM50 voucher from TMNet.

That night, I wrote an email to help@tm.net.my and explain everything.

The Next Day
I received a call from 100, TM Hotline. They said my streamyx is on, I can use it.
When I cam back home, I switched on my wireless router, I tried to browsed and yup, it is online. Again, I thought my nightmare end there.

A week later
Got a called from the guy from TMPoint. He explain that I have to hold from using my internet because my internet account still using RM20 package, not RM60 package. WTF. When I calculated, for 7 days with 24 hour of usage (I usually not turn off my router), I have to pay more than RM400.

But the guy said not to worry, just don't use the internet. Shit! It just like saying to a 4 years old kid, "Wait, don't eat that ice-cream that in your hand".

Another 2 week : Phone "rosak"
The phone I bought from them, have problem to received call. Can't ring. So, another drive to TMPoint, they give me an old telephone as temporary. Said will call me within next week.

2 weeks later
I received an email to check my last bill. Guess what...? My bill is RM401. Streamyx is really Screamyx offer by TMNut. Suck big time.

A ride to TMPoint again, a discussion with their staff again, talk with their manager. Again they promise me to solve my problem.

When ask about my broken phone, they said no record. The old phone is now my phone. Another shit for them!

When I repeatedly ask to check and give me a new phone, they give me an used phone, unclaimed by customer. I refused to accept that and demand a new phone. Finally, they give me a new phone, but old model, with no warranty.

I think every time you go to TMPoint, you should point a gun to their head before they can serve you properly.

TMPoint : Misunderstading or bad customer services

December : Start of all my problems
Last December, I moved to my new house so I want to transfer my previous telephone line+streamyx account to my new house. At the same time, because TMNet has a RM5 upgrade promotion, I want to upgrade my 512Mb combo package (RM90) to 1Mb combo package (RM95) which is cheaper than RM110 for new registration.

So, I went to TMPoint to get some advice. When I first came in, I ask a lady at the front counter (where you take ticket no.), and explain my problem. I explain to her that I'm moving to a new house and want to transfer my current streamyx combo account. I also exlpained her about my plan to take the RM5 upgrade promotion. I ask her, want should I do?

After a few minutes of checking my account, she advised me to terminate my previous telephone line and apply for a new line for my new home. But because it is a new housing area without any telephone cable installed, she explain that it will take more than a month to process my application because they need to wait for contractor to install the telephone cable first. She also said that my application will be on hold till they have enough application at my housing area before they can proceed.

So, I said "Ok" because I have no other choice. Then I ask about my streamyx account.

She suggest I downgrade to most basic package, 384kb, RM20 for 10h usage.

I ask her if I still eligible for the RM5 upgrade package, she said "Yes".

Thinking that better I sacrifice RM20/month for another 1 or 2 months than terminate my account and have to pay RM110/month (not include deposit and other processing fees) for another 2 to 3 years, I agreed. So, after I filled all the form and give it to her, I go back and wait.....

February : No telephone line
After 2 months (February), I still don't have internet access and still have to pay RM20/month. So I went back to TMPoint. This time another lady entertained me. Again after checking my account for several minutes, she explain to me that I have to wait till the contractor install the cable. So, I wait again...

April : Start installing cable
2 months later (April), I saw contractor start installing telephone cable. I wait patiently for another two weeks before going back to TMPoint. This time, I was really shocked when the lady told me they don't received any application for my new telephone line and streamyx account transfer. So again, I have to fill all the form. I also ask if I still eligible for the RM5 upgrade promotion, and they said yes.

May : Telephone line, ok. Streamyx, no ok
1 month later, which is at the end of last month (May), a contractor call me to confirm the time and date to install the telephone line in my house. Finally....

The next day after they installed the telephone line and I can receive and call out. I call 100 to ask about my streamyx account. Shockingly, the operator said in their system, I already terminate both my telephone line and streamyx account. WTF. I ask her to confirm if the info is correct or not, and of course she confirm it based on the system. I asked, "Can she do anything so I can activate my screamyx account", she answered that she can only help if there is an application. Because in their system I didn't apply for the streamyx, so she can't help. She advise me to go to the TMPoint again.

June : Start your engine, 4th visit
So, again for the fourth time, I go back to TMPoint. Then another news really make me want to burn the place, I'm not eligible for the RM5 upgrade package because it is only applicable for existing user with at least 1 year of subscription without any upgrade or downgrade during that period. Seriously, I really want to punch the guy face when I heard this. I explained to him all my problem and I said they have the worst customer service ever. They cheat my RM20/month money and expect me to accept it? This is the first time in my life I scold someone at customer service counter. WTF. 3 times I already came to their center but no one explain to me about this although I explained my situation all 3 times. I also shocked that the operator at 100 is wrong because my streamyx account still activate.

The guy also incompetent because every-time I ask an explanation, he will go to the office to discuss with his manager. 4-5 times..... Every-time when he came back, he will said he can't do anything. The 3rd times he came back, he said I have to subscribe for RM60 384kb package for a year before I can get the promotion package. I ask if the promotion still available after another year, he said yes.

Finally after more than an hour, I demand they paid back my money. I don't care what ever reasons, I want my money. After another slip trough his office, he said that they agree to give me the promotion package but for my upgrade from 384kb RM20 to 512kb RM65, not to 1Mb RM95. But first I have to upgrade to 384kb (unlimited) RM60 package before I can upgrade after I get my first bill and if only the promotion still on. :x Because I don't like 'gaduh-gaduh', I agreed.

-------------------------------------------------------------------------------------

Actually, I don't really mind to wait for the contractor to install the telephone cable because I know it is based on demand. But what I really can't 'tahan' is how the TMNet can't really appreciate their loyal customer. I have been using streamyx for more than 6 years since I start working. And because I need to move to a new house, they treat me like a new customer although I still don't terminate the account.

Why a telecommunication company can't process customer request through telephone line or online like any other company? Why we need to go to their customer service center while in this modern time, everything can be done at home by online?

I see that for new customer, they received new wireless modem and telephone for free although I doubt it actually free. What happen to existing customer which already have modem and want to have the same benefit as new customer like combo plan? Previously, they offer different package for with and without modem. But now, like combo package, they don't give a damn thing about customer who don't need the damn extra modem.

Last time, when I change from standard package (without modem) to combo package, I didn't receive any modem. When I asked about this problem, they answered that I need to bring my old modem, they will change with new one which is wireless. They ask me to return back my own modem?

But today, they improved a little bit, existing customer also can get the free modem.

How to install Windows 7 using usb?

Yesterday I finally manage to fork out some money to buy Intel i3 530 system. So after installing all part, it time to install OS. Unfortunately, I forgot to bring my Windows 7 Installer DVD. All I had was an .iso (DVD image) file, a laptop capable only to write CD and a 4GB USB drive.

I remember there are many article out there explaining step by step guide how to install Windows 7 using an USB drive. But most of them require me to execute several command line in Command Prompt. Fortunately, there are also a few way to use simple program.

1. UNetbootin (Please visit this link)
2. Microsoft's Official Tools (download)
3. UltraIso

I pick the 3rd option because I already have the software and here the steps.

What you need:

• 4Gb USB drive
• UltraIso (trial) download here
  
• Windows 7 Installer images files

If you don't have installer images file, you can create one using UltraIso.

The steps:

1. Start UltraISO as administrator
2. "Burn" the iso image to the USB stick by following these steps
   - Open the image of Windows 7 with UltraISO
   - Under BOOTABLE tab choose WRITE DISK IMAGE
   - Choose your USB stick under "Disk Drive"
   - Choose a method (It's recommended to use USB-HDD+)
   - Tick Verify
   - Press Write
3. After finish "Burning", restart you computer.
   
4. Make sure to change your BOOT order in BIOS to boot from your USB drive first

My precious… Nokia 5800 (Camera)

Camera Quality

My precious… Nokia 5800 (Applications/Games)

Applications
Symbian S60V5 is still a new OS. So, there are only a few application that work perfectly with S60V5. However, some S60V3 can be install and some have touch enable functions.

This is the list the of application that work on 5800:

Tested by me (100% working)

1. Nokia Handwriting calculator.
2. Talking Dictionary
3. Touch Piano
4. Touch Guitar
5. Touch Popper
6. Epocware Handy Series (Handy Weather, Shell, Converter, etc)
7. Avatar SMS
8. Kill Me
9. Buddycloud
10. ScreenSnap
11. Photoflow (Use
    
12. FX-602P (Calculator emulator)
13. Rotary Dialer (Dial to call app)
    

Working (Not 100%)

1. Bluetooth Remote Control (Virtual key pad is overlap by black bar)
   
2. Garmin XT
3. Virtual Key (V20 - Top Bar can't change)
4. The Pencil (Can't exit, have to use KillMe)
   

Games

1. Touch Card Match (V20 can't remove virtual keypad)
2. Touch Maneuver
3. Solitare
4. Sudoku Master
5. 3D Brick Breaker
   

My precious… Nokia 5800 (Intro 2)

Price
I got my phone at only RM1350, less than RRP. Some user even claimed the price can be as low as RM1280. With my budget, for a phone this price actually quite expensive (>RM1,000). However, for all the features, it is a good bargain.

A quick glimpse at the spec:

• 3.2-inch touchscreen display with 16 Million colors
• 3.2 megapixel camera with autofocus
• Quad-band (850/900/1800/1900Mhz) GSM/EDGE radio
• 3G UMTS/HSDPA
• Bluetooth 2.0
• WiFi
• GPS
• 3.5mm headphone jack
• TV-out port
• 81MB internal memory (expandable to 16Gb with mciroSD)
• 111 x 51.5 x 15.5 mm
• Video Support : H.263, Flash Video, H.264/AVC, MPEG-4, RealVideo 7,8,9/10, WMV 9
• Audio Support : AAC, AAC+, eAAC+, MP3, MP4, M4A, WMA, AMR-NB, AMR-WB, Mobile XMF, SP-MIDI, MIDI, RealAudio 7,8,10, True tones, WAV
  

For more details, visit this link.

3.2" Touchscreen
The screen is superb. Although this is my first touch phone, I have no problem navigate with one hand and the screen is responsive. I still get confuse to touch once or twice to open or run a program or shortcut but I found it much faster to navigate in touchscreen environment if compare with non-touchscreen (key pad). (The response is much faster in V20)

Another thing about the screen is it 640x360 resolution or known as nHD screen. With it supports of MPEG4, I can watch video smoothly with my Tube. However, all video must be converted to 5800 compatible format.

High memory capacity
Last time I thought 2Gb is enough. But now 16Gb? 5800 comes with 8Gb microSD memory card but it also can support up to 16Gb microSD. So, it means more musics and videos can be cramp into the phone. I tried storing mp3 and .mp4 file to 90% of the 8Gb microSD. The first time refreshing in Music Payer it takes around 4-5 minutes to read all the new sound files. After that, it takes only a few seconds to open. So far, I have never faced any "hang" when accessing the memory card.

The Built
5800 place firmly in my hand. The size is suitable for my daily usage and easier to carry around (not bulky). However, the front cover look like from low quality plastic. It squeak when I pressed the front cover and at night, a can see small gap with light leaking.

However the back cover is secure tightly and hard to open which is good for me. But I don't like the camera cover design. As you can see in the picture, no swipe/slip cover like N73me. The plastic cover, I believe, may reduce the amount of light penetrate through the lens, so with lower light. the higher the noise in the picture.


Interface
The interface is same like any other S60 phone. Because last time I own a N73Me, so I rearrange the shortcut to be similar like N73 interface. I use Shortcut Bar instead of Contact Bar. I just hope that the calendar in the home screen can reflect the exact date.

My precious… Nokia 5800 (Intro)

I heard about 5800 a.k.a Tube since May 2008. From the rumored pictures, what really fascinated me was the 3.2" touch screen. The screen is bigger than any other Nokia N-series. Other than that, the phone looks like ordinary candy bar phone.

The phone claimed to be Nokia's first touch S60 device. Because I was happy with my old N73ME , I didn't really care about all the hype. I assumed with all the rumored features include in this Tube, the price will be beyond my limit (>RM1.5k). I even think that 2Gb is enough for my daily use phone. Or is it?

In December 2008, I read that 5800 already available in Malaysia although it was not officially launched. What surprise me, the Recommended Retails Price is RM1499, below than my early assumption by RM1 (ha..ha... actually, I thought it will be RM1700-RM2000). The rumored features are throught. This phone really packed nice features like 3G, Wifi, MPEG4 and many other standard N-Series functions. So, starting from that, I was planning to get 5800 for my birthday present.

Now, it is already a month since I own the Tube. So here is my experience with my precious one.

(Note: I already upgraded to V20)

Quick Sneak

Pros

1. Large 3.2" Screen with 640x360 resolution (nHD)
2. Touchscreen.
   
3. Support MPEG4 with 640x360 resolution
4. Come with 8Gb microSD memory card.
5. Faster response (compare to N73).
6. Fix firmly in my hand (not too big and not too small)
7. Full screen wallpaper.
8. Nice lock key
9. Good loud speaker
   
10. Price
11. Nice search function in Home Screen(v20)
    

Cons

1. Low quality built for front cover.
2. Using none standard usb port.
3. No slip-cover for camera.
4. Sim card hard to remove, need to remove battery
   
5. Images quality from camera is low.
6. No volume bar in Music Player (probably firmware problem).
7. No pencil button.
8. Can't turn off camera sound (some region can disable the sound)
9. Lack of office suite.
10. H264 not fully supported

Please continue reading for more details.

Celcom Power38

Today I went to Celcom Centre to register for a new postpaid plan. I decided to subscribe for postpaid plan after more than 4 years of using prepaid. At first I decide to subcribe for Celcom Executive Plan but the saleperson finally manage to convince me to go for Power38 plan. So, here the comparison of prepaid and postpaid plan.

Other networks	Prepaid Mid Plan	Power38
Call Rates (adjacent)	RM1.40/min	RM0.20/min
Call Rate (Non-adjacent)	RM2.60/min	RM0.20/min
SMS	RM0.20/sms	RM0.15/sms

These are the only 3 things that very important for me. Some of my friends are from neighboring state and not within the same network. Some are living in Kuantan but using phone number registered at different state. So by using prepaid, I pay more specially when outstation.

The registration is smooth. Other than the time needed for writing the application form, I wait only a few minutes before my number were called. Actually I didn't need to go to the counter because they already set up a booth outside the premises for promotion and registration. But because I wanted to use my old prepaid number, the registration need to be done at the counter.

So, how much I payed during registration? Actually none for new number but in my case, I payed RM50. This RM50 is for processing fee to use my old prepaid number. However, for each registration they give free handphone. One is Samsung (I forgot the model name) and another is Vodafone 225 (I pick this one). So, upon registration I got one phone and a sim card. The saleperson said that the activation will take 24 hour.

VMware Player with Linux

After using several Live CD a few times, it is time for me to use the installation option. But I don't want to mess up my WinXP installation and make a dual boot. So I do some research to find the best solution to try all the functionality of the Penguin with out me sacrificing my WinXP. So, after some searching and reading, I found out that VMware Player is the answer.

VMware Player

VMware Player is a free VMware product. It enables user to run virtual machine on Windows or Linux PC. So meaning that if you run WinXP, you also can run Linux within your WinXP and vice versa. From www.vmware.com, it stated that "VMware Player runs virtual machines created by VMware Workstation, VMware Server, or VMware ESX and also supports Microsoft virtual machines and Symantec LiveState Recovery disk formats." At first, I thought that I need VMware Workstation to to properly create and run Linux and for once I thought my Linux way stop there, but nope...

How to use?

Just follow this step by step guide.

Download VMware Player from this link. Click here. Beware that the file is large (>100Mb).

Install VMware Player.

If you don't have any Linux .iso file, please download.

Create a folder and put your .iso file that folder. Example D:\vmware\

Go to this site http://www.easyvmx.com/.

Click super simple - virtual machine creator.

Enter Virtual Machine Name (Example Ubuntu 8.04), Virtual Machine OS (your Linux's Distro name), Virtual Machine Memory Size (try 512MB), Virtual Machine Disk Size (default) and LiveCD(click enable and please enter your .iso file name here).

Click "Create Virtual Machine" button download My_Virtual_Machine.zip file in the next page.

Unzipped all the file in the zip file into your created folder from step 4. Make sure your Linux .iso file also in the same folder.

Run VMware Player.

Click open and go to the created folder.

Select .vmx file.

So, now your LiveCD is running with you need to burn the image file and also without you reboot your system. You also can install LiveCD without worrying your WinXP installation. The installation will use your virtual hard disk (.vmdk file). This file can be very big depending on your linux installation.

.vmx file can be open using normal text editor (example, notepad). You can play a bit with the setting but you need to restart VMPlayer to see the effect. If you afraid to make any adjustment, open www.easyvmx.com, and click easyvmx or easyvmx v2.0. Try enable your usb setting to enable you thumbdrive in Linux environment.

I test the guide using Ubuntu 8.04 with easyvmx setting. Everything work fine. I wrote this post in my Ubuntu environment without any hassle. The only problem I have is to mount my hard disk.

Play with Linux

After I read a post at MielonG's Diary, I try googled to learn more about Linux. Actually, this is not the first time I use a Linux distro. Back in 1998, I try to use Mandrake. That time, the installation was not as easy as current linux installation. As a new linux user, to know about swap, usr, var and many other partition name was like a kid trying to learn calculus, so confusing. That time to find help using internet was hard. The only way to learn was by going to library and read a lot of books without the search tool

The nightmare didn't stop there. After installation, I need a few days to get my sound card and tv card to work properly. After 2 months, I reverted back to Win98.

So now, with all the 2 months knowledge disappear within my briliant brain, I challenge myself to play with Linux again.

Now, once again I'm a newbie

My Test Machine

E4300 Core2Duo Processor 1.8Ghz (no overclock)

2Gb DDR2 X 2 (Total 4Gb)

Intel® P965 Chipset Motherboard

500G Harddisk

ATI HD2600XT 256MB DDR3

Onboard sound

Live-CD

From wikipedia,

"A Live CD or LiveCD or CD Live Distro is a computer operating system that is executed upon boot, without installation to a hard disk drive. Typically, the LiveDistro is named after the bootable medium it is stored on, such as a CD-ROM or DVD (Live CD/DVD) or a USB flash drive (Live USB)."

Live CD is like linux on disk. No installation needed and no change made to hard disk unless we instructed to do so. There are a lots of Live Cd available in the internet and of course there are free to download. Example Ubuntu, Mandriva, Knoppix and Fedora.

I already tested all the Live CD mentioned above. Surprisingly, all are easy to use. Anyone can try using them without any Linux knowledge. My internet connection and all my hardwares work wonderfully. So I highly recommended Live CD to everyone who want to feel and learn Linux.

Linux CD also can serve as installation disk. But I haven't try this option yet because I don't want to mess up my current OS installation.

Next post, VMware with linux.

Part 6 - Installing PHPMyadmin

6.0 Installing and configuring PHPMyadmin

1. Extract the downloaded file into E:\ server\.
2. Change the folder name from phpMyAdmin-2.6.2-pl1 to phpmyadmin or any other name you like.
3. If you had followed step by step from the tutorial, your E:\server directory will look like this.
   E:\server
   +Apache2
   +mysql
   +php
   +phpmyadmin
   +www --> default directory
4. Because phpmyadmin folder is outside of our default directory, we cannot display or get any files or information from this folder when we typed http://localhost/phpmyadmin.
5. Now, open httpd.conf file.
6. Add this line:
   Alias /phpmyadmin "E:/server/phpmyadmin/"
   
   Order deny,allow
   Deny from all
   Allow from 127.0.0.1
   
7. The first line is to point /phpmyadmin as E:/server/phpmyadmin/, so every time we type http://localhost/phpmyadmin, we will be point to E:/server/phpmyadmin.
8. Line in is for security reason. Phpmyadmin can only be open by localhost which have IP 127.0.0.1. (This IP if I’m not mistaken is especially for localhost, so other computer cannot open this directory).
9. Restart your Apache2.
10. Open your browser and type http://localhost/phpmyadmin, http://127.0.0.1/phpmyadmin, http://***.***.***.***/phpmyadmin (type your ip address).
11. Previously, we had assign a password for our MySQL database. We cannot connect phpmyadmin to our database because by default phpmyadmin assume our administrator user ‘root’ has no password.
12. Now we need to edit config.inc.php located in phpmyadmin folder, again by using our powerful notepad. If you can’t find this file, try to search config.sammple.inc.php and change to config.inc.php.
13. Make these changes:
    

    From	To
    $cfg['blowfish_secret'] = ' '; Only if you type auth_type=cookie	$cfg['blowfish_secret'] = '(type anything, ex. jhgjhUAsAGjJS)'

14. Log in using your mysql username and password.

.

Note : This guide is only a strip down version (no picture). For a complete guide please download this file. Only for personal webserver.

How to install Apache, MySQL PHP (Windows XP)

Part 5 - Editing httpd.conf

5.0 Editing httpd.conf

1. You can open httpd.conf in two ways.
   • Start Menu --> Programs --> Apache HTTP Server --> Configure Apache Server --> Edit the Apache httpd.conf
   • Open folder [Drive]:\server\Apache\conf\httpd.conf

Running PHP 5 as an Apache Module

1. Add following line in the file (can copy and paste to the end of httpd.conf):
   LoadModule php5_module "e:/server/php/php5apache2_2.dll"
   AddType application/x-httpd-php .php
   AddType application/x-httpd-php-source .phps

Configuring the Default Index Page

1. Find DirectoryIndex. And add index.php.
   From -->DirectoryIndex index.html index.html.var
   To -->DirectoryIndex index.html index.html.var index.php
   This line tells Apache which file names to use when it looks for the default page for a given directory.
2. Save your file and restart Apache by click Start --> All Programs -- > Apache HTTP Server 2.2 --> Control Apache Server --> Restart or by right-click the icon in the system tray and select restart.
3. If all is well, Apache will start up again without any error.
4. If Apache cannot start, try Start Menu--> Apache HTTP Server --> Configure Apache Server --> Review Error Log and see what are the problem.

Configuring Document Root

1. I prefer to set my Directory Root other than default htdocs in Apache folder.
2. Find DocumentRoot "E:/server/Apache/htdocs" and change to other folder. I pick e:\server\www\.
   From --> DocumentRoot "E:/server/Apache/htdocs"
   To --> DocumentRoot "E:/server/www"
3. Do the same for,

Testing the PHP.

1. Make a new file named phpinfo.php by using any text editor.
2. Type this in the file.
   
3. Put the file in the E:\server\www\ (--> because previously we had assigned this directory as default).
4. Open your favorite web browser and type http://localhost/phpinfo.php.

.

Note : This guide is only a strip down version (no picture). For a complete guide please download this file. Only for personal webserver.

How to install Apache, MySQL PHP (Windows XP)

Part 4 - Installing PHP

4.0 Installing and configuring PHP

1. Extract the zip file (php-5.2.6-Win32.zip) to [Drive]:\server\php.
2. Find the files called php.ini-recommended and rename it to php.ini.
3. Open php.ini with text editor. (I prefer to use Notepad ++)
4. Find ;extension=php_mysql.dll and delete “;”.
5. Find ;extension=php_mcrypt.dll and delete “;”.
6. Find extension_dir = "./" change to extension_dir = "./ext"
7. Right click My Computer --> Properties --> Advance Tab --> Environment Variable. In system variables select Path and press edit. Add your php folder in the list e.g. E:\server\php. (optional)

.

Note : This guide is only a strip down version (no picture). For a complete guide please download this file. Only for personal webserver.

How to install Apache, MySQL PHP (Windows XP)

Part 3 - Installing MySQL

3.0 Installing and configuring MySQL

1. Unzip the downloaded file and run the setup.exe file.
2. Click --> Next.
3. Because we want to install in different folder, select Custom setup. Click --> Next.
4. In the next windows, select MySQL Server and click Change…
5. Change folder to [Drive]:\server\mysql. Click OK.
6. Click --> Next.
7. We are ready to install. Click --> Install.
8. After finish installing, some MySQL.com advertisement will come out. Click Next and Next. And in the next dialog box, tick Configure the MySQL Server now. Click Finish.
9. Click --> Next.
10. Select Standard Configuration for fresh installation. Click --> Next.
11. Check Install as Windows Service and Launch the MySQL Server automatically.
    Leave the Service Name as MySQL.
    Also check the Include Bin Directory in Windows PATH (optional).
    Click --> Next.
12. Write your root password.
    For security, your password should have mixed-case letters and alphanumeric.
    Check the Enable root access from remote machine.
    Click --> Next.
13. Click --> Execute.
14. Now we have finish using the wizard.
15. Click --> Finish.

.

Note : This guide is only a strip down version (no picture). For a complete guide please download this file. Only for personal webserver.

How to install Apache, MySQL PHP (Windows XP)

Part 2 - Installing Apache

1.0 Before you begin

Please download this software

Apache 2.2.8 [win32 binary] http://apache.leakage.org/httpd/binaries/win32/
(apache_2.2.8-win32-x86-no_ssl.msi)
MySQL 5.0.51b [Windows (x86)] http://dev.mysql.com/downloads/mysql/5.0.html#win32
(mysql-5.0.51b-win32.zip)
PHP 5.2.6 [windows binaries] http://my.php.net/downloads.php
(php-5.2.6-Win32.zip)
phpMyAdmin 2.11.2 http://www.phpmyadmin.net/home_page/downloads.php
(phpMyAdmin-2.6.2-pl1.zip)

I’m using Windows XP with sp2.

2.0 Installing Apache 2.2

1. Double-click the Apache installer file (apache_2.2.8-win32-x86-no_ssl.msi) to launch the Apache automated installer.
2. Click --> Next
3. Select “I accept the terms in the license agreement" and click Next.
4. Click --> Next
5. Example if your url is www.somenet.com (this is not important because we only want a personal webserver).
   Network Domain : somenet.com
   Server Name : www.somenet.com
   Administrator’s Email Adress : webmaster@somenet.com (your admin email address)
   Select for All User, on Port, as a Service – Recommended
   Click --> Next.
6. Select Custom setup. Click --> Next.
7. I want to install all my server program in different location. So, select Apache HTTP Server 2.2.8 and click Change.
8. Type [Drive]:\server\Apache to change installation folder. This is depending on what folder you want to install. In this case, I want to put all installation of Apache2, MySQl, and PHP in the same e:\server\ folder.
   Click --> OK --> NEXT.
9. We are ready to install. Click Install.
10. Installing... After some time, some DOS windows will appear and disappear.
11. If everything going well, we can see this window. Click --> Finish
12. To check your installation, open your favorite browser. Type http://localhost/ or http://127.0.0.1. If you see It Works! text, it means you installation is correct.

.

Note : This guide is only a strip down version (no picture). For a complete guide please download this file. Only for personal webserver.

How to install Apache, MySQL PHP (Windows XP)

Part 1 - Web Server

Introduction

Now I decided to learn more about some of Open Source Content Management System (CMS) like Joomla, Drupal, CMS Made Simple and e107. These CMS and also most of the CMS require PHP (server-side HTML embedded scripting language) and MySQL (open source database), and most importantly a webserver.

Click here to see the list of the CMS.

When I said webserver, it doesn’t mean those expensive server offered by our country webhosting company. What I means is your normal Personal Computer, equipped with require programs and services installed which listens to HTTP (and other web requests) and serves content. Now day, setting up a webserver is easy.

Hardware requirement?

My test machine is 5 years old PC with this specs:

Athlon XP 2500 (1.8Ghz)
256Mhz DDR Ram
Windows XP SP2

So, anything newer than this PC can work properly.

Software?

Automatic Installation (Packages)

Currently, there are a lot of webserver package or also known as all-in-one webserver. These packages are a bundle of apache, mysql and php. Most of the packages also include phpmyadmin, a web based database management system. User only need to install the package and it will automatically install and setup your computer.

This is the list of the webserver package (please give comment to add other):

1. EasyPHP
2. XAMPP
3. Abyss Web Server
4. WAMP (Windows)
5. MAMP (Machintosh)

Some of the package offered Lite version. This Lite version is a small version of the package with basic function but still can serve as a webserver. Some of the Lite version can be save and run in a thumbdrive like XAMPP Lite. They are ready-to-run webserver, no installation required.