No relationships image created

[fhintsch]

I use the schemaSpy 7.0.0 snapshot docker image. It runs without any errors. But it doesn't produce any images.

Expected Behavior

Should produce a meaningful content in relationships.html

Current Behavior

relationships.html shows:

SchemaSpy was unable to generate diagram(s) of table relationships.
Check application output for details.

In the application output no problems could be seen:

Using drivers:jtds-1.3.1.jar			, mariadb-java-client-1.1.10.jar
mysql-connector-java-8.0.28.jar, postgresql-42.3.8.jar
  ____       _                          ____
 / ___|  ___| |__   ___ _ __ ___   __ _/ ___| _ __  _   _
 \___ \ / __| '_ \ / _ \ '_ ` _ \ / _` \___ \| '_ \| | | |
  ___) | (__| | | |  __/ | | | | | (_| |___) | |_) | |_| |
 |____/ \___|_| |_|\___|_| |_| |_|\__,_|____/| .__/ \__, |
                                             |_|    |___/

                                              7.0.0-SNAPSHOT

SchemaSpy generates an HTML representation of a database schema's relationships.
SchemaSpy comes with ABSOLUTELY NO WARRANTY.
SchemaSpy is free software and can be redistributed under the conditions of LGPL version 3 or later.
http://www.gnu.org/licenses/

INFO  - Running SchemaSpy 7.0.0-SNAPSHOT with Java(Eclipse Adoptium) 17.0.9 PID 1 [Linux, 6.5.11-linuxkit, aarch64, /usr/local/lib/schemaspy/schemaspy-app.jar] started by java in /
INFO  - Found default configuration file: schemaspy.properties
INFO  - Starting schema analysis
INFO  - Connected to MySQL - 8.0.35-0ubuntu0.22.04.1
INFO  - Collecting schema information from database
...........................
INFO  - Collection of schema information finished after 0 seconds
INFO  - Connecting tables and views
...........................
INFO  - Tables and views connected after 0 seconds
INFO  - Graphviz renderer set to ':cairo'
INFO  - Writing/graphing summaries
......
INFO  - Summaries created after 0 seconds
INFO  - Writing routines pages
INFO  - Wrote 0 routines pages in 0 seconds
INFO  - Creating table/view pages
...........................
INFO  - Created table/view pages after 1 seconds
INFO  - View the results by opening /output/index.html
INFO  - Wrote relationship details of 27 tables/view to directory '/output' in 3 seconds

Possible Solution

Steps to Reproduce (for bugs)

Context

• Database type (e.g. MySQL): Mysql
• Database driver version (is you use a special one): what's in the docker image: mysql-connector-java-8.0.28.jar
• Your DDL (sample how to reproduce the issue):
• Full command including arguments how you run SchemaSpy: docker run -v xxx/schemaSpy/schemaspy.properties:/schemaspy.properties schemaspy/schemaspy:snapshot

Your Environment

• Version used:
• Environment name and version (e.g. Chrome 39):
• Operating System and version (e.g. Windows 10): macOS 14.2.1 (Apple M2 chip)
• Java version: see docker 7.0.0-Snapshot

[npetzall]

1, Are there images when you look at a table? Want to figure out if any images are created by Graphviz. If there's an issue with graphviz, vizjs can be used with -vizjs which is a javascript port of Graphviz.
2, Summaries was really quick. Do you know what type of application is using the database. Since base most of the information on metadata, do you know if the database contains primary and foreign keys. But we also do implied where we match name and type of columns to find possible relationships. Depending on the framework used in the application the name and type might not match an example would be a rails application.

[fhintsch]

ad 1) I attach the output-dir.

ad 2) I am the author of the application that uses the database.
out.zip

[npetzall]

Yepp, there is some kind of bug here. Diagrams are generated they are just not included in the html.

out.zip/diagrams/ is full of diagrams.

Will investigate.

[npetzall]

However the out.zip supplied is generated with SchemaSpy 6.1.0 and not 7.0.0-SNAPSHOT as per the footer in the report.

I've tested now with snapshot and it works. This is Mac Book Air M1 so with the arm64 image.

If the full command is whats reported above you've forgotten to mount the /output folder.

[fhintsch]

You are right.
It was wrong to set the output option inside the properties file... :-(
And: I should not use DNS names from the local network inside the properties file!

[fhintsch]

Many thanks for your help