Hi P.,

Do you recall the odbc version of the driver manager and the drivers?

Thanks, \Tommy

On Tue, 2008-04-08 at 20:36 +0200, Pierangelo Masarati wrote:

Tommy Ho wrote:

...

Hi,

I'm trying to get openLDAP 2.4.8 to work with postgreSQL 8.1.8. Does it matter which odbc driver manager I use?

In http://www.openldap.org/faq/data/cache/978.html, under "How To Use It", it specifies to setup unixODBC

while in http://www.samse.fr/GPL/ldap_pg/HOWTO/index.html, it says to use iodbc.

I actually installed iodbc 3.52.6 and psqlodbc 8.03.0100 but am getting into a pthread mutex lock when backsql_load_schema_map() is trying to send the query "SELECT id, name, keytbl, keycol, create_proc, delete_proc, expect_return FROM ldap_oc_mappings" to postgres. From attaching gdb, the lock is happening SQLAllocStmt where is it is recursively being called from SQLAllocStmt_internal().

If others have found success getting openLDAP working with postgres, could you please share your expertise?

Let me know if I can provide additional data, like the configure options and other setup/version info.

Not recently, but I could get it working with both, without using any special version or compile option.

p.

Ing. Pierangelo Masarati OpenLDAP Core Team

SysNet s.r.l. via Dossi, 8 - 27100 Pavia - ITALIA http://www.sys-net.it

---

Office: +39 02 23998309 Mobile: +39 333 4963172 Email: pierangelo.masarati@sys-net.it

---

Hi P.

Thanks for your input, I scratched whatever I had and started all over and now am able to bring up openLDAP (2.4.8) with postgreSQL 8.1.8 using unixODBC 2.2.9. I was able to do ldapsearch on the test data that came with the tarball under servers/slapd/back-sql/rdbms_depend/pgsql/.

I attribute part of my failed initial attempt to not knowing that I already had openssl-9.7 and unixODBC-2.2.9 installed in my base linux system. I was following the instructions in http://www.samse.fr/GPL/ldap_pg/HOWTO/index.html and installed openssl 9.8 and iodbc-3.52.6 in additional to those packages. Things were a little messed up as you probably guessed.

Thanks, \Tommy

On Wed, 2008-04-09 at 20:11 +0200, Pierangelo Masarati wrote:

Tommy Ho wrote:

...

Hi P.,

Do you recall the odbc version of the driver manager and the drivers?

bash-3.1$ rpm -qa | grep -i odbc unixODBC-devel-2.2.11-7.1 postgresql-odbc-08.01.0200-3.1

p.

Ing. Pierangelo Masarati OpenLDAP Core Team

SysNet s.r.l. via Dossi, 8 - 27100 Pavia - ITALIA http://www.sys-net.it

---

Office: +39 02 23998309 Mobile: +39 333 4963172 Email: pierangelo.masarati@sys-net.it

---