[Xerte] XOT install - down the rabbit hole

Mon Nov 30 14:58:48 GMT 2009

Hmm on a train at the moment - who exactly you teasing Pat?

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 16:05
To: Xerte discussion list
Subject: RE: [Xerte] XOT install - down the rabbit hole

.rlm

.rlo

.rlt

I think

As text/xml

And for purely teasing purposes -
http://ltdev.nottingham.ac.uk/live/play.php?template_id=22

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

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 

 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/j
peg,image/pjpeg,image/png,image/gif,image/x-png,audio/mpeg,application/vnd.m
s-excel,application/pdf,application/vnd.ms-powerpoint,video/x-ms-wmv,text/ht
ml,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="PHAgY2xhc3M9Im5ld3NfdGl0bGUiPk90aGVyIHJlc291cmNlczwvcD48cCBjbGFzc
z0ibmV3c19zdG9yeSI+PGEgaHJlZj0iIj5TaXRlIDE8L2E+PC9wPjxwIGNsYXNzPSJuZXdzX3N0b
3J5Ij48YSBocmVmPSIiPlNpdGUgMjwvYT48L3A+PHAgY2xhc3M9Im5ld3Nfc3RvcnkiPjxhIGhyZ
WY9IiI+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+PGE
gaHJlZj0iamF2YXNjcmlwdDphbGVydCgnU29ycnkuIFRoaXMgaXMgbm90IHlldCBhdmFpbGFibGU
nKSI+MzAgU2Vjb25kIERlbW88L2E+PGJyIC8+QSB2ZXJ5IHNob3J0IGNhcHRpdmF0ZSBmaWxlIHN
ob3dpbmcgYSBzaW1wbGUgcHJvamVjdCBiZWluZyBzdGFydGVkLCBidWlsdCBhbmQgcHVibGlzaGV
kIGZvciB0aGUgd2ViLjwvcD48cCBjbGFzcz0iZGVtbyI+PGEgaHJlZj0iamF2YXNjcmlwdDphbGV
ydCgnU29ycnkuIFRoaXMgaXMgbm90IHlldCBhdmFpbGFibGUnKSI+TGVhcm5pbmcgT2JqZWN0IER
lbW88L2E+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="PHAgY2xhc3M9Im5ld3NfdGl0bGUiPldhbnQgdG8gc2hhcmUgc29tZSB0aG91Z2h0cz8
8L3A+PHAgY2xhc3M9ImdlbmVyYWwiPklmIHlvdSBoYXZlIGFueSBxdWVzdGlvbnMsIHJlcXVlc3R
zIGZvciBoZWxwLCBpZGVhcyBmb3IgbmV3IHByb2plY3RzIG9yIHByb2JsZW1zIHRvIHJlcG9ydCw
gdGhlbiBwbGVhc2UgZ2V0IGluIHRvdWNoLjwvcD48cCBjbGFzcz0iZ2VuZXJhbCI+UGxlYXNlIHV
zZSBvdXIgPGEgaHJlZj0iZmVlZGJhY2svIiBzdHlsZT0iY29sb3I6IzAwMCI+RmVlZGJhY2sgRm9
ybTwvYT48L3A+" 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+PGNlbnRlcj48cD48Zm9ybSBtZXRob2Q9InBvc3QiIGFjdGl
vbj0iIj48cD5Vc2VybmFtZSA8aW5wdXQgdHlwZT0idGV4dCIgc2l6ZT0iMjAiIG1heGxlbmd0aD0
iMTIiIG5hbWU9ImxvZ2luIiAvPjwvcD48cD5QYXNzd29yZCA8aW5wdXQgdHlwZT0icGFzc3dvcmQ
iIHNpemU9IjIwIiBtYXhsZW5ndGg9IjM2IiBuYW1lPSJwYXNzd29yZCIgLz48L3A+PHA+PGlucHV
0IHR5cGU9ImltYWdlIiBzcmM9IndlYnNpdGVfY29kZS9pbWFnZXMvQnR0bl9Mb2dpbk9mZi5naWY
iIG9ubW91c2VvdmVyPSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT24
uZ2lmJyIgb25tb3VzZWRvd249InRoaXMuc3JjPSd3ZWJzaXRlX2NvZGUvaW1hZ2VzL0J0dG5fTG9
naW5DbGljay5naWYnIiBvbm1vdXNlb3V0PSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9
CdHRuX0xvZ2luT2ZmLmdpZiciIC8+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+PGNlbnRlcj48cD48Zm9ybSBtZXRob2Q9InBvc3QiIG
FjdGlvbj0iIj48cD5QYXNzd29yZCA8aW5wdXQgdHlwZT0icGFzc3dvcmQiIHNpemU9IjIwIiBtYX
hsZW5ndGg9IjM2IiBuYW1lPSJwYXNzd29yZCIgLz48L3A+PHA+PGlucHV0IHR5cGU9ImltYWdlIi
BzcmM9IndlYnNpdGVfY29kZS9pbWFnZXMvQnR0bl9Mb2dpbk9mZi5naWYiIG9ubW91c2VvdmVyPS
J0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT24uZ2lmJyIgb25tb3VzZW
Rvd249InRoaXMuc3JjPSd3ZWJzaXRlX2NvZGUvaW1hZ2VzL0J0dG5fTG9naW5DbGljay5naWYnIi
Bvbm1vdXNlb3V0PSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT2ZmLm
dpZiciIC8+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
<http://clk.atdmt.com/GBL/go/177141665/direct/01/>  now.

  _____  

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

  _____  

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

  _____  

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

  _____  

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

  _____  

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

  _____  

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=PID24
727::T:WLMTAGL:ON:WL:en-US:WWL_WIN_myidea:112009> 

  _____  

University College Plymouth St Mark & St John
Derriford Road   Plymouth  PL6 8BH

Phone 01752 636700   Web  marjon.ac.uk

Principal: Professor Margaret Noble 

A Church of England College Founded in 1840

University College Plymouth St Mark & St John is a registered charity the
trustee of which is a company limited by guarantee registered in England No.
986239

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