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

Incorrect data formatted with ClickHouse Import #8374

Closed
lucaderi opened this issue May 3, 2024 · 3 comments
Closed

Incorrect data formatted with ClickHouse Import #8374

lucaderi opened this issue May 3, 2024 · 3 comments

Comments

@lucaderi
Copy link
Member

lucaderi commented May 3, 2024

When ClickHouse Cloud is used there are a few changes that have to be taken into account

  • the MySQL connection is encrypted over TLS (on prem is not encrypted)
  • the clickhouse-client connection is also encrypted over TLS (on prem is not encrypted)
  • the username/pwd that inserts data (clickhouse-client) is different from the username/pwd that reads data via MySQL

These changes need to be supported and we need to make sure that ntopng is able to use out-of-the-box ClickHouse Cloud. Please create a demo account and publish both on ntopng manuals and the ntop blog, on how to use it.

@lucaderi
Copy link
Member Author

lucaderi commented May 7, 2024

Note that in "ntopng -h" there is no indication how to use ClickHouse over TLS. This must be fixed and documented in manuals.

@lucaderi
Copy link
Member Author

lucaderi commented May 9, 2024

There are import errors when used with the cloud
Screenshot 2024-05-09 at 09 20 02

@lucaderi lucaderi added Not Yet Working and removed Ready to Test a feedback is needed on a proposal or implementation labels May 9, 2024
@MatteoBiscosi MatteoBiscosi changed the title Implement ClickHouse Cloud Support Incorrect data formatted with ClickHouse Import May 9, 2024
@NicoMaio NicoMaio removed their assignment May 14, 2024
@MatteoBiscosi
Copy link
Member

Closing for inactivity, in case the issue is back reopen the ticket

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

No branches or pull requests

3 participants