Happy Mother’s Day, Mom. I’m really grateful for all you’ve done and the challenges you faced as a mother. You saved me from mental hospital, and this mom has been looking after me my whole life. I love you, Mom.














Happy Mother’s Day, Mom. I’m really grateful for all you’ve done and the challenges you faced as a mother. You saved me from mental hospital, and this mom has been looking after me my whole life. I love you, Mom.
I am grateful for my mom. Welcome them home.
When I get off the plane, it’s so thrilling to be on Arionza ground. It’s got this amazing vibe and nice people around, and my weather is perfect. I’d love to live in Arionza. And I went to the Cottage house to stay over. Oh man, they’ve got new technology for microwaves and good old-fashioned blind windows. Here is video and photo cool stuff.
I proceeded with the preparation of the wood, followed by sanding the table and applying waterproof paint. The outcome was exceptional. Today was a beautiful day characterized by sunshine and thirstiness. I made a decision to purchase a strawberry smoothie and blast Berry Lemonade from anthem coffee, which were both delicious. I understand that the job was challenging, but it’s good health and good for me to learn things can be handy man. I desire to enhance the appearance of my stores and adapt them daily.
Indeed, it was the correct decision. Comcast Business has recently upgraded our plans to 250 MBPS, automatically upgrading with download speeds reaching 500 MBPS and upload speeds at 200 MBPS. I have decided to relocate my server from medical to another location that offers the highest upload speeds and is ideal for smooth operation.
Subsequently, I have established a website at https://status.richardapplegate.io for my work status uptime. It is crucial to me to monitor their performance constantly. I also monitor our comcast business gateway. Great to document their outrage from time to time to provide us credit.
We’re using MariaDB for our business because it’s meant for big business, and it’s my favorite database to use for small businesses. And I have a lot of skill experience with MariaDB than any other database, but few other databases are lacking in my experience. Therefore, I do not have sufficient time to undertake these experiences. After I document all my notes and work for sure, I will study these (MongoDB, PostgreSQL) I use some on app after I document all my notes and work for sure. I will study these after I document all my notes and work for sure. Which is a pain for me, but I got the app working and stable. So let get start to Tutorial for MariaDB.
Please ensure that you complete this first. Before starting build this,
How to set up Portainer with nginx Proxy Manager
We need to create a network for the MariaDB database for another app to communicate. We prefer to refrain from exposing our port.
docker network create mariadb
Now we can begin to create details for the MariaDB Database on Portainer.
version: '2'
services:
mariadb:
container_name: mariadb
networks:
- mariadb
image: mariadb
command: --transaction-isolation=READ-COMMITTED --binlog-format=ROW
restart: always
environment:
- MYSQL_ROOT_PASSWORD=yourownpassword
- MARIADB_AUTO_UPGRADE=1
- MARIADB_DISABLE_UPGRADE_BACKUP=1
volumes:
- /mnt/nasdrive/mariadb/:/var/lib/mysql
networks:
mariadb:
external: true
Then you deploy the stacks. Your app will then be operational. Thereafter, you can easily add PhpMyAdmin to this docker-compose. But I like stacks because we can use the same app for many server databases.
PhpMyAdmin is easy to set up for any app and fix the table database or troubleshoot. So, we will set up PhpMyAdmin with NGINX SSL secure for our HTTPS. Due to the possibility of a grabber username and password exploit, we would prefer not to expose this on HTTP.
Please ensure that you complete this first. Before starting, we should make sure that this tutorial prevents hacking and exposes our port to the public. We do not want that to happen. We only want 80 and 443 to be open.
How to set up Portainer with nginx Proxy Manager
After you complete Portainer and nginx, we are good to go to build this app with nginx and PhpMyAdmin.
version: '3'
services:
pma:
networks:
- nginx
- mariadb
image: phpmyadmin/phpmyadmin
container_name: pma
environment:
PMA_ARBITRARY: 1
restart: always
#ports:
# - 8081:80
networks:
nginx:
external: true
mariadb:
external: true
I put hashtags on ports and port numbers because we don’t need them. We’ll just use nginx network on this app. Nginx proxy can talk to PhpMyAdmin instead of port or public. It is more secure to build our app before it is published to the public. Your sites can be injected with any insecure port.
After deploying the stacks, your PhpMyAdmin is now online, but it won’t show up on the site because you didn’t set up the nginx proxy info. That would be our next step.
You should open the nginx proxy manager for your site. My will be nginx__.richardapplegate.io.
Thereafter, you’ll need to access your admin account. Add proxy host, then fill this detail.
Now you may be able to open your site with a domain without port. My will be phpmyadmin.richardapplegate.io. and working!
You’re in the MariaDB database.
This baserow is my absolute favorite, it’s more like a spreadsheet with more options and an easy-to-use database. It also had a Grid and Form and a Gallery and a Calendar! It’s great for our list of things to do.
Look over Baserow.io!
You’ll need Portainer and nginx running, remember? If not, here are my instruction to set up on your server.
Let’s build stacks now.
Open Portainer site → stacks → add stacks
version: "3.4"
services:
baserow:
container_name: applegate-baserow
image: baserow/baserow:1.24.2
networks:
- nginx
- mariadb
environment:
BASEROW_PUBLIC_URL: 'https://sub.domain.com'
volumes:
- /yourpath/baserow/data:/baserow/data
networks:
nginx:
external: true
mariadb:
external: true
Before you deploy, please ensure you follow the high light and modify and edit the networks to match your nginx proxy manager and MariaDB Database Network. Then, deploy the stack and this app is online but not show on site. We need to go to nginx proxy manager to set up a proxy host for baserow.
The sign-up form should appear when you open the base row. Please complete it for the first user, and this account will provide you with an admin account.
Docker-compose is my go-to for secondary or distributed servers. It’s better than docker run because it’s more clean and organized and easier to set up. And one time, too.
So all you need to do is make sure the Secondary Server or Multiserver needs to install Docker and Docker Compose. Please follow this step by step.
Install Docker Engine on Ubuntu | Docker Documentation
Now that we have created the docker-compose files, we can create them where you want them to be saved. The secondary server has not yet set up Portainer, so this tutorial is for using SSH instead of Portainer. The docker compose will do the job, and our primary server will attach secondary from an outside server. This is cool, no need to use a port or anything else.
Open the Portainer site on the primary server, then go to environment, add environment, Docker standalone, start wizard, and edge agent standard. Write down your edge ID and key in this way.
Please ensure that you obtain the Edge ID and Edge Key. Make sure to change your volume path and change your volume path. Look for the highlights below.
Version: '3.9'
services:
agent:
image: 'portainer/agent:2.20.2'
container_name: portainer_edge_agent
environment:
- EDGE_INSECURE_POLL=1
- EDGE_KEY=
- EDGE_ID=
- EDGE=1
restart: always
volumes:
- '/yourpathportainer/data:/data'
- '/:/host'
- '/var/lib/docker/volumes:/var/lib/docker/volumes'
- '/var/run/docker.sock:/var/run/docker.sock'
After deploying the stack, your secondary portainer should be active and should appear on your primary portainer. Look like this:
Continue to deploy and build Docker Portainer many more servers to benefit the future!