IP2Country binary database maker (PHP)

// +----------------------------------------------------------------------+
// | IP2Country binary database maker                                     |
// | Copyright (C) 2007  Darren (http://ahkuan.com/weblog/199.html)       |
// |                                                                      |
// | File    : ip_csv2dat.php                                             |
// | Started : Monday, May 7, 2005                                        |
// | Version : 1.0                                                        |
// +----------------------------------------------------------------------+
// |                                                                      |
// | This is a PHP port with little modification from original            |
// | Python script coded by                                               |
// |        L. Petersen , visit http://weirdsilence.net/software/ip2c/    |
// |                                                                      |
// | What this script does is it converts the CSV database from           |
// | IP-to-Country and GeoIP into binary database for quicker lookup      |
// |                                                                      |
// | Websites:                                                            |
// | IP-to-Country  http://ip-to-country.webhosting.info                  |
// | Maxmind: GeoIP  http://www.maxmind.com/app/ip-location               |
// |                                                                      |
// | Download latest CSV database:                                        |
// | http://ip-to-country.webhosting.info/downloads/ip-to-country.csv.zip |
// | http://www.maxmind.com/download/geoip/database/GeoIPCountryCSV.zip   |
// |                                                                      |
// | *NOTE*                                                               |
// | Let me know if there is anything wrong with the code, especially     |
// | whether the formatting code used in PHP's pack() function is the     |
// | same as the Python or not. I have no Python coding experience at     |
// | all when I'm porting the original Python script to PHP... so only    |
// | God knows what mistake I've made unless you tell me ;)               |
// |                                                                      |
// | Also, I'm happy to hear if you have any improvements/suggestions.    |
// | Use the 'Contact me' link on my page to contact me.                  |
// |                                                                      |
// +----------------------------------------------------------------------+

Download

• ip_csv2dat.rar - PHP Source code rarred (CSV database included) (748 KB)
• ip_csv2dat.zip - PHP Source code zipped (CSV database included) (1 MB)

1. Go to Apache HTTP server project website to download the binary for windows. This guide uses Apache 2.2.3.
2. Open the file and follow the prompt. When it ask for the Network Domain and Server Name, use "localhost" if you're setting up a local server on your computer for development purpose, otherwise fill in the address and name according to your server. In the Administrator’s Email Address field, use any email address (e.g. "admin@localhost").
3. Continue clicking next and choose the setup type and path to install and complete the installation.
4. If Windows (SP2) firewall prompt to ask about the program, just click "Unblock".
5. At this point installation is completed, Apache HTTP server should be running as a service if everything is ok. Open your browser, type in http://localhost/ in the URL bar. You should see "It works !" on the page.
6. To customize the httpd.conf file (located in /conf in Apache folder), open with any text editor. Look for DocumentRoot, change the path if you want. For example:
   DocumentRoot "C:/Documents and Settings/user/My Documents/My Website/localhost/www"
   The default path will be pointing to /htdocs in your Apache folder.
7. If you changed the DocumentRoot mentioned above, remember to scroll down and look for a line that looks like
   # This should be changed to whatever you set DocumentRoot to.
   #
   <Directory "C:/...">
   Change the path in the <Directory> tag to the same you set for DocumentRoot in above. For example:
   <Directory "C:/Documents and Settings/user/My Documents/My Website/localhost/www">
   If you don't change it, you'll get Permission Denied when you browse http://localhost
8. Change any other settings to suit your server or for scricter security. The above is sufficient for normal static html hosting. See below if you need a script parser like PHP for dynamic page output.

1. Go to PHP website to download the binary for windows. This guide uses PHP 5.1.4.
2. Please take note that if you followed the below steps and it's still not working with Apache, continue to read down to the section Another way to make Apache and PHP work together.
3. Unzip the contents to the path you desire (eg. C:\php\).
4. Go to Control Panel -> System -> Advanced tab -> Click on Environment Variables. In the System variables list, look for the variable name Path. Select it and click on Edit. Append
   ;C:\php
   at the back of the variable value.
5. Now go back to the PHP folder (eg. C:\php\), make a copy of the file php.ini-recommended and rename it to php.ini. Open the php.ini file with text editor. *Note* This guide uses php.ini-recommended file, you can use the php.ini-dist if you know what you're doing.
6. If you changed the value of DocumentRoot in httpd.conf file mentioned above (Installing Apache, Step 6), you need to change the doc_root value to , for example:
   doc_root = C:/Documents and Settings/user/My Documents/My Website/localhost/www
7. Save the php.ini. Now open the Apache httpd.conf file, look for the "LoadModule" section. At the bottom of the LoadModule block, insert the following lines:
   # For php5 module
   LoadModule php5_module "c:/php/php5apache2.dll"
   AddType application/x-httpd-php .php
   # Configure the path to php.ini
   PHPIniDir "c:/php"
   
   You can add another optional line if you know what you're doing:
   AddType application/x-httpd-php .php-source .phps
   
   *Updated 2007-01-17*
   If you found a DLL file named php5apache2_2.dll in the PHP build you downloaded, change
   LoadModule php5_module "c:/php/php5apache2.dll"
   to
   LoadModule php5_module "c:/php/php5apache2_2.dll"
8. This step is optional. Scroll down a bit and look for something like
   <IfModule dir_module>
   DirectoryIndex index.html
   </IfModule>
   Made changes to the DirectoryIndex and add index.php. The modified one should looks like
   <IfModule dir_module>
   DirectoryIndex index.php index.html
   </IfModule>
9. Save the file and restart your computer (dont ask, just restart).
10. Create a text file in your document root (eg. C:/Documents and Settings/user/My Documents/My Website/localhost/www), insert
    <?php phpinfo(); ?>
    into the file, save it and rename it to phpinfo.php.
11. Start the Apache server as a service if it's not. Apache should be able to load the PHP module and start running. To check if everything is working, open your browser and type in http://localhost/phpinfo.php. You should get a page containing information on your installation of PHP and its settings. If you don’t, try restarting Apache. If Apache says it can't load the php5apache2.dll or it says that the module can't be found refer to Another way to make Apache and PHP work together section below

1. Go to MySQL website to download the binary for windows. This guide uses MySQL 5.0.24.
2. Extract the zip file and run the Setup file.
3. You should choose the Custom installation, to allow you to select an installation path. Click Next to continue and install it.
4. When you're asked register with MySQL, Skip it if you don't have time for it. Once the installation is complete, tick the option to launch the MySQL Configuration Wizard and finish it.
5. On the configuration wizard, select the Standard Configuration option on the first screen and click Next.
6. On next screen, leave the 2 checkbox in default, check the 2nd one (include Bin Directory in Windows Path) if you want to enter MySQL commands from the command prompt without first having to navigate to the MySQL \bin directory.
7. On next screen, you can leave the password field blank for root user for you can assign a password for it. Depends on you but I strongly recommend you assign a password.
8. Click Execute on the next screen to finish the installation. Restart your computer.
9. After rebooting, to check if MySQL is running properly or not, open a command prompt and type the following command:
   mysql -u root -p
   You need to navigate to \bin in your MySQL folder if you didn't ask MySQL to setup the Path variable during installation. If you didn't setup the password for root user, just remove the -p in the above command.
   If you get "Can't connect to MySQL server on 'localhost'" error message, that means MySQL server is not started yet. Go to Control Panel -> Administrative Tools -> Services and look for MySQL entry. Right click and select Start. Once it's started, you can make a connection to the server using the command stated above.
   Alternatively, you can invoke MySQL by calling the following command:
   mysqld-nt --defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini" MySQL
10. Once you're connected to server using the root user account, type the following command:
    mysql> show schemas;
    
    You should get the following results:
    

    +--------------------+
    | Database           |
    +--------------------+
    | information_schema |
    | mysql              |
    | test               |
    +--------------------+
    3 rows in set (0.26 sec)

11. Now you need to get PHP to talk to MySQL. Open the php.ini look for "Paths and Directories" section and find extension_dir, change it to:
    extension_dir = "c:/php/ext"
12. Scroll down and look for ;extension=php_mysql.dll. You need to uncomment it by removing the ';' (semi-colon). It should looks like
    extension=php_mysql.dll
13. This step is optional. Uncomment the ;extension=php_mbstring.dll if you need multibyte string functions (eg. to process unicode data)
14. Save the file and start/restart Apache.
15. *Hint* I strongly suggest that you should download the MySQL Administrator here and MySQL Query Browser here. MySQL Administrator has powerful functions that allows you to manage/browse/backup your MySQL server/database in GUI. MySQL Query Browser is a replacement for MySQL Control Centre. It's a GUI-based program that allows you to test/execute your SQL queries. Install the MySQL Query Browser first before you install the MySQL Administrator.
    Isn't life's good when you do all the things just using your mouse ? =)

1. *Note* This section of guide assumes that you already install PHP. If not, please complete the steps in Installing PHP section before continue the steps below.
2. *Updated 2007-01-17* On newer version of PHP (I tested with 5.2.0) you should able to find a DLL file name called php5apache2_2.dll. Now refering to Installing PHP - Step 7, change
   LoadModule php5_module "c:/php/php5apache2.dll"
   to:
   LoadModule php5_module "c:/php/php5apache2_2.dll"
   That should solved the problem and you can skip the steps below. If you're using older version of PHP build, please skip this step and follow the steps below.
3. If you have Apache installed and you're stuck, uninstall it and remember to delete the folder manually for left overs (windows installer sometimes does not delete the config files, you need to clean it yourself). If you deploy Apache via a ZIP file instead of windows installer, you better do a httpd -k uinstall to uninstall the service then only you delete the folder manually.
4. Download and install Visual C++ 2005 Redistributable Package from Microsoft. It can be downloaded at the link below:
   Microsoft
5. Download httpd-2.2.3-win32-x86-ssl.zip (binary by Steffen) from Apache Lounge or use the direct link below:
   http://www.apachelounge.com/download/binaries/httpd-2.2.3-win32-x86-ssl.zip
   *Note* This binary is build with VC 2005, that's why you need Visual C++ 2005 Redistributable Package.
6. The Apache binary is in ZIP file, there is no windows installer for this build. Unzip and place it to your C:\Program Files\Apache 2.2.3\
7. Repeat the steps in Installing Apache section to configure your Apache server.
8. Download php5apache2.dll-php5.1.x.zip from Apache Lounge or use the direct link below:
   http://www.apachelounge.com/download/mods/php5apache2.dll-php5.1.x.zip
9. Unzip the file. Read the Readme First.txt.
10. Copy & replace the php5apache2.dll to your php folder (eg. c:/php). Backup the original one if you feel to do so.
11. Copy httpd.exe.manifest to /bin in your Apache folder.
12. Open the httpd.conf file from /conf in your Apache folder. Look for ServerRoot and change the path to where you unzip the newly downloaded Apache binary. For example:
    ServerRoot "C:/Program Files/Apache 2.2.3"
13. Scroll down and look for
    <IfModule alias_module>
    ...
    ...
    ...
    ScriptAlias /cgi-bin/ ...
    </IfModule>
    Make sure the ScriptAlias is set to the correct path. For example:
    ScriptAlias /cgi-bin/ "c:/Program Files/Apache 2.2.3/cgi-bin/"
14. Scroll down and look for
    # "c:\..." should be changed to whatever your ScriptAliased
    # CGI directory exists, if you have that configured.
    #
    <Directory "c:\...">
    AllowOverride None
    Options None
    Order allow,deny
    Allow from all
    </Directory>
    Make sure the <Directory> tag has the correct path. For example:
    <Directory "c:/Program Files/Apache 2.2.3/cgi-bin">
15. Start your MySQL server and hit your Apache server. Your Apache should be able to load the php5apache2.dll now. For extra info, see also : http://www.apachelounge.com/forum/viewtopic.php?t=570