• Home
  • pcDuino
  • WiKi
  • Store
  • Distributors
  • Home
  • pcDuino
  • WiKi
  • Store
  • Distributors
HomeOpenGTSPart III: Initialization and Installation — ...
Previous Next

Part III: Initialization and Installation — Install OpenGTS

Posted by: admin , January 5, 2014

[vc_row][vc_column width=”1/1″][vc_tour][vc_tab title=” Initializing the SQL Database Tables” tab_id=”1388898590-1-85″][vc_column_text]

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= -rootPass=
Where is the user with root access to the SQL server, and 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]

[/vc_column_text][/vc_tab][vc_tab title=”Testing Installation” tab_id=”1388898590-2-84″][vc_column_text]

linksprite@linksprite-Vostro-230:/usr/local/OpenGTS_2.3.2$ bin/checkInstall.sh
Memory-K: max=233024, total=30336, free=27880, used=2456
=====================================================================================
Service Account: [opengts] Open Source OpenGTS
=====================================================================================
OpenGTS:
  (Version)              ==> 2.3.2
  (Compiled Time)        ==> Fri May 27 23:38:36 MDT 2011
  (Current Time)         ==> Sat May 28 10:17:05 MDT 2011
  (Current User)         ==> linksprite
  ServiceAccount.ID      ==> opengts
  ServiceAccount.Name    ==> Open Source OpenGTS
  ServiceAccount.Attr    ==> ?
  ServiceAccount.Key     ==>
System Information:
  os.arch                ==> amd64
  os.name                ==> Linux
  os.version             ==> 2.6.35-22-generic
  /etc/issue             ==> Ubuntu 10.10 n l
  Total Memory           ==> (unable to obtain)
Java Version (the JRE running this program):
  (Vendor)               ==> Sun Microsystems Inc.
  (Version)              ==> 1.6
  (Install dir)          ==> /usr/lib/jvm/jdk1.6.0_25
  java.awt.headless      ==> true
  (Has Fonts)            ==> true
  (Supports MD5)         ==> true
Environment variable paths (canonical):
  GTS_HOME               ==> /usr/local/OpenGTS_2.3.2
  GTS_CONF               ==> (NOTE: not defined)
  JAVA_HOME              ==> /usr/lib/jvm/jdk1.6.0_25
  ANT_HOME               ==> /usr/bin
  CATALINA_HOME          ==> /usr/local/apache-tomcat-6.0.29
Extended library Jar files: ‘java.ext.dirs’
  (Ext dir)              ==> /usr/lib/jvm/jdk1.6.0_25/jre/lib/ext
  mail.jar               ==> Found ‘mail.jar’
  mysql-connector-java-* ==> Found ‘mysql-connector-java-5.1.16-bin.jar’
  (Ext dir)              ==> /usr/java/packages/lib/ext
Runtime Configuration:
  (Default cfg dir)      ==> /usr/local/OpenGTS_2.3.2
  (Default cfg file)     ==> /usr/local/OpenGTS_2.3.2/default.conf
  (WebApp cfg file)      ==> /usr/local/OpenGTS_2.3.2/webapp.conf
  log.dir                ==> /usr/local/OpenGTS_2.3.2/logs
  db.sql.provider        ==> mysql
  db.sql.host            ==> localhost
  db.sql.dbname          ==> gts
  db.sql.user            ==> gts
  db.sql.utf8            ==> true
  db.sql.url             ==> jdbc:mysql://localhost:3306/
  db.sql.url.db          ==> jdbc:mysql://localhost:3306/gts?characterEncoding=UTF-8&useUnicode=true&characterSetResults=utf8
  StartupInit.class      ==> (default)
  (RuleFactory)          ==> (not installed)
  (SMTP)                 ==> :25  [user=, ssl=false]
  (SMTP Connection)      ==> SMTP service disabled (no host specified)
Character Encodings:
  (Default Encoding)     ==> UTF-8
  file.encoding          ==> UTF-8
  DBProvider:mysql_myisam ==> latin1[latin1_swedish_ci]
Tables [jdbc:mysql://localhost:3306/gts?characterEncoding=UTF-8&useUnicode=true&characterSetResults=utf8]
  Account                ==> RecordCount 0
  AccountString          ==> RecordCount 0
  User                   ==> RecordCount 0
  UserAcl                ==> RecordCount 0
  GroupList              ==> RecordCount 0
  Device                 ==> RecordCount 0
  Transport              ==> RecordCount 0
  UniqueXID              ==> RecordCount 0
  DeviceGroup            ==> RecordCount 0
  DeviceList             ==> RecordCount 0
  Driver                 ==> RecordCount 0
  EventData              ==> RecordCount 0
  Geozone                ==> RecordCount 0
  Resource               ==> RecordCount 0
  Role                   ==> RecordCount 0
  RoleAcl                ==> RecordCount 0
  StatusCode             ==> RecordCount 0
  SystemProps            ==> RecordCount 2
  EventTemplate          ==> RecordCount 0
  PendingPacket          ==> RecordCount 0
  Property               ==> RecordCount 0
  Diagnostic             ==> RecordCount 0
reports.xml:
  (XML file)             ==> /usr/local/OpenGTS_2.3.2/reports.xml
  (Report count)         ==> 25
   EventSpeedPosted      ==> Exceeding Posted Speed (${description})
   EventReboot           ==> Device Initialization/Reboot
   EventSpeedOption_Group ==> Speeds over ${description}
   EventDetailOBDshort   ==> OBD Event Detail (abbrev)
   EventSummary          ==> Last Known ${i18n.Vehicle} Location [${description}]
   EventExcessSpeed      ==> Device Excess Speed
   MotionSummary         ==> Driving/Stopped Time Summary [${description}]
   EventRule             ==> Custom Rules
   EventDetail_Group     ==> Event Detail (by Group)
   PropertyValue         ==> Property Values
   DriverMessageDetail   ==> Driver Message Detail
   EventSpeedPosted_Group ==> Exceeding Posted Speed (${description})
   EventDetailOBD        ==> OBD Event Detail
   EventInput            ==> Event Digital Input
   FleetMotion           ==> Driving Time Fleet Summary
   EventWaymark1Detail   ==> Device ‘${statusCodeDesc:0xF031}’ Locations
   DiagnosticValue       ==> Error/Diagnostic Values
   EventDetail           ==> Event Detail
   EntityDetail          ==> Trailer Hook/Drop Detail
   EventCount            ==> Count of ${description} Received Events
   EventDetailAll        ==> Event Detail (All fields)
   SampleCollectionDetail ==> Sample Collection Detail
   EventSpeedOption      ==> Speeds over ${description}
   EventWaymark0Detail   ==> Device ‘${statusCodeDesc:0xF030}’ Locations
   EventJ1708fault       ==> OBD Fault Codes
private.xml:
  (XML file)             ==> /usr/local/OpenGTS_2.3.2/private.xml
  (Class)                ==> org.opengts.war.tools.PrivateLabelLoader
  (Domain count)         ==> 1
  1) default             ==> en, accountLogin, userLogin[“admin”], demo
     (host)              ==>  *
     (alias)             ==>  localhost
     (map provider)      ==>  openLayers
Device Communication Servers (registered):
   1) template           ==> [TCP=31200 UDP=31200] Example Template Server
   2) taip               ==> [TCP=31275 UDP=31275] TAIP (Trimble ASCII Interface Protocol)
   3) gtsdmtp            ==> [TCP=31000 UDP=31000] OpenDMTP
   4) sipgear            ==> [TCP=31270 UDP=31270] ZhongShan SIPGEAR Technology Co, Ltd.
   5) icare              ==> [TCP=31260 UDP=31260] ICare
   6) aspicore           ==> [TCP=31265 UDP=31265] Aspicore GSM Tracker
Recommended symbolic links:
  /usr/local/gts         ==> /usr/local/OpenGTS_2.3.2
  /usr/local/java        ==> /usr/lib/jvm/jdk1.6.0_25
  /usr/local/tomcat      ==> /usr/local/apache-tomcat-6.0.29
=====================================================================================
No errors reported
No warnings reported
=====================================================================================
=====================================================================================

[/vc_column_text][/vc_tab][vc_tab title=”Creating the “sysadmin“ account” tab_id=”1388898677547-2-1″][vc_column_text]

linksprite@linksprite-Vostro-230:/usr/local/OpenGTS_2.3.2$ bin/admin.sh Account -account=sysadmin -pass=XXXXX -create
Entry Point: org.opengts.db.tables.Account
New Connection [main] jdbc:mysql://localhost:3306/gts?characterEncoding=UTF-8&useUnicode=true&characterSetResults=utf8
Created Account-ID: sysadmin
linksprite@linksprite-Vostro-230:/usr/local/OpenGTS_2.3.2$

[/vc_column_text][/vc_tab][/vc_tour][/vc_column][/vc_row]

Tags: OpenGTS

Share!
Tweet

admin

About the author

Leave a Reply Cancel reply

You must be logged in to post a comment.

Category

  • Home
  • pcDuino
  • WiKi
  • Store
  • Distributors