Re: back-sql

[Marcio Scheibler <mds@smail.ufsm.br>]

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
=====================================================================