SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    Perl/Mason Guru Flawless_koder's Avatar
    Join Date
    Feb 2002
    Location
    Gatwick, UK
    Posts
    1,206
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    LDAP - SQL structure of db

    I've just finished (finally!) setting up openLDAP
    to work with a Postgres backend. I can tell you -
    it took some work!

    Now it's up, and i've used an example db schema - and tested it - i'd like to move on to a real schema - but can't find any diagrams / notes on how they should be set up.

    I can ( and in the meanwhile probably will ) use the template of the way the example was structured - and
    base my design off of that - but i was wandering if anyone else had done an sql ldap backend and had notes
    on how best to structure it in terms of table relations, whether normalization should be used extensively (it is in the example) and how functions
    should operate.

    Thanks

    Flawless
    ---=| If you're going to buy a pet - get a Shetland Giraffe |=---

  2. #2
    SitePoint Addict EvilDoppler's Avatar
    Join Date
    Dec 2001
    Location
    Perth, Australia
    Posts
    217
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    duh - you know nuffin!!!

    hehehehe..sorry mate..can't help you there!!

    oO{thought to at least give you a reply in here and get things going}
    Last edited by EvilDoppler; May 28, 2002 at 07:04.
    * Due to the last tax raise our prices has risen
    * - answers w/o thought $1 - answers w/ thought $3
    * - correct answers $10
    * - Dumb stares are still free

  3. #3
    Database Jedi MattR's Avatar
    Join Date
    Jan 2001
    Location
    buried in the database shell (Washington, DC)
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you could attach the schema it would be useful. Although I guess it's a typical tree-type representation which is fairly simple:
    node( name, left_child, right_child ) -- unless it is more than a binary tree

  4. #4
    Perl/Mason Guru Flawless_koder's Avatar
    Join Date
    Feb 2002
    Location
    Gatwick, UK
    Posts
    1,206
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Actually it's gone a bit wierd.
    It works fine - but it also forsakes the rules of LDAP

    I'm not too sure why it's doing this... but i basically can go outside the scope of an objectClass by using a representation to the parent that i need.

    It's all working fine under that scheme, for once!

    thanks for you time though Matt


    Flawless
    ---=| If you're going to buy a pet - get a Shetland Giraffe |=---


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •