Sanav GC-101 Manual de Instalação descarregar pdf (Página 14)

4) Initialization and Installation Testing

Before using OpenGTS, it must first be initialized. This section describes the steps required for initialization and testing.

4.1) Initializing the SQL Database Tables

Before storing data in the SQL database, it must first be initialized with the tables used by OpenGTS. This can be

accomplished with the "bin/init.sh" command as follows:

/zzz> cd $GTS_HOME

/usr/local/OpenGTS_1.2.3> bin/initdb.sh -rootUser=<rootUser> -rootPass=<rootPass>

Where <rootUser> is the user with root access to the SQL server, and <rootPass> is the root user password (may

be optional depending on the configuration of your SQL server). [NOTE: This is not the same as the Linux "root" user]

4.1.a) Important note regarding ".sh" and ".bat" command files:

Commands ending with ".sh" or ".bat" MUST be executed from the OpenGTS installation directory.

Attempting to execute these commands from another directory may result in a "ClassNotFoundException" or

"NoClassDefFoundError" error, or similar. (This means that you must cd to $GTS_HOME, then execute the

command as "bin/<command>") Windows users may wish to install a Perl interpreter on their machine in

order to use the Perl versions (".pl") of the command-line scripts which do not require that they be executed

from the OpenGTS installation directory. More information on possible Perl distributions available on Win32

platforms may be found at this location: "http://win32.perl.org/wiki/index.php?title=Win32_Distributions"

4.1.b) Important note for Windows users:

When using the ".bat" version of the commands in a DOS window, command arguments such as

-rootUser=root must either be enclosed in quotes, as in "-rootUser=root", or be specified with a colon

instead of an equal-sign, as in -rootUser:root. Thus, on Windows, the command is:

bin\initdb.bat "-rootUser:userName" "-rootPass:userPass"

Where 'userName' and 'userPass' should be replaced with the appropriate root user and password.

The "initdb.sh" command performs the following functions when initializing the OpenGTS database:

• Creates a database called "gts".

• Creates/Grants user "gts" with password "opengts" with access to the "gts" database.

• Creates the following tables in the "gts" database (this is only a partial list):

• Account - Account owner table

• User - User table

• UserAcl - User Access-Control-List table

• Device - Device information table

• EventData - Received Event data

• Geozone - Geozone/Geofence definitions

• EventTemplate - Custom event packet templates (DMTP only)

• PendingPacket - Packets pending transmission to device (DMTP only)

• etc.

The "initdb.sh" command performs the same functions as the following sequence of commands:

/zzz> cd $GTS_HOME

/usr/local/OpenGTS_1.2.3> bin/dbAdmin.pl -createdb -user=<rootUser>

/usr/local/OpenGTS_1.2.3> bin/dbAdmin.pl -grant -user=<rootUser>

/usr/local/OpenGTS_1.2.3> bin/dbAdmin.pl -tables=ca

OpenGTS Configuration and Installation Manual Page 14 of 60

1 2 ... 9 10 11 12 13 14 15 16 17 18 19 ... 59 60

Sem comentários

Sanav GC-101 Manual de Instalação Página 14