Beispiel #1
0
 function connect()
 {
     if (strcmp($this->database_type, "oracle") == 0) {
         // do an oracle connect
     }
     if (strcmp($this->database_type, "mysql") == 0) {
         $connection = mysql_connect($this->host, $this->user, $this->pass);
         if (!$connection) {
             die("Could not connect: " . mysql_error());
         }
         if (!mysql_select_db($this->database, $connection)) {
             die("Could not select: " . mysql_error());
         }
         $this->connection = $connection;
     }
     if (strcmp($this->database_type, "drizzle") == 0) {
         $drizzle = drizzle_create();
         try {
             $this->connection = drizzle_con_add_tcp($drizzle, $this->host, $this->port, $this->user, $this->pass, $this->database, 0);
             if ($this->connection == FALSE) {
                 throw new Exception('drizzle_con_add_tcp_error');
             }
         } catch (Exception $e) {
             echo "Caught active server error exception:\n", $e->getMessage(), " ", $e->getFile(), ": Line ", $e->getLine(), "\n", $e->getTraceAsString(), "\n";
         }
     }
 }
Beispiel #2
0
function bmark_connect($database_type = 'mysql')
{
    $Data = Spyc::YAMLLoad(BMARK . 'db.yaml');
    if ($database_type == 'mysql') {
        $user = $Data['mysqld']['user'];
        $pass = $Data['mysqld']['pass'];
        $host = $Data['mysqld']['host'];
        $dbname = $Data['mysqld']['dbname'];
        // trying connect
        try {
            $dbh = mysql_connect("{$host}", "{$user}", "{$pass}");
            if ($dbh == FALSE) {
                throw new Exception('mysql_connect_error');
            }
        } catch (Exception $e) {
            echo "Caught active server error exception:\n", $e->getMessage(), " ", $e->getFile(), ": Line ", $e->getLine(), "\n", $e->getTraceAsString(), "\n";
        }
        // trying db select
        try {
            if (!mysql_select_db($dbname, $dbh)) {
                throw new Exception('mysql_select_db_eror');
            }
        } catch (Exception $e) {
            echo "({$dbname}) Caught active server error exception:\n", $e->getMessage(), " ", $e->getFile(), ": Line ", $e->getLine(), "\n", $e->getTraceAsString(), "\n";
        }
    }
    if ($database_type == 'drizzle') {
        // set connection parameters
        $host = $Data['drizzled']['host'];
        $port = $Data['drizzled']['port'];
        $user = $Data['drizzled']['user'];
        $pass = $Data['drizzled']['pass'];
        $db = $Data['drizzled']['dbname'];
        // create drizzle object
        $drizzle = drizzle_create();
        // connect to database server
        try {
            $dbh = drizzle_con_add_tcp($drizzle, $host, $port, $user, $pass, $db, 0);
            if ($dbh == FALSE) {
                throw new Exception('drizzle_con_add_tcp_error');
            }
        } catch (Exception $e) {
            echo "Caught active server error exception:\n", $e->getMessage(), " ", $e->getFile(), ": Line ", $e->getLine(), "\n", $e->getTraceAsString(), "\n";
        }
    }
    # print_r($dbh);
    return $dbh;
}
/**
 * Test database connection
 *
 * @param string $extension    'drizzle', 'mysql' or 'mysqli'
 * @param string $connect_type 'tcp' or 'socket'
 * @param string $host
 * @param string $port
 * @param string $socket
 * @param string $user
 * @param string $pass
 * @param string $error_key
 *
 * @return bool|array
 */
function test_db_connection($extension, $connect_type, $host, $port, $socket, $user, $pass = null, $error_key = 'Server')
{
    //    test_php_errormsg();
    $socket = empty($socket) || $connect_type == 'tcp' ? null : $socket;
    $port = empty($port) || $connect_type == 'socket' ? null : ':' . $port;
    $error = null;
    if ($extension == 'drizzle') {
        while (1) {
            $drizzle = @drizzle_create();
            if (!$drizzle) {
                $error = __('Could not initialize Drizzle connection library');
                break;
            }
            $conn = $socket ? @drizzle_con_add_uds($socket, $user, $pass, null, 0) : @drizzle_con_add_tcp($drizzle, $host, $port, $user, $pass, null, 0);
            if (!$conn) {
                $error = __('Could not connect to Drizzle server');
                drizzle_free($drizzle);
                break;
            }
            // connection object is set up but we have to send some query
            // to actually connect
            $res = @drizzle_query($conn, 'SELECT 1');
            if (!$res) {
                $error = __('Could not connect to Drizzle server');
            } else {
                drizzle_result_free($res);
            }
            drizzle_con_free($conn);
            drizzle_free($drizzle);
            break;
        }
    } else {
        if ($extension == 'mysql') {
            $conn = @mysql_connect($host . $socket . $port, $user, $pass);
            if (!$conn) {
                $error = __('Could not connect to MySQL server');
            } else {
                mysql_close($conn);
            }
        } else {
            $conn = @mysqli_connect($host, $user, $pass, null, $port, $socket);
            if (!$conn) {
                $error = __('Could not connect to MySQL server');
            } else {
                mysqli_close($conn);
            }
        }
    }
    //    test_php_errormsg(false);
    if (isset($php_errormsg)) {
        $error .= " - {$php_errormsg}";
    }
    return is_null($error) ? true : array($error_key => $error);
}
 /**
  * Test database connection
  *
  * @param string $connect_type 'tcp' or 'socket'
  * @param string $host         host name
  * @param string $port         tcp port to use
  * @param string $socket       socket to use
  * @param string $user         username to use
  * @param string $pass         password to use
  * @param string $error_key    key to use in return array
  *
  * @return bool|array
  */
 public static function testDBConnection($connect_type, $host, $port, $socket, $user, $pass = null, $error_key = 'Server')
 {
     //    static::testPHPErrorMsg();
     $error = null;
     if (PMA_DatabaseInterface::checkDbExtension('mysqli')) {
         $socket = empty($socket) || $connect_type == 'tcp' ? null : $socket;
         $port = empty($port) || $connect_type == 'socket' ? null : $port;
         $extension = 'mysqli';
     } else {
         $socket = empty($socket) || $connect_type == 'tcp' ? null : ':' . ($socket[0] == '/' ? '' : '/') . $socket;
         $port = empty($port) || $connect_type == 'socket' ? null : ':' . $port;
         $extension = 'mysql';
     }
     // dead code (drizzle extension)
     if ($extension == 'drizzle') {
         while (1) {
             $drizzle = @drizzle_create();
             if (!$drizzle) {
                 $error = __('Could not initialize Drizzle connection library!');
                 break;
             }
             $conn = $socket ? @drizzle_con_add_uds($socket, $user, $pass, null, 0) : @drizzle_con_add_tcp($drizzle, $host, $port, $user, $pass, null, 0);
             if (!$conn) {
                 $error = __('Could not connect to the database server!');
                 drizzle_free($drizzle);
                 break;
             }
             // connection object is set up but we have to send some query
             // to actually connect
             $res = @drizzle_query($conn, 'SELECT 1');
             if (!$res) {
                 $error = __('Could not connect to the database server!');
             } else {
                 drizzle_result_free($res);
             }
             drizzle_con_free($conn);
             drizzle_free($drizzle);
             break;
         }
     } else {
         if ($extension == 'mysql') {
             $conn = @mysql_connect($host . $port . $socket, $user, $pass);
             if (!$conn) {
                 $error = __('Could not connect to the database server!');
             } else {
                 mysql_close($conn);
             }
         } else {
             $conn = @mysqli_connect($host, $user, $pass, null, $port, $socket);
             if (!$conn) {
                 $error = __('Could not connect to the database server!');
             } else {
                 mysqli_close($conn);
             }
         }
     }
     //    static::testPHPErrorMsg(false);
     if (isset($php_errormsg)) {
         $error .= " - {$php_errormsg}";
     }
     return is_null($error) ? true : array($error_key => $error);
 }
Beispiel #5
0
 /**
  * This function opens a connection using the data source provided.
  *
  * @access public
  * @override
  * @throws Throwable_Database_Exception         indicates that there is problem with
  *                                              opening the connection
  *
  * @see http://wiki.drizzle.org/MySQL_Differences
  */
 public function open()
 {
     if (!$this->is_connected()) {
         $handle = drizzle_create();
         $host = $this->data_source->host;
         $port = $this->data_source->port;
         $database = $this->data_source->database;
         $username = $this->data_source->username;
         $password = $this->data_source->password;
         $this->resource = @drizzle_con_add_tcp($handle, $host, $port, $username, $password, $database, 0);
         if ($this->resource === FALSE) {
             throw new Throwable_Database_Exception('Message: Failed to establish connection. Reason: :reason', array(':reason' => @drizzle_error($handle)));
         }
         // "There is no CHARSET or CHARACTER SET commands, everything defaults to UTF-8."
     }
 }