Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 1.9.3, 2.0
-
Component/s: MNet
-
Labels:None
-
Environment:Ubuntu 8.04.1
mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486)
PHP 5.2.4-2ubuntu5.3 with Suhosin-Patch 0.9.6.2 (cli) (built: Jul 23 2008 06:44:49)
-
Database:MySQL
-
Difficulty:Moderate
-
Affected Branches:MOODLE_19_STABLE, MOODLE_20_STABLE
-
Fixed Branches:MOODLE_19_STABLE, MOODLE_20_STABLE
Description
Integration BTW Moodle 1.9.3+ (2007101533.01) and Mahara 1.0.8 works fine with https & postgresql, but https & mysql is broken. The reason appears to be that neither app is able to store port 443 in mysql.
Database install.xml version 20081010 says:
<FIELD NAME="portno" TYPE="int" LENGTH="2" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="transport" NEXT="last_connect_time"/>
I recommend LENGTH="10" instead.
This is also affecting Mahara downstream; see Mahara bug #3097 ( http://eduforge.org/tracker/?func=detail&atid=739&aid=3097&group_id=176 ).
...I was testing this to be sure this was sufficient to fix the problem, but I ended up taking a guess and setting 443 manually after setting up the integration, and it still didn't work. I just gave up and will use postgresql instead.
Attachments
Issue Links
| This issue will help resolve: | ||||
| MDL-21260 | General open bugs |
|
|
|
Activity
- All
- Comments
- History
- Activity
- Source
- Test Sessions
Assigning to Nigel and addressing to 1.9.4. I guess LENGTH=5 will be enough, isn't it?
Ciao 
+1 too.
just you'll have to use actual last digit increment instead of the one present in the patch. And don't forget HEAD, a good exercise to learn the the Moodle 2.0 Way (tm too, of course)
TIA and ciao
TIA and ciao 
I should be able to provide a patch for this, I've just fixed the Mahara side.