← Back to team overview

mahara-contributors team mailing list archive

[Bug 1247715] A change has been merged

 

Reviewed:  https://reviews.mahara.org/2688
Committed: http://gitorious.org/mahara/mahara/commit/7abb6793af0d42efc2059ba4651cd596b441e463
Submitter: Robert Lyon (robertl@xxxxxxxxxxxxxxx)
Branch:    master

commit 7abb6793af0d42efc2059ba4651cd596b441e463
Author: Aaron Wells <aaronw@xxxxxxxxxxxxxxx>
Date:   Wed Nov 6 15:07:55 2013 +1300

Pass the $CFG->dbport to ADODB separately from the hostname

Bug1247715: The mysqli driver doesn't support sending "hostname:port" but it and
the others do support setting a $db->port field manually.

Change-Id: I4f145d8a424717dbb9bed53f78cfc01f521c9dae

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1247715

Title:
  Upgrade to 1.8.0 fails - can't connect to mysql

Status in Mahara ePortfolio:
  Confirmed

Bug description:
  After upgrading to 1.8.0 I couldn't open the admin/upgrade.php page.
  The error displayed stated that mahara could not connect to the mysql
  db. Running on Ubuntu LTS Server.

  After some poking around I managed to get things running by altering
  the code in init.php.

  The new code read:

      // Transform $CFG->dbtype into the name of the ADODB driver we will use
      if (is_postgres()) {
          $CFG->dbtype = 'postgres7';
      }
      else if (is_mysql()) {
          // If they have mysqli, use it. Otherwise, fall back to the older "mysql" extension.
          if (extension_loaded('mysqli')) {
              $CFG->dbtype = 'mysqli';
          }
          else {
              $CFG->dbtype = 'mysql';
          }
      }

  I replace this with:

      // Transform $CFG->dbtype into the name of the ADODB driver we will use
      if (is_postgres()) {
          $CFG->dbtype = 'postgres7';
      }
      else if (is_mysql()) {
          // If they have mysqli, use it. Otherwise, fall back to the older "mysql" extension.
          //if (extension_loaded('mysqli')) {
          //    $CFG->dbtype = 'mysqli';
          //}
          //else {
          //    $CFG->dbtype = 'mysql';
          //}
          $CFG->dbtype = 'mysql';
      }

  I also receive the error:

  The mysqli PHP extension is not installed on your server. Thus, Mahara
  is falling back to the deprecated original mysql PHP extension. We
  recommend installing mysqli. Trouble is that fallback doesn't seem to
  be working at all.

  Fact is mysqli is  included with php5-mysql in ubuntu. Mahara doesn't
  seem to see that. Maybe the code that is suppose to detect that in
  init.php blocks connection to the server, stopping mahara from running
  at all.

  This does not happen in 1.7.x.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1247715/+subscriptions


References