(Answer) (Category) OpenLDAP Faq-O-Matic : (Category) OpenLDAP Software FAQ : (Category) Configuration : (Category) SLAPD Configuration : (Category) Backends : (Category) The SQL backend (How do I setup/configure back-sql?) : (Answer) Help in supporting other RDBMS is welcome
To provide support for a new RDBMS:
  • make sure you're using HEAD code, or the latest release (currently, 2.3 as of June 2005);
  • make sure the RDBMS can be set up using the ODBC library slapd was compiled with
  • make sure the test data in servers/slapd/back-sql/rdbms_depend/<rdbms>/ is lined up with that of pgsql, which is the current reference RDBMS; if the directory doesn't exist, create it using the files in servers/slapd/back-sql/rdbms_depend/pgsql/ as guidelines;
  • make sure (most of) the tests in the test suite can be run (at least the read-only ones, with numbers less than 900);
  • for write tests, you may need to add the <rdbms> in the related tests/scripts/sql-test<name> file to enable the new RDBMS;
  • if any, note the required tweaks in slapd.conf, and add them to the relevant configuration files in tests/data/slapd-sql*.conf as
            #<rdbms>#<directive>
    
    for example, pgsql requires
            #pgsql#concat_pattern   "?||?"
    
    You may omit the #<rdbms># prefix if the directive is of general usefulness and does not impact the other RDBMSes;

Provide a patch with the new files and the changes to the existing ones, obtained using "diff -u" against HEAD code, thru the ITS.
ando@sys-net.it

[Append to This Answer]
Previous: (Answer) PostgreSQL
Next: (Answer) Need back-sql support for free?
This document is: http://www.openldap.org/faq/index.cgi?file=1238
[Search] [Appearance]
This is a Faq-O-Matic 2.721.test.
© Copyright 1998-2013, OpenLDAP Foundation, info@OpenLDAP.org