User Guide: RFM5109-B Fixed RAIN/UHF Smart Reader with ReaderService
Page 11
www.Axzon.com IN026F12
5.3. Creating a new user
If a new DBA database administrator with
all rights was not created during the MySQL
installation to match expected database login
from the
<<reader-service>>/config/
application.properties
file, then a new
DBA role can be configured using the MySql
Workbench.
Role:
DBA
Host Matching:
%
Login:
axzon_admin
Password:
axzon_admin
5.4. Creating the Database Schema
Within the MySQL Workbench, load the SQL
file
<<reader-service>>/db-script/
schema.sql
. The lighting bolt icon will
execute “highlighted or selected” SQL com-
mands. The new
rf_sensor_db
schema
should now be listed in the left workbench
window.
5.5. Installing ActiveMQ
Download ActvieMQ version 5.15 installer.
Detailed instructions are also available at
http://activemq.apache.org/
getting-started.html
.
Extract the zip file contents to a program di
-
rectory of your choice, such as
C:\Program
Files\activemq
.
Navigate to
apache-activemq-5.14.3\
bin\win64
folder (for an x64 machine).
Within the
activeMQ/bin
directory select
and click into the folder that best matches
your operating system. Then right-click on
InstallService.bat
then select “Run as
administrator.” Confirm any Windows De
-
fender prompts.
Launch Windows Services by typing “services”
at the START menu. Verify that a new service
has been added named “ActiveMQ.” If not
running already, right click on the service and
select start.
