[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]
Leave a Reply
You must be logged in to post a comment.