Re: sql-backend

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

hi manuel!

as you could read is my config not working but i will help and me :).

Manuel Mely wrote:

> my problem is that i can't start openldap server because of this error
>
> backsql_db_open(): setting 'DELETE FROM ldap_entries WHERE id=?' by default
> ==>backsql_get_db_conn()
> ==>backsql_open_db_conn()
> backsql_open_db_conn(): connected, adding to tree
> <==backsql_open_db_conn()
> backsql_get_db_conn(): first call -- reading schema map
> ==>load_schema_map()
> ldapinfo.dn_ru field exists in the schema
> 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()
> backsql_free_db_conn(): closing db connection
> ==>backsql_close_db_conn()
> <==backsql_close_db_conn()
> <==backsql_free_db_conn()
> backsql_db_open(): connection failed, exiting
> backend_startup: bi_db_open(0) failed! (1)
> slapd shutdown: initiated
> ==>backsql_db_close()
> <==backsql_db_close()
> slapd shutdown: freeing system resources.
> ==>backsql_db_destroy()
> ==>backsql_free_db_env()
> <==backsql_free_db_env()
> ==>destroy_schema_map()
> <==destroy_schema_map()
> <==backsql_db_destroy()
> slapd stopped.
> connections_destroy: nothing to destroy.
>
>
>
> this is my slapd.conf
>
> ###########################################################################
> # Base de Datos TEST en MYSQL                                             #
> ###########################################################################
> database        sql
> suffix          "o=sql,c=RU"
> rootdn          "cn=manager,o=sql,c=RU"
> rootpw          secret
> dbhost          localhost
> dbname          test
> dbuser          mely
> dbpasswd        mely
> subtree_cond    "ldap_entries.dn LIKE CONCAT('%',?)"
> insentry_query  "INSERT INTO ldap_entries (dn,oc_map_id,parent,keyval) VALUES (?,?,?,?)"
>
> this is my odbc.ini
>
> [Test]
> Description = MySQL
> Driver = /usr/lib/libmyodbc3.so
> HOST = localhost
> PORT = 3306
> DATABASE = test
> SERVER = localhost
> USER = mely
> PASSWORD = mely
>
>
>  
send me your odbcinst.ini and try "isql test mely mely -v".
witch os do you use?

> *********** REPLY SEPARATOR  ***********
>
> On 1/15/2004 at 4:28 PM Otto Kucera wrote:
>
>  
>
> > hi manuel!
> >
> >
> >
> > Manuel Mely wrote:
> >
> >    
> >
> > > Otto and Ando, it appears that if you are using LDAPADD is that your
> > >      
> > openldap server is running with MySQL compatibility...
> >    
> >
> > > could you help? How did you start your server? 
> > >
> > >
> > >
> > >
> > >      
> > ... what should i tell you? i build openldap 2.1 with sql (odbc freebsd, 
> > gentoo) and myodbc.
> > this how to can give you an idea. 
> > http://www.flatmtn.com/computer/Linux-LDAP.html.
> >
> > or what is our problem?
> >
> > 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!
> >    
>
>
>
>  

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!