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

Patrick Lockley Patrick.Lockley at nottingham.ac.uk
Tue Feb 16 15:37:26 GMT 2010


Could you let me know what value for root file path the system suggests on page 3 and also what the query looks like that fails?

 

thanks

 

From: xerte-bounces at lists.nottingham.ac.uk [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of David Hallam
Sent: 16 February 2010 15:30
To: Xerte discussion list
Subject: Re: [Xerte] Installing Xerte Online Toolkits on a Windows IIS Server

 

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://> >  <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/41f69691/attachment.html


More information about the Xerte mailing list