Run in Docker

[matheus-souza]

How to use Docker and passing only the data from the database?

[npetzall]

Docker is just running the application in an isolated environment, it also helps control dependencies (Java, graphviz). So when you run the image(create a container) it will need to connect to the database the same way the normal Java application would.

The hub docker page has some instructions. But if you let me know what database you want to spy on. I could assist you in the commandline used and update the documentation.

[matheus-souza]

It is a PostgreSQL database

[npetzall]

Then the drivers are included.

So something like docker run -v "$Pwd/output:/output" schemaspy/schemaspy:snapshot [same options as you would provide for the jar except for -dp and -o]

Only tricky thing is, if you want to spy a db running locally on your computer, then you must use a public ip doesn't work with localhost or 127.0.0.1 since it will be trapped in the container unless network-mode host is used with docker.

[matheus-souza]

I'm having trouble with your connection:
ERROR - Connection error:
org.postgresql.util.PSQLException: FATAL: database "mydbase" does not exist

Failed to connect to database URL [jdbc:postgresql://myserver/mydbase]

But if I connect via the terminal I have access on this basis

Command executed:

docker run -v "$Pwd/output:/output" schemaspy/schemaspy:snapshot -t pgsql -db mydbase -host myserver -port myport -u user -p password

[matheus-souza]

I found the problem, because when I connect without informing the port it was able to resolve the connection

[matheus-souza]

How can I resolve the WARN error - /output/main.js (Permission denied)?

Occurs when I run the jar

I solved creating a folder and giving 777 permission to it and using it as volume

Final command:

docker run -v $PWD/output:/output schemaspy/schemaspy:snapshot -t pgsql -db mydbase -host myserver -u myuser -p mypassword

[npetzall]

The port thing is related to #109.

I've added the write-thing for the output mount to documentation on hub.docker.

Anything else you feel missing in the documentation? I want to improve it, but to me (wrote it) it seems crystal clear =)

[rafalkasa]

@matheus-souza do you have any other questions ? What you think should I close this issue ?

[matheus-souza]

I think should close the problem