protected function Tasks::connect in Drupal driver for SQL Server and SQL Azure 8

Same name and namespace in other branches

1. 8.2 drivers/lib/Drupal/Driver/Database/sqlsrv/Install/Tasks.php \Drupal\Driver\Database\sqlsrv\Install\Tasks::connect()
2. 3.0.x drivers/lib/Drupal/Driver/Database/sqlsrv/Install/Tasks.php \Drupal\Driver\Database\sqlsrv\Install\Tasks::connect()

Check if we can connect to the database.

Overrides Tasks::connect

File

drivers/lib/Drupal/Driver/Database/sqlsrv/Install/Tasks.php, line 62

Definition of Drupal\Driver\Database\sqlsrv\Tasks

Class

Tasks

Specifies installation tasks for PostgreSQL databases.

Namespace

Drupal\Driver\Database\sqlsrv\Install

Code

protected function connect() {
  try {

    // This doesn't actually test the connection.
    db_set_active();

    // Now actually do a check.
    Database::getConnection();
    $this
      ->pass('Drupal can CONNECT to the database ok.');
  } catch (\Exception $e) {

    // Attempt to create the database if it is not found.
    if ($e
      ->getCode() == Connection::DATABASE_NOT_FOUND) {

      // Remove the database string from connection info.
      $connection_info = Database::getConnectionInfo();
      $database = $connection_info['default']['database'];
      unset($connection_info['default']['database']);

      // In order to change the Database::$databaseInfo array, need to remove
      // the active connection, then re-add it with the new info.
      Database::removeConnection('default');
      Database::addConnectionInfo('default', 'default', $connection_info['default']);
      try {

        // Now, attempt the connection again; if it's successful, attempt to
        // create the database.
        Database::getConnection()
          ->createDatabase($database);
        Database::closeConnection();

        // Now, restore the database config.
        Database::removeConnection('default');
        $connection_info['default']['database'] = $database;
        Database::addConnectionInfo('default', 'default', $connection_info['default']);

        // Check the database connection.
        Database::getConnection();
        $this
          ->pass('Drupal can CONNECT to the database ok.');
      } catch (DatabaseNotFoundException $e) {

        // Still no dice; probably a permission issue. Raise the error to the
        // installer.
        $this
          ->fail(t('Database %database not found. The server reports the following message when attempting to create the database: %error.', array(
          '%database' => $database,
          '%error' => $e
            ->getMessage(),
        )));
        return FALSE;
      } catch (\PDOException $e) {

        // Still no dice; probably a permission issue. Raise the error to the
        // installer.
        $this
          ->fail(t('Database %database not found. The server reports the following message when attempting to create the database: %error.', array(
          '%database' => $database,
          '%error' => $e
            ->getMessage(),
        )));
        return FALSE;
      }
    }
    else {

      // Database connection failed for some other reason than the database
      // not existing.
      $this
        ->fail(t('Failed to connect to your database server. The server reports the following message: %error.<ul><li>Is the database server running?</li><li>Does the database exist, and have you entered the correct database name?</li><li>Have you entered the correct username and password?</li><li>Have you entered the correct database hostname?</li></ul>', array(
        '%error' => $e
          ->getMessage(),
      )));
      return FALSE;
    }
  }
  return TRUE;
}