Moodle

Sync external database doesn't work

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Critical Critical
  • Resolution: Fixed
  • Affects Version/s: 2.0
  • Fix Version/s: 2.0
  • Component/s: Authentication
  • Labels:
    None
  • Environment:
    LAMP
    External database: Oracle
  • Database:
    MySQL, Oracle
  • Affected Branches:
    MOODLE_20_STABLE
  • Fixed Branches:
    MOODLE_20_STABLE

Description

Fixing MDL-15175, I found out that the external database synchro doesn't work.
I run in a console: /usr/bin/php -c /etc/php5/cli/php.ini /home/jerome/Projects/Moodle_HEAD/moodle/auth/db/auth_db_sync_users.php

HTML text are displayed in the console. Nothing should be displayed. Users from my external database should be inserted/updated into my Moodle database. They are not.

Here the HTML text:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en" xml:lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="http://jerome.moodle.com/Moodle_HEAD/moodle/theme/standard/styles.php" />
<link rel="stylesheet" type="text/css" href="http://jerome.moodle.com/Moodle_HEAD/moodle/theme/standardwhite/styles.php" />
<meta http-equiv="refresh" content="5; url=http://jerome.moodle.com/home/jerome/Projects/Moodle_HEAD/moodle/auth/db/auth_db_sync_users.php" />
<!--[if IE 7]>
<link rel="stylesheet" type="text/css" href="http://jerome.moodle.com/Moodle_HEAD/moodle/theme/standard/styles_ie7.css" />
<![endif]-->
<!--[if IE 6]>
<link rel="stylesheet" type="text/css" href="http://jerome.moodle.com/Moodle_HEAD/moodle/theme/standard/styles_ie6.css" />
<![endif]-->

<meta name="keywords" content="moodle, " />
<title></title>
<link rel="shortcut icon" href="http://jerome.moodle.com/Moodle_HEAD/moodle/theme/standardwhite/favicon.ico" />
<script type="text/javascript" src="http://jerome.moodle.com/Moodle_HEAD/moodle/lib/editor/tinymce/jscripts/tiny_mce/tiny_mce.js"></script>
<script type="text/javascript" src="http://jerome.moodle.com/Moodle_HEAD/moodle/lib/editor/tinymce.js.php?course=1&editorlanguage=en_utf8"></script>
<Unable to render embedded object: File (--<style type="text/css">/*<) not found.[CDATA[*/ body{behavior:url(http://jerome.moodle.com/Moodle_HEAD/moodle/lib/csshover.htc);} /*]]>*/</style>-->

<script type="text/javascript" src="http://jerome.moodle.com/Moodle_HEAD/moodle/lib/javascript-static.js"></script>
<script type="text/javascript" src="http://jerome.moodle.com/Moodle_HEAD/moodle/lib/javascript-mod.php"></script>
<script type="text/javascript" src="http://jerome.moodle.com/Moodle_HEAD/moodle/lib/overlib/overlib.js"></script>
<script type="text/javascript" src="http://jerome.moodle.com/Moodle_HEAD/moodle/lib/overlib/overlib_cssstyle.js"></script>
<script type="text/javascript" src="http://jerome.moodle.com/Moodle_HEAD/moodle/lib/cookies.js"></script>
<script type="text/javascript" src="http://jerome.moodle.com/Moodle_HEAD/moodle/lib/ufo.js"></script>
<script type="text/javascript" src="http://jerome.moodle.com/Moodle_HEAD/moodle/lib/dropdown.js"></script>

<script type="text/javascript" defer="defer">
//<![CDATA[
setTimeout('fix_column_widths()', 20);
//]]>
</script>
<script type="text/javascript">
//<![CDATA[
function openpopup(url,name,options,fullscreen) {
fullurl = "http://jerome.moodle.com/Moodle_HEAD/moodle" + url;
windowobj = window.open(fullurl,name,options);
if (fullscreen) { windowobj.moveTo(0,0); windowobj.resizeTo(screen.availWidth,screen.availHeight); }
windowobj.focus();
return false;
}

function uncheckall() {
void(d=document);
void(el=d.getElementsByTagName('INPUT'));
for(i=0;i<el.length;i++) { void(el[i].checked=0); }
}

function checkall() {
void(d=document);
void(el=d.getElementsByTagName('INPUT'));
for(i=0;i<el.length;i++) { void(el[i].checked=1); }
}

function inserttext(text) {
if(!opener.document.forms['theform']){ return; } text = ' ' + text + ' ';
if ( opener.document.forms['theform'].message.createTextRange && opener.document.forms['theform'].message.caretPos) { var caretPos = opener.document.forms['theform'].message.caretPos; caretPos.text = caretPos.text.charAt(caretPos.text.length - 1) == ' ' ? text + ' ' : text; } else { opener.document.forms['theform'].message.value += text; }
opener.document.forms['theform'].message.focus();
}

function getElementsByClassName(oElm, strTagName, oClassNames){
var arrElements = (strTagName == "*" && oElm.all)? oElm.all : oElm.getElementsByTagName(strTagName);
var arrReturnElements = new Array();
var arrRegExpClassNames = new Array();
if(typeof oClassNames == "object"){
for(var i=0; i<oClassNames.length; i++){ arrRegExpClassNames.push(new RegExp("(^|\\s)" + oClassNames[i].replace(/\-/g, "\\-") + "(\\s|$)")); }
}
else{ arrRegExpClassNames.push(new RegExp("(^|\\s)" + oClassNames.replace(/\-/g, "\\-") + "(\\s|$)")); }
var oElement;
var bMatchesAll;
for(var j=0; j<arrElements.length; j++){
oElement = arrElements[j];
bMatchesAll = true;
for(var k=0; k<arrRegExpClassNames.length; k++){
if(!arrRegExpClassNames[k].test(oElement.className)){ bMatchesAll = false; break; }
}
if(bMatchesAll){ arrReturnElements.push(oElement); }
}
return (arrReturnElements)
}
var id2suffix = {};
//]]>
</script>
</head>

<body class="http:-jerome.moodle.com-home-jerome-Projects-Moodle_HEAD-moodle-auth-db course-1 notloggedin dir-ltr lang-en_utf8" id="http:-jerome.moodle.com-home-jerome-Projects-Moodle_HEAD-moodle-auth-db-auth_db_sync_users">

<div id="page">

<!-- END OF HEADER -->
<div id="content" class=" clearfix"><div id="redirect"><div id="message">A server error that affects your login session was detected. Please login again or restart your browser.</div><div id="continue">( <a href="http://jerome.moodle.com/home/jerome/Projects/Moodle_HEAD/moodle/auth/db/auth_db_sync_users.php">Continue</a> )</div></div><script type="text/javascript">
//<![CDATA[

function redirect() { document.location.replace('http://jerome.moodle.com/home/jerome/Projects/Moodle_HEAD/moodle/auth/db/auth_db_sync_users.php'); }
setTimeout("redirect()", 8000);
//]]>
</script>
</div><div id="footer"><hr /><p class="helplink"></p> <div class="validators"><ul>
<li><a href="http://validator.w3.org/check?verbose=1&ss=1&uri=http%3A%2F%2Fjerome.moodle.com%2Fhome%2Fjerome%2FProjects%2FMoodle_HEAD%2Fmoodle%2Fauth%2Fdb%2Fauth_db_sync_users.php">Validate HTML</a></li>
<li><a href="http://www.contentquality.com/mynewtester/cynthia.exe?rptmode=-1&url1=http%3A%2F%2Fjerome.moodle.com%2Fhome%2Fjerome%2FProjects%2FMoodle_HEAD%2Fmoodle%2Fauth%2Fdb%2Fauth_db_sync_users.php">Section 508 Check</a></li>
<li><a href="http://www.contentquality.com/mynewtester/cynthia.exe?rptmode=0&warnp2n3e=1&url1=http%3A%2F%2Fjerome.moodle.com%2Fhome%2Fjerome%2FProjects%2FMoodle_HEAD%2Fmoodle%2Fauth%2Fdb%2Fauth_db_sync_users.php">WCAG 1 (2,3) Check</a></li>
</ul></div>
</div>
</div>
</body>
</html>

Activity

Hide
Permalink
Petr Škoda (skodak) added a comment -

Works fine for me now, closing,
thank you for the report.

Petr Skoda

Show
Petr Škoda (skodak) added a comment - Works fine for me now, closing, thank you for the report. Petr Skoda

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.