[gentoo-server] openLDAP with mysql backend (problems with libmyodbc.so => undefined symbol: lt_dlclose )

[Claudinei Matos <claudineimatos@gmail.com>]

hi,

I'm trying to setup openLDAP to use mysql as backend with a guid I
found here http://www.section6.net/help/openldap.php
Well, I did reinstalled openLDAP with unixODBC use flag on and setup
/etc/unixODBC/ odbc.ini and odbcinst.ini since this files comes empty.
Bellow follow what I setup in these files:

(odbcinst.ini)
[ODBC Drivers]
MySQL = Installed

[MySQL]
Description=ODBC for MySQL
Driver=/usr/lib/libmyodbc3.so

(odbc.ini)
[ODBC Data Sources]
ldap = MySQL LDAP DSN

[ldap]
Driver          = /usr/lib/libmyodbc3.so
Description     = OpenLDAP Database
Host            = localhost
ServerType      = MySQL
Port            = 3306
FetchBufferSize = 99
User            = ldap_user
Password        = ldap_pass
Database        = ldap_db
ReadOnly        = no
Socket          = /var/run/mysqd/mysqld.sock

[ODBC]
InstallDir=/usr/local/lib


Well, since I saw that /usr/lib/libmyodbc3.so doesn't exist I've tried
to use libodbc.so instead and even libodbcmyS.so.
The next step was to test odbc connection with iodbctest but this
application hadn't been instaled, so I try to emerge libiodbc and
iodbc.
Well, installing these 2 packages I got iodbctest, tried to connect:

root@host # iodbctest
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.51.0001.0908

Enter ODBC connect string (? shows list): ?

DSN                            | Description
---------------------------------------------------------------
ldap                           | MySQL LDAP DSN

but when I try to pass DSN=ldap that's what I get:

"Enter ODBC connect string (? shows list): DSN=ldap
1:  (0), SQLSTATE=

Have a nice day."

Looking around I've found that libmyodbc3.so is provided by myodbc
package which one I've emerged and setup in both odbc.ini and
odbcinst.ini like the tutorial says, but now, if I try to run
iodbctest that's what I get when I type "DSN=ldap":
1: [iODBC][Driver Manager]/usr/lib/libmyodbc3.so: undefined symbol:
lt_dlclose (0), SQLSTATE=00000
2: [iODBC][Driver Manager]Specified driver could not be loaded (0),
SQLSTATE=IM003


Since I got this error, I've thinked that may I had to reinstall
unixODBC, iodbc, libiodbc but even after reinstall all these packages
I still getting the same error.

Do somebody knows how to fix that? Is there another way to use mysql
as a backend to LDAP?

Tks in advice,

Claudinei Matos

-- 
gentoo-server@gentoo.org mailing list