[Xerte] Installing Xerte Online Toolkits on a Windows IIS Server

David Hallam dhallam at grantham.ac.uk
Tue Feb 16 15:30:25 GMT 2010


I think I may have found one problem as I have now done a fresh  
install and it is throwing a error setting up the database stuff.
It errors on the setting root_file_path saying that the mysql syntax  
is incorrect so I think this might be causing my problems
Any ideas why it would only fall on this on entry as everything else  
is goon in fine.
Their is no rush as I am off this week but keep remoting the server to  
tweak

Sent from my iPhone

On 15 Feb 2010, at 07:59 PM, "Patrick Lockley" <Patrick.Lockley at nottingham.ac.uk 
 > wrote:

> it should be the root folder of the site
>
> From: xerte-bounces at lists.nottingham.ac.uk on behalf of David Hallam
> Sent: Mon 15/02/2010 17:33
> To: Xerte discussion list
> Subject: Re: [Xerte] Installing Xerte Online Toolkits on a Windows  
> IIS Server
>
> i have just noticed tho in my database in the site details that the
> root_file_path section is empty ..... Should this have infomation
> pointing to the user-files folder ?
>
> Sent from my iPhone
>
> On 15 Feb 2010, at 04:27 PM, "Patrick Lockley" <Patrick.Lockley at nottingham.ac.uk
>  > wrote:
>
> > This seems to be the critical bit
> >
> > C:\Inetpub\wwwroot\VLE\Xerte\website_code\php\templates
> > \new_template.php
> > on line 56 [15-Feb-2010 15:59:50] PHP Warning:  include(): Failed
> > opening 'modules/xerte/new_template.php' for inclusion
> > (include_path='.;C:\php5\pear') in
> > C:\Inetpub\wwwroot\VLE\Xerte\website_code\php\templates
> > \new_template.php
> > on line 56 [15-Feb-2010 15:59:50] PHP Fatal error:  Call to  
> undefined
> > function create_new_template() in
> > C:\Inetpub\wwwroot\VLE\Xerte\website_code\php\templates
> > \new_template.php
> > on line 58
> >
> > You might need to go into
> > C:\Inetpub\wwwroot\VLE\Xerte\website_code\php\templates
> > \new_template.php
> > , and replace the call to modules/Xerte/new_template.php with one  
> to a
> > full path.
> >
> > This is a new error, so I am guessing.
> >
> > -----Original Message-----
> > From: xerte-bounces at lists.nottingham.ac.uk
> > [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of David
> > Hallam
> > Sent: 15 February 2010 16:07
> > To: Xerte discussion list
> > Subject: RE: [Xerte] Installing Xerte Online Toolkits on a Windows  
> IIS
> > Server
> >
> > well i have now noticed that it does not create any items in the
> > user-files folder on the server, and i have seen some infomation in
> > the
> > php error log below when i try to create any template:
> >
> >
> > [15-Feb-2010 15:59:37] PHP Fatal error:  Can't use function return
> > value
> > in write context in
> > C:\Inetpub\wwwroot\VLE\Xerte\website_code\php\logout.php on line 17
> > [15-Feb-2010 15:59:37] PHP Notice:  Undefined variable:  
> form_string in
> > C:\Inetpub\wwwroot\VLE\Xerte\index.php on line 39 [15-Feb-2010
> > 15:59:42]
> > PHP Notice:  Undefined variable: session_id in
> > C:\Inetpub\wwwroot\VLE\Xerte\index.php on line 111 [15-Feb-2010
> > 15:59:42] PHP Notice:  Use of undefined constant givenname - assumed
> > 'givenname' in C:\Inetpub\wwwroot\VLE\Xerte\index.php on line 120
> > [15-Feb-2010 15:59:42] PHP Notice:  Use of undefined constant sn -
> > assumed 'sn' in C:\Inetpub\wwwroot\VLE\Xerte\index.php on line 122
> > [15-Feb-2010 15:59:42] PHP Notice:  Undefined variable:
> > database_fail in
> > C:\Inetpub\wwwroot\VLE\Xerte\website_code\php\database_library.php  
> on
> > line 49 [15-Feb-2010 15:59:42] PHP Notice:  Undefined index:
> > toolkits_logon_username in
> > C:\Inetpub\wwwroot\VLE\Xerte\website_code\php\database_library.php  
> on
> > line 57 [15-Feb-2010 15:59:42] PHP Warning:  date(): It is not  
> safe to
> > rely on the system's timezone settings. You are *required* to use  
> the
> > date.timezone setting or the date_default_timezone_set() function.  
> In
> > case you used any of those methods and you are still getting this
> > warning, you most likely misspelled the timezone identifier. We
> > selected
> > 'Europe/London' for '0.0/no DST' instead in
> > C:\Inetpub\wwwroot\VLE\Xerte\website_code\php\user_library.php on  
> line
> > 210 [15-Feb-2010 15:59:50] PHP Notice:  Undefined variable:
> > database_fail in
> > C:\Inetpub\wwwroot\VLE\Xerte\website_code\php\database_library.php  
> on
> > line 49 [15-Feb-2010 15:59:50] PHP Notice:  Undefined variable:
> > query_reponse in
> > C:\Inetpub\wwwroot\VLE\Xerte\website_code\php\template_library.php  
> on
> > line 21 [15-Feb-2010 15:59:50] PHP Warning:  date(): It is not  
> safe to
> > rely on the system's timezone settings. You are *required* to use  
> the
> > date.timezone setting or the date_default_timezone_set() function.  
> In
> > case you used any of those methods and you are still getting this
> > warning, you most likely misspelled the timezone identifier. We
> > selected
> > 'Europe/London' for '0.0/no DST' instead in
> > C:\Inetpub\wwwroot\VLE\Xerte\website_code\php\templates
> > \new_template.php
> > on line 46 [15-Feb-2010 15:59:50] PHP Warning:  date(): It is not  
> safe
> > to rely on the system's timezone settings. You are *required* to use
> > the
> > date.timezone setting or the date_default_timezone_set() function.  
> In
> > case you used any of those methods and you are still getting this
> > warning, you most likely misspelled the timezone identifier. We
> > selected
> > 'Europe/London' for '0.0/no DST' instead in
> > C:\Inetpub\wwwroot\VLE\Xerte\website_code\php\templates
> > \new_template.php
> > on line 46 [15-Feb-2010 15:59:50] PHP Warning:
> > include(modules/xerte/new_template.php): failed to open stream: No
> > such
> > file or directory in
> > C:\Inetpub\wwwroot\VLE\Xerte\website_code\php\templates
> > \new_template.php
> > on line 56 [15-Feb-2010 15:59:50] PHP Warning:  include(): Failed
> > opening 'modules/xerte/new_template.php' for inclusion
> > (include_path='.;C:\php5\pear') in
> > C:\Inetpub\wwwroot\VLE\Xerte\website_code\php\templates
> > \new_template.php
> > on line 56 [15-Feb-2010 15:59:50] PHP Fatal error:  Call to  
> undefined
> > function create_new_template() in
> > C:\Inetpub\wwwroot\VLE\Xerte\website_code\php\templates
> > \new_template.php
> > on line 58 [15-Feb-2010 16:00:06] Mismatched tag at line 8, column 7
> > [15-Feb-2010 16:05:07] Mismatched tag at line 8, column 7 [15- 
> Feb-2010
> > 16:06:40] PHP Notice:  Undefined variable: session_id in
> > C:\Inetpub\wwwroot\VLE\Xerte\index.php on line 111 [15-Feb-2010
> > 16:06:40] PHP Notice:  Use of undefined constant givenname - assumed
> > 'givenname' in C:\Inetpub\wwwroot\VLE\Xerte\index.php on line 120
> > [15-Feb-2010 16:06:40] PHP Notice:  Use of undefined constant sn -
> > assumed 'sn' in C:\Inetpub\wwwroot\VLE\Xerte\index.php on line 122
> > [15-Feb-2010 16:06:40] PHP Notice:  Undefined variable:
> > database_fail in
> > C:\Inetpub\wwwroot\VLE\Xerte\website_code\php\database_library.php  
> on
> > line 49 [15-Feb-2010 16:06:40] PHP Warning:  date(): It is not  
> safe to
> > rely on the system's timezone settings. You are *required* to use  
> the
> > date.timezone setting or the date_default_timezone_set() function.  
> In
> > case you used any of those methods and you are still getting this
> > warning, you most likely misspelled the timezone identifier. We
> > selected
> > 'Europe/London' for '0.0/no DST' instead in
> > C:\Inetpub\wwwroot\VLE\Xerte\website_code\php\user_library.php on  
> line
> > 210 [15-Feb-2010 16:10:06] Mismatched tag at line 8, column 7
> >
> >
> >
> > ________________________________
> >
> > From: xerte-bounces at lists.nottingham.ac.uk on behalf of Patrick
> > Lockley
> > Sent: Mon 15/02/2010 15:49
> > To: Xerte discussion list
> > Subject: RE: [Xerte] Installing Xerte Online Toolkits on a Windows  
> IIS
> > Server
> >
> >
> >
> > After you've created a file, or just generally.
> >
> > i.e. when does the JS error appear?
> >
> > -----Original Message-----
> > From: xerte-bounces at lists.nottingham.ac.uk
> > [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of David
> > Hallam
> > Sent: 15 February 2010 15:14
> > To: Xerte discussion list
> > Subject: RE: [Xerte] Installing Xerte Online Toolkits on a Windows  
> IIS
> > Server
> >
> >
> > on the main page i am getting javascript errors once logged into  
> xerte
> > and they are :
> >
> >
> > Message: 'drag_manager.last_selected.id' is null or not an object
> > Line: 930
> > Char: 4
> > Code: 0
> > URI: http://vle.grantham.ac.uk/xerte/website_code/scripts/file_system.js
> >
> > Message: 'drag_manager.last_selected.id' is null or not an object
> > Line: 930
> > Char: 4
> > Code: 0
> > URI: http://vle.grantham.ac.uk/xerte/website_code/scripts/file_system.js
> >
> >
> > on the preview side i cannot view source in IE8 as it does open a
> > Flash
> > Player windows but the load bar appears in the centre but notting
> > else.
> > If i view it in firefox that does not have the flast plugin
> > installed i
> > can get the source code which is the  i get the following :
> > <!--
> >
> > University of Nottingham Xerte Online Toolkits
> >
> > HTML to use at the top of the Xerte preview and play windows Version
> > 1.0
> >
> > -->
> >
> > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
> > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
> > <html style="width:100%; height:100%; min-height:100%;"> <head>
> > <title>Interactive Learning Content</title> <script
> > type="text/javascript"> function enableTTS(){
> >  if (navigator.appName.indexOf("Microsoft") != -1){
> >    VoiceObj = new ActiveXObject("Sapi.SpVoice");
> >  }
> > }
> > </script>
> >
> > <script type="text/javascript" src = "rloObject.js
> > <view-source:http://vle.grantham.ac.uk/xerte/rloObject.js> "></ 
> script>
> > </head>
> >
> > <body style="margin:0; width:100%; height:100%; min-height:100%;">
> >
> > <!--<div style="margin:0px auto;">-->
> > <div style="min-height:100%; width:100%; height:100%;">
> >
> > <script type="text/javascript" language="JavaScript">myRLO = new
> > rloObject('800','600','modules/xerte/parent_templates/Nottingham/
> > Notting
> > ham.rlt','USER-FILES/18-dhallam-Nottingham/',
> > 'USER-FILES/18-dhallam-Nottingham/preview.xml?time=1266246782',
> > 'http://vle.grantham.ac.uk/xerte/' , '')</script></div></body></ 
> html>
> >
> >
> >
> > ________________________________
> >
> > From: xerte-bounces at lists.nottingham.ac.uk on behalf of Patrick
> > Lockley
> > Sent: Mon 15/02/2010 14:41
> > To: Xerte discussion list
> > Subject: RE: [Xerte] Installing Xerte Online Toolkits on a Windows  
> IIS
> > Server
> >
> >
> >
> > If you right click on it and view source do you see anything?
> >
> > -----Original Message-----
> > From: xerte-bounces at lists.nottingham.ac.uk
> > [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of David
> > Hallam
> > Sent: 15 February 2010 14:40
> > To: Xerte discussion list
> > Subject: Re: [Xerte] Installing Xerte Online Toolkits on a Windows  
> IIS
> > Server
> >
> > No it appears with a loading screen then goes blank
> >
> > Sent from my iPhone
> >
> > On 15 Feb 2010, at 02:16 PM, "Patrick Lockley"
> > <Patrick.Lockley at nottingham.ac.uk
> >> wrote:
> >
> >> The reason the page won't refresh is probably a javascript error?
> >>
> >> Does the blank window produce any source code?
> >>
> >> -----Original Message-----
> >> From: xerte-bounces at lists.nottingham.ac.uk
> >> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of David
> >> Hallam
> >> Sent: 15 February 2010 14:00
> >> To: Xerte discussion list
> >> Subject: Re: [Xerte] Installing Xerte Online Toolkits on a Windows
> >> IIS
> >
> >> Server
> >>
> >> Hi I hve just done an install on my moodle server that has the  
> latest
> >> mysql and php. I have added the mime types and looked through the  
> php
> >> settings but iam having a few problems.
> >> I have ldap working and can log onto the server but when creating
> >> anything nothing appears in the list on the left until you refresh
> >> the
> >
> >> page then it appears in the list Also when you click on any of the
> >> created items the new windo opens bit just displays a blank window
> >>
> >> Does anyone have any ideas could it be php related or mysql
> >>
> >> My moodle install works fine
> >>
> >> Sent from my iPhone
> >>
> >> On 13 Feb 2010, at 11:03 AM, "Hartley, Peter"
> >> <peter.hartley at kedst.ac.uk> wrote:
> >>
> >>> Below I have listed the tasks needed to be done by myself to get
> >>> Xerte working on IIS, I hope this helps others and I wonder if  
> there
> >>> are any extras that need to be done or if there are mistakes. I am
> >>> not going to use ldap so I have not delved into that.
> >>> Installation of Xerte on an IIS server
> >>>
> >>> 1.  The server should be running MySQL and PHP - the usual set up
> >>> for
> >
> >>> something like Moodle should suffice 2.  Create a database on the
> >>> server using MySQL called xerte 3.  Create a user called xerte and
> >>> give them all schema privileges to the database, choose a suitable
> >>> password 4.  Create a folder in the server web site called
> >>> xertetoolkits 5.  Give Everyone modify access rights to this  
> folder
> >>> 6.  In IIS Manager right click on the folder and go to properties
> >>>  *   In Directory Security make the folder Anonymous Access
> >>>  *   In HTTP headers select MIME Types and add
> >>>     *   Extension: .rlm and MIMEtype: text/plain
> >>>     *   Extension: .rlo and MIMEtype: text/plain
> >>>     *   Extension: .rlt and MIMEtype: text/plain
> >>> 7.  Download the Xerte Online Toolkits from
> >> http://www.nottingham.ac.uk/toolkits/
> >>> 8.  Extract the zip file to another folder 9.  Rename the file
> >>> index.php as index1.php 10. Rename the file switch.txt as  
> index.php
> >>> 11. Look at the index.php file and find the line which says switch
> >>> ($_POST["login"]){
> >>>  *   Below that line is a set of users and passwords, you will
> >>> need to use one of these for testing
> >>> 12. Now copy all the files from the extracted folder into the  
> xerte
> >>> folder on the web site 13. On the server itself load a web browser
> >>> and run http:// <http:///>  <http:///>
> >>>
> >>
> > (yourserver)/xertetoolkits/setup<http://%28yourserver%29/xertetoolkits/s
> >> etup
> >>>> and click on 'For a full install'
> >>> 14. On Page 1 enter the following:
> >>>  *   Please start by typing in the name of the host where you'd
> >>> like the toolkits database to be created on. People following the
> >>> XAMPP path / or testing locally should type in localhost. -
> >>> localhost
> >>>  *   Please enter the username for a MySQL account that has Create
> >>> and Insert rights on this host from this location. People  
> following
> >>> the XAMPP path / or testing locally should type in root. - xerte  
> as
> >>> above
> >>>  *   Please enter the password for this account (optional). People
> >>> following the XAMPP path / or testing locally should leave this
> >>> field
> >
> >>> blank. - xerte password as above
> >>>  *   Please enter the name for the database if it already exists,
> >>> or the name of the new database if you'd like one creating. -  
> xerte
> >>> as above
> >>>  *   If you'd like to prefix the tables installed with a word to
> >>> help house keeping, please type it in below (optional). - leave
> >>> blank
> >
> >>> 15. On Page 2 enter the following:
> >>>  *   Database account name for users of the site. People following
> >>> the XAMPP path / or testing locally should type in root. - xerte  
> as
> >>> above
> >>>  *   Database password for the account above. People following the
> >>> XAMPP path / or testing locally should leave this field blank. -
> >>> xerte password as above 16. On page 3 enter the following:
> >>>  *   The site url is (This is the URL of the site - changing this
> >>> will not change the URL) -
> >> http://(yourserver)/xertetoolkits<http://%28yourserver%29/
> >> xertetoolkits
> >>>>
> >>>  *   The admin username is - xerteadmin
> >>>  *   The admin password is - suitable password
> >>>  *   Leave the rest to edit later
> >>> 17. The installation should now finish 18. Leave the server and go
> >>> to
> >
> >>> the web site on a local computer at
> >>>
> >>
> > http://(yourserver)/xertetoolkits/management.php<http://%28yourserver%29
> >> /xertetoolkits/management.php
> >>>> and logon as the xerteadmin
> >>>  *   From here you can edit the details you missed out on page 3
> >>> 19. Now logout and go to
> >>
> > http://(yourserver)/xertetoolkits/<http://%28yourserver%29/xertetoolkits
> >> /
> >>>> using the user and password you noted from the switch.txt which
> >>> you renamed index.php
> >>> 20. Test Xerte to see if it works
> >>> 21. Add more users to index.php for testing or change the users
> >>> already there 22. To use ldap edit the ldap settings, rename
> >>> index.php as switch.txt and rename index1.php as index.php
> >>>  *   This process can be reversed if ldap does not work
> >>>
> >>>
> >>> Peter Hartley
> >>> peter.hartley at kedst.ac.uk<mailto:peter.hartley at kedst.ac.uk>
> >>>
> >>>> From my MacBook
> >>>
> >>>
> >>>
> >>> ***
> >>> ***
> >>> ***
> >>>  
> *******************************************************************
> >>> This email is confidential and intended solely for the use of the
> >>> individual to whom it is addressed. Any views or opinions  
> presented
> >>> are solely those of the author and do not necessarily represent
> >>> those
> >
> >>> of King Edward VI College Stourbridge. If you are not the intended
> >>> recipient, be advised that you have received this email in error  
> and
> >>> we request that you do not disseminate, forward, print, or copy  
> this
> >>> email. If you have received this email in error please notify King
> >>> Edward VI College Stourbridge, West Midlands, DY8 1TD, UK on +44- 
> (0)
> >>> 1384 398100.
> >>> ***
> >>> ***
> >>> ***
> >>>  
> *******************************************************************
> >>>
> >>>
> >>> _______________________________________________
> >>> Xerte mailing list
> >>> Xerte at lists.nottingham.ac.uk
> >>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> >>> All email activity is logged. Please ensure that, where possible,
> >>> email messages relate strictly to college business.
> >>>
> >>> Help save paper - do you need to print this email?
> >>
> >> Information transmitted in this electronic message may contain
> >> confidential and or privileged materials.
> >>
> >> For full details and restrictions see
> >> www.Grantham.ac.uk/about/disclaimer.htm
> >>
> >> Help save paper - do you need to print this email?
> >> _______________________________________________
> >> Xerte mailing list
> >> Xerte at lists.nottingham.ac.uk
> >> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> >> _______________________________________________
> >> Xerte mailing list
> >> Xerte at lists.nottingham.ac.uk
> >> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> >> All email activity is logged. Please ensure that, where possible,
> >> email messages relate strictly to college business.
> >>
> >> Help save paper - do you need to print this email?
> >
> > Information transmitted in this electronic message may contain
> > confidential and or privileged materials.
> >
> > For full details and restrictions see
> > www.Grantham.ac.uk/about/disclaimer.htm
> >
> > Help save paper - do you need to print this email?
> > _______________________________________________
> > Xerte mailing list
> > Xerte at lists.nottingham.ac.uk
> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> > _______________________________________________
> > Xerte mailing list
> > Xerte at lists.nottingham.ac.uk
> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> > All email activity is logged. Please ensure that, where possible,
> > email
> > messages relate strictly to college business.
> >
> > Help save paper - do you need to print this email?
> >
> > Information transmitted in this electronic message may contain
> > confidential and or privileged materials.
> >
> > For full details and restrictions see
> > www.Grantham.ac.uk/about/disclaimer.htm
> >
> > Help save paper - do you need to print this email?
> > _______________________________________________
> > Xerte mailing list
> > Xerte at lists.nottingham.ac.uk
> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> > All email activity is logged. Please ensure that, where possible,
> > email
> > messages relate strictly to college business.
> >
> > Help save paper - do you need to print this email?
> >
> > Information transmitted in this electronic message may contain
> > confidential and or privileged materials.
> >
> > For full details and restrictions see
> > www.Grantham.ac.uk/about/disclaimer.htm
> >
> > Help save paper - do you need to print this email?
> > _______________________________________________
> > Xerte mailing list
> > Xerte at lists.nottingham.ac.uk
> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> > All email activity is logged. Please ensure that, where possible,
> > email messages relate strictly to college business.
> >
> > Help save paper - do you need to print this email?
>
> Information transmitted in this electronic message may contain  
> confidential and or privileged materials.
>
> For full details and restrictions see www.Grantham.ac.uk/about/disclaimer.htm
>
> Help save paper - do you need to print this email?
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>
> All email activity is logged. Please ensure that, where possible,  
> email messages relate strictly to college business.
> Help save paper - do you need to print this email?
>
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>
> All email activity is logged. Please ensure that, where possible,  
> email messages relate strictly to college business.
>
> Help save paper - do you need to print this email?

Information transmitted in this electronic message may contain confidential and or privileged materials.

For full details and restrictions see www.Grantham.ac.uk/about/disclaimer.htm

Help save paper - do you need to print this email?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20100216/04f840a7/attachment.html


More information about the Xerte mailing list