Return to password_2.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / oci8 / tests

Annotation of embedaddon/php/ext/oci8/tests/password_2.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: oci_password_change() for persistent connections
                      3: --SKIPIF--
                      4: <?php 
                      5: if (!extension_loaded('oci8')) die("skip no oci8 extension"); 
                      6: require(dirname(__FILE__)."/details.inc");
                      7: if (empty($dbase)) die ("skip requires database connection string be set");
                      8: if (strcasecmp($user, "system") && strcasecmp($user, "sys")) die("skip needs to be run as a DBA user"); 
                      9: if ($test_drcp) die("skip password change not supported in DRCP Mode");
                     10: ?>
                     11: --FILE--
                     12: <?php
                     13: 
                     14: require(dirname(__FILE__)."/connect.inc");
                     15: 
                     16: $stmtarray = array(
                     17:        "drop user testuser cascade",
                     18:     "create user testuser identified by testuserpwd",
                     19:     "grant connect, create session to testuser"
                     20: );
                     21: 
                     22: oci8_test_sql_execute($c, $stmtarray);
                     23: 
                     24: // Connect (persistent) and change the password
                     25: $c1 = oci_pconnect("testuser", "testuserpwd", $dbase);
                     26: var_dump($c1);
                     27: $rn1 = (int)$c1;
                     28: 
                     29: oci_password_change($c1, "testuser", "testuserpwd", "testuserpwd2");
                     30: 
                     31: // Second connect should return a new resource because the hash string will be different from $c1
                     32: $c2 = oci_pconnect("testuser", "testuserpwd2", $dbase);
                     33: var_dump($c2);
                     34: $rn2 = (int)$c2;
                     35: 
                     36: // Despite using the old password this connect should succeed and return the original resource
                     37: $c3 = oci_pconnect("testuser", "testuserpwd", $dbase);  
                     38: var_dump($c3);
                     39: $rn3 = (int)$c3;
                     40: 
                     41: // Connections should differ
                     42: if ($rn1 == $rn2) {
                     43:        echo "First and second connections share a resource: Not OK\n";
                     44:        var_dump($c1);
                     45: }
                     46: else {
                     47:        echo "First and second connections are different: OK\n";
                     48: }
                     49: 
                     50: // Connections should be the same
                     51: if ($rn1 == $rn3) {
                     52:        echo "First and third connections share a resource: OK\n";
                     53: }
                     54: else {
                     55:        echo "First and third connections are different: Not OK\n";
                     56:        var_dump($c1);
                     57:        var_dump($c2);
                     58: }
                     59: 
                     60: echo "Done\n";
                     61: 
                     62: ?>
                     63: --CLEAN--
                     64: <?php
                     65: 
                     66: require(dirname(__FILE__)."/connect.inc");
                     67: 
                     68: $stmtarray = array(
                     69:     "drop user testuser cascade"
                     70: );
                     71: 
                     72: oci8_test_sql_execute($c, $stmtarray);
                     73: 
                     74: ?>
                     75: --EXPECTF--
                     76: resource(%d) of type (oci8 persistent connection)
                     77: resource(%d) of type (oci8 persistent connection)
                     78: resource(%d) of type (oci8 persistent connection)
                     79: First and second connections are different: OK
                     80: First and third connections share a resource: OK
                     81: Done