Category Filtering: 'commandbox'

Remove Filter

Coldfusion/Lucee Running on MeLE Fanless Stick PC

I started out with a MeLE PCG02 Mini PC Stick Fanless Windows 11 Pro stick computer running Windows 11.

This is a great little computer for your TV.

You can check it out in action at NOTE: It may not always be running as I'm constantly playing with it bringing it offline. Also, this is running on home internet and a dynamic dns service. 

But can you imagine the possibilities? I'm thinking of a dynamic system for displaying Real Estate on a TV for local Realtors.

What will you use yours for?

Docker Swarm + Portainer + mySQL + NGINX + CommandBox/ContentBox

start docker swarm

docker swarm init

add the docker portainer service for easy management

docker service create \
    --name portainer \
    --publish 9000:9000 \
    --constraint 'node.role == manager' \
    --mount type=bind,src=/var/run/docker.sock,dst=/var/run/docker.sock \
    portainer/portainer \
    -H unix:///var/run/docker.sock

login to port 9000, add two named volumes to be used below:

  1. mysqldata
  2. nginx

docker swarm join info coming soon

create overlay network (details coming soon)

This may not be necessary now that I'm running all containers as a service (even though I only have 1 instance running)

add mysql service

docker service create \
--name mysql \
--network bluewater \
-p 3306:3306 \
--mount type=volume,source=mysqldata,target=/var/lib/mysql,readonly=false \
--env MYSQL_ROOT_PASSWORD=superSecretPassword! \

You will need to login and create a database.

start docker contentbox image

docker service create \
--name docker_blusol_io \
--network bluewater \
-e 'installer=true' \
-e 'rewrites=true' \
-e 'cfconfig_whitespaceManagement=white-space-pref' \
-e 'cfconfig_adminPassword=superSecretCFMPassword! \
-e "DB_CONNECTION_STRING=jdbc:mysql: //mysql:3306/blusol_docker?useUnicode=true&characterEncoding=UTF-8&useLegacyDatetimeCode=true" \
-e '' \
-e 'DB_USER=root' \
-e 'DB_PASSWORD=superSecretPassword! \

adding nginx for reverse proxy

docker service create \
--name nginx \
--network bluewater \
-p 80:80 \
-p 443:443 \
--mount type=volume,source=nginx,target=/etc/nginx,readonly=false \


       	listen 80;
        location / {
                proxy_set_header Host $host;
                proxy_set_header X-Real-IP $remote_addr;
                proxy_pass "http://docker_blusol_io:8080";