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.

  1. 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"

  1. Install Ladder99.

"$repo_root/shell/install/cli"
source ~/.bashrc

  1. Create and use a Ladder99 configuration setup. This copies setups/example configuration to setups/$configuration_name.

configuration_name='dev'
l99 init "$configuration_name"

  1. Edit setups/$configuration_name/services/docker-compose.yaml file to provide overrides per your requirements. In order to access the database outside of localhost, you need to add ports 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

  1. Selectively start the stack, omitting adapter and relay.

l99 start agent dozzle grafana pgadmin portainer postgres

  1. 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.

  2. Start the services again.

l99 start agent dozzle grafana pgadmin portainer postgres

  1. 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