Skip to content

2.0.7 — the console says what it needs

Choose a tag to compare

@srmadscience srmadscience released this 27 Aug 07:53
· 7 commits to main since this release

Generates Oracle DAO, SOAP and MCP server code from a config file. This is the source drop for
2.0.7; the running article is the container image.

docker pull ghcr.io/srmadscience/mcpdbwizard:2.0.7

What is new in 2.0.7

A console release. Nothing in the generator, a generated server or the proxy changed — the tools
your configs publish are identical to 2.0.6. What changed is what the console tells you when
something is not configured.

The setup instructions now show a command that works. The documented docker run had no Oracle
settings and pointed at another page for them, which held a bare -e fragment with no command
around it. Following either produced a console that starts, passes its healthcheck, and refuses
every Design page. The minimum is now the whole command.

"Oracle is not configured" names the password. It listed host, SID and user and said nothing
about DB_PASS, so an operator who set exactly the three things they were told to set got a login
failure — which reads as a wrong password rather than as one nobody asked for.

Start-up warns once per missing variable, each line naming the variable, what it is for and an
example, so a line can be read on its own:

WARN  Oracle is not configured: 4 required setting(s) are not set.
WARN    MCPDBWIZARD_ORACLE_HOST is not set - the database host, e.g. db.example.com
WARN    MCPDBWIZARD_ORACLE_SID is not set - the SID, or /SERVICE for a pluggable database, e.g. /FREEPDB1
WARN    MCPDBWIZARD_ORACLE_USER is not set - the Oracle account to connect as
WARN    DB_PASS is not set - the password for that account, or DB_PASS_FILE naming a file that holds it

Admin → Audit stops understating what it protects. The page said flatly that the write-ahead
spool is not encrypted. It has been optional since 2.0.5 — set MCP_AUDIT_SPOOL_KEY and it is
AES-256-GCM — and the page now reports what your deployment actually does.

What this repository is

The generator, its runtime library, the MCP emitter and a database-free test suite that passes on a
clean checkout. No test schema ships. You point it at your own Oracle database;
Scripts/check_provisioning.sh will tell you which objects a config expects.
examples/generated-output/ holds 107 generated .java files so you can see what the generator
emits without an Oracle instance to hand.

Honest limits

The image is not signed — no cosign or Sigstore signature, so nothing here identifies the
publisher. It carries a BuildKit provenance record and an SPDX SBOM, both self-attested by the same
party that publishes the image: useful for what is in it, not evidence of who built it.

Known issues, with a workaround for each: https://mcpdbwizard.com/docs/known-issues/