openldap连接mysql

import ldap
import mysql.connector

# 连接 OpenLDAP
ldap_conn = ldap.initialize('ldap://ldap.example.com')
ldap_conn.simple_bind_s('cn=admin,dc=example,dc=com', 'password')

# 连接 MySQL
mysql_conn = mysql.connector.connect(
    host='mysql.example.com',
    user='ldap_user',
    password='password',
    database='ldap_db'
)
mysql_cursor = mysql_conn.cursor()

# 查询 LDAP 数据并插入到 MySQL
ldap_search_scope = ldap.SCOPE_SUBTREE
ldap_search_filter = '(objectClass=person)'
ldap_search_base = 'ou=people,dc=example,dc=com'
ldap_attributes = ['uid', 'cn', 'mail']

ldap_conn.search_s(ldap_search_base, ldap_search_filter, ldap_search_scope, ldap_attributes)

for dn, entry in ldap_conn.response:
    insert_query = "INSERT INTO users (uid, cn, mail) VALUES (%s, %s, %s)"
    mysql_cursor.execute(insert_query, (entry['uid'][0], entry['cn'][0], entry['mail'][0]))

mysql_conn.commit()
mysql_cursor.close()
mysql_conn.close()
ldap_conn.unbind_s()