HTTPS protocol for embedded version

[usatenko]

Please add https version of embedded version http://loader.tabix.io/master.js

[eocron]

still not added

[Slach]

yep, i tried new http://dash.tabix.io
and it still doesn't support HTTPS

[isublimity]

Try https://beta.tabix.io/?

[Slach]

I mean https schema in connection URL

got error

Error: Can`t fetch version server,check connection URL/DNS/Host:PORT, open in browser:http://https://github.demo.trial.altinity.cloud:8443

[isublimity]

! github.demo.trial.altinity.cloud - USE READONLY USER !
! Readonly user not support in Tabix !

Tabix first send query if query false tabix can`t connect, please check on console

 curl "https://__HOST__:__SSL_PORT__/?output_format_json_quote_denormals=1&output_format_json_quote_64bit_integers=1&log_queries=1&enable_http_compression=1&add_http_cors_header=1&result_overflow_mode=throw&timeout_overflow_mode=throw&max_execution_time=10&max_result_rows=90000&max_result_bytes=10000000&user=_XXXX_&password=_XXXX_&query=SELECT%20version()%20as%20version"

replace:
https://__HOST__:_SSL_PORT__/? and &user=_XXXX_&password=_XXXX_

Then open browser: https://__HOST__:_SSL_PORT__/ - need response OK!

[Slach]

changed to not readonly user

got

Code: 452. DB::Exception: Setting max_execution_time should not be changed. (SETTING_CONSTRAINT_VIOLATION)

maybe, allow readonly restriction is not so bad idea?

[isublimity]

tabix use special parameters, if not set cannot work normally.

Like this:

      output_format_json_quote_denormals: 1,
      output_format_json_quote_64bit_integers: 1,

Full list setting by request:

      output_format_json_quote_denormals: 1,
      output_format_json_quote_64bit_integers: 1,
      log_queries: 1,
      enable_http_compression: 1,
      add_http_cors_header: 1,
      result_overflow_mode: 'throw', // break
      timeout_overflow_mode: 'throw',
      max_execution_time: 10,
      max_result_rows: 90000,
      max_result_bytes: 10000000,

I m try add "readOnly" mode, but without json_quote can some error on render

[isublimity]

Try i`m update http://dash.tabix.io - support ssl & readOnly