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

mnet broken for mssql and oracle

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 2.4.7, 2.5.3, 2.6
    • 2.6.3
    • MNet
    • MySQL, PostgreSQL, Microsoft SQL, Oracle
    • MOODLE_24_STABLE, MOODLE_25_STABLE, MOODLE_26_STABLE
    • MOODLE_26_STABLE
    • MDL-42956-master
    • 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
    • 13
    • 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

            lameze Simey Lameze
            stronk7 Eloy Lafuente (stronk7)
            Ankit Agarwal Ankit Agarwal
            Dan Poltawski Dan Poltawski
            Rajesh Taneja Rajesh Taneja
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              12/May/14