git.sur5r.net Git - openldap/blob - servers/slapd/back-sql/delete.c

   1 /* $OpenLDAP$ */
   2 /* This work is part of OpenLDAP Software <http://www.openldap.org/>.
   3  *
   4  * Copyright 1999-2005 The OpenLDAP Foundation.
   5  * Portions Copyright 1999 Dmitry Kovalev.
   6  * Portions Copyright 2002 Pierangelo Masarati.
   7  * All rights reserved.
   8  *
   9  * Redistribution and use in source and binary forms, with or without
  10  * modification, are permitted only as authorized by the OpenLDAP
  11  * Public License.
  12  *
  13  * A copy of this license is available in the file LICENSE in the
  14  * top-level directory of the distribution or, alternatively, at
  15  * <http://www.OpenLDAP.org/license.html>.
  16  */
  17 /* ACKNOWLEDGEMENTS:
  18  * This work was initially developed by Dmitry Kovalev for inclusion
  19  * by OpenLDAP Software.  Additional significant contributors include
  20  * Pierangelo Masarati.
  21  */
  22
  23 #include "portable.h"
  24
  25 #include <stdio.h>
  26 #include <sys/types.h>
  27 #include "ac/string.h"
  28
  29 #include "slap.h"
  30 #include "proto-sql.h"
  31
  32 typedef struct backsql_delete_attr_t {
  33         Operation               *op;
  34         SlapReply               *rs;
  35         SQLHDBC                 dbh;
  36         backsql_entryID         *e_id;
  37 } backsql_delete_attr_t;
  38
  39 static int
  40 backsql_delete_attr_f( void *v_at, void *v_bda )
  41 {
  42         backsql_at_map_rec      *at = (backsql_at_map_rec *)v_at;
  43         backsql_delete_attr_t   *bda = (backsql_delete_attr_t *)v_bda;
  44         int                     rc;
  45
  46         rc = backsql_modify_delete_all_values( bda->op,
  47                         bda->rs, bda->dbh, bda->e_id, at );
  48
  49         if ( rc != LDAP_SUCCESS ) {
  50                 return BACKSQL_AVL_STOP;
  51         }
  52
  53         return BACKSQL_AVL_CONTINUE;
  54 }
  55
  56 static int
  57 backsql_delete_all_attrs(
  58         Operation               *op,
  59         SlapReply               *rs,
  60         SQLHDBC                 dbh,
  61         backsql_entryID         *e_id,
  62         backsql_oc_map_rec      *oc )
  63 {
  64         backsql_delete_attr_t   bda;
  65         int                     rc;
  66
  67         bda.op = op;
  68         bda.rs = rs;
  69         bda.dbh = dbh;
  70         bda.e_id = e_id;
  71
  72         rc = avl_apply( oc->bom_attrs, backsql_delete_attr_f, &bda,
  73                         BACKSQL_AVL_STOP, AVL_INORDER );
  74         if ( rc == BACKSQL_AVL_STOP ) {
  75                 return rs->sr_err;
  76         }
  77
  78         return LDAP_SUCCESS;
  79 }
  80
  81 int
  82 backsql_delete( Operation *op, SlapReply *rs )
  83 {
  84         backsql_info            *bi = (backsql_info*)op->o_bd->be_private;
  85         SQLHDBC                 dbh = SQL_NULL_HDBC;
  86         SQLHSTMT                sth = SQL_NULL_HSTMT;
  87         RETCODE                 rc;
  88         int                     prc = LDAP_SUCCESS;
  89         backsql_oc_map_rec      *oc = NULL;
  90         backsql_srch_info       bsi = { 0 };
  91         backsql_entryID         e_id = { 0 };
  92         Entry                   d = { 0 }, p = { 0 }, *e = NULL;
  93         struct berval           pdn = BER_BVNULL;
  94         int                     manageDSAit = get_manageDSAit( op );
  95         /* first parameter no */
  96         SQLUSMALLINT            pno = 0;
  97
  98         Debug( LDAP_DEBUG_TRACE, "==>backsql_delete(): deleting entry \"%s\"\n",
  99                         op->o_req_ndn.bv_val, 0, 0 );
 100
 101         rs->sr_err = backsql_get_db_conn( op, &dbh );
 102         if ( rs->sr_err != LDAP_SUCCESS ) {
 103                 Debug( LDAP_DEBUG_TRACE, "   backsql_delete(): "
 104                         "could not get connection handle - exiting\n",
 105                         0, 0, 0 );
 106                 rs->sr_text = ( rs->sr_err == LDAP_OTHER )
 107                         ? "SQL-backend error" : NULL;
 108                 e = NULL;
 109                 goto done;
 110         }
 111
 112         /*
 113          * Get the entry
 114          */
 115         bsi.bsi_e = &d;
 116         rs->sr_err = backsql_init_search( &bsi, &op->o_req_ndn,
 117                         LDAP_SCOPE_BASE,
 118                         (time_t)(-1), NULL, dbh, op, rs, slap_anlist_no_attrs,
 119                         ( BACKSQL_ISF_MATCHED | BACKSQL_ISF_GET_ENTRY ) );
 120         switch ( rs->sr_err ) {
 121         case LDAP_SUCCESS:
 122                 break;
 123
 124         case LDAP_REFERRAL:
 125                 if ( manageDSAit && !BER_BVISNULL( &bsi.bsi_e->e_nname ) &&
 126                                 dn_match( &op->o_req_ndn, &bsi.bsi_e->e_nname ) )
 127                 {
 128                         rs->sr_err = LDAP_SUCCESS;
 129                         rs->sr_text = NULL;
 130                         rs->sr_matched = NULL;
 131                         if ( rs->sr_ref ) {
 132                                 ber_bvarray_free( rs->sr_ref );
 133                                 rs->sr_ref = NULL;
 134                         }
 135                         break;
 136                 }
 137                 e = &d;
 138                 /* fallthru */
 139
 140         default:
 141                 Debug( LDAP_DEBUG_TRACE, "backsql_delete(): "
 142                         "could not retrieve deleteDN ID - no such entry\n",
 143                         0, 0, 0 );
 144                 if ( !BER_BVISNULL( &d.e_nname ) ) {
 145                         /* FIXME: should always be true! */
 146                         e = &d;
 147
 148                 } else {
 149                         e = NULL;
 150                 }
 151                 goto done;
 152         }
 153
 154         if ( get_assert( op ) &&
 155                         ( test_filter( op, &d, get_assertion( op ) )
 156                           != LDAP_COMPARE_TRUE ) )
 157         {
 158                 rs->sr_err = LDAP_ASSERTION_FAILED;
 159                 e = &d;
 160                 goto done;
 161         }
 162
 163         if ( !access_allowed( op, &d, slap_schema.si_ad_entry,
 164                         NULL, ACL_WDEL, NULL ) )
 165         {
 166                 Debug( LDAP_DEBUG_TRACE, "   backsql_delete(): "
 167                         "no write access to entry\n",
 168                         0, 0, 0 );
 169                 rs->sr_err = LDAP_INSUFFICIENT_ACCESS;
 170                 e = &d;
 171                 goto done;
 172         }
 173
 174         rs->sr_err = backsql_has_children( op, dbh, &op->o_req_ndn );
 175         switch ( rs->sr_err ) {
 176         case LDAP_COMPARE_FALSE:
 177                 rs->sr_err = LDAP_SUCCESS;
 178                 break;
 179
 180         case LDAP_COMPARE_TRUE:
 181                 if ( get_treeDelete( op ) ) {
 182                         /* not supported yet */ ;
 183                 }
 184                 Debug( LDAP_DEBUG_TRACE, "   backsql_delete(): "
 185                         "entry \"%s\" has children\n",
 186                         op->o_req_dn.bv_val, 0, 0 );
 187                 rs->sr_err = LDAP_NOT_ALLOWED_ON_NONLEAF;
 188                 rs->sr_text = "subordinate objects must be deleted first";
 189                 /* fallthru */
 190
 191         default:
 192                 e = &d;
 193                 goto done;
 194         }
 195
 196         oc = backsql_id2oc( bi, bsi.bsi_base_id.eid_oc_id );
 197         if ( oc == NULL ) {
 198                 Debug( LDAP_DEBUG_TRACE, "   backsql_delete(): "
 199                         "cannot determine objectclass of entry -- aborting\n",
 200                         0, 0, 0 );
 201                 rs->sr_err = LDAP_UNWILLING_TO_PERFORM;
 202                 rs->sr_text = "operation not permitted within namingContext";
 203                 e = NULL;
 204                 goto done;
 205         }
 206
 207         if ( oc->bom_delete_proc == NULL ) {
 208                 Debug( LDAP_DEBUG_TRACE, "   backsql_delete(): "
 209                         "delete procedure is not defined "
 210                         "for this objectclass - aborting\n", 0, 0, 0 );
 211                 rs->sr_err = LDAP_UNWILLING_TO_PERFORM;
 212                 rs->sr_text = "operation not permitted within namingContext";
 213                 e = NULL;
 214                 goto done;
 215         }
 216
 217         /*
 218          * Get the parent
 219          */
 220         if ( !be_issuffix( op->o_bd, &op->o_req_ndn ) ) {
 221                 dnParent( &op->o_req_ndn, &pdn );
 222                 bsi.bsi_e = &p;
 223                 e_id = bsi.bsi_base_id;
 224                 rs->sr_err = backsql_init_search( &bsi, &pdn,
 225                                 LDAP_SCOPE_BASE,
 226                                 (time_t)(-1), NULL, dbh, op, rs,
 227                                 slap_anlist_no_attrs,
 228                                 BACKSQL_ISF_GET_ENTRY );
 229                 if ( rs->sr_err != LDAP_SUCCESS ) {
 230                         Debug( LDAP_DEBUG_TRACE, "backsql_delete(): "
 231                                 "could not retrieve deleteDN ID "
 232                                 "- no such entry\n",
 233                                 0, 0, 0 );
 234                         e = &p;
 235                         goto done;
 236                 }
 237
 238                 (void)backsql_free_entryID( op, &bsi.bsi_base_id, 0 );
 239
 240                 /* check parent for "children" acl */
 241                 if ( !access_allowed( op, &p, slap_schema.si_ad_children,
 242                                 NULL, ACL_WDEL, NULL ) )
 243                 {
 244                         Debug( LDAP_DEBUG_TRACE, "   backsql_delete(): "
 245                                 "no write access to parent\n",
 246                                 0, 0, 0 );
 247                         rs->sr_err = LDAP_INSUFFICIENT_ACCESS;
 248                         e = &p;
 249                         goto done;
 250
 251                 }
 252         }
 253
 254         /* avl_apply ... */
 255         rs->sr_err = backsql_delete_all_attrs( op, rs, dbh, &e_id, oc );
 256         if ( rs->sr_err != LDAP_SUCCESS ) {
 257                 e = &d;
 258                 goto done;
 259         }
 260
 261         rc = backsql_Prepare( dbh, &sth, oc->bom_delete_proc, 0 );
 262         if ( rc != SQL_SUCCESS ) {
 263                 Debug( LDAP_DEBUG_TRACE,
 264                         "   backsql_delete(): "
 265                         "error preparing delete query\n",
 266                         0, 0, 0 );
 267                 backsql_PrintErrors( bi->sql_db_env, dbh, sth, rc );
 268
 269                 rs->sr_err = LDAP_OTHER;
 270                 rs->sr_text = "SQL-backend error";
 271                 e = NULL;
 272                 goto done;
 273         }
 274
 275         if ( BACKSQL_IS_DEL( oc->bom_expect_return ) ) {
 276                 pno = 1;
 277                 rc = backsql_BindParamInt( sth, 1, SQL_PARAM_OUTPUT, &prc );
 278                 if ( rc != SQL_SUCCESS ) {
 279                         Debug( LDAP_DEBUG_TRACE,
 280                                 "   backsql_delete(): "
 281                                 "error binding output parameter for objectClass %s\n",
 282                                 oc->bom_oc->soc_cname.bv_val, 0, 0 );
 283                         backsql_PrintErrors( bi->sql_db_env, dbh,
 284                                 sth, rc );
 285                         SQLFreeStmt( sth, SQL_DROP );
 286
 287                         rs->sr_text = "SQL-backend error";
 288                         rs->sr_err = LDAP_OTHER;
 289                         e = NULL;
 290                         goto done;
 291                 }
 292         }
 293
 294         rc = backsql_BindParamID( sth, pno + 1, SQL_PARAM_INPUT, &e_id.eid_keyval );
 295         if ( rc != SQL_SUCCESS ) {
 296                 Debug( LDAP_DEBUG_TRACE,
 297                         "   backsql_delete(): "
 298                         "error binding keyval parameter for objectClass %s\n",
 299                         oc->bom_oc->soc_cname.bv_val, 0, 0 );
 300                 backsql_PrintErrors( bi->sql_db_env, dbh,
 301                         sth, rc );
 302                 SQLFreeStmt( sth, SQL_DROP );
 303
 304                 rs->sr_text = "SQL-backend error";
 305                 rs->sr_err = LDAP_OTHER;
 306                 e = NULL;
 307                 goto done;
 308         }
 309
 310         rc = SQLExecute( sth );
 311         if ( rc == SQL_SUCCESS && prc == LDAP_SUCCESS ) {
 312                 rs->sr_err = LDAP_SUCCESS;
 313
 314         } else {
 315                 Debug( LDAP_DEBUG_TRACE, "   backsql_delete(): "
 316                         "delete_proc execution failed (rc=%d, prc=%d)\n",
 317                         rc, prc, 0 );
 318
 319
 320                 if ( prc != LDAP_SUCCESS ) {
 321                         /* SQL procedure executed fine
 322                          * but returned an error */
 323                         rs->sr_err = BACKSQL_SANITIZE_ERROR( prc );
 324
 325                 } else {
 326                         backsql_PrintErrors( bi->sql_db_env, dbh,
 327                                         sth, rc );
 328                         rs->sr_err = LDAP_OTHER;
 329                 }
 330                 SQLFreeStmt( sth, SQL_DROP );
 331                 e = &d;
 332                 goto done;
 333         }
 334         SQLFreeStmt( sth, SQL_DROP );
 335
 336         /* delete "auxiliary" objectClasses, if any... */
 337         rc = backsql_Prepare( dbh, &sth, bi->sql_delobjclasses_stmt, 0 );
 338         if ( rc != SQL_SUCCESS ) {
 339                 Debug( LDAP_DEBUG_TRACE,
 340                         "   backsql_delete(): "
 341                         "error preparing ldap_entry_objclasses delete query\n",
 342                         0, 0, 0 );
 343                 backsql_PrintErrors( bi->sql_db_env, dbh, sth, rc );
 344
 345                 rs->sr_err = LDAP_OTHER;
 346                 rs->sr_text = "SQL-backend error";
 347                 e = NULL;
 348                 goto done;
 349         }
 350
 351         rc = backsql_BindParamID( sth, 1, SQL_PARAM_INPUT, &e_id.eid_id );
 352         if ( rc != SQL_SUCCESS ) {
 353                 Debug( LDAP_DEBUG_TRACE,
 354                         "   backsql_delete(): "
 355                         "error binding auxiliary objectClasses "
 356                         "entry ID parameter for objectClass %s\n",
 357                         oc->bom_oc->soc_cname.bv_val, 0, 0 );
 358                 backsql_PrintErrors( bi->sql_db_env, dbh,
 359                         sth, rc );
 360                 SQLFreeStmt( sth, SQL_DROP );
 361
 362                 rs->sr_text = "SQL-backend error";
 363                 rs->sr_err = LDAP_OTHER;
 364                 e = NULL;
 365                 goto done;
 366         }
 367
 368         rc = SQLExecute( sth );
 369         switch ( rc ) {
 370         case SQL_NO_DATA:
 371                 /* apparently there were no "auxiliary" objectClasses
 372                  * for this entry... */
 373         case SQL_SUCCESS:
 374                 break;
 375
 376         default:
 377                 Debug( LDAP_DEBUG_TRACE, "   backsql_delete(): "
 378                         "failed to delete record from ldap_entry_objclasses\n",
 379                         0, 0, 0 );
 380                 backsql_PrintErrors( bi->sql_db_env, dbh, sth, rc );
 381                 SQLFreeStmt( sth, SQL_DROP );
 382                 rs->sr_err = LDAP_OTHER;
 383                 rs->sr_text = "SQL-backend error";
 384                 e = NULL;
 385                 goto done;
 386         }
 387         SQLFreeStmt( sth, SQL_DROP );
 388
 389         /* delete entry... */
 390         rc = backsql_Prepare( dbh, &sth, bi->sql_delentry_stmt, 0 );
 391         if ( rc != SQL_SUCCESS ) {
 392                 Debug( LDAP_DEBUG_TRACE,
 393                         "   backsql_delete(): "
 394                         "error preparing ldap_entries delete query\n",
 395                         0, 0, 0 );
 396                 backsql_PrintErrors( bi->sql_db_env, dbh, sth, rc );
 397
 398                 rs->sr_err = LDAP_OTHER;
 399                 rs->sr_text = "SQL-backend error";
 400                 e = NULL;
 401                 goto done;
 402         }
 403
 404         rc = backsql_BindParamID( sth, 1, SQL_PARAM_INPUT, &e_id.eid_id );
 405         if ( rc != SQL_SUCCESS ) {
 406                 Debug( LDAP_DEBUG_TRACE,
 407                         "   backsql_delete(): "
 408                         "error binding entry ID parameter "
 409                         "for objectClass %s\n",
 410                         oc->bom_oc->soc_cname.bv_val, 0, 0 );
 411                 backsql_PrintErrors( bi->sql_db_env, dbh,
 412                         sth, rc );
 413                 SQLFreeStmt( sth, SQL_DROP );
 414
 415                 rs->sr_text = "SQL-backend error";
 416                 rs->sr_err = LDAP_OTHER;
 417                 e = NULL;
 418                 goto done;
 419         }
 420
 421         rc = SQLExecute( sth );
 422         if ( rc != SQL_SUCCESS ) {
 423                 Debug( LDAP_DEBUG_TRACE, "   backsql_delete(): "
 424                         "failed to delete record from ldap_entries\n",
 425                         0, 0, 0 );
 426                 backsql_PrintErrors( bi->sql_db_env, dbh, sth, rc );
 427                 SQLFreeStmt( sth, SQL_DROP );
 428                 rs->sr_err = LDAP_OTHER;
 429                 rs->sr_text = "SQL-backend error";
 430                 e = NULL;
 431                 goto done;
 432         }
 433         SQLFreeStmt( sth, SQL_DROP );
 434
 435         rs->sr_err = LDAP_SUCCESS;
 436
 437         /*
 438          * Commit only if all operations succeed
 439          */
 440         if ( sth != SQL_NULL_HSTMT ) {
 441                 SQLUSMALLINT    CompletionType = SQL_ROLLBACK;
 442
 443                 if ( rs->sr_err == LDAP_SUCCESS && !op->o_noop ) {
 444                         CompletionType = SQL_COMMIT;
 445                 }
 446
 447                 SQLTransact( SQL_NULL_HENV, dbh, CompletionType );
 448         }
 449
 450 done:;
 451 #ifdef SLAP_ACL_HONOR_DISCLOSE
 452         if ( e != NULL ) {
 453                 if ( !access_allowed( op, e, slap_schema.si_ad_entry, NULL,
 454                                         ACL_DISCLOSE, NULL ) )
 455                 {
 456                         rs->sr_err = LDAP_NO_SUCH_OBJECT;
 457                         rs->sr_text = NULL;
 458                         rs->sr_matched = NULL;
 459                         if ( rs->sr_ref ) {
 460                                 ber_bvarray_free( rs->sr_ref );
 461                                 rs->sr_ref = NULL;
 462                         }
 463                 }
 464         }
 465 #endif /* SLAP_ACL_HONOR_DISCLOSE */
 466
 467         send_ldap_result( op, rs );
 468
 469         Debug( LDAP_DEBUG_TRACE, "<==backsql_delete()\n", 0, 0, 0 );
 470
 471         if ( !BER_BVISNULL( &e_id.eid_ndn ) ) {
 472                 (void)backsql_free_entryID( op, &e_id, 0 );
 473         }
 474
 475         if ( !BER_BVISNULL( &d.e_nname ) ) {
 476                 backsql_entry_clean( op, &d );
 477         }
 478
 479         if ( !BER_BVISNULL( &p.e_nname ) ) {
 480                 backsql_entry_clean( op, &p );
 481         }
 482
 483         return rs->sr_err;
 484 }
 485