Return to mysql_query_load_data_openbasedir.phpt CVS log

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

Annotation of embedaddon/php/ext/mysql/tests/mysql_query_load_data_openbasedir.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: LOAD DATA INFILE - open_basedir
        !             3: --SKIPIF--
        !             4: <?php
        !             5: @include_once("connect.inc");
        !             6: 
        !             7: if (!isset($db)) {
        !             8:   die("skip open_basedir setting prevents inclusing of required files");
        !             9: }
        !            10: 
        !            11: include_once('skipif.inc');
        !            12: include_once('skipifconnectfailure.inc');
        !            13: 
        !            14: 
        !            15: if (!$IS_MYSQLND)
        !            16:        die("skip mysqlnd only, libmysql does not know about open_basedir restrictions");
        !            17: 
        !            18: if (file_exists('./simple.csv') && !unlink('./simple.csv'))
        !            19:        die("skip Cannot remove previous CSV file");
        !            20: 
        !            21: if (!$fp = fopen('./simple.csv', 'w'))
        !            22:        die("skip Cannot create test CSV file");
        !            23: 
        !            24: fclose($fp);
        !            25: @unlink('./simple.csv');
        !            26: 
        !            27: if ($socket == "" && $host != NULL && $host != 'localhost' && $host != '.') {
        !            28:        /* could be a remote TCP/IP connection. LOCAL INFILE may not work */
        !            29:        if (gethostbyaddr($host) != gethostname()) {
        !            30:                die("skip LOAD DATA LOCAL INFILE will fail if connecting to remote MySQL");
        !            31:        }
        !            32: }
        !            33: ?>
        !            34: --INI--
        !            35: open_basedir="."
        !            36: --FILE--
        !            37: <?php
        !            38: @include_once("connect.inc");
        !            39: 
        !            40: if (!isset($db)) {
        !            41:        // run-tests, I love you for not allowing me to set ini settings dynamically
        !            42:        print "[006] [1148] The used command is not allowed with this MySQL version
        !            43: [007] [0]
        !            44: [008] LOAD DATA not run?
        !            45: [010] [1148] The used command is not allowed with this MySQL version
        !            46: done!";
        !            47:        die();
        !            48: }
        !            49: require('table.inc');
        !            50: mysql_close($link);
        !            51: if ($socket)
        !            52:        $host = sprintf("%s:%s", $host, $socket);
        !            53: else if ($port)
        !            54:        $host = sprintf("%s:%s", $host, $port);
        !            55: 
        !            56: if (!$link = mysql_connect($host, $user, $passwd, true, 128)) {
        !            57:        printf("[001] Cannot connect using host '%s', user '%s', password '****', [%d] %s\n",
        !            58:                $host, $user, $passwd,
        !            59:                mysql_errno(), mysql_error());
        !            60: }
        !            61: 
        !            62: if (!mysql_select_db($db, $link)) {
        !            63:        printf("[002] [%d] %s\n", mysql_errno($link), mysql_error($link));
        !            64: }
        !            65: 
        !            66: if (file_exists('./simple.csv'))
        !            67:        unlink('./simple.csv');
        !            68: 
        !            69: if (!$fp = fopen('./simple.csv', 'w'))
        !            70:        printf("[003] Cannot open CSV file\n");
        !            71: 
        !            72: if (version_compare(PHP_VERSION, '5.9.9', '>') >= 0) {
        !            73:        if (!fwrite($fp, (binary)"'97';'x';\n") ||
        !            74:                !fwrite($fp, (binary)"'98';'y';\n") ||
        !            75:                !fwrite($fp, (binary)"99;'z';\n")) {
        !            76:                printf("[004] Cannot write CVS file '%s'\n", $file);
        !            77:        }
        !            78: } else {
        !            79:        if (!fwrite($fp, "97;'x';\n") ||
        !            80:                !fwrite($fp, "98;'y';\n") ||
        !            81:                !fwrite($fp, "99;'z';\n")) {
        !            82:                printf("[005] Cannot write CVS file '%s'\n", $file);
        !            83:        }
        !            84: }
        !            85: fclose($fp);
        !            86: 
        !            87: $sql = sprintf("LOAD DATA LOCAL INFILE '%s'
        !            88:                        INTO TABLE test
        !            89:                        FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '\''
        !            90:                        LINES TERMINATED BY '\n'",
        !            91:                        mysql_real_escape_string(realpath('./simple.csv'), $link));
        !            92: 
        !            93: if (!mysql_query($sql, $link))
        !            94:        printf("[006] [%d] %s\n", mysql_errno($link), mysql_error($link));
        !            95: 
        !            96: if (!($res = mysql_query('SELECT label FROM test WHERE id = 97', $link)) ||
        !            97:                !($row = mysql_fetch_assoc($res)) ||
        !            98:                !mysql_free_result($res))
        !            99:        printf("[007] [%d] '%s'\n", mysql_errno($link), mysql_error($link));
        !           100: 
        !           101: if ($row['label'] != "x")
        !           102:        printf("[008] LOAD DATA not run?\n");
        !           103: 
        !           104: if (!mysql_query('DELETE FROM test', $link))
        !           105:        printf("[009] [%d] %s\n", mysql_errno($link), mysql_error($link));
        !           106: 
        !           107: $sql = "LOAD DATA LOCAL INFILE '/tmp/idonotexist'
        !           108:                        INTO TABLE test
        !           109:                        FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '\''
        !           110:                        LINES TERMINATED BY '\n'";
        !           111: 
        !           112: if (!mysql_query($sql, $link))
        !           113:        printf("[010] [%d] %s\n", mysql_errno($link), mysql_error($link));
        !           114: 
        !           115: mysql_close($link);
        !           116: unlink("./simple.csv");
        !           117: 
        !           118: print "done!";
        !           119: ?>
        !           120: --EXPECTF--
        !           121: [006] [1148] %s
        !           122: [007] [0] ''
        !           123: [008] LOAD DATA not run?
        !           124: [010] [1148] %s
        !           125: done!