You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by GitBox <gi...@apache.org> on 2022/01/17 10:15:17 UTC
[GitHub] [pinot] mr-agrwal opened a new issue #8031: Pinot JDBC does not support pinot authentication
mr-agrwal opened a new issue #8031:
URL: https://github.com/apache/pinot/issues/8031
When trying to connect to pinot using jdbc client, after passing username/password details we are still getting 403.
Steps to setup test pinot cluster with auth to test
```
./bin/pinot-admin.sh AuthQuickStart -type batch
```
Code for jdbc client
```
@Bean
public DataSource pinotDatabase(PinotConfig pinotConfig) {
Map<String, PinotClientProperties> clients = pinotConfig.getClients();
Optional<PinotClientProperties> client = clients.values().stream().findFirst();
String host;
if (client.isPresent()) {
host = String.format("jdbc:pinot://%s:%s", client.get().getHosts().get(0), client.get().getPort());
} else {
throw new DataLabException(false,
"Unable to find cluster name configured under key 'pinot.clients' in application.yml.");
}
DriverManagerDataSource dataSource = new DriverManagerDataSource();
dataSource.setUrl(host);
dataSource.setDriverClassName("org.apache.pinot.client.PinotDriver");
dataSource.setUsername("secret");
dataSource.setPassword("verysecret");
return dataSource;
}
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[GitHub] [pinot] kbastani edited a comment on issue #8031: Pinot JDBC does not support pinot authentication
Posted by GitBox <gi...@apache.org>.
kbastani edited a comment on issue #8031:
URL: https://github.com/apache/pinot/issues/8031#issuecomment-1015825289
@mr-agrwal Here is a workaround until @KKcorps implements basic authorization in the JDBC spec. Authorization headers are only supported in the latest snapshot and will not work in the 0.9.3 release or earlier.
See the new docs section for JDBC authentication:
https://docs.pinot.apache.org/users/clients/java#authentication
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[GitHub] [pinot] kbastani edited a comment on issue #8031: Pinot JDBC does not support pinot authentication
Posted by GitBox <gi...@apache.org>.
kbastani edited a comment on issue #8031:
URL: https://github.com/apache/pinot/issues/8031#issuecomment-1015825289
@mr-agrwal Here is a workaround until @KKcorps implements basic authorization in the JDBC spec. See the new docs section for JDBC authentication:
https://docs.pinot.apache.org/users/clients/java#authentication
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[GitHub] [pinot] kbastani commented on issue #8031: Pinot JDBC does not support pinot authentication
Posted by GitBox <gi...@apache.org>.
kbastani commented on issue #8031:
URL: https://github.com/apache/pinot/issues/8031#issuecomment-1015825289
@mr-agrwal Here is a workaround until @KKcorps implements basic authorization in the JDBC spec. See the new docs section for JDBC authentication:
https://github.com/kbastani/order-delivery-microservice-example/blob/5232fb4b60e3e62b28041746dfea7e2ce60c9c2c/debezium-mysql-connector-order-outbox.json#L25
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[GitHub] [pinot] KKcorps commented on issue #8031: Pinot JDBC does not support pinot authentication
Posted by GitBox <gi...@apache.org>.
KKcorps commented on issue #8031:
URL: https://github.com/apache/pinot/issues/8031#issuecomment-1014354565
Taking this up.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org