[Xerte] Re: Upgraded to XOT 2.1 - worked and then broke it

Thu Nov 21 11:26:34 GMT 2013

Hi Adam,

Pod_one and pod_two are base64 encoded (for legacy reasons) and should be like that.... The other two form and peer are probably the same...

Regards,

John Smith
Learning Technologist
School of Health & Life Sciences
Glasgow Caledonian University

From: xerte-bounces at lists.nottingham.ac.uk [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Adam Read
Sent: Thursday, November 21, 2013 11:04 AM
To: 'Xerte discussion list'
Subject: [Xerte] Re: Upgraded to XOT 2.1 - worked and then broke it

Hi Pat

The LDAP table has 2 rows, both the same, duplicating our ldap details which has 2 separate queries separated with $$$ (this has always worked).

Sitedetails has the same LDAP values.

However, sitedetails appears to be full of junk (?) data (e.g. pod_one, form_string) following using the management page (?) (note, I've hidden some values with XXXX):

  <!-- Table sitedetails -->
    <sitedetails>
        <site_id>1</site_id>
        <site_url>http://elearning.net.marjon.ac.uk/xerte2/</site_url<http://elearning.net.marjon.ac.uk/xerte2/%3c/site_url>>
        <apache>false</apache>
        <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,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,application/vnd.openxmlformats-officedocument.wordprocessingml.document,application/vnd.openxmlformats-officedocument.presentationml.presentation</mimetypes>
        <site_session_name>XERTE_TOOLKITS</site_session_name>
        <LDAP_preference>XXXX</LDAP_preference>
        <LDAP_filter>XXXX</LDAP_filter>
        <integration_config_path></integration_config_path>
        <admin_username>XXXXX</admin_username>
        <admin_password>XXXXX</admin_password>
        <site_title>Welcome to Xerte Online Toolkits</site_title>
        <site_name>Xerte Online Toolkits</site_name>
        <site_logo>website_code/images/xerteLogo.jpg</site_logo>
        <organisational_logo>website_code/images/UofNLogo.jpg</organisational_logo>
        <welcome_message>Welcome to Xerte Online Toolkits</welcome_message>
        <site_text>Welcome to the toolkits front page, developed by the University of Nottingham~~~</site_text>
        <news_text>PHAgY2xhc3M9Im5ld3NfdGl0bGUiPk90aGVyIHJlc291cmNlczwvcD48cCBjbGFzcz0ibmV3c19zdG9yeSI+PGEgaHJlZj0iIj5TaXRlIDE8L2E+PC9wPjxwIGNsYXNzPSJuZXdzX3N0b3J5Ij48YSBocmVmPSIiPlNpdGUgMjwvYT48L3A+PHAgY2xhc3M9Im5ld3Nfc3RvcnkiPjxhIGhyZWY9IiI+U2l0ZSAzPC9hPjwvcD4=</news_text>
        <pod_one>PHAgY2xhc3M9Im5ld3NfdGl0bGUiPlJlc291cmNlczwvcD48cCBjbGFzcz0iZGVtbyI+PGEgaHJlZj0iaHR0cDovL3d3dy54ZXJ0ZS5vcmcudWsiPkNvbW11bml0eSBSZXNvdXJjZXM8L2E+PGJyIC8+VGhlIFhlcnRlIHVzZXIgY29tbXVuaXR5IHdlYnNpdGUuPC9wPjxwIGNsYXNzPSJkZW1vIj48YSBocmVmPSJodHRwOi8vd3d3Lm5vdHRpbmdoYW0uYWMudWsvdG9vbGtpdHMvcGxheV81NjAiPkxlYXJuaW5nIE9iamVjdCBEZW1vPC9hPjxiciAvPkEgY29tcHJlaGVuc2l2ZSBkZW1vIG9mIGFsbCB0aGUgcGFnZSB0ZW1wbGF0ZXMuPC9wPg==</pod_one>
        <pod_two>PHAgY2xhc3M9Im5ld3NfdGl0bGUiPk5lZWQgc29tZSBoZWxwPzwvcD48cCBjbGFzcz0iZ2VuZXJhbCI+WGVydGUgaXMgaG9zdGVkIGJ5IHRoZSBlLUxlYXJuaW5nIFRlYW0uIEdldCBpbiB0b3VjaCB3aXRoIHVzIHZpYSA8YSBocmVmPSJtYWlsdG86TFNIZWxwQG1hcmpvbi5hYy51ayI+TFNIZWxwQG1hcmpvbi5hYy51azwvYT4uPC9wPg==</pod_two>
        <copyright>Xerte Copyright University of Nottingham 2008 - 2013</copyright>
        <rss_title>Xerte Online Toolkits RSS Feed</rss_title>
        <synd_publisher>University of St Mark</synd_publisher>
        <synd_rights>Licensed under a Creative Commons Attribution - NonCommercial-ShareAlike 2.0 Licence - see http://creativecommons.org/licenses/by-nc-sa/2.0/uk/</synd_rights<http://creativecommons.org/licenses/by-nc-sa/2.0/uk/%3c/synd_rights>>
        <synd_license>Licensed under a Creative Commons Attribution - NonCommercial-ShareAlike 2.0 Licence - see http://creativecommons.org/licenses/by-nc-sa/2.0/uk/</synd_license<http://creativecommons.org/licenses/by-nc-sa/2.0/uk/%3c/synd_license>>
        <demonstration_page>modules/xerte/training/toolkits.htm</demonstration_page>
        <form_string>PGh0bWw+PGJvZHk+PGNlbnRlcj48cD48Zm9ybSBtZXRob2Q9InBvc3QiIGFjdGlvbj0iIj48cD5Vc2VybmFtZSA8aW5wdXQgdHlwZT0idGV4dCIgc2l6ZT0iMjAiIG1heGxlbmd0aD0iMTIiIG5hbWU9ImxvZ2luIiAvPjwvcD48cD5QYXNzd29yZCA8aW5wdXQgdHlwZT0icGFzc3dvcmQiIHNpemU9IjIwIiBtYXhsZW5ndGg9IjM2IiBuYW1lPSJwYXNzd29yZCIgLz48L3A+PHA+PGlucHV0IHR5cGU9ImltYWdlIiBzcmM9IndlYnNpdGVfY29kZS9pbWFnZXMvQnR0bl9Mb2dpbk9mZi5naWYiIG9ubW91c2VvdmVyPSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT24uZ2lmJyIgb25tb3VzZWRvd249InRoaXMuc3JjPSd3ZWJzaXRlX2NvZGUvaW1hZ2VzL0J0dG5fTG9naW5DbGljay5naWYnIiBvbm1vdXNlb3V0PSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT2ZmLmdpZiciIC8+PC9wPg==</form_string>
        <peer_form_string>PGh0bWw+PGJvZHk+PGNlbnRlcj48cD48Zm9ybSBtZXRob2Q9InBvc3QiIGFjdGlvbj0iIj48cD5QYXNzd29yZCA8aW5wdXQgdHlwZT0icGFzc3dvcmQiIHNpemU9IjIwIiBtYXhsZW5ndGg9IjM2IiBuYW1lPSJwYXNzd29yZCIgLz48L3A+PHA+PGlucHV0IHR5cGU9ImltYWdlIiBzcmM9IndlYnNpdGVfY29kZS9pbWFnZXMvQnR0bl9Mb2dpbk9mZi5naWYiIG9ubW91c2VvdmVyPSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT24uZ2lmJyIgb25tb3VzZWRvd249InRoaXMuc3JjPSd3ZWJzaXRlX2NvZGUvaW1hZ2VzL0J0dG5fTG9naW5DbGljay5naWYnIiBvbm1vdXNlb3V0PSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT2ZmLmdpZiciIC8+PC9wPg==</peer_form_string>
        <module_path>modules/</module_path>
        <website_code_path>website_code/</website_code_path>
        <users_file_area_short>USER-FILES/</users_file_area_short>
        <php_library_path>website_code/php/</php_library_path>
        <import_path>C:/Inetpub/wwwroot/xerte2/import/</import_path>
        <root_file_path>C:/Inetpub/wwwroot/xerte2/</root_file_path>
        <play_edit_preview_query>c2VsZWN0ICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gIm9yaWdpbmFsdGVtcGxhdGVzZGV0YWlscy50ZW1wbGF0ZV9uYW1lLCAiIC4gJHhlcnRlX3Rvb2xraXRzX3NpdGUtPmRhdGFiYXNlX3RhYmxlX3ByZWZpeCAuICJsb2dpbmRldGFpbHMudXNlcm5hbWUsICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gIm9yaWdpbmFsdGVtcGxhdGVzZGV0YWlscy50ZW1wbGF0ZV9mcmFtZXdvcmssICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlcmlnaHRzLnVzZXJfaWQsICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlcmlnaHRzLmZvbGRlciwgIiAuICR4ZXJ0ZV90b29sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAidGVtcGxhdGVyaWdodHMudGVtcGxhdGVfaWQsICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlZGV0YWlscy5hY2Nlc3NfdG9fd2hvbSBmcm9tICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gIm9yaWdpbmFsdGVtcGxhdGVzZGV0YWlscywgIiAuICR4ZXJ0ZV90b29sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAidGVtcGxhdGVyaWdodHMsICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlZGV0YWlscywgIiAuICR4ZXJ0ZV90b29sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAibG9naW5kZXRhaWxzIHdoZXJlICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlZGV0YWlscy50ZW1wbGF0ZV90eXBlX2lkID0gIiAuICR4ZXJ0ZV90b29sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAib3JpZ2luYWx0ZW1wbGF0ZXNkZXRhaWxzLnRlbXBsYXRlX3R5cGVfaWQgYW5kICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlZGV0YWlscy5jcmVhdG9yX2lkID0gIiAuICR4ZXJ0ZV90b29sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAibG9naW5kZXRhaWxzLmxvZ2luX2lkIGFuZCAiIC4gJHhlcnRlX3Rvb2xraXRzX3NpdGUtPmRhdGFiYXNlX3RhYmxlX3ByZWZpeCAuICJ0ZW1wbGF0ZXJpZ2h0cy50ZW1wbGF0ZV9pZCA9ICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlZGV0YWlscy50ZW1wbGF0ZV9pZCBhbmQgIiAuICR4ZXJ0ZV90b29sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAidGVtcGxhdGVyaWdodHMudGVtcGxhdGVfaWQ9IlRFTVBMQVRFX0lEX1RPX1JFUExBQ0UiIGFuZCByb2xlPSJjcmVhdG9yIg==</play_edit_preview_query>
        <error_log_path>error_logs/</error_log_path>
        <email_error_list></email_error_list>
        <error_log_message>true</error_log_message>
        <max_error_size>10</max_error_size>
        <error_email_message>10</error_email_message>
        <ldap_host>XXXX</ldap_host>
        <ldap_port>XXXX</ldap_port>
        <bind_pwd>XXXX</bind_pwd>
        <basedn>XXXX</basedn>
        <bind_dn>XXXX</bind_dn>
        <flash_save_path>modules/xerte/engine/save.php</flash_save_path>
        <flash_upload_path>upload.php?path=</flash_upload_path>
        <flash_preview_check_path>modules/xerte/engine/file_exists.php</flash_preview_check_path>
        <flash_flv_skin>modules/xerte/engine/tools/SteelOverAll.swf</flash_flv_skin>
        <site_email_account></site_email_account>
        <headers></headers>
        <email_to_add_to_username></email_to_add_to_username>
        <proxy1></proxy1>
        <port1></port1>
        <feedback_list></feedback_list>
    </sitedetails>

Just to note that setting login to guest allows access, so perhaps the weird data above isn't impacting the ldap login?

Adam

Adam Read BA (Hons) PG Cert ODE (Open)
Senior e-Learning Technologist
University of St Mark & St John

From: xerte-bounces at lists.nottingham.ac.uk<mailto:xerte-bounces at lists.nottingham.ac.uk> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Pat @ Pgogy
Sent: 18 November 2013 13:13
To: Xerte discussion list
Subject: [Xerte] Re: Upgraded to XOT 2.1 - worked and then broke it

Did you look in the sitedetails or ldapdetails for the ldap stuff?

On Mon, Nov 18, 2013 at 12:02 PM, Adam Read <aread at marjon.ac.uk<mailto:aread at marjon.ac.uk>> wrote:
Hi Ron

It works with Guest access so must be an LDAP issue. Not sure what else to try as settings in the DB look the same as always.

Is there anything in the sitedetails table that might be worth checking?

Adam

Adam Read BA (Hons) PG Cert ODE (Open)
Senior e-Learning Technologist
University of St Mark & St John

From: xerte-bounces at lists.nottingham.ac.uk<mailto:xerte-bounces at lists.nottingham.ac.uk> [mailto:xerte-bounces at lists.nottingham.ac.uk<mailto:xerte-bounces at lists.nottingham.ac.uk>] On Behalf Of Ron Mitchell
Sent: 18 November 2013 12:00
To: xerte at pgogywebstuff.com<mailto:xerte at pgogywebstuff.com>; 'Xerte discussion list'
Subject: [Xerte] Re: Upgraded to XOT 2.1 - worked and then broke it

Also does switching back to guest access allow the installation to work or is it now broken regardless of authentication method? e.g. is the problem exclusive to ldap or wider than that?
Close all browserwindows or clear cache after making that change.
HTH
Ron

From: xerte-bounces at lists.nottingham.ac.uk<mailto:xerte-bounces at lists.nottingham.ac.uk> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Pat @ Pgogy
Sent: 18 November 2013 11:18
To: Xerte discussion list
Subject: [Xerte] Re: Upgraded to XOT 2.1 - worked and then broke it

ok, so LDAP doesn't seem to work

Try installing a localhost, but setting the LDAP to be the settings in the database

Does that connect?

On Mon, Nov 18, 2013 at 8:52 AM, Adam Read <aread at marjon.ac.uk<mailto:aread at marjon.ac.uk>> wrote:
I have looked at the database. The LDAP tables look the same as before (as far as I can tell).

Adam Read BA (Hons) PG Cert ODE (Open)
Senior e-Learning Technologist
University of St Mark & St John

From: xerte-bounces at lists.nottingham.ac.uk<mailto:xerte-bounces at lists.nottingham.ac.uk> [mailto:xerte-bounces at lists.nottingham.ac.uk<mailto:xerte-bounces at lists.nottingham.ac.uk>] On Behalf Of Pat @ Pgogy
Sent: 15 November 2013 17:34
To: Xerte discussion list
Subject: [Xerte] Re: Upgraded to XOT 2.1 - worked and then broke it

Hello,

Guessing that "save" has broken something. If it is logging in that's not working, I would suggest going into the DB via something other than management and checking for settings.

Pat

On Fri, Nov 15, 2013 at 2:57 PM, Adam Read <aread at marjon.ac.uk<mailto:aread at marjon.ac.uk>> wrote:
Hi all

Hope you can help! Just upgraded our XOT installation to 2.1 using the 2.1 ZIP and 2.1_update zip from the community site. I did the following:

(0)    Backed up XOT 2.0 installation

1)      Extracted 2.1 zip and copied files over top of XOT installation

2)      Extracted 2.1 update zip and copied over top of XOT installation

3)      Tried to login to XOT via browser - logged me in as a Guest

4)      Edited auth_config and commented out guest, opted for Ldap.

5)      Successfully logged in OK and could see my own content

6)      Logged in to Management.php to tweak some of the help text, clicked "save"

7)      Could no longer login to index.php

8)      Reverted changes in mangement.php - saved

9)      Still couldn't login to index

10)   Repeated steps 1 and 2 and then 4 to overwrite files

11)   Still can't login.

I'm a bit stuck! As far as I can tell the Ldap settings inside management.php and the MySQL database look fine. Can't see any errors, cleared cash, tried 3 different browsers.

Hmmmm?

Adam Read BA (Hons) PG Cert ODE (Open)
Senior e-Learning Technologist
University of St Mark & St John

This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it.   Please do not use, copy or disclose the information contained in this message or in any attachment.  Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.

This message has been checked for viruses but the contents of an attachment may still contain software viruses which could damage your computer system, you are advised to perform your own checks. Email communications with the University of Nottingham may be monitored as permitted by UK legislation.

_______________________________________________
Xerte mailing list
Xerte at lists.nottingham.ac.uk<mailto:Xerte at lists.nottingham.ac.uk>
http://lists.nottingham.ac.uk/mailman/listinfo/xerte

This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it.   Please do not use, copy or disclose the information contained in this message or in any attachment.  Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.

This message has been checked for viruses but the contents of an attachment may still contain software viruses which could damage your computer system, you are advised to perform your own checks. Email communications with the University of Nottingham may be monitored as permitted by UK legislation.

[http://www.marjon.ac.uk/media/marjon/promotions/email-signature/Email_Signature_Image.jpg]

This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it.   Please do not use, copy or disclose the information contained in this message or in any attachment.  Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.

This message has been checked for viruses but the contents of an attachment may still contain software viruses which could damage your computer system, you are advised to perform your own checks. Email communications with the University of Nottingham may be monitored as permitted by UK legislation.

Glasgow Caledonian University is a registered Scottish charity, number SC021474

Winner: Times Higher Education's Widening Participation Initiative of the Year 2009 and Herald Society's Education Initiative of the Year 2009.
http://www.gcu.ac.uk/newsevents/news/bycategory/theuniversity/1/name,6219,en.html

Winner: Times Higher Education's Outstanding Support for Early Career Researchers of the Year 2010, GCU as a lead with Universities Scotland partners.
http://www.gcu.ac.uk/newsevents/news/bycategory/theuniversity/1/name,15691,en.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20131121/e98c9a41/attachment-0001.html>