Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to connect to clickhouse #253

Open
Hua777 opened this issue Oct 24, 2022 · 11 comments
Open

Unable to connect to clickhouse #253

Hua777 opened this issue Oct 24, 2022 · 11 comments

Comments

@Hua777
Copy link

Hua777 commented Oct 24, 2022

Version

Tabix version: Tabix ©2022 Version: 22.05.25 is last
ClickHouse version: 21.8.15.1

Error

I got this error always:

image
image

Step URL returns

  1. http://url:8123/

OK.

  1. http://url:8123/?user=xxxxx&password=xxxxx&query=SELECT%20version()%20as%20version%20FORMAT%20JSON
{
	"meta":
	[
		{
			"name": "version",
			"type": "String"
		}
	],

	"data":
	[
		{
			"version": "21.8.15.1"
		}
	],

	"rows": 1,

	"statistics":
	{
		"elapsed": 0.000170965,
		"rows_read": 1,
		"bytes_read": 1
	}
}
  1. http://url:8123/?add_http_cors_header=1&user=xxxxx&password=xxxxx&query=SELECT%20version()%20as%20version%20FORMAT%20JSON
{
	"meta":
	[
		{
			"name": "version",
			"type": "String"
		}
	],

	"data":
	[
		{
			"version": "21.8.15.1"
		}
	],

	"rows": 1,

	"statistics":
	{
		"elapsed": 0.000103174,
		"rows_read": 1,
		"bytes_read": 1
	}
}
  1. http://url:8123/?max_result_rows=123&add_http_cors_header=1&user=xxxxx&password=xxxxx&query=SELECT%20version()%20as%20version%20FORMAT%20JSON
{
	"meta":
	[
		{
			"name": "version",
			"type": "String"
		}
	],

	"data":
	[
		{
			"version": "21.8.15.1"
		}
	],

	"rows": 1,

	"statistics":
	{
		"elapsed": 0.000097852,
		"rows_read": 1,
		"bytes_read": 1
	}
}

Other Information

None

@RapidCodeLab
Copy link

having absolutely same problems, both on http://dash.tabix.io/ and self installed version

@isublimity
Copy link
Contributor

isublimity commented Oct 30, 2022

having absolutely same problems, both on http://dash.tabix.io/ and self installed version

Version is "version": "21.8.15.1" ?

@Hua777
Copy link
Author

Hua777 commented Nov 4, 2022

having absolutely same problems, both on http://dash.tabix.io/ and self installed version

Version is "version": "21.8.15.1" ?

I use http://dash.tabix.io/ is okay. Only self installed has this problem.

@RapidCodeLab
Copy link

having absolutely same problems, both on http://dash.tabix.io/ and self installed version

Version is "version": "21.8.15.1" ?

nope, on my side version is "version": "22.6.9.11"

@isublimity
Copy link
Contributor

try open console for more information, what error write?

Снимок экрана 2022-11-15 в 09 37 03

@isublimity
Copy link
Contributor

I think problem in parameter add_http_cors_header

@isublimity
Copy link
Contributor

 /// Add CORS header if 'add_http_cors_header' setting is turned on send * in Access-Control-Allow-Origin
    /// Note that whether the header is added is determined by the settings, and we can only get the user settings after authentication.
    /// Once the authentication fails, the header can't be added.
    if (settings.add_http_cors_header && !request.get("Origin", "").empty() && !config.has("http_options_response"))
        used_output.out->addHeaderCORS(true);

@isublimity
Copy link
Contributor

@isublimity
Copy link
Contributor

If you use 21.X, < 22.10 send me console.log

@sherlockwhite
Copy link

try open console for more information, what error write?

Снимок экрана 2022-11-15 в 09 37 03

I am using clickhouse version 23.6.2.18, and I have the same problem as the picture, how to solve it?

@sherlockwhite
Copy link

Is tabix not available now?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants