Results 1 to 2 of 2

Thread: need help configuring Openldap with mysql database

  1. #1

    need help configuring Openldap with mysql database

    Morning All,

    So I have successfully installed and configured openldap with BerkeleyDB on Fedora 8. I have been for the past couple a months trying without success to configure it with MySQL. I have loaded the backsql files, configured the odbc.ini and odbcinst.init files and have configured slapd.conf. When I run /etc/init/d/ldap start it says [ok] but when I check the status it says [stopped]. when I run /etc/init.d/ldap retart it says [failed]. Below is a sample of the slapd.conf file I configured. I could really use the help cause I need this to be up and running, thanks.

    # See slapd.conf(5) for details on configuration options.
    # This file should NOT be world readable.
    #
    include /etc/openldap/schema/core.schema
    include /etc/openldap/schema/cosine.schema
    include /etc/openldap/schema/inetorgperson.schema
    include /etc/openldap/schema/nis.schema
    include /etc/openldap/schema/misc.schema

    # Allow LDAPv2 client connections. This is NOT the default.
    allow bind_v2

    # Do not enable referrals until AFTER you have a working directory
    # service AND an understanding of referrals.
    #referral ldap://root.openldap.org

    pidfile /var/run/openldap/slapd.pid
    argsfile /var/run/openldap/slapd.args

    # Load dynamic backend modules:
    modulepath /usr/lib64/openldap
    # moduleload accesslog.la
    # moduleload auditlog.la
    moduleload back_sql.la
    # moduleload denyop.la
    # moduleload dyngroup.la
    # moduleload dynlist.la
    # moduleload lastmod.la
    # moduleload pcache.la
    # moduleload ppolicy.la
    # moduleload refint.la
    # moduleload retcode.la
    # moduleload rwm.la
    # moduleload syncprov.la
    # moduleload translucent.la
    # moduleload unique.la
    # moduleload valsort.la

    # The next three lines allow use of TLS for encrypting connections using a
    # dummy test certificate which you can generate by changing to
    # /etc/pki/tls/certs, running "make slapd.pem", and fixing permissions on
    # slapd.pem so that the ldap user or group can read it. Your client software
    # may balk at self-signed certificates, however.
    # TLSCACertificateFile /etc/pki/tls/certs/ca-bundle.crt
    # TLSCertificateFile /etc/pki/tls/certs/slapd.pem
    # TLSCertificateKeyFile /etc/pki/tls/certs/slapd.pem

    # Sample security restrictions
    # Require integrity protection (prevent hijacking)
    # Require 112-bit (3DES or better) encryption for updates
    # Require 63-bit encryption for simple bind
    # security ssf=1 update_ssf=112 simple_bind=64

    # Sample access control policy:
    # Root DSE: allow anyone to read it
    # Subschema (sub)entry DSE: allow anyone to read it
    # Other DSEs:
    # Allow self write access
    # Allow authenticated users read access
    # Allow anonymous users to authenticate
    # Directives needed to implement policy:
    # access to dn.base="" by * read
    # access to dn.base="cn=Subschema" by * read
    # access to *
    # by self write
    # by users read
    # by anonymous auth
    #
    # if no access controls are present, the default policy
    # allows anyone and everyone to read anything but restricts
    # updates to rootdn. (e.g., "access to * by * read")
    #
    # rootdn can always read and write EVERYTHING!

    ################################################## #####################
    # ldbm and/or bdb database definitions
    ################################################## #####################

    #database bdb
    #suffix "dc=my-domain,dc=com"
    #rootdn "cn=Manager,dc=my-domain,dc=com"
    # Cleartext passwords, especially for the rootdn, should
    # be avoided. See slappasswd(8) and slapd.conf(5) for details.
    # Use of strong authentication encouraged.
    # rootpw secret
    # rootpw {crypt}ijFYNcSNctBYg

    # The database directory MUST exist prior to running slapd AND
    # should only be accessible by the slapd and slap tools.
    # Mode 700 recommended.
    #directory /var/lib/ldap

    # Indices to maintain for this database
    #index objectClass eq,pres
    #index ou,cn,mail,surname,givenname eq,pres,sub
    #index uidNumber,gidNumber,loginShell eq,pres
    #index uid,memberUid eq,pres,sub
    #index nisMapName,nisMapEntry eq,pres,sub

    # Replicas of this database
    #replogfile /var/lib/ldap/openldap-master-replog
    #replica host=ldap-1.example.com:389 starttls=critical
    # bindmethod=sasl saslmech=GSSAPI
    # authcId=host/ldap-master.example.com@EXAMPLE.COM

    database sql
    suffix "dc=my-domain,dc=com"
    rootdn "cn=manager,dc=my-domain,dc=com"
    rootpw secret
    dbname ldapdb
    dbuser dbUser
    dbpasswd dataB.01
    subtree_cond "ldap_entries.dn LIKE CONCAT('%',?)"
    insentry_query "INSERT INTO ldap_entries (dn,oc_map_id,parent,keval) VALUES (?,?,?,?)"
    has_ldapinfo_dn_ru no

    I have ran this config with and without "directory /var/lib/ldap" commented out as I have seen some configs with it commented out.

    Thanks.

    ryswick.

  2. #2
    Administrator Advisor peter's Avatar
    Join Date
    Apr 2004
    Posts
    882
    What error messages do you see in the /var/log/messages file? They should lead you in the right direction.

    Make sure syslog is logging at the debug level so that you can see all possible error messages.

Similar Threads

  1. Automated MySQL Database backup Script-on timely basis
    By linuxdepro in forum Linux - General Topics
    Replies: 2
    Last Post: 10-28-2013, 09:22 AM
  2. MySQL database user creation help needed
    By Compunuts in forum Linux - Software, Applications & Programming
    Replies: 2
    Last Post: 05-24-2006, 06:48 AM
  3. moving database from its default directory where mysql puts on new databases
    By infinite_root in forum Linux - Hardware, Networking & Security
    Replies: 2
    Last Post: 05-15-2004, 11:52 PM
  4. MySQL database creation error
    By Compunuts in forum Linux - Hardware, Networking & Security
    Replies: 6
    Last Post: 10-24-2003, 06:09 AM
  5. Iptables logging to MySql database
    By xkill in forum Linux - Software, Applications & Programming
    Replies: 1
    Last Post: 02-11-2002, 07:45 PM

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
  •