Aspicore GSM Tracker 續
由於 Aspicore GSM Tracker 是以SQL数据库為结構, 因此可被很多大公司提供的服務所支援, 如: Microsoft MapPoint .NET ( 見附圖) 和 Google Earth Map ( 見附圖) 等. 用家更可自行於運行数据库的機子上安裝地圖軟件系统: 如 OziExplorer ( 見附圖) .
通過此等技術, 就可實現 "定位" 及 "追踪"!
因此追踪你的手機目標, 如: 兒童, 老人, 公司員工/車隊, 老婆老公...就萬無一失了!!
Aspicore GSM Tracker 以 ASCII characters 傳送資料 並以 UDP datagram 為主要資料架構. 因此, 用家可自由以 Perl scripts 或 Java code (及UDP Sockets) 來開發系统, 然後存於MySQL DataBase 数据库中.
S60 platform 2nd Edition (Symbian OS v7.0s/8.0)
Nokia 3230, 6260, 6600, 6620, 6630, 6670, 6680, 6681, 6682, 7610, N70
Panasonic X700, X800
Samsung SGH-D720, SGH-D730
AcGsmTrckr1.00繁體版漢化版下載:
http://3g365.com/attachment.php?aid=70023
(*Aspicore GSM Tracker S60 V2.13_cracked 最新破解版 559楼.)
OziExplorer Software Trial:
http://64.71.184.220/eng/downloads/395loc/oziexp_setup.exe
附加資料:
How I can install Perl source code? Do I have to compile?
--------------------------------------------------------------------------
Copy the source code from UDP_perl_tools.zip into some directory on your computer. Perl is an interpreted language, so there is no need to compile the source files. You need to have a Perl interpreter installed. For Windows you can get Perl interpreter e.g. from ActiveState web site.
To get familiar with Aspicore UDP Perl Tools, start with socket_udp_server.pl. Open command prompt. Go to the directory containing socket_udp_server.pl. Type one of the three alternative commands:
socket_udp_server.pl (This works, if the .pl extension is associated with the Perl interpreter)
socket_udp_server.bat (Perl must be along the PATH)
c:\perl\bin\perl.exe socket_udp_server.pl
You should see something like:
socket_udp_server.pl 1916: server started on port 1002 at Mon Dec 20 11:01:21 2004
(If you want to use another port, change the "my $port" line in *.pl accordingly, or use the command line argument for the port number.)
With the following commands you can test, that the server application works:
Leave socket_udp_server.pl running in the command prompt.
Start another command prompt. Go to sources directory.
Execute socket_udp_client.pl
Soon you should see a test message appearing in the first command window. This shows that the server has received an UDP message from the client.
When you start socket_udp_client.pl without parameters, it sends the test message to localhost, i.e. the same computer. If you append the command line socket_udp_client.pl with an IP address or a host name, the test message is send to the given destination computer. In the latter case, you must first start socket_udp_server.pl in the destination computer.
How I can install SQL scripts to MS SQL Server?
------------------------------------------------------------
The original SQL scripts of UDP Perl Tools have been created for MySQL database. If you want to use Microsoft SQL Server or MSDE, you need to use a little different SQL script to create the database. For Microsoft databases, use the following SQL script: GSM_Tracker_MSSQL7.sql
Run the script in the SQL Server computer with osql.exe or with the MS SQL Server Query Analyzer.
You must also change the database connection settings in the Perl sources. Instead of Perl module DBD-MySQL you can use e.g. the module DBD-ODBC (ODBC driver for DBI).
First you must install this module into your Perl environment with the PPM utility, if you haven't already done it before:
ppm> install DBI
ppm> install DBD-ODBC
Next, create a DSN for database GSMTRACK with the Windows control panel applet Administrative Tools / Data Sources (ODBC). Select the tab System DSN and click the Add button. Select the driver for SQL Server and give the name DSNGSMTRACK for the new DSN. Remember to select the check box "Change the default database to" and choose the database GSMTRACK from the combo box. Finish the DSN creation.
Next modify the "my $data_source", "my $user" and "my $password" lines in the Perl sources e.g. as follows:
my $data_source = "dbi:ODBC
SNGSMTRACK";
my $user = "";
my $password = "";
Now the Perl scripts should be ready for your MS SQL database.
Setup and Usage Guide (for Series 60, Adobe PDF, 129 kB)
http://www.aspicore.com/pdf/GSM_Tracker_Setup_And_Usage.pdf
Printable facts (Adobe PDF, 105 kB)
http://www.aspicore.com/pdf/Aspicore_GSM_Tracker_Flyer2.pdf
Flyer (Adobe PDF, 1.2 MB)
http://www.aspicore.com/pdf/AspicoreGSMTracker_Info.pdf
Aspicore GSM Tracker Help for S60
http://www.aspicore.com/gsmtrackerhelp/v110/default.htm
Support FAQ (Including detailed installation instructions for S60)
http://www.aspicore.com/support/gsmtrckr/default.htm
Supported GPS devices
-----------------------------
Any NMEA-0183 compliant Bluetooth GPS. Tested with
Nokia Wireless GPS Module LD-1W
Socket Bluetooth GPS receiver (technically identical to Emtac)
Holux GR-230 Bluetooth GPS
Anycom GP-600 BC79 Bluetooth GPS
TomTom Wireless GPS
Belkin Bluetooth GPS Receiver (resembles Fortuna Clip-On)
Bluei Wireless GPS Receiver
FALCOM NAVI-1
FALCOM NAVI-XT
Pretec BluetoothGPS
Pretec BluetoothGPS Mini
Deluo / Polstar PBT-111
Deluo BlackBox Bluetooth Receiver
Rikaline GPS-6033 Bluetooth GPS
RoyalTek RBT-2001 Bluetooth GPS Receiver
Aspicore GSM Tracker
Real-Time GPS Tracking with Series 60 Smartphone
UDP Perl Tools
Listen a UDP socket, collect, parse and store datagrams from GSM Tracker mobile clients into SQL database. Can be used with or without a database.
Compatible with MySQL 4.0. (Now adapted for MySQL 4.1.1 and above, 2005-03-31)
Run in a computer, which should be connected to the Internet with a public IP. The computer must have Perl installed. We recommend v5.8.0 or newer. For Windows, you can download Perl from ActiveState web site.
http://www.activestate.com/
You can use these scripts as a demonstration, how to handle UDP packets at the server end, even if you are not going to use Perl and MySQL.
Download
-------------
Download Perl tools here.
http://www.aspicore.com/download/perl/UDP_perl_tools.zip
(6 kB Zip file, contains socket_udp_server.pl, socket_udp_server.bat, socket_udp_client.pl, socket_udp_srv_parser.pl, socket_udp_srv_parser.bat, store_gps_datagrams.pl)
MySQL related scripts and info here.
http://www.aspicore.com/download/perl/UDP_perl_mysql.zip
(4 kB Zip file, contains GSM_Tracker_MySQL_tab.sql, GSM_Tracker_MySQL.txt, select.pl, insert.pl, delete.pl.)
Below is an explanation for the files, that you find within the downloaded Zip files.
Tools to test UDP communication locally
File name Description
socket_udp_server.pl
http://www.aspicore.com/download/perl/socket_udp_server.pl.html
This program receives UDP datagrams from Aspicore GSM Tracker (or from socket_udp_client.pl) and prints them to the console.
socket_udp_server.bat Optional command file to run socket_udp_server.pl
socket_udp_client.pl
http://www.aspicore.com/download/perl/socket_udp_client.pl.html
Simulate Aspicore GSM Tracker mobile client by sending UDP datagrams.
Usage: socket_udp_client.pl <remote_IP> <remote_port>.
(Arguments optional)
Support FAQ
http://www.aspicore.com/support/udpperltools/default.htm
(Including Getting Started info for Windows)
Tool to display GSM Tracker datagrams
File name Description
socket_udp_srv_parser.pl
http://www.aspicore.com/download ... _srv_parser.pl.html
This program receives UDP datagrams from Aspicore GSM Tracker, parses and prints them to the console
socket_udp_srv_parser.bat Optional command file to run socket_udp_srv_parser.pl
Tool to store datagrams into SQL database
File name Description
store_gps_datagrams.pl
http://www.aspicore.com/download/perl/store_gps_datagrams.pl.html
This program receives UDP datagrams from Aspicore GSM Tracker, parses and stores them to a MySQL database. (You need to create the database first.)
Usage: store_gps_datagrams.pl <mysql_password> <local_port>.
(Arguments optional)
In a real production environment you must add some error checking code etc. to make store_gps_datagrams.pl robust enough in different exception cases like temporary break in the database connection etc.
Files to create and test the SQL database
File name Description
GSM_Tracker_MySQL_tab.sql
http://www.aspicore.com/download/perl/GSM_Tracker_MySQL_tab.sql
Database creation SQL script for table GPS.
GSM_Tracker_MySQL.txt
http://www.aspicore.com/download/perl/GSM_Tracker_MySQL.txt
Instructions how to create the database gsmtrack and run the script GSM_Tracker_MySQL_tab.sql.
select.pl
http://www.aspicore.com/download/perl/select.pl.html
Make a SQL SELECT from MySQL database gsmtrack.
insert.pl
http://www.aspicore.com/download/perl/insert.pl.html
Make a SQL INSERT to MySQL database gsmtrack.
delete.pl
http://www.aspicore.com/download/perl/delete.pl.html
Delete all records from the GPS table in the MySQL database gsmtrack.
Installation
--------------
Install Perl
Install Aspicore Perl scripts
Install database engine (MySQL)
Create database by executing the SQL scripts.
Configure UDP port number at the server, if necessary (store_gps_datagrams.pl line starting with "my $port" )
Run store_gps_datagrams.pl
Configure your possible firewall to pass the UDP packets through to the local port number you are using.
Start Aspicore GSM Tracker in your phone and change the setting "GPRS Server IP" to the public IP address of the computer, where your Perl script is running.
Restart Aspicore GSM Tracker in your phone.
Now you are ready. The datagrams sent by your phone should appear into the SQL database.
UDP Java Tools
-------------------
This is a Java solution to reading the data from the Aspicore GSM Tracker. The downloadable ZIP archive below contains java code that acts as a server for the UDP packets that arrive from the GSM Tracker client.
Compatible with MySQL 4.1 and J2SE 5.0. Run in a computer, which should be accessible from the Internet via a public IP address.
The server is setup to store the data in a MySQL database including the incoming and outgoing cell information. Two mysql text files are included to setup the database that includes a cell table.
The zip file includes project files for use within Eclipse.
We share this code by courtesy of Carlton O'Riley.
Download
-------------
Download Java tools from here:
http://www.aspicore.com/download/java/GSMTracker.zip
(GSMTracker.zip, 400 kB, version 19-Jan-2005 20:21)
Installation
You will need the JRE 1.5 to run the code. (The general Sun web site for Java is
http://java.sun.com/. Look for J2SE 5.0 or JRE 5.0)
Uncompress the GSMTracker.zip into some directory on your hard disk. Note that the Zip file contains subdirectories.
Setup the MySQL database with the .sql file as described in GSM_Tracker_MySQL.txt
Starting the server
Open the OS command prompt. Go to the directory containing GSMTracker.jar.
Issue the following command:
java -cp mysql-connector-java-3.1.6-bin.jar;GSMTracker.jar asp.location.gsmtracker.TrackerServer
Now the server should be running. It shows the arriving UDP packets on the console in real time. It also parses and stored them into the database, if the db connection was successful.
Next development step
Obviously you need to write or purchase some additional program code to do something with the positioning data collected to the database.
Troubleshooting
If you get error
java.sql.SQLException: Access denied for user: 'root@localhost',
check the database connection parameters from TrackerServer.java. Either change the connection parameters from there, or change your root password to 'root' with MySQL command
mysql> SET PASSWORD = PASSWORD('root');
If you get error
java.sql.SQLException: Unknown system variable 'time_zone',
check that you have a correct version of MySQL. In our case an upgrade from mysql-4.0.20b-win.zip to mysql-essential-4.1.9-win32.msi helped. (
http://dev.mysql.com/, Windows Essentials Installation Package)
Some additional installation and usage hints you can get from our Perl tools page
Using the test client
Open another OS command prompt from the same computer where TrackerServer is running. Go to the directory containing GSMTracker.jar.
Issue the following command:
java asp.location.gsmtracker.TrackerTestClient
The test client sends an UDP datagram to localhost. The datagram is a simulated message from Aspicore GSM Tracker mobile client.
The following text should appear into the TrackerServer console window:
Received from /127.0.0.1:
IMEI 123456789012345
$GPRMC,144858.159,A,6009.0358,N,02453.3223,E,0.00,006.40,191104,,*05
OutCell 38091 LAC 30464 Name SAT-C MCC 510 MNC 1
In Cell 34747 LAC 2161 Name SONERA MCC 244 MNC 91
Label Aspicore Ltd
*DE6279AE
Next you can test, whether the simulated message got stored into the database. Open MySQL Command Line Client (mysql.exe) and make some select queries:
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14 to server version: 4.1.9-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use gsmtrack;
Database changed
mysql> select TIME_RECEIVED, LATITUDE, LONGITUDE FROM GPS;
+---------------------+------------------+-----------+
| TIME_RECEIVED | LATITUDE | LONGITUDE |
+---------------------+------------------+-----------+
| 2005-01-21 08:52:32 | 60.1505966666667 | 24.888705 |
+---------------------+------------------+-----------+
1 row in set (0.00 sec)
mysql> select * from cells;
+-----------+-------+-------+--------+------+------+
| CELLRECID | CID | LAC | NAME | MCC | MNC |
+-----------+-------+-------+--------+------+------+
| 3 | 34747 | 2161 | SONERA | 244 | 91 |
| 4 | 38091 | 30464 | SAT-C | 510 | 1 |
+-----------+-------+-------+--------+------+------+
2 rows in set (0.00 sec)
mysql>
If everything seems to be working as expected, you can try sending location data from your phone. Start Aspicore GSM Tracker in your phone and change the setting "GPRS Server IP" to the public IP address of the computer, where TrackerServer is running. Restart Aspicore GSM Tracker in your phone.
If you want to make sure, that your TrackerServer is accessible from the public Internet, as is required unless you have purchased a private GPRS access point from your carrier, you can modify TrackerTestClient.java a little to send test messages to another IP address instead of localhost. Then you can use TrackerTestClient to send test messages from another computer through your firewall to your TrackerServer and see that your firewall passes the UDP packets through.
How to evaluate?
The central database solution is not included, but customers can use Aspicore's test server in the Internet for evaluation and testing. The test server:
http://www.toimii.com/gps
can also be used to evaluate the network cell based positioning. Collect first the cell locations along your daily routes with a Bluetooth GPS and then try positioning without a GPS receiver! This is a more affordable and a real-time alternative to operator based mobile phone positioning.
Server interface and tools
Aspicore GSM Tracker sends data to the server as plain ASCII characters in an UDP datagram. You can write the receiving end program yourself by using UDP sockets, if you wish. NEW: You are free to use the sample Perl scripts or Java code to process the UDP datagrams and store them to a MySQL database. You can also use our Aspicore UDP Server (
http://www.aspicore.com/en/UDPServer.asp?tab=2&sub=2 ) tool. Http data from S60 v2.xx or S80 can be processed as shown in our PHP and ASP samples. There is a freeware Windows .NET (
http://www.aspicore.com/en/UDP_serial.asp?tab=2&sub=2 ) PC utility to receive NMEA datagrams via UDP and send them to a standard GPS moving map program through COM ports.
Aspicore Ltd is willing to provide you with the data collection database server software or to assist you to integrate the Aspicore GSM Tracker solution into your enterprise system.
(*Aspicore GSM Tracker S60 V2.13_cracked 最新破解版 559楼.)
[
本帖最后由 joeywong 于 2007-1-2 03:00 编辑 ]
