Annotation of embedaddon/php/ext/mysql/tests/mysql_pconn_max_links.phpt, revision 1.1
1.1 ! misho 1: --TEST--
! 2: Persistent connections and mysql.max_persistent
! 3: --SKIPIF--
! 4: <?php
! 5: require_once('skipif.inc');
! 6: require_once('skipifconnectfailure.inc');
! 7: require_once('table.inc');
! 8:
! 9: if ($socket)
! 10: $host = sprintf("%s:%s", $host, $socket);
! 11: else if ($port)
! 12: $host = sprintf("%s:%s", $host, $port);
! 13:
! 14: // we need a second DB user to test for a possible flaw in the ext/mysql[i] code
! 15: if (!$link = mysql_connect($host, $user, $passwd, true))
! 16: die(sprintf("skip Cannot connect [%d] %s", mysql_errno(), mysql_error()));
! 17:
! 18: if (!mysql_select_db($db, $link))
! 19: die(sprintf("skip [%d] %s", mysql_errno($link), mysql_error($link)));
! 20:
! 21: if (!$res = mysql_query('SHOW VARIABLES LIKE "old_passwords"', $link)) {
! 22: die(sprintf("skip [%d] %s", mysql_errno($link), mysql_error($link)));
! 23: }
! 24:
! 25: if (mysql_num_rows($res) != 1) {
! 26: die(sprintf("skip Can't check if old_passwords = ON"));
! 27: }
! 28:
! 29: $row = mysql_fetch_assoc($res);
! 30: mysql_free_result($res);
! 31: if ($row['Value'] == "ON")
! 32: die(sprintf("skip Test will fail because old_passwords = ON. Hint: old passwords are insecure!"));
! 33:
! 34: if (!$res = mysql_query("SELECT CURRENT_USER() AS _user", $link))
! 35: die(sprintf("skip [%d] %s", mysql_errno($link), mysql_error($link)));
! 36:
! 37: $row = mysql_fetch_assoc($res);
! 38: mysql_free_result($res);
! 39: $host = substr($row['_user'], strrpos($row['_user'], "@") + 1, strlen($row['_user']));
! 40:
! 41: mysql_query('DROP USER pcontest', $link);
! 42: mysql_query(sprintf('DROP USER pcontest@"%s"', mysql_real_escape_string($host, $link)), $link);
! 43: if (!mysql_query(sprintf('CREATE USER pcontest@"%s" IDENTIFIED BY "pcontest"', mysql_real_escape_string($host, $link)), $link)) {
! 44: printf("skip Cannot create second DB user [%d] %s", mysql_errno($link), mysql_error($link));
! 45: mysql_close($link);
! 46: die();
! 47: }
! 48:
! 49: // we might be able to specify the host using CURRENT_USER(), but...
! 50: if (!mysql_query(sprintf('GRANT SELECT ON TABLE %s.test TO pcontest@"%s"', $db, mysql_real_escape_string($host, $link)), $link)) {
! 51: printf("skip Cannot GRANT SELECT to second DB user [%d] %s", mysql_errno($link), mysql_error($link));
! 52: mysql_query(sprintf('REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest@"%s"', mysql_real_escape_string($host, $link)), $link);
! 53: mysql_query(sprintf('DROP USER pcontest@"%s"', mysql_real_escape_string($host, $link)), $link);
! 54: mysql_close($link);
! 55: die();
! 56: }
! 57:
! 58: mysql_close($link);
! 59: ?>
! 60: --INI--
! 61: mysql.max_links=3
! 62: mysql.max_persistent=2
! 63: mysql.allow_persistent=1
! 64: --FILE--
! 65: <?php
! 66: require_once("connect.inc");
! 67: require_once('table.inc');
! 68:
! 69: if ($socket)
! 70: $host = sprintf("%s:%s", $host, $socket);
! 71: else if ($port)
! 72: $host = sprintf("%s:%s", $host, $port);
! 73:
! 74: if (!$plink = mysql_pconnect($host, $user, $passwd))
! 75: printf("[001] Cannot connect using the second DB user created during SKIPIF, [%d] %s\n",
! 76: mysql_errno(), mysql_error());
! 77:
! 78: if (!mysql_select_db($db, $plink))
! 79: printf("[002] [%d] %s\n", mysql_errno($plink), mysql_error($plink));
! 80:
! 81: ob_start();
! 82: phpinfo();
! 83: $phpinfo = strip_tags(ob_get_contents());
! 84: ob_end_clean();
! 85: $phpinfo = substr($phpinfo, strpos($phpinfo, 'MySQL Support => enabled'), 500);
! 86: if (!preg_match('@Active Persistent Links\s+=>\s+(\d+)@ismU', $phpinfo, $matches))
! 87: printf("[003] Cannot get # active persistent links from phpinfo()");
! 88: $num_plinks = $matches[1];
! 89:
! 90: if (!$res = mysql_query('SELECT id, label FROM test WHERE id = 1', $plink))
! 91: printf("[004] Cannot run query on persistent connection of second DB user, [%d] %s\n",
! 92: mysql_errno($plink), mysql_error($plink));
! 93:
! 94: if (!$row = mysql_fetch_assoc($res))
! 95: printf("[005] Cannot run fetch result, [%d] %s\n",
! 96: mysql_errno($plink), mysql_error($plink));
! 97: mysql_free_result($res);
! 98: var_dump($row);
! 99:
! 100: // change the password for the second DB user and kill the persistent connection
! 101: if (!$res = mysql_query("SELECT CURRENT_USER() AS _user", $link))
! 102: printf("[006] [%d] %s", mysql_errno($link), mysql_error($link));
! 103:
! 104: $row = mysql_fetch_assoc($res);
! 105: mysql_free_result($res);
! 106: $host = substr($row['_user'], strrpos($row['_user'], "@") + 1, strlen($row['_user']));
! 107:
! 108: $sql = sprintf('SET PASSWORD FOR pcontest@"%s" = PASSWORD("newpass")', mysql_real_escape_string($host, $link));
! 109: if (!mysql_query($sql, $link))
! 110: printf("[007] Cannot change PW of second DB user, [%d] %s\n", mysql_errno($link), mysql_error($link));
! 111:
! 112: // persistent connections cannot be closed but only be killed
! 113: $pthread_id = mysql_thread_id($plink);
! 114: if (!mysql_query(sprintf('KILL %d', $pthread_id), $link))
! 115: printf("[008] Cannot KILL persistent connection of second DB user, [%d] %s\n", mysql_errno($link), mysql_error($link));
! 116: // give the server a second to really kill the thread
! 117: sleep(1);
! 118:
! 119: if (!$res = mysql_query("SHOW FULL PROCESSLIST", $link))
! 120: printf("[009] [%d] %s\n", mysql_errno($link), mysql_error($link));
! 121:
! 122: $running_threads = array();
! 123: while ($row = mysql_fetch_assoc($res))
! 124: $running_threads[$row['Id']] = $row;
! 125: mysql_free_result($res);
! 126:
! 127: if (isset($running_threads[$pthread_id]))
! 128: printf("[010] Persistent connection has not been killed\n");
! 129:
! 130: // we might get the old handle
! 131: if ($plink = @mysql_pconnect($host, 'pcontest', 'pcontest'))
! 132: printf("[011] Can connect using the old password, [%d] %s\n",
! 133: mysql_errno(), mysql_error());
! 134:
! 135: ob_start();
! 136: phpinfo();
! 137: $phpinfo = strip_tags(ob_get_contents());
! 138: ob_end_clean();
! 139: $phpinfo = substr($phpinfo, strpos($phpinfo, 'MySQL Support => enabled'), 500);
! 140: if (!preg_match('@Active Persistent Links\s+=>\s+(\d+)@ismU', $phpinfo, $matches))
! 141: printf("[012] Cannot get # active persistent links from phpinfo()\n");
! 142:
! 143: $num_plinks_kill = $matches[1];
! 144: if ($num_plinks_kill > $num_plinks)
! 145: printf("[013] Statistics seems to be wrong, got %d active persistent links, expecting < %d links\n",
! 146: $num_plinks_kill, $num_plinks);
! 147:
! 148: // The first connection has been closed, the last pconnect() was unable to connect -> no connection open
! 149: // We must be able to connect because max_persistent limit has not been reached
! 150: if (!$plink = mysql_pconnect($host, 'pcontest', 'newpass'))
! 151: die(sprintf("[014] Cannot connect using the second DB, [%d] %s\n",
! 152: mysql_errno(), mysql_error()));
! 153:
! 154: if (!mysql_select_db($db, $plink))
! 155: printf("[015] [%d] %s\n", mysql_errno($plink), mysql_error($plink));
! 156:
! 157: if (!$res = mysql_query('SELECT id, label FROM test WHERE id = 1', $plink))
! 158: printf("[016] Cannot run query on persistent connection of second DB user, [%d] %s\n",
! 159: mysql_errno($plink), mysql_error($plink));
! 160:
! 161: if (!$row = mysql_fetch_assoc($res))
! 162: printf("[017] Cannot run fetch result, [%d] %s\n",
! 163: mysql_errno($plink), mysql_error($plink));
! 164: mysql_free_result($res);
! 165: var_dump($row);
! 166:
! 167: mysql_query(sprintf('REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest@"%s"', mysql_real_escape_string($host, $link)), $link);
! 168: mysql_query(sprintf('DROP USER pcontest@"%s"', mysql_real_escape_string($host, $link)), $link);
! 169: mysql_close($link);
! 170: print "done!";
! 171: ?>
! 172: --CLEAN--
! 173: <?php
! 174: // connect + select_db
! 175: require_once("connect.inc");
! 176: if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) {
! 177: printf("[c001] Cannot connect to the server using host=%s/%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
! 178: $host, $myhost, $user, $db, $port, $socket);
! 179: }
! 180:
! 181: if (!$res = mysql_query("SELECT CURRENT_USER() AS _user", $link))
! 182: printf("[c002] [%d] %s", mysql_errno($link), mysql_error($link));
! 183:
! 184: $row = mysql_fetch_assoc($res);
! 185: mysql_free_result($res);
! 186: $host = substr($row['_user'], strrpos($row['_user'], "@") + 1, strlen($row['_user']));
! 187:
! 188: @mysql_query(sprintf('REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest@"%s"', mysql_real_escape_string($host, $link)), $link);
! 189: @mysql_query(sprintf('DROP USER pcontest@"%s"', mysql_real_escape_string($host, $link)), $link);
! 190:
! 191: mysql_close($link);
! 192: ?>
! 193: --EXPECTF--
! 194: array(2) {
! 195: [%u|b%"id"]=>
! 196: %unicode|string%(1) "1"
! 197: [%u|b%"label"]=>
! 198: %unicode|string%(1) "a"
! 199: }
! 200: array(2) {
! 201: [%u|b%"id"]=>
! 202: %unicode|string%(1) "1"
! 203: [%u|b%"label"]=>
! 204: %unicode|string%(1) "a"
! 205: }
! 206: done!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>
![[BACK]](/icons/cvsweb/back.gif){kind=icon}
Return to mysql_pconn_max_links.phpt CVS log ![[TXT]](/icons/cvsweb/text.gif){kind=icon}
![[DIR]](/icons/cvsweb/dir.gif){kind=icon}
Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / mysql / tests