That's a great suggestion, but I don't see anything that looks like a likely replacement for dbname and no mention of the term sql anywhere (for that matter there's not much mention of hdb or bdb either). The output is attached, if the list permits attachments that is... Many thanks Alan -----Original Message----- From: Howard Chu [mailto:hyc@symas.com] Sent: Friday, January 31, 2014 3:30 PM To: Robson, Alan; openldap-technical@openldap.org Subject: Re: slapd.d and back-sql Robson, Alan wrote: > Hi all, > > I'm trying to set up back-sql on Ubuntu using openldap version 2.4.39 > that uses slapd.d as its configuration store. > > All of the config examples I can find online use slapd.conf. A 2011 > email from this mailing list explains that it simply is not possible > to use the slapd.d config method to specify a dbname. Is that still the case ? Read the schema. ldapsearch -b cn=schema,cn=config -s base [and whatever authentication you need] | grep -i sql > > I am trying to add an entry for my mysql database using ldapadd and > the following ldif... > > # order value not present so entry will be appended > > # to current children > > dn: olcDatabase=sql,cn=config > > objectClass: olcDatabaseConfig > > olcDatabase: mysql > > dbName: ldap > > olcSuffix: dc=nodomain > > The response I get is... > > adding new entry "olcDatabase=sql,cn=config" > > ldap_add: Undefined attribute type (17) > > additional info: dbName: attribute type undefined > > I tried dbname (no capital N) as well, but I get the same result. > > As you may be able to tell, I have a very loose grip on what to do > here ! I'd appreciate some guidance. I am confident that I have odbc > and the database/user set up as it describes in the manual section on > back-sql. My database connection is called "ldap" in odbc.ini. > > /etc/odbcinst.ini: > > [mysql] > > Description = ODBC for MySQL > > Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so > > Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so > > FileUsage = 1 > > /etc/odbc.ini: > > [ldap] > > Description = MySQL connection to 'test' database > > Driver = mysql > > Database = ldap > > UserName = ldap > > Password = ldap > > Server = localhost > > Port = 3306 > > Socket = /var/run/mysqld/mysqld.sock > > If I need to go back to using slapd.conf, how can I generate one from > my slapd.d setup ? > > Many thanks > > Alan > -- -- Howard Chu CTO, Symas Corp. https://urldefense.proofpoint.com/v1/url?u=http://www.symas.com/&k=OWT%2FB14AE7ysJN06F7d2nQ%3D%3D%0A&r=OzuJgNYWNrY%2F3yqABVDsLpgwbUfST3hTZUuwDEyrkFA%3D%0A&m=pZT55Sh2jVIGfJdtY1iQoMHJqdY2G3tzbomIXC9g26A%3D%0A&s=a4ed2640564585aaac2fc447fe28896485d31293a3258b9e3eb6795c33da2a93 Director, Highland Sun https://urldefense.proofpoint.com/v1/url?u=http://highlandsun.com/hyc/&k=OWT%2FB14AE7ysJN06F7d2nQ%3D%3D%0A&r=OzuJgNYWNrY%2F3yqABVDsLpgwbUfST3hTZUuwDEyrkFA%3D%0A&m=pZT55Sh2jVIGfJdtY1iQoMHJqdY2G3tzbomIXC9g26A%3D%0A&s=03aea5954b08fcfb86d43081c58c0a888199d1da69a1411f76cc05e78db5a145 Chief Architect, OpenLDAP https://urldefense.proofpoint.com/v1/url?u=http://www.openldap.org/project/&k=OWT%2FB14AE7ysJN06F7d2nQ%3D%3D%0A&r=OzuJgNYWNrY%2F3yqABVDsLpgwbUfST3hTZUuwDEyrkFA%3D%0A&m=pZT55Sh2jVIGfJdtY1iQoMHJqdY2G3tzbomIXC9g26A%3D%0A&s=58d878698b14eb6ed0aacf6dd4c18ebf9a11efebfb82674ece7d66b25f0e8225
Attachment:
base.ldif
Description: base.ldif