RE: OpenLDAP with MySQL backend not working

[masarati@aero.polimi.it]

> I have added the line you suggested and now I have "No database selected"
> mysql error
> I have run "isql -v MySQL ldap ldap" and it works...
>
> [root@server ~]# isql -v MySQL ldap ldap
> +---------------------------------------+
> | Connected!                            |
> |                                       |
> | sql-statement                         |
> | help [tablename]                      |
> | quit                                  |
> |                                       |
> +---------------------------------------+
>
> Somehow the dbname parameter is not transmited..
>
> ---
> ### the slapd -d -1 output
> ---
>
> <<< dnPrettyNormal: <dc=example,dc=com>, <dc=example,dc=com>
> <==backsql_dn2id("dc=example,dc=com"): err=0
> ==>backsql_id2entry()
> backsql_id2entry(): retrieving all attributes
> ==>backsql_get_attr_vals(): oc="organization" attr="o" keyval=1
> backsql_get_attr_vals(): error executing attribute count query 'SELECT
> COUNT(*) FROM institutes WHERE institutes.id=?'
> Return code: -1
>    nativeErrCode=1046 SQLengineState=3D000 msg="[unixODBC][MySQL][ODBC
> 3.51
> Driver][mysqld-5.0.77-log]No database selected"

To me this looks like either a RDBMS or an ODBC internal error.

p.