Re: back-sql

[David White <davet@mutronics.co.uk>]

Hi Marcio

I've checked the odbc setup, and I can pull data into excel and other  
applications without a problem.
Ldap is talking to the the odbc driver, but seems to be generating  
queries containing a '?' as below, which mysql does not like.

Regards

David

On 14 Oct 2005, at 14:16, Marcio Scheibler wrote:

> Talking as a general level (I have never used Mac OS X)...
> Have you tested your ODBC setup through some tool
> like iSQL ??
>
> David White escreveu:
>
> > Hi All
> > I've compiled openldap on mac-osx 10.4 with back-sql, and I'm  
> > trying  to talk to a mysql database.
> > I'm using the test files, and I've come across a number of problems.
> > The first was that a field called sel_expr_u appeared to be  
> > missing  from the ldap_attr_mappings table, which was an easy fix,
> > The second is that no searches appear to be working.
> > When I try ldapsearch -x -b 'o=sql,c=RU' 'objectclass=*'
> > I get the following:
> > # extended LDIF
> > #
> > # LDAPv3
> > # base <o=sql,c=RU> with scope sub
> > # filter: objectclass=*
> > # requesting: ALL
> > #
> > # search result
> > search: 2
> > result: 0 Success
> > # numResponses: 1
> > The SELECT query going to the database appears to be:
> > SELECT DISTINCT ldap_entries.id,persons.id,'inetOrgPerson' AS   
> > objectClass,ldap_entries.dn AS dn FROM ldap_entries,persons WHERE   
> > persons.id=ldap_entries.keyval AND ldap_entries.oc_map_id=? AND   
> > ldap_entries.dn LIKE ? AND 1=1
> > from slapd in debug mode
> > and:
> > Thu Oct 13 12:08:47 2005.77117  ENTER atmysqlExecDirect 0x184a200   
> > SELECT DISTINCT ldap_entries.id,persons.id,'inetOrgPerson' AS   
> > objectClass,ldap_entries.dn AS dn FROM ldap_entries,persons WHERE   
> > persons.id=ldap_entries.keyval AND ldap_entries.oc_map_id=? AND   
> > ldap_entries.dn LIKE ? AND 1=1 -3
> > Thu Oct 13 12:08:47 2005.77300  --> expanded query: SELECT  
> > DISTINCT  ldap_entries.id,persons.id,'inetOrgPerson' AS   
> > objectClass,ldap_entries.dn AS dn FROM ldap_entries,persons WHERE   
> > persons.id=ldap_entries.keyval AND ldap_entries.oc_map_id=NULL  
> > AND  ldap_entries.dn LIKE NULL AND 1=1
> > Thu Oct 13 12:08:47 2005.78218  EXIT atmysqlExecDirect 0x184a200   
> > SELECT DISTINCT ldap_entries.id,persons.id,'inetOrgPerson' AS   
> > objectClass,ldap_entries.dn AS dn FROM ldap_entries,persons WHERE   
> > persons.id=ldap_entries.keyval AND ldap_entries.oc_map_id=? AND   
> > ldap_entries.dn LIKE ? AND 1=1 -3: 0
> >  From the ODBC driver.
> > The slap.conf file is taken from the samples folder, and  
> > everything  has been setup as described in the install info.
> > Any help, pointers you could give me would be very much appreciated.
> > Thanks
> > David
> > --------------------------------------------------------------------- 
> > ---
> > David White
> > Engineer & Producer
> > www.audio.org.uk
> > The time that we waste playing with computers is exponential to  
> > the  time they save us.
> > This email is confidential, if you have received it in error  
> > please  delete it and inform the sender. Thank you.
>
>
> --
> ---------------------------------------------------------------------
> Marcio Scheibler
> UFSM - CPD - Divisao de Suporte
> =====================================================================

------------------------------------------------------------------------
David White
Engineer & Producer
www.audio.org.uk

The time that we waste playing with computers is exponential to the  
time they save us.

This email is confidential, if you have received it in error please  
delete it and inform the sender. Thank you.