<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    The user database is only created if you choose Db as authentication
    method in auth_config.<br>
    <br>
    Then, you can also manage the users through the management.php
    'users' page.<br>
    <br>
    You can also set $development to true temporarily on line 26 of
    config.php. That should give you an indication of what goes wrong
    when you export.<br>
    <br>
    Tom<br>
    <br>
    <div class="moz-cite-prefix">Op 4-5-2013 12:36, Thomas Rochford
      schreef:<br>
    </div>
    <blockquote
      cite="mid:008201ce48b3$303b1f90$90b15eb0$@jiscadvance.ac.uk"
      type="cite">
      <meta http-equiv="Content-Type" content="text/html;
        charset=ISO-8859-1">
      <meta name="Generator" content="Microsoft Word 15 (filtered
        medium)">
      <style><!--
/* Font Definitions */
@font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Consolas;
        panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif";
        color:black;
        mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:#0563C1;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:#954F72;
        text-decoration:underline;}
pre
        {mso-style-priority:99;
        mso-style-link:"HTML Preformatted Char";
        margin:0cm;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:"Courier New";
        color:black;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
        {mso-style-priority:34;
        margin-top:0cm;
        margin-right:0cm;
        margin-bottom:0cm;
        margin-left:36.0pt;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif";
        color:black;
        mso-fareast-language:EN-US;}
span.EmailStyle18
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:windowtext;}
span.HTMLPreformattedChar
        {mso-style-name:"HTML Preformatted Char";
        mso-style-priority:99;
        mso-style-link:"HTML Preformatted";
        font-family:"Consolas","serif";
        color:black;
        mso-fareast-language:EN-US;}
span.EmailStyle21
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
        {page:WordSection1;}
/* List Definitions */
@list l0
        {mso-list-id:1013261970;
        mso-list-type:hybrid;
        mso-list-template-ids:771137760 134807569 134807577 134807579 134807567 134807577 134807579 134807567 134807577 134807579;}
@list l0:level1
        {mso-level-text:"%1\)";
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-18.0pt;}
@list l0:level2
        {mso-level-number-format:alpha-lower;
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-18.0pt;}
@list l0:level3
        {mso-level-number-format:roman-lower;
        mso-level-tab-stop:none;
        mso-level-number-position:right;
        text-indent:-9.0pt;}
@list l0:level4
        {mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-18.0pt;}
@list l0:level5
        {mso-level-number-format:alpha-lower;
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-18.0pt;}
@list l0:level6
        {mso-level-number-format:roman-lower;
        mso-level-tab-stop:none;
        mso-level-number-position:right;
        text-indent:-9.0pt;}
@list l0:level7
        {mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-18.0pt;}
@list l0:level8
        {mso-level-number-format:alpha-lower;
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-18.0pt;}
@list l0:level9
        {mso-level-number-format:roman-lower;
        mso-level-tab-stop:none;
        mso-level-number-position:right;
        text-indent:-9.0pt;}
ol
        {margin-bottom:0cm;}
ul
        {margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
      <div class="WordSection1">
        <p class="MsoNormal"><span style="color:#1F497D">Thanks, I’m
            glad I’m not the only one who can fat-finger this kind of
            data!<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
        <p class="MsoNormal"><span style="color:#1F497D">I can’t find
            anything in the basic.sql code, however, that CREATEs a
            ‘user’ table. Could this be a problem?<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
        <p class="MsoNormal"><span style="color:#1F497D">I’ve also run
            into a problem exporting LOs now, possibly because the
            temporary directory isn’t defined? Could be default to /tmp
            – that’s supposed to have write privileges for all users,
            isn’t it. I’m not sure what the equivalent is in Windows,
            however.<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
        <p class="MsoNormal"><span style="color:#1F497D">Kindest
            regards, Thomas<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
        <div>
          <div style="border:none;border-top:solid #E1E1E1
            1.0pt;padding:3.0pt 0cm 0cm 0cm">
            <p class="MsoNormal"><b><span
                  style="color:windowtext;mso-fareast-language:EN-GB"
                  lang="EN-US">From:</span></b><span
                style="color:windowtext;mso-fareast-language:EN-GB"
                lang="EN-US"> <a class="moz-txt-link-abbreviated" href="mailto:xerte-dev-bounces@lists.nottingham.ac.uk">xerte-dev-bounces@lists.nottingham.ac.uk</a>
                [<a class="moz-txt-link-freetext" href="mailto:xerte-dev-bounces@lists.nottingham.ac.uk">mailto:xerte-dev-bounces@lists.nottingham.ac.uk</a>] <b>On
                  Behalf Of </b>Tom Reijnders<br>
                <b>Sent:</b> 04 May 2013 11:12 AM<br>
                <b>To:</b> For Xerte technical developers<br>
                <b>Subject:</b> [Xerte-dev] Re: Xerte Install<o:p></o:p></span></p>
          </div>
        </div>
        <p class="MsoNormal"><o:p> </o:p></p>
        <p class="MsoNormal" style="margin-bottom:12.0pt">I fixed issue
          2 yesterday evening. Too many people ran into that one.<br>
          <br>
          <span style="font-size:12.0pt;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
        <div>
          <p class="MsoNormal">Op 4-5-2013 11:21, Pat @ Pgogy schreef:<o:p></o:p></p>
        </div>
        <blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
          <div>
            <p class="MsoNormal">2 is simple enough to fix<o:p></o:p></p>
          </div>
          <div>
            <p class="MsoNormal"><o:p> </o:p></p>
          </div>
          <div>
            <p class="MsoNormal">3 is a problem - would want want the
              maximum size to be a php ini limit, or a XOT specific
              limit? Different sites on the same server?<o:p></o:p></p>
          </div>
          <div>
            <p class="MsoNormal" style="margin-bottom:12.0pt"><br>
              On 3 May 2013, at 22:09, "Thomas Rochford" <<a
                moz-do-not-send="true"
                href="mailto:thomas.rochford@jiscadvance.ac.uk">thomas.rochford@jiscadvance.ac.uk</a>>
              wrote:<o:p></o:p></p>
          </div>
          <blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
            <div>
              <p class="MsoNormal">Good Evening Tom,<o:p></o:p></p>
              <p class="MsoNormal"> <o:p></o:p></p>
              <p class="MsoNormal">First of all a Big Thank you for your
                work. As a small gesture of appreciation I have produced
                a document describing how to upload Learning Objects
                directly, via FTP, webDav etc. If you think it will be
                useful, please put it somewhere appropriate on the
                Community web site. It would be good if you (and
                others?) looked it over, in case I have made some
                mistakes or you feel things could have been explained a
                little better.<o:p></o:p></p>
              <p class="MsoNormal"> <o:p></o:p></p>
              <p class="MsoNormal">It was an ‘interesting’ experience,
                and I learnt a number of lessons that may help others.<o:p></o:p></p>
              <p class="MsoNormal"> <o:p></o:p></p>
              <p class="MsoListParagraph"
                style="text-indent:-18.0pt;mso-list:l0 level1 lfo2"><!--[if !supportLists]--><span
                  style="mso-list:Ignore">1)<span style="font:7.0pt
                    "Times New Roman"">      </span></span><!--[endif]-->My
                website is hosted in Germany (I believe) by  1&1
                Internet. They offer quite a restricted interface
                compared with some others that I have seen and I think
                that there is a ridiculously long period in which pages
                are cached by the server. For no reason that I can think
                of, Tom’s new code (replacing the ‘fault’ occasioned by
                not having a temporary upload file specified in php.ini
                with a ‘warning’) did not seem to work. Furthermore any
                changes that I made (e.g. trying to FORCE it to go to
                page1.php by commenting out just about everything else),
                didn’t work either, so I suspect the output had been
                cached by the server (I flushed the browser cache). So I
                just went straight to page1.php. It might be a good idea
                to add a link to this at the bottom, rather than using
                the ‘submit’ button.<br>
                In any event generating a fault or warning of this kind
                is probably not necessary. Because I wanted to do a
                clean installation in order to test it out, I had to
                re-import my existing LOs as .zip files and they all
                worked well, provided they were less than the
                ridiculously low level set by 1&1. But of that more
                anon…<o:p></o:p></p>
              <p class="MsoListParagraph"
                style="text-indent:-18.0pt;mso-list:l0 level1 lfo2"><!--[if !supportLists]--><span
                  style="mso-list:Ignore">2)<span style="font:7.0pt
                    "Times New Roman"">      </span></span><!--[endif]-->The
                next problem I encountered was to do with database.php.
                1&1 do not allow you to choose the name of your
                database and give it a thoroughly unmemorable and easily
                mistyped name and the same for the managing account. I
                tried to copy and paste them from the web page but, in
                doing so, inadvertently copied an extra space at the end
                of the database name. Although I went back via the
                browser and re-entered it correctly, the installer still
                had the pesky space and I had to get rid of it by
                editing database.php. Would it be possible to overwrite
                any existing database.php with a new one every time the
                data is re-submitted , because I’m sure other users
                could also make this mistake.<o:p></o:p></p>
              <p class="MsoListParagraph"
                style="text-indent:-18.0pt;mso-list:l0 level1 lfo2"><!--[if !supportLists]--><span
                  style="mso-list:Ignore">3)<span style="font:7.0pt
                    "Times New Roman"">      </span></span><!--[endif]-->The
                final problem I had was uploading some LOs. I’m sure it
                was size related, but the generic failure message about
                only accepting zip files threw me for a few minutes. I
                would like to suggest that the upload script checks to
                make sure that the size of the object to be uploaded is
                less than ‘max_file_uploadsize’ (or whatever the php
                variable is called), before attempting the upload and
                warns the user that they will have to transfer the data
                manually if it is.<o:p></o:p></p>
              <p class="MsoNormal"> <o:p></o:p></p>
              <p class="MsoNormal">Because of problem #3 I documented
                the process of FTP’ing data directly up to Toolkits as
                described in the attached document.<o:p></o:p></p>
              <p class="MsoNormal"> <o:p></o:p></p>
              <p class="MsoNormal">I should point out that this could be
                quite an issue because many smaller organisations are
                either using the free JANET-hosted web servers, or other
                commercially hosted ones which have locked down php.ini
                files which they will not change, so some or all of
                these points may have relevance to a significant number
                of other users.<o:p></o:p></p>
              <p class="MsoNormal"> <o:p></o:p></p>
              <p class="MsoNormal">Apologies for the length.<o:p></o:p></p>
              <p class="MsoNormal"> <o:p></o:p></p>
              <p class="MsoNormal">Kindest regards, Thomas<o:p></o:p></p>
              <p class="MsoNormal" style="margin-bottom:12.0pt"><span
                  style="font-size:12.0pt;font-family:"Times New
                  Roman","serif";mso-fareast-language:EN-GB"><br>
                  <br>
                  <o:p></o:p></span></p>
            </div>
          </blockquote>
          <blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
            <div>
              <p class="MsoNormal"><span
                  style="font-size:12.0pt;font-family:"Times New
                  Roman","serif";mso-fareast-language:EN-GB"><Manual
                  Uploads to Xerte.docx><o:p></o:p></span></p>
            </div>
          </blockquote>
          <blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
            <div>
              <p class="MsoNormal"><span
                  style="font-size:12.0pt;font-family:"Times New
                  Roman","serif";mso-fareast-language:EN-GB">_______________________________________________<br>
                  Xerte-dev mailing list<br>
                  <a moz-do-not-send="true"
                    href="mailto:Xerte-dev@lists.nottingham.ac.uk">Xerte-dev@lists.nottingham.ac.uk</a><br>
                  <a moz-do-not-send="true"
                    href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev">http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev</a><o:p></o:p></span></p>
            </div>
          </blockquote>
          <p class="MsoNormal"><span
              style="font-size:12.0pt;font-family:"Times New
              Roman","serif";mso-fareast-language:EN-GB"><br>
              <br>
              <br>
              <br>
              <br>
              <br>
              <o:p></o:p></span></p>
          <pre>_______________________________________________<o:p></o:p></pre>
          <pre>Xerte-dev mailing list<o:p></o:p></pre>
          <pre><a moz-do-not-send="true" href="mailto:Xerte-dev@lists.nottingham.ac.uk">Xerte-dev@lists.nottingham.ac.uk</a><o:p></o:p></pre>
          <pre><a moz-do-not-send="true" href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev">http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev</a><o:p></o:p></pre>
        </blockquote>
        <p class="MsoNormal"><span
            style="font-size:12.0pt;font-family:"Times New
            Roman","serif";mso-fareast-language:EN-GB"><br>
            <br>
            <o:p></o:p></span></p>
        <pre>-- <o:p></o:p></pre>
        <pre>--<o:p></o:p></pre>
        <pre><o:p> </o:p></pre>
        <pre>Tom Reijnders<o:p></o:p></pre>
        <pre>TOR Informatica<o:p></o:p></pre>
        <pre>Chopinlaan 27<o:p></o:p></pre>
        <pre>5242HM Rosmalen<o:p></o:p></pre>
        <pre>Tel: 073 5226191<o:p></o:p></pre>
        <pre>Fax: 073 5226196<o:p></o:p></pre>
        <pre><o:p> </o:p></pre>
        <p class="MsoNormal" style="margin-bottom:12.0pt"><span
            style="font-size:12.0pt;font-family:"Times New
            Roman","serif";mso-fareast-language:EN-GB"><br>
            <br>
            <o:p></o:p></span></p>
      </div>
      <br>
      <br>
      <br>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
Xerte-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Xerte-dev@lists.nottingham.ac.uk">Xerte-dev@lists.nottingham.ac.uk</a>
<a class="moz-txt-link-freetext" href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev">http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev</a>
</pre>
    </blockquote>
    <br>
    <pre class="moz-signature" cols="72">-- 
--

Tom Reijnders
TOR Informatica
Chopinlaan 27
5242HM Rosmalen
Tel: 073 5226191
Fax: 073 5226196

</pre>
  </body>
</html>