The table ldap_organizational unit is indeed not mentioned, it’s a simple table which just holds the names of organization units (just one, in my case), here’s the definition of our OpenERP database:

CREATE TABLE ldap_organizationalunit
(
id serial NOT NULL,
"name" character(255),
CONSTRAINT "ldap_organizationalUnit_pkey" PRIMARY KEY (id)
)


The errors about expect_return are likely to be specific to your install, as they get generated by the definition of the view ‘ldap_inetorgperson’which references the standard OpenERP table ‘res_partner_address’. That table may have different constraints in your install depending on what OpenERP modules you have installed. By the looks of it, there is a column expect_return which wants to have a value.

There are some typos in there. For one, after the CREATE TABLE statement for the ldap_organizationalUnit table there is a semicolon missing, leading to the syntax error.

Not sure about the error ‘schema a not found’you’ll have to dig around a bit to see what’s wrong there.

I think the main difference is I used the script inside openldap openldap-2.4.23/servers/slapd/back-sql/rdbms_depend/pgsql/backsql_create.sql which is slightly different from yours.

it seems to be the
WHERE
a.email ” AND
a.email ‘”‘ AND
a.type = ‘contact’;

So I have subsituted it to. I take it this just filters out all the records without an email address and not type contact?

WHERE
a.email IS NOT NULL AND
a.type = ‘contact’;

Hitting a new snag now. I install openldap with back-sql as per the instructions at http://www.darold.net/projects/ldap_pg/HOWTO/index.html

So now I am getting nativeErrCode=0 SQLengineState=IM002 msg=”[unixODBC][Driver Manager]Data source name not found, and no default driver specified”

When I run slad from the commandline.

any thoughts?

Woops typo spotted, now getting a bit further.

==>backsql_load_schema_map()
backsql_load_schema_map(): oc_query “SELECT id,name,keytbl,keycol,create_proc,delete_proc,expect_return FROM ldap_oc_mappings”
backsql_load_schema_map(): error executing oc_query:
Return code: -1
nativeErrCode=7 SQLengineState=S1000 msg=”ERROR: permission denied for relation ldap_oc_mappings;
Error while executing the query”

Sussed it. Dropped and recreated all db’s with correct user.

Here is my latest combined sql file. I am trying to create a all in one file to make this simpler;

drop table ldap_oc_mappings cascade;
drop sequence ldap_oc_mappings_id_seq;
create table ldap_oc_mappings
(
id serial not null primary key,
name varchar(64) not null,
keytbl varchar(64) not null,
keycol varchar(64) not null,
create_proc varchar(255),
delete_proc varchar(255),
expect_return int not null
);

drop table ldap_attr_mappings;
drop sequence ldap_attr_mappings_id_seq;
create table ldap_attr_mappings
(
id serial not null primary key,
oc_map_id integer not null references ldap_oc_mappings(id),
name varchar(255) not null,
sel_expr varchar(255) not null,
sel_expr_u varchar(255),
from_tbls varchar(255) not null,
join_where varchar(255),
add_proc varchar(255),
delete_proc varchar(255),
param_order int not null,
expect_return int not null
);

drop table ldap_entries;
drop sequence ldap_entries_id_seq;
create table ldap_entries
(
id serial not null primary key,
dn varchar(255) not null,
oc_map_id integer not null references ldap_oc_mappings(id),
parent int NOT NULL,
keyval int NOT NULL,
UNIQUE ( oc_map_id, keyval ),
UNIQUE ( dn )
);

drop table ldap_entry_objclasses;
create table ldap_entry_objclasses
(
entry_id integer not null references ldap_entries(id),
oc_name varchar(64)
);

INSERT INTO ldap_oc_mappings(name,keytbl,keycol,expect_return) VALUES(‘inetOrgPerson’,'ldap_inetOrgPerson’,'id’,0);

INSERT INTO ldap_oc_mappings(name,keytbl,keycol,expect_return) VALUES(‘organizationalUnit’,'ldap_organizationalUnit’,'id’,0);

/* DROP VIEW ldap_inetOrgPerson CASCADE; */
CREATE OR REPLACE VIEW ldap_inetorgperson AS
SELECT
a.id,
a.name as cn,
a.phone AS telephonenumber,
a.name AS sn,
a.name AS givenname,
a.fax AS facsimiletelephonenumber,
a.mobile,
a.phone AS homephone,
lower(a.email) AS mail,
a.street,
a.zip AS postalcode
FROM res_partner_address as a
WHERE
a.email IS NOT NULL AND
a.type = ‘contact’;

DROP TABLE ldap_organizationalUnit;
drop sequence ldap_organizationalUnit_id_seq;
CREATE TABLE ldap_organizationalUnit
(
id serial NOT NULL,
“name” character(255),
CONSTRAINT “ldap_organizationalUnit_pkey” PRIMARY KEY (id)
);

INSERT INTO ldap_organizationalUnit(name) VALUES (‘addressbook’);

INSERT INTO ldap_attr_mappings(oc_map_id,name,sel_expr,from_tbls,join_where,param_order,expect_return) VALUES(1,’telephoneNumber’,'telephoneNumber’,'ldap_inetOrgPerson’,’1=1′,3,0);

/* drop view ldap_entries;*/
CREATE OR REPLACE VIEW ldap_entries AS
SELECT
0 AS id,
‘ou=addressbook,dc=fbwgroup,dc=local’AS dn,
2 AS oc_map_id,
0 AS parent,
0 AS keyval
UNION
SELECT
ldap_inetorgperson.id,
(‘cn=’|| ldap_inetorgperson.cn) ||
‘,ou=addressbook,dc=fbwgroup,dc=local’AS dn,
1 AS oc_map_id,
0 AS parent,
ldap_inetorgperson.id AS keyval
FROM ldap_inetorgperson;

Output when I run the sql script;

NOTICE: drop cascades to constraint ldap_attr_mappings_oc_map_id_fkey on table ldap_attr_mappings
DROP TABLE
ERROR: sequence “ldap_oc_mappings_id_seq” does not exist
NOTICE: CREATE TABLE will create implicit sequence “ldap_oc_mappings_id_seq” for serial column “ldap_oc_mappings.id”
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index “ldap_oc_mappings_pkey” for table “ldap_oc_mappings”
CREATE TABLE
DROP TABLE
ERROR: sequence “ldap_attr_mappings_id_seq” does not exist
NOTICE: CREATE TABLE will create implicit sequence “ldap_attr_mappings_id_seq” for serial column “ldap_attr_mappings.id”
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index “ldap_attr_mappings_pkey” for table “ldap_attr_mappings”
CREATE TABLE
NOTICE: drop cascades to constraint ldap_entry_objclasses_entry_id_fkey on table ldap_entry_objclasses
DROP TABLE
ERROR: sequence “ldap_entries_id_seq” does not exist
NOTICE: CREATE TABLE will create implicit sequence “ldap_entries_id_seq” for serial column “ldap_entries.id”
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index “ldap_entries_pkey” for table “ldap_entries”
NOTICE: CREATE TABLE / UNIQUE will create implicit index “ldap_entries_oc_map_id_key” for table “ldap_entries”
NOTICE: CREATE TABLE / UNIQUE will create implicit index “ldap_entries_dn_key” for table “ldap_entries”
CREATE TABLE
DROP TABLE
CREATE TABLE
INSERT 0 1
INSERT 0 1
CREATE VIEW
DROP TABLE
ERROR: sequence “ldap_organizationalunit_id_seq” does not exist
NOTICE: CREATE TABLE will create implicit sequence “ldap_organizationalunit_id_seq” for serial column “ldap_organizationalunit.id”
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index “ldap_organizationalUnit_pkey” for table “ldap_organizationalunit”
CREATE TABLE
INSERT 0 1
INSERT 0 1
ERROR: “ldap_entries” is not a view