Aspicore GSM Tracker / Server part
----------------------------------

Change History:
2004-11-23 jje - Instructions written for MySQL 4.0
2005-03-30 jje - Adapted for MySQL 4.1.1 and above
2007-01-17 ml  - Installation instructions for Linux added

WINDOWS SETUP INSTRUCTIONS FOR MySQL 4.0 and above
==========================================

This directory contains files that can be used to set up the gsmtrack
database into a MySQL server.

First, you should create the database.

Connect to the database, e.g. with
C:\mysql\bin>mysql -u root

( Or perhaps from directory C:\Program Files\MySQL\MySQL Server 4.1\bin  )
( Try command line
   mysql -u root -p
  if you get 'Access denied' error )

In the mysql program, issue this statement:

    mysql> CREATE DATABASE gsmtrack;

If you use a different name for the database in the CREATE DATABASE
statement, use that same name wherever you see gsmtrack in the following
examples.  For the mysql command, supply any connection
parameters necessary (host, user, password) on the command line before the
database name.

To create the tables:

    shell> c:\mysql\bin\mysql -u root gsmtrack < GSM_Tracker_MySQL_tab.sql -p

Grant sufficient privileges for users to access gsmtrack database.

Connect to the database, e.g. with
C:\mysql\bin>mysql -u root

In the mysql program, issue this statement:

mysql> GRANT ALL ON gsmtrack.* TO '';

If you want better protection to your tracking data, do not use the above
statement as such, but pay some more attention to the user account management
 and access privileges.


LINUX SETUP INSTRUCTIONS (Tested with PHP 5.1.6 / MySQL 5.0.24a / Apache 2.0.55)                                             
==========================================

This directory contains files that can be used to set up the gsmtrack
database into a MySQL server.

First, you should create the database.

Connect to the database, e.g. with
shell>mysql -u root -p

In the mysql program, issue this statement:

mysql> CREATE DATABASE gsmtrack;

If you use a different name for the database in the CREATE DATABASE
statement, use that same name wherever you see gsmtrack in the following
examples.  For the mysql command, supply any connection
parameters necessary (host, user, password) on the command line before the
database name.

To create the tables:

mysql> use gsmtrack;
mysql> \. GSM_Tracker_MySQL_tab.sql

mysql> GRANT ALL ON gsmtrack.* TO '';

If you want better protection to your tracking data, do not use the above
statement as such, but pay some more attention to the user account management
 and access privileges.