Re: Segfault on backsql_open_db_conn()

[BigSmoke <bigsmoke@gmail.com>]

On 2/5/06, Pierangelo Masarati <ando@sys-net.it> wrote:
> On Sat, 2006-02-04 at 21:02 +0100, BigSmoke wrote:
> > I can't get back_sql to work with a postgresql 8.1.0 backend through
> > odbc-postgresql 1:08.00.0102 and iodbc 3.52.3.
> >
> > I've tried it with the newest OpenLDAP in Debian testing (2.2.26) and
> > with the newest stable source release (2.3.19).
> >
> > The datasource is working fine with iodbctest.
> >
> > slapd -d 255 -4 gives me the following output at the end:
> > slapd startup: initiated.
> > backend_startup: starting "o=sql,c=RU"
> > ==>backsql_db_open(): testing RDBMS connection
> > backsql_db_open(): subtree search SQL condition not specified (use
> > "subtree_cond" directive in slapd.conf)
> > backsql_db_open(): setting "upper(ldap_entries.dn) LIKE upper('%'||?)"
> > as default
> > backsql_db_open(): setting "upper(ldap_entries.dn)=upper(?)" as default
> > backsql_db_open(): objectclass mapping SQL statement not specified
> > (use "oc_query" directive in slapd.conf)
> > backsql_db_open(): setting "SELECT
> > id,name,keytbl,keycol,create_proc,delete_proc,expect_return FROM
> > ldap_oc_mappings" by default
> > backsql_db_open(): attribute mapping SQL statement not specified (use
> > "at_query" directive in slapd.conf)
> > backsql_db_open(): setting "SELECT
> > name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_return,sel_expr_u
> > FROM ldap_attr_mappings WHERE oc_map_id=?" by default
> > backsql_db_open(): entry deletion SQL statement not specified (use
> > "delentry_query" directive in slapd.conf)
> > backsql_db_open(): setting "DELETE FROM ldap_entries WHERE id=?" by default
> > backsql_db_open(): objclasses deletion SQL statement not specified
> > (use "delobjclasses_query" directive in slapd.conf)
> > backsql_db_open(): setting "DELETE FROM ldap_entry_objclasses WHERE
> > entry_id=?" by default
> > backsql_db_open(): referrals deletion SQL statement not specified (use
> > "delreferrals_query" directive in slapd.conf)
> > backsql_db_open(): setting "DELETE FROM ldap_referrals WHERE
> > entry_id=?" by default
> > ==>backsql_get_db_conn()
> > ==>backsql_open_db_conn()
> > Segmentation fault
>
> A backtrace of this segfault would be much more useful than the rest you
> provided.  You should also keep that core around because we might need
> you to print some values or so.  Please file an ITS and follow
> guidelines at <http://www.openldap.org/faq/data/cache/56.html>.
>
> Ing. Pierangelo Masarati

I've followed the instructions in the FAQ. The issue has been assigned #4389.

A document which I also found useful in obtaining the necesasry
information is http://www.linuxfocus.org/English/July2004/article343.shtml.
You might want to link to that from
http://www.openldap.org/faq/data/cache/59.html.

Not having done anything in C(++) for years and not having done
anything serious in these languages ever, learning how to perform some
of the most basic debugging tasks was long overdue. Hopefully, in the
future my issue submissions will become more accurate.

Please let me know if you need any more information, or if you just
want to blow some steam about the nth clueless issue submission by nth
clueless user ;-)

Thanks for your time and your patience so far,

  - Rowan

--
Morality is usually taught by the immoral.