Re: sql-backend

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

hi adam!

work your sql-backend?

Adam Williams wrote:

> > as you could read is my config not working but i will help and me :).
> > ...
> >    
> >
> > > load_schema_map(): at_query 'SELECT name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_return,sel_expr_u FROM ldap_attr_mappings WHERE oc_map_id=?'
> > > load_schema_map(): objectClass 'inetOrgPerson' is not defined in schema
> > > ==>backsql_free_db_conn()
> > >      
>
> Are you includeing /etc/openldap/schema/inetorgperson.schema in 
> slapd.conf?
>  
yes, but i see ...

[...]
==>backsql_add(): adding entry 'dc=sql,dc=hosting'
oc_check_required entry (dc=sql,dc=hosting), objectClass "dcObject"
oc_check_required entry (dc=sql,dc=hosting), objectClass "organization"
oc_check_allowed type "objectClass"
oc_check_allowed type "o"
oc_check_allowed type "dc"
oc_check_allowed type "structuralObjectClass"
oc_check_allowed type "entryUUID"
oc_check_allowed type "creatorsName"
oc_check_allowed type "createTimestamp"
oc_check_allowed type "entryCSN"
oc_check_allowed type "modifiersName"
oc_check_allowed type "modifyTimestamp"
backsql_add(): cannot determine objectclass of entry -- aborting
send_ldap_result: conn=9 op=1 p=3
send_ldap_result: err=53 matched="" text="operation not permitted within namingContext"
send_ldap_response: msgid=2 tag=105 err=53
ber_flush: 58 bytes to sd 12
connection_get(12)
connection_get(12): got connid=9
connection_read(12): checking for input on id=9
ber_get_next
ber_get_next: tag 0x30 len 5 contents:
ber_get_next
ber_get_next on fd 12 failed errno=11 (Resource temporarily unavailable)
do_unbind
==>backsql_unbind()
send_ldap_result: conn=9 op=2 p=3
send_ldap_result: err=0 matched="" text=""
send_ldap_response: msgid=0 tag=48 err=0
ber_flush: 14 bytes to sd 12
<==backsql_unbind()
connection_closing: readying conn=9 sd=12 for close
connection_resched: attempting closing conn=9 sd=12
connection_close: conn=9 sd=12
==>backsql_connection_destroy()
==>backsql_free_db_conn()
<==backsql_free_db_conn()
<==backsql_connection_destroy()


the straing thing is that the other database works great with db 4.1.

>>> dnPrettyNormal: <cn=Manager,dc=my,dc=hosting>
=> ldap_bv2dn(cn=Manager,dc=my,dc=hosting,0)
<= ldap_bv2dn(cn=Manager,dc=my,dc=hosting,0)=0
=> ldap_dn2bv(272)
<= ldap_dn2bv(cn=Manager,dc=my,dc=hosting,272)=0
=> ldap_dn2bv(272)
<= ldap_dn2bv(cn=manager,dc=my,dc=hosting,272)=0
<<< dnPrettyNormal: <cn=Manager,dc=my,dc=hosting>, 
<cn=manager,dc=my,dc=hosting>
do_bind: version=3 dn="cn=Manager,dc=my,dc=hosting" method=128
==> bdb_bind: dn: cn=Manager,dc=my,dc=hosting
bdb_dn2entry_rw("cn=manager,dc=my,dc=hosting")
=> bdb_dn2id_matched( "cn=manager,dc=my,dc=hosting" )
====> bdb_cache_find_entry_dn2id("dc=my,dc=hosting"): 1 (1 tries)
====> bdb_cache_find_entry_id( 1 ) "dc=my,dc=hosting" (found) (1 tries)
====> bdb_cache_return_entry_r( 1 ): returned (0)
do_bind: v3 bind: "cn=Manager,dc=my,dc=hosting" to 
"cn=Manager,dc=my,dc=hosting"
send_ldap_result: conn=9 op=0 p=3
send_ldap_result: err=0 matched="" text=""
send_ldap_response: msgid=1 tag=97 err=0
ber_flush: 14 bytes to sd 12


i build the mysql database with backsql_create.sql what ever there must 
be the problem!

now i have to look what Pierangelo means with his stuff ...

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!