CiviCRM Community Forums (archive)

Hi there

Following this: http://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+LDAP+Integration#CiviCRMLDAPIntegration-ConfigureOpenLDAP

When I create the ldap_entries view in MySQL civicrm database, it says the civicrm_individual table does not exist. But the other civicrm tables do exist. Is there something I need to do within CiviCRM before the civicrm_individual table is created?

ERROR 1146 (42S02): Table 'civicrm.civicrm_individual' doesn't exist

CREATE
    VIEW ldap_entries AS
SELECT
    civicrm_individual.contact_id                                AS id,
    ucase(concat('contactID=',civicrm_contact.id,',ou=civicrm')) AS dn,
    1                                                            AS oc_map_id,
    0                                                            AS parent,
    civicrm_individual.id                                        AS keyval
FROM
    (civicrm_individual
JOIN
    civicrm_contact
    ON
    (
        (
            civicrm_individual.contact_id = civicrm_contact.id
        )
    )
    )
UNION
SELECT
    civicrm_organization.contact_id                              AS id,
    ucase(concat('contactID=',civicrm_contact.id,',ou=civicrm')) AS dn,
    2                                                            AS oc_map_id,
    0                                                            AS parent,
    civicrm_organization.id                                      AS id
FROM
    (civicrm_organization
JOIN
    civicrm_contact
    ON
    (
        (
            civicrm_organization.contact_id = civicrm_contact.id
        )
    )
    );
Is the civicrm_contact table similar to the civicrm_individual table?

Are you sure? At the top of that wiki page it says:

This documentation refers to CiviCRM 3.1, current stable version

This is the version I have. If the document is outdated, does anyone know where I can find more info on OpenLDAP integration?

Thanks I'll have a look around to see what else I can find on the net