taivokasper / docker-omnidb Goto Github PK

Hello @taivokasper

I discovered that alpine has a CVE problem described here:

https://www.zdnet.com/article/alpine-linux-docker-images-ship-a-root-account-with-no-password/

It seems that latest version of alpine are now protected against this threat.
I see on docker hub that the image was rebuild 18 days ago, but I cannot find if the alpine version was already OK at that date!

Do you think an image rebuilt is needed?

Thomas

Hello
I'm trying to use your setup docker omnidb but some errors occured.

Step 1: [ok]
docker pull taivokasper/omnidb

Step 2: [Failed]
docker run -it --rm -p 8080:8080 taivokasper/omnidb

/usr/local/lib/python3.5/dist-packages/psycopg2/__init__.py:144: UserWarning: The psycopg2 wheel package will be renamed from release 2.8; in order to keep installing from binary please use "pip install psycopg2-binary" instead. For details see: <http://initd.org/psycopg/docs/install.html#binary-install-from-pypi>.
  """)
Starting OmniDB server...
Checking port availability...
Starting server at port 8080.
User database version 2.4.1 is already matching server version.
Press Ctrl+C to exit.
[07/06/2018 13:49:23] ERROR [OmniDB_app.QueryServer:360] *** Exception ***
Traceback (most recent call last):
  File "/opt/OmniDB-2.4.1/OmniDB/OmniDB/ws_core.py", line 356, in start_wsserver
    server.listen(settings.OMNIDB_PORT)
  File "/usr/local/lib/python3.5/dist-packages/tornado/tcpserver.py", line 145, in listen
    self.add_sockets(sockets)
  File "/usr/local/lib/python3.5/dist-packages/tornado/tcpserver.py", line 159, in add_sockets
    sock, self._handle_connection)
  File "/usr/local/lib/python3.5/dist-packages/tornado/netutil.py", line 219, in add_accept_handler
    io_loop = IOLoop.current()
  File "/usr/local/lib/python3.5/dist-packages/tornado/ioloop.py", line 283, in current
    loop = asyncio.get_event_loop()
  File "/usr/lib/python3.5/asyncio/events.py", line 671, in get_event_loop
    return get_event_loop_policy().get_event_loop()
  File "/usr/lib/python3.5/asyncio/events.py", line 583, in get_event_loop
    % threading.current_thread().name)
RuntimeError: There is no current event loop in thread 'Thread-1'.

Service exposed on port 8080 but not working.
Any ideas ?

Hello,

First of all, I am really a beginer with Docker, however, I do have some containers running via docker-compose, behind Traefik reverse proxy with Google OAuth. I am trying to run OmniDB instead an already functioning PHPMyAdmin container, but I get a permission denied when running the command with volume mount for config persistance. Without the volume mount, the container starts succesfully.

`cosmin@server:~$ docker run -it --rm -v /home/cosmin/docker/omnidb:/etc/omnidb -p 127.0.0.1:8080:8080 -p 127.0.0.1:25482:25482 taivokasper/omnidb
Unable to find image 'taivokasper/omnidb:latest' locally
latest: Pulling from taivokasper/omnidb
e6b0cf9c0882: Already exists
72d79304a186: Pull complete
Digest: sha256:2589bd9925fe30f1368c5269e87082cad122a74255242d298e5077b61144d33f
Status: Downloaded newer image for taivokasper/omnidb:latest
Traceback (most recent call last):
File "omnidb-server.py", line 70, in
import OmniDB.runtime_settings
File "/opt/OmniDB-2.17.0/OmniDB/OmniDB/runtime_settings.py", line 20, in
shutil.copyfile(os.path.join(BASE_DIR, 'omnidb.conf'), CONFFILE)
File "/usr/lib/python3.8/shutil.py", line 259, in copyfile
with open(src, 'rb') as fsrc, open(dst, 'wb') as fdst:
PermissionError: [Errno 13] Permission denied: '/etc/omnidb/omnidb.conf'

Same issue also in docker compose. I have the relevant section like this:

omnidb:
image: taivokasper/omnidb
container_name: omnidb
hostname: omnidb
ports:
- 9090:8080
- 25482:25482
volumes:
- ${USERDIR}/docker/omnidb:/etc/omnidb
networks:
- traefik_proxy
- default
labels:
traefik.enable: "true"
traefik.backend: omnidb
traefik.protocol: http
traefik.port: 8080
traefik.frontend.rule: Host:test.${DOMAINNAME}
traefik.frontend.headers.SSLHost: test.${DOMAINNAME}
traefik.docker.network: traefik_proxy
traefik.frontend.passHostHeader: "true"
traefik.frontend.headers.SSLForceHost: "true"
traefik.frontend.headers.SSLRedirect: "true"
traefik.frontend.headers.browserXSSFilter: "true"
traefik.frontend.headers.contentTypeNosniff: "true"
traefik.frontend.headers.forceSTSHeader: "true"
traefik.frontend.headers.STSSeconds: 315360000
traefik.frontend.headers.STSIncludeSubdomains: "true"
traefik.frontend.headers.STSPreload: "true"
traefik.frontend.headers.customResponseHeaders: X-Robots-Tag:noindex,nofollow,nosnippet,noarchive,notranslate,noimageindex
traefik.frontend.headers.customFrameOptionsValue: 'allow-from https:${DOMAINNAME}'
traefik.frontend.auth.forward.address: "http://oauth:4181"
traefik.frontend.auth.forward.authResponseHeaders: X-Forwarded-User
traefik.frontend.auth.forward.trustForwardHeader: "true"

I tried in compose file with PUID=${PUID} and PGID=${PGID} also, as environment entries, but no go.
`

Hi, can the web version be used with sqlite ?

[12/02/2021 18:23:40] ERROR [django.request:224] Internal Server Error: /get_tree_info_mariadb/
Traceback (most recent call last):
File "/usr/lib/python3.8/site-packages/django/core/handlers/exception.py", line 47, in inner
response = get_response(request)
File "/usr/lib/python3.8/site-packages/django/core/handlers/base.py", line 181, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/opt/OmniDB-3.0.3b/OmniDB/OmniDB_app/views/memory_objects.py", line 46, in wrap
return function(request, *args, **kwargs)
File "/opt/OmniDB-3.0.3b/OmniDB/OmniDB_app/views/memory_objects.py", line 96, in wrap
return function(request, v_database, *args, **kwargs)
TypeError: get_tree_info() takes 1 positional argument but 2 were given

any help to fix?

Hi,

I try ur Docker file to manage my Oracle Database and there's an error message

Plis ur help, i want to try this amazing management in my oracle's databases~

Hello,
Im deploying Omnidb with kubernetes,
i cant find the right service/ingress configuration to establish the websocket connection.
the current configs are :
-service with port 25482 and 80 as a targetPort
-an ingress targeting that service
but still when inspect the navigator, the url that's being invoked to establish the websocket connection is attached with the port 25482 instead of 80
im using nginx as ingress controller,
any help would be relly appreciated!