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

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.