Return to password.phpt CVS log

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

Annotation of embedaddon/php/ext/oci8/tests/password.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: oci_password_change() for non-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: 
        !            25: // Connect and change the password
        !            26: $c1 = oci_connect("testuser", "testuserpwd", $dbase);
        !            27: var_dump($c1);
        !            28: $rn1 = (int)$c1;
        !            29: 
        !            30: oci_password_change($c1, "testuser", "testuserpwd", "testuserpwd2");
        !            31: 
        !            32: // Second connect should return a new resource because the hash string will be different from $c1
        !            33: $c2 = oci_connect("testuser", "testuserpwd2", $dbase);
        !            34: var_dump($c2);
        !            35: $rn2 = (int)$c2;
        !            36: 
        !            37: // Despite using the old password this connect should succeed and return the original resource
        !            38: $c3 = oci_connect("testuser", "testuserpwd", $dbase);  
        !            39: var_dump($c3);
        !            40: $rn3 = (int)$c3;
        !            41: 
        !            42: // Connections should differ
        !            43: if ($rn1 == $rn2) {
        !            44:        echo "First and second connections share a resource: Not OK\n";
        !            45:        var_dump($c1);
        !            46: }
        !            47: else {
        !            48:        echo "First and second connections are different: OK\n";
        !            49: }
        !            50: 
        !            51: // Connections should be the same
        !            52: if ($rn1 == $rn3) {
        !            53:        echo "First and third connections share a resource: OK\n";
        !            54: }
        !            55: else {
        !            56:        echo "First and third connections are different: Not OK\n";
        !            57:        var_dump($c1);
        !            58:        var_dump($c2);
        !            59: }
        !            60: 
        !            61: echo "Done\n";
        !            62: 
        !            63: ?>
        !            64: --CLEAN--
        !            65: <?php
        !            66: 
        !            67: require(dirname(__FILE__)."/connect.inc");
        !            68: 
        !            69: $stmtarray = array(
        !            70:     "drop user testuser cascade"
        !            71: );
        !            72: 
        !            73: oci8_test_sql_execute($c, $stmtarray);
        !            74: 
        !            75: ?>
        !            76: --EXPECTF--
        !            77: resource(%d) of type (oci8 connection)
        !            78: resource(%d) of type (oci8 connection)
        !            79: resource(%d) of type (oci8 connection)
        !            80: First and second connections are different: OK
        !            81: First and third connections share a resource: OK
        !            82: Done