OpenLDAP/BackSQL

SQL Schema

cat << DDL | psql -U ${USER}
CREATE DATABASE openldap;
CREATE USER openldap WITH ENCRYPTED PASSWORD 'sadaqah!';
GRANT ALL PRIVILEGES ON DATABASE openldap TO openldap;
ALTER DATABASE openldap OWNER TO openldap;
DDL

SQL Backend

lxc launch ubuntu:24.04 openldap lxc list
cat <<'EXE' | lxc exec openldap -- bash apt-get update apt-get install -y unixodbc-dev build-essential libssl-dev libdb-dev libldap2-dev libpq-dev postgresql-client odbc-postgresql EXE
# fetch lxd bridge ip using ip address show command LXD_BRIDGE_IP="$(ip addr show lxdbr0 | awk '/inet / {print $2}' | cut -d '/' -f 1)" cat << EXE | lxc exec openldap -- bash echo "${LXD_BRIDGE_IP} host.lxd.internal"|tee -a /etc/hosts ping -c5 host.lxd.internal EXE
lxc exec openldap -- bash echo -n 'password: ';read -s PGPASSWORD;export PGPASSWORD;echo # password: sadaqah! psql -d openldap -U openldap -h host.lxd.internal
lxc snapshot openldap base:2.6.7	lxc publish openldap/base:2.6.7 --alias openldap/base:2.6.7	lxc restore openldap base:2.6.7

Playground

lxc image info ubuntu:noble --vm|yq .Aliases lxc image info ubuntu:24.04 --vm|yq .Aliases lxc image info ubuntu:noble |yq .Aliases lxc image info ubuntu:24.04 |yq .Aliases	lxc image list ubuntu: os=ubuntu release=noble type=virtual-machine lxc image list ubuntu: os=ubuntu release=noble type=virtual-machine lxc image list ubuntu: os=ubuntu release=noble type=container lxc image list ubuntu: os=ubuntu release=noble type=container
lxc image list ubuntu:24.04 lxc launch ubuntu:24.04 openldap lxc launch ubuntu:40d8df642812 openldap	lxc list status=running name=openldap --format=json |jq -r '.[].state.network.[].addresses' lxc list status=running name=openldap --format=yaml |yq -r '.[].state.network.[].addresses' lxc info openldap|yq '.Resources.["Network usage"][]["IP addresses"].inet'
systemctl list-dependencies graphical.target dpkg -l | grep 'gnome-shell-extension' apt list --installed|grep linux-image	lxc snapshot openldap base:2.6.7 lxc publish openldap/base:2.6.7 --alias openldap/base:2.6.7 lxc restore openldap base:2.6.7
cat <<-'EXE'|sudo bash umount /var/snap/firefox/common/host-hunspell snap remove firefox EXE	cat <<-'EXE'|sudo bash snap disable lxd snap remove --purge lxd EXE	systemctl list-dependencies --type=service --state=running systemctl list-dependencies --type=service --state=active systemctl list-dependencies docker.service systemctl list-dependencies --all
LXD_BRIDGE_IP="$(lxc network ls --format=json|jq -r '.[]|select(.name=="lxdbr0")|.config."ipv4.address"|split("/")[0]')"

References

LDAP » OID » Chorke, Org » Request LDAP » OID » Shahed, Inc » Request LDAP » OID » Chorke, Inc » Request LDAP » OID » Chorke, Org » 61820 LDAP » OID » Shahed, Inc » 61752 LDAP » OID » Chorke, Inc » 62865 LDAP » Schema Specification LDAP » Back SQL » Config LDAP » Back SQL LDAP » Config	LDAP » Manage & Use with OpenLDAP Utilities LDAP » Internet Assigned Numbers Authority LDAP » Build Docker Image from Ubuntu LDAP » 2.5.17 LTS Release Changes LDAP » MySQL Store & Fetch Data LDAP » Administrator's Guide LDAP » Clone phpLDAPadmin LDAP » Download
Ubuntu/Raspberry Pi Ubuntu Upgrade ActiveMQ Minikube Keycloak Hadoop Jenkins WildFly Spark MinIO	Alpine/Morefine Ruby on Rails TensorFlow Homebrew Linuxbrew PyEnv TMux 7Zip Zip Tar	Linux Service Creation Bash/Port/Forward Linux Mount Drive YouTube/Channel Bash/Network Bash/RAM Bash/CPU Bash/Port Bash Port
Private Enterprise Number Linux User Creation Linux Containers PostgreSQL IPTables MySQL CIDR UFW YQ JQ	Cloud Computing Cost Helm » PostgreSQL Benchmarks Helm