[Xerte] Re: Xerte Upgrade

Tue Jan 15 15:39:33 GMT 2013

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
[elearninglogo300dpi2]<http://moodle.marjon.ac.uk/>

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
[elearninglogo300dpi2]<http://moodle.marjon.ac.uk/>

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 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> [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
[elearninglogo300dpi2]<http://moodle.marjon.ac.uk/>

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 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> [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
[elearninglogo300dpi2]<http://moodle.marjon.ac.uk/>

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 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> [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
[elearninglogo300dpi2]<http://moodle.marjon.ac.uk/>

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 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> [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
[elearninglogo300dpi2]<http://moodle.marjon.ac.uk/>

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 Butler, Ross
Sent: 20 September 2012 10:28
To: Xerte discussion list (xerte at lists.nottingham.ac.uk<mailto: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<http://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