[Xerte] Re: Xerte Upgrade

Tue Jan 15 16:07:07 GMT 2013

Ok glad you got a short term solution. I just suggested an even worse hack
so ignore that!

Hopefully we'll get this fixed and re-post to this thread once it is.

Make sure everything else works before making it open to everyone again!
Once new LO's are created it wouldn't be easy to revert back to 1.8.

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Adam Read
Sent: 15 January 2013 15:40
To: 'Xerte discussion list'
Subject: [Xerte] Re: Xerte Upgrade

OK, so I've hacked the ldap.php script and got it working. In the end I
worked out that the private function _valid_login($username, $password) was
in fact returning "true" if the ldap table contains 1 row with the correct
data.

So therefore I located the issue as being the "@ldap_search" which was only
using the first row's basedn. I hard coded in both basedn as separate
searches, then in the ldap_get_entries made a check for both being empty to
output the error (#4).

Seems to work fine now but obviously not the ideal solution.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Adam Read BA (Hons) PG Cert ODE (Open)

Senior e-Learning Technologist

University College Plymouth St Mark & St John

Tel: 01752 636700 Ext: 5673 | Room: 108

 <http://moodle.marjon.ac.uk/> elearninglogo300dpi2

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Adam Read
Sent: 15 January 2013 14:04
To: 'Xerte discussion list'
Subject: [Xerte] Re: Xerte Upgrade

I've turned on error reporting, however, it doesn't output anything
different on failed login. Just the following message:

Issue connecting to ldap server (#4) : No entries found 

- which correlates with what I'd expect to see if it's looking in the wrong
OU. Swap the rows around and I get straight in using my staff details, no
errors.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Adam Read BA (Hons) PG Cert ODE (Open)

Senior e-Learning Technologist

University College Plymouth St Mark & St John

Tel: 01752 636700 Ext: 5673 | Room: 108

 <http://moodle.marjon.ac.uk/> elearninglogo300dpi2

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Ron Mitchell
Sent: 15 January 2013 13:16
To: 'Xerte discussion list'
Subject: [Xerte] Re: Xerte Upgrade

It looks like the code should loop through each row in the ldap table trying
to use the username and password posted but I could be wrong about that.
Hopefully someone else will respond but meanwhile try changing $development
= false; to $development = true; in the top of config.php and then restart
all browser windows and see what errors you get when trying to login.

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Adam Read
Sent: 15 January 2013 12:39
To: 'Xerte discussion list'
Subject: [Xerte] Re: Xerte Upgrade

I had that "urika" moment also. However, it still doesn't work. With a
student ldap bind in the first row of ldap table students can login staff
cannot and vice versa. Having 2 rows in the ldap table still only allows
whichever ldap query is set in row one to work.

I thought I might be even sneakier and added the $$$ delimiter to every
value in row 1 of the table but that means no one can login.

Oerrr. 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Adam Read BA (Hons) PG Cert ODE (Open)

Senior e-Learning Technologist

University College Plymouth St Mark & St John

Tel: 01752 636700 Ext: 5673 | Room: 108

 <http://moodle.marjon.ac.uk/> elearninglogo300dpi2

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Ron Mitchell
Sent: 15 January 2013 12:28
To: 'Xerte discussion list'
Subject: [Xerte] Re: Xerte Upgrade

Sorry I don't have regular access to different LDAP configurations to test
this kind of thing but there are some notes in
\library\Xerte\Authentication\Ldap.php that might help you resolve this. As
a guess try adding an extra row in the ldap table which I think you'll have
to do direct in the db because I don't think there's an option for that in
management.php Also from memory there's a field (knownname) that I think
isn't typically used but requires a not null value sow when adding a row
manually just put elm in there which I think is added by default during a
new install.

Let us know if that works or indeed if not?

Pat or David or Thomas if he's about might have additional suggestions.

Ron

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Adam Read
Sent: 15 January 2013 12:05
To: 'Xerte discussion list'
Subject: [Xerte] Re: Xerte Upgrade

OK, so we've identified the problem. It would appear that 1.9 no longer
likes "multiple entries" in the LDAP configuration.

So, in our installation we use the $$$ delimiter to differentiate ldap calls
between staff and students. This breaks it with a "binding" error at logon.
Using just the details for either staff or students works.

Any ideas if the delimiter stuff has been altered in the upgrade?

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Adam Read BA (Hons) PG Cert ODE (Open)

Senior e-Learning Technologist

University College Plymouth St Mark & St John

Tel: 01752 636700 Ext: 5673 | Room: 108

 <http://moodle.marjon.ac.uk/> elearninglogo300dpi2

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Ron Mitchell
Sent: 15 January 2013 11:30
To: 'Xerte discussion list'
Subject: [Xerte] Re: Xerte Upgrade

You can change the settings via management.php but if you're looking direct
in the database perhaps the attached will help?

Let us know?

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Adam Read
Sent: 15 January 2013 11:06
To: 'Xerte discussion list'
Subject: [Xerte] Re: Xerte Upgrade

OK, so I've followed all the steps listed below (guest access worked etc)
and when attempting to login via LDAP I'm getting 

Issue connecting to ldap server (#2) : Binding

All the details in the ldap table look correct to me. The only thing missing
was a blank "ldap_filter" entry whereas ldap_filter_atr had a value. Is this
the issue? I've tried changing the entries to be the same with no joy but
suspect that's wrong

 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Adam Read BA (Hons) PG Cert ODE (Open)

Senior e-Learning Technologist

University College Plymouth St Mark & St John

Tel: 01752 636700 Ext: 5673 | Room: 108

 <http://moodle.marjon.ac.uk/> elearninglogo300dpi2

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Ron Mitchell
Sent: 15 January 2013 10:25
To: 'Xerte discussion list'
Subject: [Xerte] Re: Xerte Upgrade

Why create a new install? Easier and better to upgrade the existing install.
General process as follows:

1. backup existing database and directory just in case

2. drop 1.9 code over top of existing code

3. visit the install to test the basics are working ok via guest access e.g.
create and test an LO

4. If you are using LDAP for authentication visit
http://yourinstall/upgrade.php to automatically copy details from
sitedeatils to ldap table

5. change from guest to ldap or one of the other authentication options in
auth_config.php by commenting/un-commenting the relevant line

6. If you are using Moodle for authentication read and follow the
instructions in the moodle_integration_readme file

7. refresh index.php and test login and creation etc

A final point - there isn't a maintenance mode like these is in Moodle for
preventing non-admins logging in during upgrade and you dodn't want people
creating new LO's in case you do have to revert back so perhaps schedule
this and notify people and/or rename index.php temporarily so only you can
visit and test etc.

HTH

Ron

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Adam Read
Sent: 15 January 2013 09:49
To: 'Xerte discussion list'
Subject: [Xerte] Re: Xerte Upgrade

I was hoping to do the very same today. Any technical suggestions for this
all?

I suppose the alternative is to run up a new installation of XOT in a
separate location/database and then move the user content over - how
possible/easy is this?

Guidance gratefully received.

Adam

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Adam Read BA (Hons) PG Cert ODE (Open)

Senior e-Learning Technologist

University College Plymouth St Mark & St John

Tel: 01752 636700 Ext: 5673 | Room: 108

 <http://moodle.marjon.ac.uk/> elearninglogo300dpi2

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Butler, Ross
Sent: 20 September 2012 10:28
To: Xerte discussion list (xerte at lists.nottingham.ac.uk)
Subject: [Xerte] Xerte Upgrade

Dear all,

We are currently seeking to upgrade from an older version of Xerte (Online
Toolkits) hosted on IIS to the latest version. We wish to maintain the
existing database in order to preserve our existing content. Which config
files would need to be modified after installing a fresh version of Xerte in
order to hook it up to our existing database? I presume that once done,
Xerte will pick up our LDAP settings from the database but would any
additional configuration be required in order to re-enable LDAP
authentication on this new install (we authenticate at present using our
Active Directory server with Xerte)?

Many thanks in advance for your assistance,

Kind regards,

Ross

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. 

University College Plymouth St Mark & St John,  Derriford Road, Plymouth,
PL6 8BH 
            Phone:  01752 636700     Web:  www.ucpmarjon.ac.uk 
 Acting Principal: Karen Cook    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.
7635609
University College Plymouth St Mark & St John,  Derriford Road, Plymouth,
PL6 8BH 
            Phone:  01752 636700     Web:  www.ucpmarjon.ac.uk 
 Acting Principal: Karen Cook    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.
7635609
University College Plymouth St Mark & St John,  Derriford Road, Plymouth,
PL6 8BH 
            Phone:  01752 636700     Web:  www.ucpmarjon.ac.uk 
 Acting Principal: Karen Cook    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.
7635609
University College Plymouth St Mark & St John,  Derriford Road, Plymouth,
PL6 8BH 
            Phone:  01752 636700     Web:  www.ucpmarjon.ac.uk 
 Acting Principal: Karen Cook    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.
7635609
University College Plymouth St Mark & St John,  Derriford Road, Plymouth,
PL6 8BH 
            Phone:  01752 636700     Web:  www.ucpmarjon.ac.uk 
 Acting Principal: Karen Cook    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.
7635609
University College Plymouth St Mark & St John,  Derriford Road, Plymouth,
PL6 8BH 
            Phone:  01752 636700     Web:  www.ucpmarjon.ac.uk 
 Acting Principal: Karen Cook    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.
7635609
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20130115/2039c398/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 3679 bytes
Desc: not available
URL: <http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20130115/2039c398/attachment-0001.jpg>