sql-backend

[Otto Kucera <ok@72pixel.at>]

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!