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

mnet broken for mssql and oracle

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.4.7, 2.5.3, 2.6
    • Fix Version/s: 2.6.3
    • Component/s: MNet
    • Labels:
    • Database:
      MySQL, PostgreSQL, Microsoft SQL, Oracle
    • Testing Instructions:
      Hide

      Repeat this with a MNet server running on Oracle, MS-SQL, MySQL And PostgreSQL

      1. Install Oracle and MS-SQL or use VirtualBox and configure network connections so your Moodle instances can communicate with your Oracle/MS-SQL servers.
      2. Enable PHP support for Oracle and MS-SQL servers and make sure if it's working.
      3. Setup moodle instances for each database (Oracle/MS-SQL).
      4. Create MNET connection between your client/server using the Moodle MNET docs: http://docs.moodle.org/en/MNet
        Your client instance could be MySQL or PostgreSQL but the server should be Oracle/MS-SQL.
        (Both instances could be in the same machine)
      5. Add Network Servers block and check if the server is avaiable.
        (If your install is working you will be able to see the Oracle server in the list)
      6. Click on the server link and will be redirected to your server instance. You should see your server moodle homepage without any error. (see attachment FIXED.png)

      Run the cron.php file and see if display errors
      /usr/bin/php admin/cli/cron.php

      Show
      Repeat this with a MNet server running on Oracle, MS-SQL, MySQL And PostgreSQL Install Oracle and MS-SQL or use VirtualBox and configure network connections so your Moodle instances can communicate with your Oracle/MS-SQL servers. Enable PHP support for Oracle and MS-SQL servers and make sure if it's working. Setup moodle instances for each database (Oracle/MS-SQL). Create MNET connection between your client/server using the Moodle MNET docs: http://docs.moodle.org/en/MNet Your client instance could be MySQL or PostgreSQL but the server should be Oracle/MS-SQL. (Both instances could be in the same machine) Add Network Servers block and check if the server is avaiable. (If your install is working you will be able to see the Oracle server in the list) Click on the server link and will be redirected to your server instance. You should see your server moodle homepage without any error. (see attachment FIXED.png) Run the cron.php file and see if display errors /usr/bin/php admin/cli/cron.php
    • Affected Branches:
      MOODLE_24_STABLE, MOODLE_25_STABLE, MOODLE_26_STABLE
    • Fixed Branches:
      MOODLE_26_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      MDL-42956-master
    • Story Points:
      13
    • Sprint:
      BACKEND Sprint 12

      Description

      While looking for other recent problems it was detected that mnet auth is using a harcoded LIMIT clause. That automatically means both mssql/sqlsrv/oracle are crashing there:

      https://github.com/moodle/moodle/blob/master/auth/mnet/auth.php#L779

      It's there since ages ago, so needs fixing in all supported versions.

      Ciao

        Attachments

        1. FIXED.png
          FIXED.png
          109 kB
        2. MNET.png
          MNET.png
          152 kB
        3. MNET error 2.png
          MNET error 2.png
          134 kB

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                12/May/14