HowTo: Install GeoNetMap on LAMP (Linux, Apache, MySql, PHP)

Discuss GeoSelects' IP address to geographic location database component here.

Moderators: Moderators, GeobytesAdmins

HowTo: Install GeoNetMap on LAMP (Linux, Apache, MySql, PHP)

Postby Adrian » Tue Feb 23, 2010 2:55 pm

How to install and maintain a GeoNetMap instance in a LAMP (Linux, Apache, MySql, PHP) environment

We have automated the process of installing and maintaining an instance of our IP Address Map database - GeoNetMap in a LAMP (Linux, Apache, MySql, PHP) environment. The following process will work on both shared and dedicated server environments.

Note: The following instructions assume that you have SSH access to your server. If you don't know what that means then check your hosting company's FAQ - they will probably recommend that you use something like Putty ( ... nload.html) to establish a SSH session with your server. If you do not have shell access, then you may still be able to complete the following steps via cPanel or an equivalent facility, but unfortunately I am unable to provide you with step by step instructions to do this as each provider's facilities are different. In this case, you will need to research you local provider's documentation and possibly seek their assistance.

Once you have established a command line session with your server, then download the installation archive in to an empty directory on your server, (perhaps create a geobytes directory in your home directory), then extract the contents of the archive, and then finally run the installation script.
Here are the commands to do this: (You need to enter them at a command/shell prompt.)
Code: Select all
mkdir geobytes
cd geobytes
curl > geonetmaploader.tar
tar -xvf geonetmaploader.tar

The installation script will then prompt you for your Geobytes' Access Credentials (that were emailed to you when you purchased your GeoSelect subscription/license) and the database name, user, and password that it should use for access to your local MySql database. The script will then create the required tables in the database, and import the raw data in to the tables. Upon completion, it will check that the importation was successful and will create a cron job that is configured to execute once per day and check for and install any map updates. If your hosting provider has restricted command line access to crontab, then you may need to create the cron job manually via cPanel or an equivalent facility. Note: The script that you want the cron job to run is

Once the installation script has completed, then you will be able to access the data via embedded SQL queries in your PHP code. There are some sample queries in our Map Implementation Guide, and there is a sample PHP script for performing the actual IP to location look-ups here.

In any case, please let me know if I can assist further.
“When it absolutely, positively has to be there, try looking in your Spam folder.” - Adrian McElligott - July 2009
Have you tried the Local Search facility on the IP Locator Page yet?
User avatar
Posts: 970
Joined: Thu Nov 20, 2003 9:58 am

Re: HowTo: Install GeoNetMap on LAMP (Linux, Apache, MySql,

Postby naturedude » Wed Jun 08, 2011 2:08 am

Hi Adrian,

Firstly, thankyou for this wonderful free service.

Just wanted to let you know that I encountered an error with the script. The error occurs when the "import_all.sql" script is called. The error message is "Checking Tables row count
ERROR 1140 (42000) at line 91: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause"

All the tables have been created and data loaded into my mySQL database, so since this error was generated during the checking process, it hasn't stopped me from using the database.


Posts: 1
Joined: Wed Jun 08, 2011 1:58 am

Re: HowTo: Install GeoNetMap on LAMP (Linux, Apache, MySql,

Postby Aiden » Fri Sep 26, 2014 9:08 am

I'm getting this error;

"Checking Tables row count
ERROR 1140 (42000) at line 91: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause"

I think it's the same as yours naturedude. How did you fix it?
Posts: 1
Joined: Fri Sep 26, 2014 9:02 am

Return to GeoNetMap

Who is online

Users browsing this forum: No registered users and 2 guests