[Date Prev][Date Next] [Chronological] [Thread] [Top]

RE: problem with back-sql



create_proc metadata entry is executed when an entry is added through ldap interface.  This is to isolate database specific statements out of openldap.
 
You should be able to substitute this with what works in your database (mysql).  I am not familiar with mysql, so may be someone else can comment.
 
-----Original Message-----
From: sajida kalsoom [mailto:sajida@advcomm.net]
Sent: Tuesday, August 07, 2001 3:50 AM
To: openldap-software@OpenLDAP.org
Subject: Fw: problem with back-sql

 Rajen! you did not answer this portion of my question ???
....
Also when i try to insert this query in mysql database it gives me syntex error at "insert....' even when i replace the " with ' it gives the error at ; then. Then i insert ' ' value in create_proc field. Is it correct way.. if not what is correct syntax for its value.. Please help me I am totally struct in these errors since last two /three days.
 
 insert into ldap_oc_mappings (id,name,keytbl,keycol,create_proc,delete_proc,expect_return)
values (1,'inetOrgPerson','persons','id',"insert into persons (name) values ('');\n select last_insert_id();",NULL,0);
 
Also what is the purpose of  'insert into persons...'  value of create_proc ...
Please help me...

----- Original Message -----
Sent: Saturday, August 04, 2001 1:52 PM
Subject: Re: problem with back-sql

 
Hi Rajen!
I did what you said means run the  slapd -d 0 .. well it runs with no error but when i try to connect with ldap server  it says  'unable to connect with ldap server'  then i try the nestat command and check the status of ldap server using netstat command it shows BOUND instead of listening
 
Local Address        Remote Address    Swind Send-Q Rwind Recv-Q  State
-------------------- -------------------- ----- ------ ----- ------ -------
 
 *.ldap                         *.*                       0          0          0          0       BOUND
 
when i try slapd with ldbm instead of back-sql .. netstat -a shows the status of LISTEN means server running well.
 

   Local Address        Remote Address    Swind Send-Q Rwind Recv-Q  State
-------------------- -------------------- ----- ------ ----- ------ -------
 
 *.ldap               *.*                0      0     0      0 LISTEN
 
Also when i try to insert this query in mysql database it gives me syntex error at "insert....' even when i replace the " with ' it gives the error at ; then. Then i insert ' ' value in create_proc field. Is it correct way.. if not what is correct syntax for its value.. Please help me I am totally struct in these errors since last two /three days.
 
 insert into ldap_oc_mappings (id,name,keytbl,keycol,create_proc,delete_proc,expect_return)
values (1,'inetOrgPerson','persons','id',"insert into persons (name) values ('');\n select last_insert_id();",NULL,0);

----- Original Message -----
Sent: Friday, August 03, 2001 10:10 PM
Subject: RE: problem with back-sql

I believe this is a problem with one of the debug trace.  Try the same with tracing turned off. ( -d 0).
 
This is fixed in the version Dmitry just checked in.
-----Original Message-----
From: Rajen Damani [mailto:rdamani@timesten.com]
Sent: Friday, August 03, 2001 9:46 AM
To: 'sajida kalsoom'; openldap-software@OpenLDAP.org
Subject: RE: problem with back-sql

What version of OpenLDAP are you using?
-----Original Message-----
From: sajida kalsoom [mailto:sajida@advcomm.net]
Sent: Friday, August 03, 2001 4:36 AM
To: openldap-software@OpenLDAP.org
Subject: problem with back-sql

Hi users!
 can some one please hlep me on this erorr when i try to run  slapd it results in the following error!
 
 
backsql_db_open(): setting 'SELECT name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_return FROM ldap_attr_mappings WHERE oc_map_id=?' by default
backsql_db_open(): entry deletion SQL statement not specified (use delentry_query directive in slapd.conf)
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()
load_schema_map(): objectclass 'inetOrgPerson': keytbl='persons' keycol='id' Segmentation Fault (core dumped)
 
#####
 
I am using openldap with back-sql module and mysql as backend database... I have created the sample tables and when try to run slapd with sample slapd.conf it gives me above error?? 
 
regards
sajida kalsoom.