2 /* This work is part of OpenLDAP Software <http://www.openldap.org/>.
4 * Copyright 1999-2004 The OpenLDAP Foundation.
5 * Portions Copyright 1999 Dmitry Kovalev.
8 * Redistribution and use in source and binary forms, with or without
9 * modification, are permitted only as authorized by the OpenLDAP
12 * A copy of this license is available in the file LICENSE in the
13 * top-level directory of the distribution or, alternatively, at
14 * <http://www.OpenLDAP.org/license.html>.
17 * This work was initially developed by Dmitry Kovalev for inclusion
18 * by OpenLDAP Software.
26 #include <sys/types.h>
27 #include "ac/string.h"
31 #include "proto-sql.h"
34 backsql_delete( Operation *op, SlapReply *rs )
36 backsql_info *bi = (backsql_info*)op->o_bd->be_private;
40 backsql_oc_map_rec *oc = NULL;
43 /* first parameter no */
46 Debug( LDAP_DEBUG_TRACE, "==>backsql_delete(): deleting entry \"%s\"\n",
47 op->o_req_ndn.bv_val, 0, 0 );
49 dnParent( &op->o_req_dn, &e.e_name );
50 dnParent( &op->o_req_ndn, &e.e_nname );
53 /* check parent for "children" acl */
54 if ( !access_allowed( op, &e, slap_schema.si_ad_children,
55 NULL, ACL_WRITE, NULL ) ) {
56 Debug( LDAP_DEBUG_TRACE, " backsql_delete(): "
57 "no write access to parent\n",
59 rs->sr_err = LDAP_INSUFFICIENT_ACCESS;
64 rs->sr_err = backsql_get_db_conn( op, &dbh );
65 if ( rs->sr_err != LDAP_SUCCESS ) {
66 Debug( LDAP_DEBUG_TRACE, " backsql_delete(): "
67 "could not get connection handle - exiting\n",
69 rs->sr_text = ( rs->sr_err == LDAP_OTHER )
70 ? "SQL-backend error" : NULL;
74 rs->sr_err = backsql_dn2id( bi, &e_id, dbh, &op->o_req_ndn );
75 if ( rs->sr_err != LDAP_SUCCESS ) {
76 Debug( LDAP_DEBUG_TRACE, " backsql_delete(): "
77 "could not lookup entry id\n", 0, 0, 0 );
81 rs->sr_err = backsql_has_children( bi, dbh, &op->o_req_ndn );
82 switch ( rs->sr_err ) {
83 case LDAP_COMPARE_TRUE:
84 Debug( LDAP_DEBUG_TRACE, " backsql_delete(): "
85 "entry \"%s\" has children\n",
86 op->o_req_dn.bv_val, 0, 0 );
87 rs->sr_err = LDAP_NOT_ALLOWED_ON_NONLEAF;
88 rs->sr_text = "subtree delete not supported";
91 case LDAP_COMPARE_FALSE:
98 oc = backsql_id2oc( bi, e_id.oc_id );
100 Debug( LDAP_DEBUG_TRACE, " backsql_delete(): "
101 "cannot determine objectclass of entry -- aborting\n",
103 rs->sr_err = LDAP_UNWILLING_TO_PERFORM;
104 rs->sr_text = "operation not permitted within namingContext";
108 if ( oc->bom_delete_proc == NULL ) {
109 Debug( LDAP_DEBUG_TRACE, " backsql_delete(): "
110 "delete procedure is not defined "
111 "for this objectclass - aborting\n", 0, 0, 0 );
112 rs->sr_err = LDAP_UNWILLING_TO_PERFORM;
113 rs->sr_text = "operation not permitted within namingContext";
117 SQLAllocStmt( dbh, &sth );
119 rc = backsql_Prepare( dbh, &sth, oc->bom_delete_proc, 0 );
120 if ( rc != SQL_SUCCESS ) {
121 Debug( LDAP_DEBUG_TRACE,
122 " backsql_delete(): "
123 "error preparing delete query\n",
125 backsql_PrintErrors( bi->db_env, dbh, sth, rc );
127 rs->sr_err = LDAP_OTHER;
128 rs->sr_text = "SQL-backend error";
132 if ( BACKSQL_IS_DEL( oc->bom_expect_return ) ) {
134 SQLBindParameter( sth, 1, SQL_PARAM_OUTPUT, SQL_C_ULONG,
135 SQL_INTEGER, 0, 0, &rc, 0, 0 );
140 SQLBindParameter( sth, pno + 1, SQL_PARAM_INPUT,
141 SQL_C_ULONG, SQL_INTEGER, 0, 0, &e_id.keyval, 0, 0 );
143 rc = SQLExecute( sth );
144 if ( rc != SQL_SUCCESS ) {
145 Debug( LDAP_DEBUG_TRACE, " backsql_delete(): "
146 "delete_proc execution failed\n", 0, 0, 0 );
147 backsql_PrintErrors( bi->db_env, dbh, sth, rc );
148 SQLFreeStmt( sth, SQL_DROP );
149 rs->sr_err = LDAP_OTHER;
150 rs->sr_text = "SQL-backend error";
153 #ifndef BACKSQL_REALLOC_STMT
154 SQLFreeStmt( sth, SQL_RESET_PARAMS );
155 #else /* BACKSQL_REALLOC_STMT */
156 SQLFreeStmt( sth, SQL_DROP );
157 SQLAllocStmt( dbh, &sth );
158 #endif /* BACKSQL_REALLOC_STMT */
160 rc = backsql_Prepare( dbh, &sth, bi->delentry_query, 0 );
161 if ( rc != SQL_SUCCESS ) {
162 Debug( LDAP_DEBUG_TRACE,
163 " backsql_delete(): "
164 "error preparing ldap_entries delete query\n",
166 backsql_PrintErrors( bi->db_env, dbh, sth, rc );
168 rs->sr_err = LDAP_OTHER;
169 rs->sr_text = "SQL-backend error";
173 SQLBindParameter( sth, 1, SQL_PARAM_INPUT, SQL_C_ULONG, SQL_INTEGER,
174 0, 0, &e_id.id, 0, 0 );
175 rc = SQLExecute( sth );
176 if ( rc != SQL_SUCCESS ) {
177 Debug( LDAP_DEBUG_TRACE, " backsql_delete(): "
178 "failed to delete record from ldap_entries\n",
180 backsql_PrintErrors( bi->db_env, dbh, sth, rc );
181 SQLFreeStmt( sth, SQL_DROP );
182 rs->sr_err = LDAP_OTHER;
183 rs->sr_text = "SQL-backend error";
188 * Commit only if all operations succeed
190 * FIXME: backsql_add() does not fail if add operations
191 * are not available for some attributes, or if
192 * a multiple value add actually results in a replace,
193 * or if a single operation on an attribute fails
196 SQLTransact( SQL_NULL_HENV, dbh,
197 op->o_noop ? SQL_ROLLBACK : SQL_COMMIT );
199 rs->sr_err = LDAP_SUCCESS;
202 send_ldap_result( op, rs );
204 Debug( LDAP_DEBUG_TRACE, "<==backsql_delete()\n", 0, 0, 0 );
206 return ( ( rs->sr_err == LDAP_SUCCESS ) ? op->o_noop : 1 );
209 #endif /* SLAPD_SQL */