1.在Kubernetes集群上安装Altinity operator,并在spec中添加以下内容,并进行相应修改:
config:
ldap:
enabled: true
url: "ldap://ldap.mydomain.local:389"
baseDn: "OU=Users,DC=mydomain,DC=local"
bindDn: "CN=Operator,OU=ServiceAccounts,DC=mydomain,DC=local"
bindPassword:
valueFrom:
secretKeyRef:
name: operator-secrets
key: ldap-bind-password
userSearchFilter: "(sAMAccountName={0})"
kubectl create secret generic operator-secrets --from-literal="ldap-bind-password="
CREATE ROLE "ldap_readonly" NOT EXTERNAL TO LDAP
SETTINGS
(
ldap_server='ldap://ldap.mydomain.local:389',
ldap_search_base='OU=Users,DC=mydomain,DC=local',
ldap_bind_dn='CN=ClickHouse-Operator,OU=ServiceAccounts,DC=mydomain,DC=local',
ldap_bind_password='',
ldap_user_filter='(sAMAccountName={0})',
ldap_group_filter='',
ldap_group_attribute='memberOf',
ldap_group_is_dn=false,
ldap_credentials_query='',
ldap_use_tls=false,
ldap_tls_options='no_cert_check=1',
ldap_timeout=30
)
GRANT SELECT ON *.*
TO user 'ldap_readonly';