summaryrefslogtreecommitdiff
path: root/ext/mysql/tests/mysql_connect.phpt
diff options
context:
space:
mode:
authorLorry Tar Creator <lorry-tar-importer@baserock.org>2013-03-14 05:42:27 +0000
committer <>2013-04-03 16:25:08 +0000
commitc4dd7a1a684490673e25aaf4fabec5df138854c4 (patch)
tree4d57c44caae4480efff02b90b9be86f44bf25409 /ext/mysql/tests/mysql_connect.phpt
downloadphp2-master.tar.gz
Imported from /home/lorry/working-area/delta_php2/php-5.4.13.tar.bz2.HEADphp-5.4.13master
Diffstat (limited to 'ext/mysql/tests/mysql_connect.phpt')
-rw-r--r--ext/mysql/tests/mysql_connect.phpt108
1 files changed, 108 insertions, 0 deletions
diff --git a/ext/mysql/tests/mysql_connect.phpt b/ext/mysql/tests/mysql_connect.phpt
new file mode 100644
index 0000000..7158248
--- /dev/null
+++ b/ext/mysql/tests/mysql_connect.phpt
@@ -0,0 +1,108 @@
+--TEST--
+mysql_connect()
+--SKIPIF--
+<?php
+require_once('skipif.inc');
+require_once('skipifconnectfailure.inc');
+?>
+--FILE--
+<?php
+include_once "connect.inc";
+
+$tmp = NULL;
+$link = NULL;
+
+// mysql_connect ( [string server [, string username [, string password [, bool new_link [, int client_flags]]]]] )
+if (NULL !== ($tmp = @mysql_connect($link, $link, $link, $link, $link, $link)))
+ printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
+
+$myhost = (is_null($socket)) ? ((is_null($port)) ? $host : $host . ':' . $port) : $host . ':' . $socket;
+if (!$link = mysql_connect($myhost, $user, $passwd, true))
+ printf("[002] Cannot connect to the server using host=%s/%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
+ $host, $myhost, $user, $db, $port, $socket);
+
+mysql_close($link);
+
+if (!$link = mysql_connect($myhost, $user, $passwd, true))
+ printf("[003] Cannot connect to the server using host=%s/%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
+ $host, $myhost, $user, $db, $port, $socket);
+
+mysql_close();
+
+if ($link = mysql_connect($myhost, $user . 'unknown_really', $passwd . 'non_empty', true))
+ printf("[004] Can connect to the server using host=%s/%s, user=%s, passwd=***non_empty, dbname=%s, port=%s, socket=%s\n",
+ $host, $myhost, $user . 'unknown_really', $db, $port, $socket);
+
+if (false !== $link)
+printf("[005] Expecting boolean/false, got %s/%s\n", gettype($link), $link);
+
+// Run the following tests without an anoynmous MySQL user and use a password for the test user!
+ini_set('mysql.default_socket', $socket);
+if (!is_null($socket)) {
+ if (!is_resource($link = mysql_connect($host, $user, $passwd, true))) {
+ printf("[006] Usage of mysql.default_socket failed\n");
+ } else {
+ mysql_close($link);
+ }
+}
+
+if (!ini_get('sql.safe_mode')) {
+
+ ini_set('mysql.default_port', $port);
+ if (!is_null($port)) {
+ if (!is_resource($link = mysql_connect($host, $user, $passwd, true))) {
+ printf("[007] Usage of mysql.default_port failed\n");
+ } else {
+ mysql_close($link);
+ }
+ }
+
+ ini_set('mysql.default_password', $passwd);
+ if (!is_resource($link = mysql_connect($myhost, $user))) {
+ printf("[008] Usage of mysql.default_password failed\n");
+ } else {
+ mysql_close($link);
+ }
+ ini_set('mysql.default_user', $user);
+ if (!is_resource($link = mysql_connect($myhost))) {
+ printf("[009] Usage of mysql.default_user failed\n");
+ } else {
+ mysql_close($link);
+ }
+
+ ini_set('mysql.default_host', $myhost);
+ if (!is_resource($link = mysql_connect())) {
+ printf("[010] Usage of mysql.default_host failed\n") ;
+ } else {
+ mysql_close($link);
+ }
+
+ if (!is_resource($link = mysql_connect()) || !is_resource($link2 = mysql_connect())) {
+ printf("[011] Usage of mysql.default_host failed\n") ;
+ } else {
+ mysql_close();
+ mysql_close($link2);
+ }
+
+ if (!stristr(PHP_OS, 'win') && !stristr(PHP_OS, 'netware')) {
+ ini_set('mysql.default_port', -1);
+ if (putenv(sprintf('MYSQL_TCP_PORT=%d', $port))) {
+ if (!is_resource($link = mysql_connect())) {
+ printf("[012] Usage of env MYSQL_TCP_PORT failed\n") ;
+ } else {
+ mysql_close($link);
+ }
+ } else if (putenv(sprintf('MYSQL_TCP_PORT=%d', $port + 1))) {
+ if (!is_resource($link = mysql_connect())) {
+ printf("[013] Usage of env MYSQL_TCP_PORT=%d should have failed\n", $port + 1) ;
+ mysql_close($link);
+ }
+ }
+ }
+}
+
+print "done!";
+?>
+--EXPECTF--
+Warning: mysql_connect(): Access denied for user '%s'@'%s' (using password: YES) in %s on line %d
+done!