[problem]
Whilst working on the automatic production of web statistics – came across the following problem:
“How do I get relational data from an Hierarchical structure?”
[/problem]
[solution]
It didn’t take long to realize – I’d have to use PHP to talk to LDAP, pull off records & upload into a series of tables, using the cn as primary key. Which then could be queried relationally. Pulling off large, queries and repeatedly transcending LDAP trees is pretty slow – so I built my LDAP to SQL engine, by flattening dns into table names. Then used PHP scripts to query produce
daily snap shots.
This is the Perl port of the PHP version. Requires some setting up on db side, but invaluable once implemented.
Perl LDAP to SQL – Traverses LDAP trees and spits out SQL:
Now on github
Please leave a comment if you want help with this.
[/solution]
If you have found my website useful, please consider buying me a coffee below 😉