Re: Permission denied while opening odbcinst.ini

["Dieter Kluenter" <dieter@dkluenter.de>]

"Andreas Backman" <abackman@gmail.com> writes:

> Hi all!
> I'm trying to configure an OpenLDAP server with a mySQL server as back-end.
> This is what happens when i try to start the server.
>
> root@ldap:~# slapd -d1
> ---------
> backsql_open_db_handle(): SQLConnect() to database "MySQL" failed.
> Return code: -1
>    nativeErrCode=0 SQLengineState=IM002 msg="[unixODBC][Driver Manager]Data
> source name not found, and no default driver specified"
[...]
> Contents of my odbc.ini and odbcinst.ini:
>
> odbc.ini:
> ---------
> [MySQL]
> Description     = MySQL test database
> Driver      = MySQL
> SERVER      = 192.168.100.38
> USER        = root
> PASSWORD    = ***
> PORT        = 3306
> DATABASE    = kplatsen
> ----------
[...]

You should define the database name in square brakets, not the engine,
see servers/slapd/back-sql/rdbms_depend/REDADME for examples.

-Dieter

-- 
Dieter Klünter | Systemberatung
http://www.dkluenter.de
GPG Key ID:8EF7B6C6