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

RE: problem with back-sql



Turning off tracing fixes your earlier problem, however it is kind of difficult to see whats going on without tracing (for the next problem you are having).  So my suggestion would be to try the latest back-sql code (not 2.0.11)  that was just checked into CVS.
 
  -----Original Message-----
From: sajida kalsoom [mailto:sajida@advcomm.net]
Sent: Saturday, August 04, 2001 1:53 AM
To: openldap-software@OpenLDAP.org; Rajen Damani
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.