Remote Setup
Start Remote Services
Log into the computer where you want to install Ladder99 and follow the following instructions. This computer will run Postgres and Grafana.
Clone the Ladder99 repository.
repo_root="$HOME/ladder99"
commit='v0.11.7' # Branch, commit or tag to check out; use tags for specific releases
git clone https://github.com/Ladder99/ladder99 "$repo_root"
Install Ladder99.
"$repo_root/shell/install/cli"
source ~/.bashrc
Create and use a Ladder99 configuration setup. This copies
setups/example
configuration tosetups/$configuration_name
.
configuration_name='dev'
l99 init "$configuration_name"
Edit
setups/$configuration_name/services/docker-compose.yaml
file to provide overrides per your requirements. In order to access the database outside oflocalhost
, you need to addports
to
postgres:
# allow remote access to db
ports:
- $PGPORT:5432/tcp
You also need to comment out the ports
in the base compose file (services/docker-compose.yaml
) to prevent Postgres port conflicts:
# ports:
# - 127.0.0.1:$PGPORT:5432/tcp # this way, only localhost can access the port
Selectively start the stack, omitting
adapter
andrelay
.
l99 start agent dozzle grafana pgadmin portainer postgres
It is strongly suggested you change the environment variables such as credentials to database and Grafana in
setups/$configuration_name/.env
. For testing purposes you can also accept the defaults.Start the services again.
l99 start agent dozzle grafana pgadmin portainer postgres
l99 status
will display the status of the stack.
project service STATUS PORTS
ladder99 agent Up 24 seconds 0.0.0.0:5000->5000/tcp, :::5000->5000/tcp
ladder99 dozzle Up 24 seconds 0.0.0.0:8080->8080/tcp, :::8080->8080/tcp
ladder99 grafana Up 23 seconds 0.0.0.0:80->3000/tcp, :::80->3000/tcp
ladder99 pgadmin Up 24 seconds 0.0.0.0:5050->5050/tcp, :::5050->5050/tcp
ladder99 portainer Up 23 seconds 8000/tcp, 9443/tcp, 0.0.0.0:9000->9000/tcp, :::9000->9000/tcp
ladder99 postgres Up 23 seconds 0.0.0.0:5432->5432/tcp, :::5432->5432/tcp
Start Local Development
On your development machine, clone https://github.com/Ladder99/ladder99
and open in your IDE.
The setup file used will be setups/example/setup.yaml
. It is configured to query two Agents: http://agent:5000
which is innacessible; and http://mtconnect.mazakcorp.com:5701
which should be accessible from your development machine.
Install the NodeJS dependencies:
cd "$repo_root/services/relay" && npm i
Set your environment variables, with PGHOST
pointing to the remote computer:
FETCH_COUNT=800
FETCH_INTERVAL=2000
L99_SETUP_FOLDER=../../setups/example
PGDATABASE=postgres
PGHOST=10.1.10.135
PGPASSWORD=postgres
PGPORT=5432
PGUSER=postgres
Run $repo_root/services/relay/src/index.js
.
node "$repo_root/services/relay/src/index.js"
The remote database will begin populating with data from Mazak’s Agent. You can check it using the following queries.
SELECT * FROM public.devices
SELECT * FROM public.dataitems
SELECT * FROM public.history_all