[Xerte] XOT install - down the rabbit hole

Fri Nov 27 15:28:59 GMT 2009

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.

_________________________________________________________________
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20091127/edce92a9/attachment.html