adminer | Database management in REDAXO | Collaboration library

My code is as follows:

I created a Spring Boot application which uses a MySQL database. I use a docker-compose to launch the database.

Good day, coders!

Im using Win 10 with wsl2. Trying to build development environment in modern way with Docker for Windows. Im using nginx, php:fpm, mariadb, adminer. All is working fine, exept debuger. And i just dont undersand why. I even see it from my local machine!

Here is my docker-compose file, mysql.yml:

I can confirm docker container is running:

trying to use custom configuration file in docker-compose mysql 8. The docker-compose.yml looks like

I need your advice. What is the best way, from an opsec-perspective, when sharing an LE wildcard certificates between several web-services on the same host?

• On my domain I have an auto-renewed LE wildcard cert (containerized)
  • The folder holding the certificates is mapped to a host folder, owned by LE-user:LE-group and has 700 privileges assigned
• All sub-domains are pointing to web-services on the same host (all containerized)
• All publicly accessible services are handled by an Nginx reverse proxy (containerized) and thus they are all LE SSL encrypted downstream
• The admin services (portainer, adminer, cockpit, etc.) are only accessible from the LAN and are all protected by strong and unique passwords

I want to protect the above-mentioned admin-services with the LE wildcard cert as I am tired of having to confirm that I "accept the risk" because they are using self-signed certs, but I'm in doubt what is the best way to achieve this. So far I see three possible ways around it, all having their own drawbacks:

1. Create a script executed by a cron-job that copy the LE certificate to the various admin-services cert-folders whenever the cert is renewed.
   • Drawback: The script would need to be run with root privileges
2. Allow the admin-services to access the cert in the host-mapped folder.
   • Drawback: I would need 704 access to the LE Cert folder or 740 and add all admin-sevice-users to the LE group
3. Serve the admin-services through the reverse proxy, enable TOTP protection and restrict access to the public IP of the server.
   • Drawback: If I mess something up or there is a zero-day exploid in my Nginx or TOTP installation, the admin-services are publicly accessible

Which of the above mentioned solutions do you see as the "best-practice" solution from a opsec perspective or would you suggest a completely different solution that I haven't thought about?

Many thanks in advance!

I'm working on automation script to use variable from one yaml and replace in another yaml.

Requirement: i should load the yaml1 and create variables, and use those as variables in yaml2. I'm able to to create variables but not able to get logic for replace those obtained variables in yaml2. please help.

Sample yaml1

variable.yaml

How to view Recent Order from Magento 2.2.6 through Adminer as Our admin URL is not working. Can we run some query to view recent orders and their address ?

Please suggest a query to find out recent orders through Order ID.

I have no database skills to run a complex query.

Thanks in Advance!