[Xerte] XOT install - down the rabbit hole

Fri Nov 27 16:19:56 GMT 2009

.rlt, .rlm, .rlo, .xwd are all xml variants. That's it I think.

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

Is there a list of types I can send to the ISP?

________________________________

Subject: RE: [Xerte] XOT install - down the rabbit hole
Date: Fri, 27 Nov 2009 15:39:39 +0000
From: Patrick.Lockley at nottingham.ac.uk
To: xerte at lists.nottingham.ac.uk

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,ima
ge/jpeg,image/pjpeg,image/png,image/gif,image/x-png,audio/mpeg,applicati
on/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="PHAgY2xhc3M9Im5ld3NfdGl0bGUiPk90aGVyIHJlc291cmNlczwvcD48cCBjb
GFzcz0ibmV3c19zdG9yeSI+PGEgaHJlZj0iIj5TaXRlIDE8L2E+PC9wPjxwIGNsYXNzPSJuZ
XdzX3N0b3J5Ij48YSBocmVmPSIiPlNpdGUgMjwvYT48L3A+PHAgY2xhc3M9Im5ld3Nfc3Rvc
nkiPjxhIGhyZWY9IiI+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
+PGEgaHJlZj0iamF2YXNjcmlwdDphbGVydCgnU29ycnkuIFRoaXMgaXMgbm90IHlldCBhdmF
pbGFibGUnKSI+MzAgU2Vjb25kIERlbW88L2E+PGJyIC8+QSB2ZXJ5IHNob3J0IGNhcHRpdmF
0ZSBmaWxlIHNob3dpbmcgYSBzaW1wbGUgcHJvamVjdCBiZWluZyBzdGFydGVkLCBidWlsdCB
hbmQgcHVibGlzaGVkIGZvciB0aGUgd2ViLjwvcD48cCBjbGFzcz0iZGVtbyI+PGEgaHJlZj0
iamF2YXNjcmlwdDphbGVydCgnU29ycnkuIFRoaXMgaXMgbm90IHlldCBhdmFpbGFibGUnKSI
+TGVhcm5pbmcgT2JqZWN0IERlbW88L2E+PGJyIC8+QSB2ZXJ5IHNpbXBsZSBkZW1vIG9mIGE
gbGVhcm5pbmcgb2JqZWN0LjwvcD4=" 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="PHAgY2xhc3M9Im5ld3NfdGl0bGUiPldhbnQgdG8gc2hhcmUgc29tZSB0aG91Z2h
0cz88L3A+PHAgY2xhc3M9ImdlbmVyYWwiPklmIHlvdSBoYXZlIGFueSBxdWVzdGlvbnMsIHJ
lcXVlc3RzIGZvciBoZWxwLCBpZGVhcyBmb3IgbmV3IHByb2plY3RzIG9yIHByb2JsZW1zIHR
vIHJlcG9ydCwgdGhlbiBwbGVhc2UgZ2V0IGluIHRvdWNoLjwvcD48cCBjbGFzcz0iZ2VuZXJ
hbCI+UGxlYXNlIHVzZSBvdXIgPGEgaHJlZj0iZmVlZGJhY2svIiBzdHlsZT0iY29sb3I6IzA
wMCI+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+PGNlbnRlcj48cD48Zm9ybSBtZXRob2Q9InBvc3QiIGF
jdGlvbj0iIj48cD5Vc2VybmFtZSA8aW5wdXQgdHlwZT0idGV4dCIgc2l6ZT0iMjAiIG1heGx
lbmd0aD0iMTIiIG5hbWU9ImxvZ2luIiAvPjwvcD48cD5QYXNzd29yZCA8aW5wdXQgdHlwZT0
icGFzc3dvcmQiIHNpemU9IjIwIiBtYXhsZW5ndGg9IjM2IiBuYW1lPSJwYXNzd29yZCIgLz4
8L3A+PHA+PGlucHV0IHR5cGU9ImltYWdlIiBzcmM9IndlYnNpdGVfY29kZS9pbWFnZXMvQnR
0bl9Mb2dpbk9mZi5naWYiIG9ubW91c2VvdmVyPSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2l
tYWdlcy9CdHRuX0xvZ2luT24uZ2lmJyIgb25tb3VzZWRvd249InRoaXMuc3JjPSd3ZWJzaXR
lX2NvZGUvaW1hZ2VzL0J0dG5fTG9naW5DbGljay5naWYnIiBvbm1vdXNlb3V0PSJ0aGlzLnN
yYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT2ZmLmdpZiciIC8+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+PGNlbnRlcj48cD48Zm9ybSBtZXRob2Q9InBvc3
QiIGFjdGlvbj0iIj48cD5QYXNzd29yZCA8aW5wdXQgdHlwZT0icGFzc3dvcmQiIHNpemU9Ij
IwIiBtYXhsZW5ndGg9IjM2IiBuYW1lPSJwYXNzd29yZCIgLz48L3A+PHA+PGlucHV0IHR5cG
U9ImltYWdlIiBzcmM9IndlYnNpdGVfY29kZS9pbWFnZXMvQnR0bl9Mb2dpbk9mZi5naWYiIG
9ubW91c2VvdmVyPSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT2
4uZ2lmJyIgb25tb3VzZWRvd249InRoaXMuc3JjPSd3ZWJzaXRlX2NvZGUvaW1hZ2VzL0J0dG
5fTG9naW5DbGljay5naWYnIiBvbm1vdXNlb3V0PSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2
ltYWdlcy9CdHRuX0xvZ2luT2ZmLmdpZiciIC8+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.c
om/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=P
ID24727::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=P
ID24727::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=P
ID24727::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/39565707/attachment.html