could it support the es x-pack basic-authentication?

matthewfranglen / postgres-elasticsearch-fdw

Postgres to Elastic Search Foreign Data Wrapper

MIT License

108 stars 32 forks source link

could it support the es x-pack basic-authentication? #9

Closed yasz closed 4 years ago

yasz commented 4 years ago

Thank you very much！

matthewfranglen commented 4 years ago

Hey,

Thanks for the suggestion. I'll have a look into this and see if I can enable it.

matthewfranglen commented 4 years ago

I've released a new version that has basic auth support via the username and password options on table creation. I've added a test for this using es 6 (as the docker container for that can start with authentication enabled), and it passes so I am reasonably sure this works.

This has been released as version 0.7.4. It would be great if you could test if this works.

If this does not work with your setup please provide detailed instructions regarding how to reproduce your environment - ideally via a dockerfile that will launch elasticsearch with your configuration.

matthewfranglen commented 4 years ago

I think this is resolved. Please let me know if it is not.

playerla commented 1 month ago

Hi, seems not to work : https://github.com/matthewfranglen/postgres-elasticsearch-fdw/blob/576ccd30598ff110fcc7d6f67e5b6fcd12af8926/pg_es_fdw/options.py#L52 use Basic Auth but it's only exist in ES8 https://discuss.elastic.co/t/basic-authentication-not-working-via-python-client/301435 (https://elasticsearch-py.readthedocs.io/en/v7.17.1/api.html#elasticsearch)

bw-matthew commented 1 month ago

Opened https://github.com/matthewfranglen/postgres-elasticsearch-fdw/issues/42 to track that. This did work for version 6!