Re: sql-backend

["Manuel Mely" <mely@tm.minbas.cu>]

I have the same problem, i configured unixODBC and MyODBC and it works fine, but there is a problem with back-sql and openldap, im running red hat 8.0, 

*********** REPLY SEPARATOR  ***********

On 1/14/2004 at 9:59 AM Otto Kucera wrote:

>hi!
>
>i try to a sql-backend config but i have problems to store or read 
>informations :(. this config runs on gentoo linux.
>
>odbc.ini:
>[ldap]
>Description             = MySQL
>Driver                  = MySQL
>Host                    = localhost
>Port                    = 3306
>Database                = ldap
>
>odbcinst.ini:
>[MySQL]
>Description             = MySQL driver for Linux
>Driver                  = /usr/lib/libmyodbc3.so
>TraceFile               = mysql.log
>FileUsage               = 1
>
>slapd:
>[...]
>#######################################################################
># sql database definitions
>#######################################################################
>database        sql
>suffix          "dc=sql,dc=hosting"
>rootdn          "cn=manager,dc=sql,dc=hosting"
>rootpw          {MD5}5WRd2F3rEA/R1x0OjWcQkQ==
>dbname          ldap
>dbuser          ldap
>dbpasswd        ldap
>subtree_cond    "ldap_entries.dn LIKE CONCAT('%',?)"
>insentry_query  "INSERT INTO ldap_entries (dn,oc_map_id,parent,keyval) 
>VALUES (?,?,?,?)"
>upper_func      "upper"
>strcast_func    "text"
>concat_pattern  "?||?"
>
>i created the mysql database the testdb with:
>backsql_create.sql
>testdb_create.sql
>testdb_data.sql
>testdb_metadata.sql
>
>this do i get:
>connection_get(12)
>connection_get(12): got connid=0
>connection_read(12): checking for input on id=0
>ber_get_next
>ber_get_next: tag 0x30 len 34 contents:
>do_bind
>ber_get_next
>ber_get_next on fd 12 failed errno=11 (Resource temporarily unavailable)
>ber_scanf fmt ({imt) ber:
>ber_scanf fmt (m}) ber:
> >>> dnPrettyNormal: <cn=root,o=sql,c=RU>
>=> ldap_bv2dn(cn=root,o=sql,c=RU,0)
><= ldap_bv2dn(cn=root,o=sql,c=RU,0)=0
>=> ldap_dn2bv(272)
><= ldap_dn2bv(cn=root,o=sql,c=RU,272)=0
>=> ldap_dn2bv(272)
><= ldap_dn2bv(cn=root,o=sql,c=ru,272)=0
><<< dnPrettyNormal: <cn=root,o=sql,c=RU>, <cn=root,o=sql,c=ru>
>do_bind: version=3 dn="cn=root,o=sql,c=RU" method=128
>send_ldap_result: conn=0 op=0 p=3
>send_ldap_result: err=49 matched="" text=""
>send_ldap_response: msgid=1 tag=97 err=49
>ber_flush: 14 bytes to sd 12
>connection_get(12)
>connection_get(12): got connid=0
>connection_read(12): checking for input on id=0
>ber_get_next
>ber_get_next: tag 0x30 len 5 contents:
>deferring operation
>connection_get(12)
>connection_get(12): got connid=0
>connection_read(12): checking for input on id=0
>ber_get_next
>ber_get_next on fd 12 failed errno=0 (Success)
>connection_read(12): input error=-2 id=0, closing.
>connection_closing: readying conn=0 sd=12 for close
>connection_close: deferring conn=0 sd=12
>do_unbind
>==>backsql_unbind()
>send_ldap_result: conn=0 op=1 p=3
>send_ldap_result: err=0 matched="" text=""
>send_ldap_response: msgid=0 tag=48 err=0
><==backsql_unbind()
>connection_resched: attempting closing conn=0 sd=12
>connection_close: conn=0 sd=12
>==>backsql_connection_destroy()
>==>backsql_free_db_conn()
><==backsql_free_db_conn()
><==backsql_connection_destroy()
>
>i have no idea ...
>
>otto
>
>-- 
>-----------------------------------
>Otto Kucera
>A-1020 Wien Engerthstrasse 137/6/7
>Tel: +43 699 1 942 30 91 [neue Nummer!]
>Email: ok@72pixel.at
>Icq: 65351173
>-----------------------------------
>
>And root said rm -rf /     ......and there was nothing
>*BSD is like a wigwam: NO windows, NO gates and an Apache inside!
>
>Your mailserver MUST resolve properly (Fully Qualified Domain Name) or the
>mail will not go through!