Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-40490

Database connection error MS SQL

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 2.6
    • 2.6
    • Database SQL/XMLDB
    • None
    • MOODLE_26_STABLE
    • MOODLE_26_STABLE
    • wip-MDL-40490-master
    • Hide

      Prerequisite

      • This test needs to be run on an ms sql database with the mssql driver.

      Testing

      1. Do a fresh web based install of the master branch.
      2. Make sure that when choosing the database driver, to select SQL * Server FreeTDS (native/mssql)
      3. With the database settings try:
        • One installation with "Database port" left blank.
        • One installation with "Database port" set to the default port (1466 on the moodle server here, but 1433 by default).

      Make sure that each installation proceeds with no database connection error occurring when your settings are correct

      Show
      Prerequisite This test needs to be run on an ms sql database with the mssql driver. Testing Do a fresh web based install of the master branch. Make sure that when choosing the database driver, to select SQL * Server FreeTDS (native/mssql) With the database settings try: One installation with "Database port" left blank. One installation with "Database port" set to the default port (1466 on the moodle server here, but 1433 by default). Make sure that each installation proceeds with no database connection error occurring when your settings are correct

      Doing a fresh install of moodle master with MSSQL will result in a Database connection error.
      The addition of a database port and unix socket on the configuration page, means that the settings are now set with no information and the dbhost gets a colon appended with no port settings. This will cause the connection error.

            abgreeve Adrian Greeve
            abgreeve Adrian Greeve
            Petr Skoda Petr Skoda
            Damyon Wiese Damyon Wiese
            Michael de Raadt Michael de Raadt
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.