RE : problems with back-sql

["Emmanuel Duru" <emmanuel.duru@atosorigin.com>]

Hi,

Here are some corrections and remarks for ITS# 2639 to 2642.

- ITS#2639 : 
        - oracle : a simple correction consists to add
"has_ldap_info_dn_ru no" in the slapd.conf sample (that is what I have
done for my tests):
#######################################################################
# sql database definitions
#######################################################################
database	sql
suffix		"o=sql,c=RU"
rootdn		"cn=root,o=sql,c=RU"
rootpw		secret
dbname		ldap_ora8
dbuser		ldap
dbpasswd	ldap
subtree_cond	"UPPER(ldap_entries.dn) LIKE CONCAT('%',UPPER(?))"
insentry_query	"INSERT INTO ldap_entries
(id,dn,oc_map_id,parent,keyval) VALUES (ldap_entry_ids.nextval,?,?,?,?)"
upper_func	UPPER
has_ldap_info_dn_ru no
        - mysql : add the definition of the sel_expr_u column in the
ldap_attr_mappings table definition, in backsql_create.sql :
create table ldap_attr_mappings
 (
	id integer unsigned not null primary key auto_increment,
	oc_map_id integer unsigned not null references
ldap_oc_mappings(id),
	name varchar(255) not null,
	sel_expr varchar(255) not null,
	sel_expr_u varchar(255) not null,
	from_tbls varchar(255) not null,
	join_where varchar(255),
	add_proc varchar(255),
	delete_proc varchar(255),
	param_order tinyint not null,
	expect_return tinyint not null
);
- ITS#2640 : tested, OK.
- ITS#2641 : I think this is the same kind of problem as ITS#2568
(SQLBindParameter + SQLExecDirect instead of SQLPrepare +
SQLBindParameter + SQLExecute). This problem occurs several times in the
code, I need some time to fix them all.
- ITS#2642 :  tested, OK, though another problem occurs later in
backsql_count_children(), in the call to backsql_bindRowAsStrings() (I
have to investigate this problem more).

-----Message d'origine-----
De : Pierangelo Masarati [mailto:ando@sys-net.it] 
Envoyé : mardi 15 juillet 2003 10:09
À : emmanuel.duru@atosorigin.com
Cc : openldap-bugs@openldap.org
Objet : problems with back-sql


Dear Emmanuel,

I appreciate your trace activity in back-sql;
however, since I have no possibility to test
it with Oracle, I would appreciate if you
could send patches for all the ITS you opened;
I'll blindly apply them after basic review,
and solicit feedback from other users as a
cross-check.

Thanks, Pierangelo.


-- 
Pierangelo Masarati
mailto:pierangelo.masarati@sys-net.it