[Xerte] XOT install - down the rabbit hole

Fri Nov 27 17:42:02 GMT 2009

>What does view source show you?
Blank.
Pop-up window has address of: domain/xerte_ot/edit.php?template_id=6

>Install fiddler and track what PHP runs
Already have it. I'll run it.

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 17:20

To: Xerte list

Subject: RE: [Xerte] XOT install - down the rabbit hole

I actually found a spot in the ISP control panel to add MIME.

Tried:

text/xml

and 

text/plain

for the 4 types.

Still get a blank window on Create.

:-|

Subject:
RE: [Xerte] XOT install - down the rabbit hole

Date: Fri, 27 Nov 2009 16:05:14 +0000

From: Patrick.Lockley at nottingham.ac.uk

To: xerte at lists.nottingham.ac.uk

.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 

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="©
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.

Windows 7: It works the way you want. Learn
more.

Bing brings you maps, menus, and reviews
organized in one place. Try
it now.

Windows 7: It works the way you want. Learn
more.

Hotmail: Trusted email with Microsoft's powerful
SPAM protection. Sign
up now.

Windows 7: I wanted simpler, now it's
simpler. I'm
a rock star.

  University College Plymouth St Mark & St JohnDerriford 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

Hotmail: Trusted email with Microsoft's
powerful SPAM protection. Sign up now.

_________________________________________________________________
Bing brings you maps, menus, and reviews organized in one place.
http://www.bing.com/search?q=restaurants&form=MFESRP&publ=WLHMTAG&crea=TEXT_MFESRP_Local_MapsMenu_Resturants_1x1
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20091127/efa6d155/attachment.html