[Xerte] XOT install - down the rabbit hole

Adam Read aread at marjon.ac.uk
Fri Nov 27 15:56:37 GMT 2009


What MIME types need to be set on server for XOT?

___________________________________
 Adam Read
 Learning Technologist
 University College Plymouth St Mark & St John

 aread at marjon.ac.uk<mailto:aread at marjon.ac.uk>
 tel: 01752 636700 ext: 5673
 Room 563, Kirby Cudmore Building
 twitter.com/adamread<http://www.twitter.com/adamread>

From: xerte-bounces at lists.nottingham.ac.uk [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Patrick Lockley
Sent: 27 November 2009 15:40
To: Xerte discussion list
Subject: RE: [Xerte] XOT install - down the rabbit hole

No

That's the need to set mimetypes on the server.



From: xerte-bounces at lists.nottingham.ac.uk [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Dave Burnett
Sent: 27 November 2009 15:29
To: Xerte list
Subject: RE: [Xerte] XOT install - down the rabbit hole

grr.

Are there cascading authentication issues?
Xerte Online Toolkit > Create > Name Project >Create Project button

Pop-up window is blank.




________________________________
Subject: RE: [Xerte] XOT install - down the rabbit hole
Date: Fri, 27 Nov 2009 14:57:23 +0000
From: Patrick.Lockley at nottingham.ac.uk
To: xerte at lists.nottingham.ac.uk
And then rename index.php to be index.notphpanymore and rename switch.txt to index.php

From: xerte-bounces at lists.nottingham.ac.uk [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Patrick Lockley
Sent: 27 November 2009 14:55
To: Xerte discussion list
Subject: RE: [Xerte] XOT install - down the rabbit hole

Oh no you've got in installed version, and the code is sitting there all ready and willing to be used, its just you've not got LDAP on the server.

Hence the white screen.

The simplest answer is to  look at switch.txt in the root, search through it for the typed in username / passwords (its not a big file, search with the wheely mouse) and change those.

From: xerte-bounces at lists.nottingham.ac.uk [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Dave Burnett
Sent: 27 November 2009 14:48
To: Xerte list
Subject: RE: [Xerte] XOT install - down the rabbit hole


It must ahve been reusing that temp txt file.

Clean install, bingo.

Unfortunately, entering signin info on home page takes me to blank page, not
even any underlying code.

Getting closer though. :-)

Dave
________________________________
Subject: RE: [Xerte] XOT install - down the rabbit hole
Date: Fri, 27 Nov 2009 14:24:18 +0000
From: Patrick.Lockley at nottingham.ac.uk
To: xerte at lists.nottingham.ac.uk
It builds a temp database.txt in setup, before copying it into root when it is done.

So have a look in the setup folder.

But I'd say start again

From: xerte-bounces at lists.nottingham.ac.uk [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Dave Burnett
Sent: 27 November 2009 14:19
To: Xerte list
Subject: RE: [Xerte] XOT install - down the rabbit hole



Deleted database.php and then went through the install again from page 1 watching for it's point of creation.

When created, I dl'ed and got this:

* Database table prefix
*/
$xerte_toolkits_site->database_table_prefix ="test";
?>

I had changed the prefix value, so I'm not sure where it is re-pulling it from.

Rip it all off the server and start clean?
________________________________
Subject: RE: [Xerte] XOT install - down the rabbit hole
Date: Fri, 27 Nov 2009 13:00:36 +0000
From: Patrick.Lockley at nottingham.ac.uk
To: xerte at lists.nottingham.ac.uk
I would post up a edited version of database.php from the root folder

From: xerte-bounces at lists.nottingham.ac.uk [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Dave Burnett
Sent: 27 November 2009 12:57
To: Xerte list
Subject: RE: [Xerte] XOT install - down the rabbit hole

So I missed supplying something on page 2?

Can I restart the setup procedure without beggaring something up?
________________________________
Subject: RE: [Xerte] XOT install - down the rabbit hole
Date: Fri, 27 Nov 2009 12:43:52 +0000
From: Patrick.Lockley at nottingham.ac.uk
To: xerte at lists.nottingham.ac.uk
Page 2 uses your admin details to create the database, and page 2 doesn't make an account, it relies on one already being there.

Page 3 / 4 uses the details supplied on page 2


From: xerte-bounces at lists.nottingham.ac.uk [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Dave Burnett
Sent: 27 November 2009 12:38
To: Xerte list
Subject: RE: [Xerte] XOT install - down the rabbit hole


Wouldn't the same connection string be used that created the tables on page2?
________________________________
Subject: RE: [Xerte] XOT install - down the rabbit hole
Date: Fri, 27 Nov 2009 12:29:07 +0000
From: Patrick.Lockley at nottingham.ac.uk
To: xerte at lists.nottingham.ac.uk
I would imagine its that your mysql server doesn't called itself localhost

From: xerte-bounces at lists.nottingham.ac.uk [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Dave Burnett
Sent: 27 November 2009 12:27
To: Xerte list
Subject: RE: [Xerte] XOT install - down the rabbit hole

The sitedetails site ID query insert into testsitedetails(site_id) VALUES ( "1") has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails site url query update testsitedetails set site_url="http://www.hipgnosys.com/xot/" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails apache query update testsitedetails set apache="false" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails apache query update testsitedetails set apache="false" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails mimetypes query update testsitedetails set mimetypes="text/xml,application/msword,application/x-shockwave-flash,image/jpeg,image/pjpeg,image/png,image/gif,image/x-png,audio/mpeg,application/vnd.ms-excel,application/pdf,application/vnd.ms-powerpoint,video/x-ms-wmv,text/html,video/mp4,video/avi,audio/wav,text/plain,video/quicktime" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails LDAP preference query update testsitedetails set LDAP_preference="sAMAccountName" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails LDAP preference query update testsitedetails set LDAP_preference="sAMAccountName" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails LDAP_filter query update testsitedetails set LDAP_filter="cn=" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails integration_config_path query update testsitedetails set integration_config_path="" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails admin_username query update testsitedetails set admin_username="xot_dave" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails admin_password query update testsitedetails set admin_password="xot_dave" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails site_session_name query update testsitedetails set site_session_name="XERTE_TOOLKITS" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails site_title query update testsitedetails set site_title="Xerte Online Toolkits" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails site_name query update testsitedetails set site_name="Xerte Online Toolkits" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails site_logo query update testsitedetails set site_logo="website_code/images/xerteLogo.jpg" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails organisational_logo query update testsitedetails set organisational_logo="website_code/images/UofNLogo.jpg" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails welcome_message query update testsitedetails set welcome_message="Welcome to Xerte Online toolkits" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails site_text query update testsitedetails set site_text="Welcome to the toolkits front page, developed by the University of Nottingham" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails news_text query update testsitedetails set news_text="PHAgY2xhc3M9Im5ld3NfdGl0bGUiPk90aGVyIHJlc291cmNlczwvcD48cCBjbGFzcz0ibmV3c19zdG9yeSI+PGEgaHJlZj0iIj5TaXRlIDE8L2E+PC9wPjxwIGNsYXNzPSJuZXdzX3N0b3J5Ij48YSBocmVmPSIiPlNpdGUgMjwvYT48L3A+PHAgY2xhc3M9Im5ld3Nfc3RvcnkiPjxhIGhyZWY9IiI+U2l0ZSAzPC9hPjwvcD4=" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails pod_one query update testsitedetails set pod_one="PHAgY2xhc3M9Im5ld3NfdGl0bGUiPkhvdyB0bzwvcD48cCBjbGFzcz0iZGVtbyI+PGEgaHJlZj0iamF2YXNjcmlwdDphbGVydCgnU29ycnkuIFRoaXMgaXMgbm90IHlldCBhdmFpbGFibGUnKSI+MzAgU2Vjb25kIERlbW88L2E+PGJyIC8+QSB2ZXJ5IHNob3J0IGNhcHRpdmF0ZSBmaWxlIHNob3dpbmcgYSBzaW1wbGUgcHJvamVjdCBiZWluZyBzdGFydGVkLCBidWlsdCBhbmQgcHVibGlzaGVkIGZvciB0aGUgd2ViLjwvcD48cCBjbGFzcz0iZGVtbyI+PGEgaHJlZj0iamF2YXNjcmlwdDphbGVydCgnU29ycnkuIFRoaXMgaXMgbm90IHlldCBhdmFpbGFibGUnKSI+TGVhcm5pbmcgT2JqZWN0IERlbW88L2E+PGJyIC8+QSB2ZXJ5IHNpbXBsZSBkZW1vIG9mIGEgbGVhcm5pbmcgb2JqZWN0LjwvcD4=" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails pod_two query update testsitedetails set pod_two="PHAgY2xhc3M9Im5ld3NfdGl0bGUiPldhbnQgdG8gc2hhcmUgc29tZSB0aG91Z2h0cz88L3A+PHAgY2xhc3M9ImdlbmVyYWwiPklmIHlvdSBoYXZlIGFueSBxdWVzdGlvbnMsIHJlcXVlc3RzIGZvciBoZWxwLCBpZGVhcyBmb3IgbmV3IHByb2plY3RzIG9yIHByb2JsZW1zIHRvIHJlcG9ydCwgdGhlbiBwbGVhc2UgZ2V0IGluIHRvdWNoLjwvcD48cCBjbGFzcz0iZ2VuZXJhbCI+UGxlYXNlIHVzZSBvdXIgPGEgaHJlZj0iZmVlZGJhY2svIiBzdHlsZT0iY29sb3I6IzAwMCI+RmVlZGJhY2sgRm9ybTwvYT48L3A+" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails copyright query update testsitedetails set copyright="(c) Copyright University of Nottingham 2008" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails rss_title query update testsitedetails set rss_title="Xerte Web Toolkits RSS Feed" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails synd_publisher query update testsitedetails set synd_publisher="Put your institution\'s name here" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails synd_rights query update testsitedetails set synd_rights="Licensed under a Creative Commons Attribution - NonCommercial-ShareAlike 2.0 Licence - see http://creativecommons.org/licenses/by-nc-sa/2.0/uk/" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails synd_license query update testsitedetails set synd_license="Licensed under a Creative Commons Attribution - NonCommercial-ShareAlike 2.0 Licence - see http://creativecommons.org/licenses/by-nc-sa/2.0/uk/" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails demonstration_page query update testsitedetails set demonstration_page="modules/xerte/training/toolkits.htm" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails form_string query update testsitedetails set form_string="PGh0bWw+PGJvZHk+PGNlbnRlcj48cD48Zm9ybSBtZXRob2Q9InBvc3QiIGFjdGlvbj0iIj48cD5Vc2VybmFtZSA8aW5wdXQgdHlwZT0idGV4dCIgc2l6ZT0iMjAiIG1heGxlbmd0aD0iMTIiIG5hbWU9ImxvZ2luIiAvPjwvcD48cD5QYXNzd29yZCA8aW5wdXQgdHlwZT0icGFzc3dvcmQiIHNpemU9IjIwIiBtYXhsZW5ndGg9IjM2IiBuYW1lPSJwYXNzd29yZCIgLz48L3A+PHA+PGlucHV0IHR5cGU9ImltYWdlIiBzcmM9IndlYnNpdGVfY29kZS9pbWFnZXMvQnR0bl9Mb2dpbk9mZi5naWYiIG9ubW91c2VvdmVyPSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT24uZ2lmJyIgb25tb3VzZWRvd249InRoaXMuc3JjPSd3ZWJzaXRlX2NvZGUvaW1hZ2VzL0J0dG5fTG9naW5DbGljay5naWYnIiBvbm1vdXNlb3V0PSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT2ZmLmdpZiciIC8+PC9wPg==" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails peer_form_string query update testsitedetails set peer_form_string="PGh0bWw+PGJvZHk+PGNlbnRlcj48cD48Zm9ybSBtZXRob2Q9InBvc3QiIGFjdGlvbj0iIj48cD5QYXNzd29yZCA8aW5wdXQgdHlwZT0icGFzc3dvcmQiIHNpemU9IjIwIiBtYXhsZW5ndGg9IjM2IiBuYW1lPSJwYXNzd29yZCIgLz48L3A+PHA+PGlucHV0IHR5cGU9ImltYWdlIiBzcmM9IndlYnNpdGVfY29kZS9pbWFnZXMvQnR0bl9Mb2dpbk9mZi5naWYiIG9ubW91c2VvdmVyPSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT24uZ2lmJyIgb25tb3VzZWRvd249InRoaXMuc3JjPSd3ZWJzaXRlX2NvZGUvaW1hZ2VzL0J0dG5fTG9naW5DbGljay5naWYnIiBvbm1vdXNlb3V0PSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT2ZmLmdpZiciIC8+PC9wPg==" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails module_path query update testsitedetails set module_path="modules/" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails website_code_path query update testsitedetails set website_code_path="website_code/" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
The sitedetails users_file_area_short query update testsitedetails set users_file_area_short="USER-FILES/" where site_id="1" has failed due to Can't connect to MySQL server on 'localhost' (10061)
________________________________
Subject: RE: [Xerte] XOT install - down the rabbit hole
Date: Fri, 27 Nov 2009 12:03:25 +0000
From: Patrick.Lockley at nottingham.ac.uk
To: xerte at lists.nottingham.ac.uk
Could I get the errors?

From: xerte-bounces at lists.nottingham.ac.uk [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Dave Burnett
Sent: 27 November 2009 11:47
To: Xerte list
Subject: [Xerte] XOT install - down the rabbit hole

After some thrashing aout I managed to get past page2.php of the install and create the tables on my hosting ISP.

On page3.php I left most everything default, but on submission I get a slew of:
Can't connect to MySQL server on 'localhost'
errors.

Pretty sure I created tables on my ISP, as I do not have mySQL installed locally. ;-)


??

Dave


________________________________
Hotmail: Trusted email with powerful SPAM protection. Sign up now.<http://clk.atdmt.com/GBL/go/177141665/direct/01/>

________________________________
Windows 7: It works the way you want. Learn more.<http://www.microsoft.com/Windows/windows-7/default.aspx?ocid=PID24727::T:WLMTAGL:ON:WL:en-US:WWL_WIN_evergreen:112009v2>

________________________________
Bing brings you maps, menus, and reviews organized in one place. Try it now.<http://www.bing.com/search?q=restaurants&form=MFESRP&publ=WLHMTAG&crea=TEXT_MFESRP_Local_MapsMenu_Resturants_1x1>

________________________________
Windows 7: It works the way you want. Learn more.<http://www.microsoft.com/Windows/windows-7/default.aspx?ocid=PID24727::T:WLMTAGL:ON:WL:en-US:WWL_WIN_evergreen:112009v2>

________________________________
Hotmail: Trusted email with Microsoft's powerful SPAM protection. Sign up now.<http://clk.atdmt.com/GBL/go/177141664/direct/01/%0D%0Ahttp:/clk.atdmt.com/GBL/go/177141664/direct/01/>

________________________________
Windows 7: I wanted simpler, now it's simpler. I'm a rock star.<http://www.microsoft.com/Windows/windows-7/default.aspx?h=myidea?ocid=PID24727::T:WLMTAGL:ON:WL:en-US:WWL_WIN_myidea:112009>

________________________________
Windows 7: I wanted simpler, now it's simpler. I'm a rock star.<http://www.microsoft.com/Windows/windows-7/default.aspx?h=myidea?ocid=PID24727::T:WLMTAGL:ON:WL:en-US:WWL_WIN_myidea:112009>

<center>
<HR>
University College Plymouth St Mark &amp; St John
Derriford Road   Plymouth  PL6 8BH
<P>Phone 01752 636700   Web  marjon.ac.uk
<BR>Principal: Professor Margaret Noble 

<I>
A Church of England College Founded in 1840
<P>
University College Plymouth St Mark &amp; St John is a registered charity the trustee of which is a company limited by guarantee registered in England No. 986239
</I>
</center>


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20091127/96f2efa8/attachment.html


More information about the Xerte mailing list