Exasol-Docker

rodrigogargiulo
Contributor

https://github.com/EXASOL/docker-db

https://hub.docker.com/r/exasol/docker-db 

 

Good Morning,

I have a question about exasol in docker, I have managed to launch a separate exasol container by following the GitHub steps, but I don't know exactly how to use it I have tried several ways and I have not succeeded, I appreciate the help.

 

Greetings and thanks

1 ACCEPTED SOLUTION

Accepted Solutions

exa-Torsten
Team Exasol
Team Exasol

That explains it. Start your docker-db like that

docker run --name exasoldb -p 0.0.0.0:9563:8563 --detach --privileged --stop-timeout 120 exasol/docker-db:<version>

This means the database port is bound to all IP addresses of the virtual machine and not only 127.0.0.1. With that the port is then reachable from outside of the virtual machine. Next, make sure that the port 9563 of the virtual machine is available from your host. Then connect to the IP of your virtual machine (which the host sees) from the SQL Client on the host. You might need to configure port forwarding between or bridge network between your virtual machine and the host.

View solution in original post

11 REPLIES 11

exa-Torsten
Team Exasol
Team Exasol

Hi @rodrigogargiulo ,

Did you forward the ports for the database as described on Github like that

$ docker run --name exasoldb -p 127.0.0.1:9563:8563 --detach --privileged --stop-timeout 120 exasol/docker-db:<version>

If you have done that, you should be able to connect via your favorite Exasol client to the following address  127.0.0.1:9563. If you need also the BucketFS, you need to forward its port, too. For that, please check the following section in the Github repo https://github.com/exasol/docker-db#connecting-to-bucketfs.

Depending on your use case, we also provide to abstraction which simplify the usage of the docker-db a bit. Both projects are meant to be used for testing and not for production.

The integration-test-docker-environment provides a command line on top of the docker-db.

The exasol-testcontainers can be used in Java JUnit tests.

rodrigogargiulo
Contributor

Do I connect via a database?

exa-Torsten
Team Exasol
Team Exasol

Hi @rodrigogargiulo,

you connect via a client. For example, you can use DBeaver, DBVisualizer or DataGrip as graphical SQL Client. Please, visit our documentation for more information about the SQL Clients.

If you want to access the database programmatically you can use JDBC (Java), pyexasol (Python) or r-exasol (R). Please, visit our documentation about the drivers.

rodrigogargiulo
Contributor

Thanks, and , What would be the credentials to make the connection?

exa-Torsten
Team Exasol
Team Exasol

If not configured differently, you can use the following:

user: sys

password: exasol

For more details, have a look at https://github.com/exasol/docker-db#connecting-to-the-database

rodrigogargiulo
Contributor

I have tried to connect but I get this error message

exa-Torsten
Team Exasol
Team Exasol

Hi @rodrigogargiulo ,

 

the docker-db needs a few minutes to start. SO, maybe wait 5 minutes and then try to connect. And, if it then still doesn't work, can you send me the whole output of

docker logs exasoldb

rodrigogargiulo
Contributor

the same error, here is the log

exa-Torsten
Team Exasol
Team Exasol

The log at least look good. The database is up and running. Did you start your SQL Client on the same physical machine or virtual machine as the docker-db?