MYSQL preview metadata issue / question

[happy-machine]

Hello Legends, your work is changing lives, thank you

Maybe a bit optimistic but we tried to connect to a remote MYSQL genomics database and got the following error:

graphql-engine_1  | Connected to MySQL!
graphql-engine_1  | {"path":"$","error":"Cannot use database previously used with a newer version of graphql-engine (expected a catalog version <=37, but the current version is 47).","code":"not-supported"}

Which suggests someone had previously created a metadata table on the target database, but we are connecting using the example docker-compose which setups up a local db for the metadata table, does this error mean anything to you guys?

[seanonthenet]

Not sure about this. But is your version of graphql-engine up to date?
try with image: hasura/graphql-engine:v2.6.0 in your docker compose file.

[happy-machine]

the image is the one in the current preview docs

if i run hasura/graphql-engine:v2.6.0 MYSQL-preview (Invalid option `--mysql-host')

@GavinRay97 pointed out i should try doing docker-compose down -v, which solved the error but now i can't connect to the port hasura is supposedly published on (8080 according to the file and logs):

postgres_1        | 2022-05-24 09:18:42.717 UTC [67] LOG:  database system was shut down at 2022-05-24 09:18:42 UTC
postgres_1        | 2022-05-24 09:18:42.726 UTC [1] LOG:  database system is ready to accept connections
graphql-engine_1  | {"type":"startup","timestamp":"2022-05-24T09:18:43.377+0000","level":"info","detail":{"kind":"server_configuration","info":{"live_query_options":{"batch_size":100,"refetch_delay":1},"transaction_isolation":"ISOLATION LEVEL READ COMMITTED","plan_cache_options":{"plan_cache_size":4000},"enabled_log_types":["http-log","websocket-log","startup","webhook-log","query-log"],"server_host":"HostAny","enable_allowlist":false,"log_level":"info","auth_hook_mode":null,"use_prepared_statements":true,"unauth_role":null,"stringify_numeric_types":false,"enabled_apis":["metadata","graphql","config","pgdump","developer"],"enable_telemetry":true,"enable_console":true,"auth_hook":null,"jwt_secret":null,"cors_config":{"allowed_origins":"*","disabled":false,"ws_read_cookie":null},"console_assets_dir":null,"admin_secret_set":false,"port":8080}}}
graphql-engine_1  | {"type":"startup","timestamp":"2022-05-24T09:18:43.377+0000","level":"info","detail":{"kind":"postgres_connection","info":{"retries":1,"database_url":"postgres://postgres:...
[@postgres](https://twitter.com/postgres)
:5432/postgres"}}}

[seanonthenet]

Can you share your docker-compose file?

[happy-machine]

Sure, these creds are for a public db so i've left them in just in case the db itself is related, thanks Sean

version: '3.6'
services:
  postgres:
    image: postgres:12
    restart: always
    volumes:
    - db_data:/var/lib/postgresql/data
    environment:
      POSTGRES_PASSWORD: postgrespassword
  graphql-engine:
    image: hasura/graphql-engine:pull5655-633f084f
    ports:
    - "8080:8080"
    depends_on:
    - "postgres"
    command:
    - graphql-engine
    - --mysql-host
    - ensembldb.ensembl.org
    - --mysql-user
    - anonymous
    - --mysql-port
    - "3306"
    - --mysql-dbname
    - ensembl_compara_104
    - --mysql-password
    - ""
    - serve
    restart: always
    environment:
      HASURA_GRAPHQL_DATABASE_URL: postgres://postgres:postgrespassword@postgres:5432/postgres
      ## enable the console served by server
      HASURA_GRAPHQL_ENABLE_CONSOLE: "true" # set to "false" to disable console
      ## enable debugging mode. It is recommended to disable this in production
      HASURA_GRAPHQL_DEV_MODE: "true"
      HASURA_GRAPHQL_ENABLED_LOG_TYPES: startup, http-log, webhook-log, websocket-log, query-log
      ## uncomment next line to set an admin secret
      # HASURA_GRAPHQL_ADMIN_SECRET: myadminsecretkey
volumes:
  db_data:

[seanonthenet]

Maybe if you try change your HASURA_GRAPHQL_DATABASE_URL env var to HASURA_GRAPHQL_METADATA_DATABASE_URL (documentation) so that Hasura doesn't try to save metadata documentation on that connected mySQL database.

And then remove the mysql stuff from your Hasura start command and in console add the mySQL database source using the Connect Database UI flow like this (you can do this also with an environment variable later but this way for now might be easier)

Hopefully this will make Hasura not try to save any metadata on that target data source.

[happy-machine]

Hey

This image when i remove the commands (and use that env variable) gives me:

Expecting all database connection params (host, port, user, dbname, password) or database-url (HASURA_GRAPHQL_DATABASE_URL)

[seanonthenet]

So I've been playing around with the docker compose file and it does seem like a different build which doesn't have the new support for HASURA_GRAPHQL_METADATA_DATABASE_URL

I have managed to get it spun up but haven't been able to connect to console.

Testing some other things...

[happy-machine]

Thanks for your help Sean you're a star!

[happy-machine]

@seanonthenet did you get anywhere with this?