SARTrack Logo

How to use the SARTrack Database system 


All SARTrack (Clients) must connect to a Database Server (which is automatic on the local LAN), and will require a Login and Password.  There are several layers of access: Supervisor, Operations, Data Entry, Read-Only and 'Database Server'.  Only the Supervisor can add new Users on the Database Server, and give them the required access level.

With the SARTrack Database Server system now in place, it is NO LONGER POSSIBLE to use the APRS-IS network to link SARTrack computers together. This must now be done using one or more Database Servers.
The only reason to connect to an APRS-IS Server would be to receive APRS Tracker information, and in this case only ONE SARTrack client should connect to it, as this client will forward the APRS data to all other connected SARTrack clients via the Database Server.


Non-New Zealand users: Using the existing SARTrack Internet Database Server in Germany (this is free):
SARTrack Limited has set up a worldwide Internet based SARTrack Database Server in Germany. (Germany because of its good privacy regulations)
If your organisation wants to use this Server (currently for free), send an email to info@sartrack.co.nz with the following information for your Supervisor:

Login name

First name; 

Last name

Initial Password;
 
And the SARTrack "GroupID" you use for your organisation.

I will set you up on the server with Supervisor access, and you can change your password later if you wish.
See below on how to set up the SARTrack Client to directly connect to this Database Server.

New Zealand users ONLY:
Since November 2017, NZSAR has installed a New Zealand based Database Server for NZ SAR groups only.
To be able to use this server, please
send an email to info@sartrack.co.nz with your Group name, and I will allocate you a 'GroupID' and Callsign range.


For local use (In the field, and at a Permanent Base), you install a Local Database Server on ONE computer only.  See below for the Setup procedure.
Please have a look at the recommended Database / SARTrack Clients Setup for both a Permanent Base and Remote location.

If you are going to install your own Internet Based Database Server, you must set this one up first. Details on this in Advanced Setup.

Installing a Local Database SERVER:
http://www.sartrack.nl/downloads/SartrackServerInstall.exe

Download and install the package.
After installation you will see a new Icon 
on the Desktop with an "M" in it,  called SARTrack Server Monitor.
When you click on this, it will start the "SARTrack Monitor" program, in 32 bit mode. This program will detect if you have a 32 bit or 64 bit operating system, and then start the correct "SARTrack Server" version. The 'Monitor' program will check if the Server is still running, and will attempt to restart the Server if it is not running. The "Monitor" program will minimize itself into the Windows Icon tray, from where you can open it to close/restart the Server.

On first start of the Database Server, the Setup window will open.
In the primary Setup, use a *** UNIQUE *** CALLSIGN!! Never should any Callsign be the same as any other SARTrack Server or SARTRack Client callsign. Every SARTrack computer (Server or Client) MUST have a unique callsign!
The option "Server is on the Internet" should NOT be ticked, except when you are installing your OWN permanent Internet based server, please see below for Advanced Setup).
The difference between a "Local Database Server" and an "Internet Database Server" is this selection
"Server is on the Internet". This will completely change the behaviour of the Server, so take care with this setting!

Please click on the Help button for full information on the required settings.

NOTE: To connect direct to your
own Local Database Server for the first time, 
use the Login with the name: "ServerAdmin" with the special password which you have just set up in your local Database Server Setup.
This gives you 'root' access to the Server, and
will get you into the local Server regardless of the GroupID you have set up in the SARTrack client, but when you then add/edit more Database Users, these will be generated under the GroupID which you have set in SARTrack client at that moment. This is mosly an issue if you are setting up your own Internet based Database Server.


Connecting the Local Database Server to an Internet based Database Server:
You can program the Local Server to connect to an Internet based Server to synchronize the (Active Operation) database between these two servers. This is a powerfull feature, as it allows you to work in a remote area, with multiple SARTrack clients connected via a local LAN or WIFI, but have SARTrack clients anywhere in the world linked into the Operation via the Internet based Server.  This will work even with an intermittent Internet connection (Satellite link or Mobile Broadband), as the two Servers will re-synchonize on re-connect, and immediately update all SARTrack clients on both sides.
Please read the Server help for more details.

NOTE: Be aware: You can only connect your Local Database Server to an Internet Database Server when a special DTB Login & Password has been set up for it there!
First use your SARTrack client to connect to the Internet Server
direct (using your personal Login) and add a special Login & Password for your Local Database Server in 'DTBUsers'! You cannot let your Local Server try to connect using your own personal  'Supervisor' level login!  
Please read the following steps for details:

1) In the SARTrack Client program, Setup>SAR check "Use Database Server".
2) In the Connection Menu, right-click on Database, and select 'Setup Database Server''.
3) Select the SARTrack Internet Database Server 
(it shows in the pulldown list as "dtb-germany.sartrack.nl"). (or use your own Internet Database Server)
4) Login to the server using the Login and password I allocated for you (and emailed to you)
on the SARTrack Internet Server. Make sure you use the correct GroupID !
5) Under 'DTBUsers' set up a NEW Database User for your own LOCAL Database Server with a unique login name, and an Access Level of "Database Server".  (If you are going to use TWO Local Database Servers (One at a Permanent Base and one for in the Field) set up two separate Login/passwords for these two local servers.)
6) In your Local Server Remote Connection setup, select the German Database Server (dtb-germany.sartrack.nl), and the same Login and Password you have just set up for this LOCAL Server there.  Do NOT try to use another Login, it must be the special Login with an Access Level of "Database Server".  

You can now connect your Local Server to the Internet Database Server.

Do make sure to add more User logins on your Database Server for all other users in your organisation, with the appropriate Access Levels.

NOTE: The Database User Login's (DTBuser's) and automatically synchronized between the Local Server and the Internet Server. Once you have set them up on one Server, they should be available on BOTH Servers after they have connected and synchonized. So all your users should then be able to Log into either the Local server, or the Internet Server as required.

*******************************************************

The SARTrack client:
http://www.sartrack.nl/downloads/sartrack_inst.exe

Make sure ALL your computers run the SAME and latest version of SARTrack, and are all set up with the same GroupID.
In Setup>SAR check the 'Use Database Server" option.

After logging into the Internet Database Server, or your own Local Database Server you can add more 'DTBUsers' which are all other people allowed to log into the Server.

- In the SARTrack "Manage Menu" click on "DTB Users" and enter new User accounts with their access levels, including one for yourself with Supervisor access.  (If that was not already done) After that you should no longer have to use the primary "ServerAdmin" login when using a Local Database Server.
The new 'DTBUsers' can now log in from all SARTrack computers connected to the Database Server.
(Note: If you are also using an Internet based Database Server, any DTBUsers on that server will be synchonized with the Local Server on first connect. So, all database users will then be able to connect either to the Local Server or the Internet Server.)

You can now logout, and then Login again using your own private DTBUser account.

- Once connected, click on "Operations", this will open the new Operations Menu.
- In the Operation Log window, start a new Active Operation (Supervisor access required).

On all SARTrack clients, in 'Setup>SAR' select "Use Database Server", then in "Connection Setup>Database", set the Database Server to be used (or Automatic when on the local LAN/WIFI) and select "Connect to Server".
SARTrack will ask the user for a Login and Password. When correctly entered by the operator the Client will connect with the preset Access Level and download the databases. If a new Operation has started it will close all Windows, switch to the new Operation, and re-open the Operations Log window.  

Note: If you run a SARTrack client on the same computer on which the Local Server is running, the 'Server' field will be fixed at 'localhost'. If you want to connect to another Database Server, you must shutdown the Server on the local computer first.

If you wish, you can now try to connect one of the SARTrack computers to an APRS Server on the Internet, or a radio/satellite based tracking device. All data received from the APRS network or device should now appear on all Server connected computers.
NOTE: Only ONE SARTrack computer should be connected to the Internet APRS network!

Please report any problems (in detail) by using the Debug window, 'send Bug report' and attach the Debug file.  In some cases it may be required that you send it from all affected computers (including the Server!), so I can compare the Debug logs.

Please report ALL problems and bugs you may encounter. I rely heavily on feedback to be able to fix bugs in the program.


Advanced Setup: Installing an Internet based permanent Database Server
I strongly recommend that you use a real VPS (Virtual Private Server) which you can lease from many companies in the world. Do NOT use a Server which is installed at some (home) location via an ADSL modem for real Operations, as the risk is to great that the Server may be unavailable due to ADSL problems, or because somebody switched off the PC...

When installing on a VPS, this will generally be a Microsoft Server. Any version will do, the cheaper the better. SARTrack German server runs on Microsoft Server 2012.
1 Gb memory is more than enough, and diskspace is also barely required. Just select the cheapest option.

After downloading and installing the Database Server, you can initially proceed as per Local Database Server above, except that you now check the box "Server is on the Internet". This will completely change the way the Server interacts with all connected Clients.

Once the Server is running, you will have to open up the Firewall ports in the Microsoft Server. Even if you are using a desktop version of Windows, you still need to give SARTrackServer32.exe or SARTrackServer64.exe full Internet access.

When it is required to select the actual Ports: SARTrackServer uses the following INCOMING ports: 8050, 8051: Primary and secundary TCP ports. 8052: DebugLog port. 8053 HTTP Web port (NOT Port 80).
So, you can open a range of incoming TCP ports: 8050 to 8053.

The Server also uses OUTGOING ports for SMTP: Normaly port 587.

Then the SARTrackMonitor.exe program requires OUTGOING access to the FTP port 21, to be able to download the Updates.
 
Once you have all this done, you may need to restart the Database Server (via the Monitor program).

The initial Login to the Server (using a SARTrack client) must be done with the special Login name of "ServerAdmin", and the password you have set up in the Server Setup for this.
Do make sure that in the SARTrack  client, you have set up the GroupID you are planning to use.

You can now click on the 'DTBUsers' button in the Management Menu and start adding more Database User Login's, and one for yourself.
You also need to add special DBBUser Login's for your Local Database Server(s)s. each with the special Access Level of "SartrackServer".

IMPORTANT: At the present time, the Database Server runs in Windows 'User space': It will only run after you have logged into  Windows!  The Database Server does NOT run automatically after a Windows reboot. You must first log in for it to run, and you cannot Log log out, else the Server will stop. Instead of logging out, just use the Switch User option, or when connected to a Windows Server with Windows Remote Desktop, just close that session, and the Login will stay active.

For more technical information on how the SARTrack Database system actually works, read this document. (Only if you are interested in the technical background)
.
 

Thanks,


Bart Kindt
CEO, SARTrack developer