Skip to main content

November 2026

Every post published in November 2026, newest first. Pick a day to jump straight to it.

Posts
802
Topics
75
Reading time
91 h
Active days
15

Posts 781–802 of 802 · November 2–3, 2026

Page 27 of 27

Tuesday, November 3, 2026

1 of 91 posts

  1. Fixed: "[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate" in Python on macOS

    A Python script on macOS failed to open an HTTPS address with ssl.SSLCertVerificationError: CERTIFICATE_VERIFY_FAILED, unable to get local issuer certificate, while curl opened it fine. Python from python.org uses its own OpenSSL without the Mac's certificates; its Install Certificates script fixes it. Shown on Python 3.15.2.

Monday, November 2, 2026

21 posts

  1. How to Connect a .NET C# Web API to a MySQL Database — Part 1: Connect with EF Core and a Secure Connection String

    Connect an ASP.NET Core minimal Web API in .NET 10 and C# to MySQL 9.7 with EF Core 10 and Oracle's MySql.EntityFrameworkCore provider. Install the packages, write the DbContext, keep the connection string in user-secrets, require TLS, retry short outages and prove the connection with a readiness health check, then watch the same connection from inside MySQL.

  2. How to Add Liveness and Readiness Health Checks to a .NET C# Web API

    Add /health/live and /health/ready endpoints to an ASP.NET Core minimal API in .NET 10 and C#: AddHealthChecks, MapHealthChecks, tags and predicates, and an EF Core database check with AddDbContextCheck. See the real 200 and 503 answers when the database goes down and comes back.

  3. How to Store a Connection String in .NET C# with dotnet user-secrets

    Keep a database connection string and its password out of appsettings.json and out of Git with .NET's Secret Manager: dotnet user-secrets init, set, list, remove and clear, where the secrets file lives, why it's read in Development only, and how the same setting reaches the app as an environment variable everywhere else.

  4. How to Create a .NET C# Web API Solution with a Class Library

    Create a production-ready .NET 10 C# solution from the command line: an .slnx solution, global.json, shared build rules in Directory.Build.props, central package management, an ASP.NET Core minimal Web API project and a class library that it references. Includes the two errors the strict settings raise on the template, and how to fix them.

  5. How to Stop, Start and Remove Docker Compose Containers Without Losing Data

    Learn which Docker Compose commands keep your data and which one deletes it: docker compose stop, start, down and up keep a database's named volume, while down -v removes it. Shown live with MySQL 9.7, including proof the data survived.

  6. How to Check if a MySQL Connection Uses TLS

    Check whether your MySQL connection is encrypted with the status command and the Ssl_cipher and Ssl_version session variables, understand why a Unix socket shows SSL Not in use, make the mysql client require TLS with --ssl-mode=REQUIRED, and check an application's connection in the Performance Schema. Real output from MySQL 9.7.

  7. How to Check the MySQL Character Set and Collation

    Check the character set and collation of your MySQL server, database and connection, understand what utf8mb4 and utf8mb4_0900_ai_ci mean, and see real proof of accent- and case-insensitive comparisons in MySQL 9.7. Includes the latin1 surprise in Docker's mysql client.

  8. How to Check the MySQL Version

    Five ways to see exactly which MySQL version you run: SELECT VERSION(), the client's welcome banner, SHOW VARIABLES LIKE 'version%', the status command, and mysqld --version without signing in. Plus why a Docker image tag isn't the exact version. Real output from MySQL 9.7.4.

  9. How to Connect to MySQL in a Docker Container with the mysql Client

    Open the mysql command-line client that ships inside the official MySQL Docker image with docker compose exec, sign in safely, run your first queries, run a single query or a whole .sql file without staying in, and leave. No MySQL install on your computer. Real output from MySQL 9.7.

  10. How to Run MySQL in Docker with Docker Compose

    Run MySQL 9.7 LTS on any computer with Docker Desktop: one compose.yaml with a named data volume, a health check, a port only your own computer can reach, and passwords kept in a .env file. Every line explained, with real output from the first start.

  11. How to Keep Passwords Out of compose.yaml with an .env File

    Keep database passwords out of compose.yaml and out of Git: reference them as ${VARIABLE} with :? so Docker Compose refuses to start without them, store the real values in a git-ignored .env file, and commit a safe .env.example instead. Real output from Docker Compose v5.

  12. How to Generate a Strong Random Password in the Terminal

    Generate a cryptographically random password with one command, using openssl rand -hex on macOS and Linux and .NET's RandomNumberGenerator in Windows PowerShell, and write it straight into a .env file without it ever appearing on screen.

  13. How to Add a .gitignore to a .NET C# Project

    Create Microsoft's ready-made .gitignore for .NET and C# with dotnet new gitignore, see what it keeps out of Git (bin, obj, .vs, .env and more), and prove a file is ignored with git check-ignore and git status --ignored. Real output from .NET 10.

  14. How to Create a Git Repository and Make Your First Commit

    Turn any project folder into a Git repository with git init -b main, then stage and commit your files with git add and git commit, step by step, with real output on Git 2.56 and the same commands for macOS, Linux and Windows.

  15. Fixed: Git Shows Every Line Changed in Files from dotnet new (CRLF Line Endings)

    A small change to a .NET project file showed up in Git as every line changed. The dotnet new Web API template ships Windows CRLF line endings, even on macOS, and dotnet commands rewrite files with LF. A .gitattributes file with * text=auto and git add --renormalize fixes it for good.

  16. Fixed: error CA1852: Type 'WeatherForecast' can be sealed because it has no subtypes in its containing assembly and is not externally visible

    A brand-new .NET 10 Web API failed to build with error CA1852 on the template's WeatherForecast record, once the recommended analysis rules and TreatWarningsAsErrors were on. Mark the type sealed, as Microsoft's rule page says, and the build succeeds.

  17. Fixed: warning Unable to find a project to restore!

    dotnet restore printed warning Unable to find a project to restore! in a .NET 10 solution folder, because the .slnx solution didn't list any projects yet. Restore the project by its path, or add the projects to the solution with dotnet sln add and restore again.

  18. Fixed: error NU1008: The following PackageReference items cannot define a value for Version

    dotnet new webapi failed its restore with error NU1008 in a .NET 10 solution that uses central package management, because the template writes the package version into the project file. Move the version to Directory.Packages.props, remove it from the PackageReference, and restore again.

  19. Fixed: Warning 1287: 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release

    SHOW PROCESSLIST in MySQL 9.7 answered with 1 warning, and SHOW WARNINGS revealed Warning 1287: 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated. Query performance_schema.processlist instead: the same connections, no warning, and a server setting isn't needed.

  20. Fixed: "ERROR 1045 (28000): Access denied for user 'inventory_app'@'localhost' (using password: YES)" in a MySQL Docker Container

    I changed MYSQL_PASSWORD in .env, recreated my MySQL 9.7 container with Docker Compose, and the new password was rejected. The official image only applies its MYSQL_* settings on the very first start. Here is how I proved it and fixed it with ALTER USER without losing any data.

  21. Fixed: Accented Letters Disappear When Typed into the mysql Client in a Docker Container

    I typed SELECT 'café' into the mysql client inside the official MySQL 9.7 Docker container and got 'caf': the é never arrived. The container has no locale set. Passing -e LANG=C.utf8 to docker compose exec fixes typing and switches the client to utf8mb4.