[Xerte] LDAP settings

Wed Feb 10 14:25:52 GMT 2010

Trawling the archives it seems the database.php is a regular culprit.

Maybe the first thing to do would be to download database.php and see if your correct info is in there.

There seems to be 2 regular things that crop up:

1. AS PL mentioned, wrong permissions so the file does not get updated with your info.
2. It's corrupted, e.g. user puts in "mypass" and it shows up as "aamypass", etc (not sure what would cause that one)

Better error handling would be handy, but at least in the interim this might get someone up and running.

Dave

----------------------------------------
> Subject: RE: [Xerte] LDAP settings
> Date: Wed, 10 Feb 2010 14:00:10 +0000
> From: Patrick.Lockley at nottingham.ac.uk
> To: xerte at lists.nottingham.ac.uk
>
> The problem is the mysql error trapping isn't great (and is often
> governed by individual set ups), and you don't always get a reliable
> error message back from the server (there are php functions you can use,
> but sometimes they aren't set up, so if you call them you get nothing).
>
> The problem isn't directly the database selection here, it's the file
> permissions, and the only way to test that is to use chmod, but I don't
> know if chmod works on IIS as a function call, it might even be blocked
> on some hosts.
>
> I've asked on here before if some one could run some scripts for me to
> see what happens on IIS, no one ever got back to me.
>
> -----Original Message-----
> From: xerte-bounces at lists.nottingham.ac.uk
> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Julian Tenney
> Sent: 10 February 2010 13:51
> To: Xerte discussion list
> Subject: RE: [Xerte] LDAP settings
>
> Can we make the error messages point to thyose sort of things? If the
> error gets thrown, in this case 'No database selected' then can we also
> highlight the possible problems solutions?
>
> Otherwise we have the situation where someone did select a database and
> the computer says 'no you didn't' and he says 'yes I did' and it all
> gets a bit rowdy.
>
> -----Original Message-----
> From: xerte-bounces at lists.nottingham.ac.uk
> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Patrick
> Lockley
> Sent: Wednesday, February 10, 2010 1:40 PM
> To: Xerte discussion list
> Subject: RE: [Xerte] LDAP settings
>
> Probably a failure of the database.php file to set itself, which is
> usually write permissions on the root folder of the site and / or setup
> folder.
>
> -----Original Message-----
> From: xerte-bounces at lists.nottingham.ac.uk
> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Julian Tenney
> Sent: 10 February 2010 13:37
> To: Xerte discussion list
> Subject: RE: [Xerte] LDAP settings
>
> If you don't want to use LDAP, there are three options currently, really
> four:
>
> - Set up for a single user, but fairly insecure if anyone else knows /
> can figure out your URL;
> - Use switch.txt. Fairly painless way to add usernames / passwords;
> - Use the moodle patch. Ron can advise.
> - Roll your own.
>
> Nothing has changed this week. Pat - why would the " No database
> selected" error be thrown?
>
> J
>
> -----Original Message-----
> From: xerte-bounces at lists.nottingham.ac.uk
> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Hartley,
> Peter
> Sent: Wednesday, February 10, 2010 1:23 PM
> To: Xerte discussion list
> Subject: RE: [Xerte] LDAP settings
>
> HI
>
> I do not want to use ldap but since we have Active Directory I am trying
> in a last effort to get it to work that way.
>
> But having just downloaded the latest version from your web site all I
> get now from page 4 of the installation is for all the inserts:
>
> The sitedetails site ID query insert into sitedetails(site_id) VALUES (
> "1") has failed due to No database selected
>
> I am using the same method that worked earlier this week which went
> straight through. Has there been a change to the setup?
>
>
>
> ------oooooo000000oooooo------
> Please consider the environment before printing this email.
>
> Peter Hartley
> College Information Systems Manager
>
> -----Original Message-----
> From: xerte-bounces at lists.nottingham.ac.uk
> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Julian Tenney
> Sent: 10 February 2010 12:54
> To: Xerte discussion list
> Subject: RE: [Xerte] LDAP settings
>
> So now I'm confused. You have LDAP or not? Earlier you said you didn't /
> couldn't use it?
>
> -----Original Message-----
> From: xerte-bounces at lists.nottingham.ac.uk
> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Hartley,
> Peter
> Sent: Wednesday, February 10, 2010 12:21 PM
> To: Xerte discussion list
> Subject: RE: [Xerte] LDAP settings
>
> Hi
>
> I have an AD ldap based on 'kedst.ac.uk' with staff under an OU Staff,
> so what do I put in:
>
> LDAP_filter - ?
> Ldap_host - I assume the IP number of a domain controller
> Ldap_port - I assume 389
> Bind_pwd - ?
> Basedn - is that dc=uk,dc=ac,dc=kedst
> Bind_dn - ?
>
> For Moodle we use an external MySQL database which contains the
> necessary fields.
>
> ------oooooo000000oooooo------
> Please consider the environment before printing this email.
>
> Peter Hartley
> College Information Systems Manager
> King Edward VI College
> Lower High Street
> Stourbridge
> West Midlands
> DY8 1TD
>
> Phone: +44-(0) 1384 398100
> Fax: +44-(0) 1384 398123
> email: its at kedst.ac.uk
> web: www.kedst.ac.uk
>
> Delivery or sat nav address:
> King Edward VI College
> Duke Street
> Stourbridge
> West Midlands
> DY8 1YR
>
>
> -----Original Message-----
> From: xerte-bounces at lists.nottingham.ac.uk
> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Julian Tenney
> Sent: 10 February 2010 12:04
> To: Xerte discussion list
> Subject: RE: [Xerte] LDAP settings
>
> Can you tell us what information is missing? That would be very helpful.
>
> How do you authenticate your moodle users?
>
> The moodle patch was created by Ron Mitchell - I need to Ron to chip in
> if there are problems with it.
>
> Xerte can run on IIS. We need to understand why your own situation is
> failing.
>
> -----Original Message-----
> From: xerte-bounces at lists.nottingham.ac.uk
> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Hartley,
> Peter
> Sent: Wednesday, February 10, 2010 11:41 AM
> To: Xerte discussion list
> Subject: RE: [Xerte] LDAP settings
>
> I have found the installation guide very unfriendly and not supplying
> the information required to fill in table entries.
>
> The problem is that I do not know how Xerte actually works and with
> users having to logon via LDAP - which I actually do not/cannot use -
> there is little information on what to enter in LDAP fields, in say an
> Active Directory situation.
>
> I am trying to use the Moodle patch which is our preferred route and all
> goes well until I edit or preview a project at which point I get a blank
> screen. As I cannot get LDAP working I cannot logon to get a project
> created and test it out.
>
> The server I am using runs Moodle, Mediawiki and WordPress quite happily
> and these installs were fairly straightforward and we just run a
> standard setup.
>
> I am coming to the conclusion that as it stands Xerte is simply
> uninstallable in a standard Windows/IIS/MySQL/PHP environment as I
> cannot find what I have done wrong.
>
> ------oooooo000000oooooo------
> Please consider the environment before printing this email.
>
> Peter Hartley
> College Information Systems Manager
> King Edward VI College
> Lower High Street
> Stourbridge
> West Midlands
> DY8 1TD
>
> Phone: +44-(0) 1384 398100
> Fax: +44-(0) 1384 398123
> email: its at kedst.ac.uk
> web: www.kedst.ac.uk
>
> Delivery or sat nav address:
> King Edward VI College
> Duke Street
> Stourbridge
> West Midlands
> DY8 1YR
>
> -----Original Message-----
> From: xerte-bounces at lists.nottingham.ac.uk
> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Julian Tenney
> Sent: 10 February 2010 10:17
> To: Xerte discussion list
> Subject: RE: [Xerte] LDAP settings
>
> Pat tells me he has been in dialog with you over the last week to
> resolve the issue. We'd like some feedback on why you've found this so
> difficult. There is still some confusion, because we don't store login
> data in the database.
>
> Are you using Ron Mitchell's moodle patch, and is the problem with that?
>
> Do you have any feedback on the installation guide, provided in the root
> of the zip file?
>
> Thanks,
>
> J
>
>
> -----Original Message-----
> From: xerte-bounces at lists.nottingham.ac.uk
> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Hartley,
> Peter
> Sent: Wednesday, February 10, 2010 8:34 AM
> To: Xerte discussion list
> Subject: RE: [Xerte] LDAP settings
>
> Hi
>
> I am still trying to get Xerte to work after a week. The installation is
> difficult and required me to use phpMyAdmin to get into the database. I
> have set nothing in LDAP since we want to use Moodle to access it. You
> can set the password - and everything else - in the database as it is
> clear text.
>
> Unlike Moodle Xerte uses the database to store MySQL logon information
> and so on.
>
> If you are using IIs and get Xerte to work tell me how you did it!
>
> ------oooooo000000oooooo------
> Please consider the environment before printing this email.
>
> Peter Hartley
> College Information Systems Manager
>
>
> ************************************************************************
> ****
> This email is confidential and intended solely for the use of
> the individual to whom it is addressed. Any views or
> opinions presented are solely those of the author and do
> not necessarily represent those of King Edward VI College
> Stourbridge. If you are not the intended recipient, be
> advised that you have received this email in error and
> we request that you do not disseminate, forward, print, or
> copy this email. If you have received this
> email in error please notify King Edward VI College
> Stourbridge, West Midlands, DY8 1TD, UK on +44-(0) 1384 398100.
> ************************************************************************
> ****
>
>
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>
> ************************************************************************
> ****
> This email is confidential and intended solely for the use of
> the individual to whom it is addressed. Any views or
> opinions presented are solely those of the author and do
> not necessarily represent those of King Edward VI College
> Stourbridge. If you are not the intended recipient, be
> advised that you have received this email in error and
> we request that you do not disseminate, forward, print, or
> copy this email. If you have received this
> email in error please notify King Edward VI College
> Stourbridge, West Midlands, DY8 1TD, UK on +44-(0) 1384 398100.
> ************************************************************************
> ****
>
>
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>
> ************************************************************************
> ****
> This email is confidential and intended solely for the use of
> the individual to whom it is addressed. Any views or
> opinions presented are solely those of the author and do
> not necessarily represent those of King Edward VI College
> Stourbridge. If you are not the intended recipient, be
> advised that you have received this email in error and
> we request that you do not disseminate, forward, print, or
> copy this email. If you have received this
> email in error please notify King Edward VI College
> Stourbridge, West Midlands, DY8 1TD, UK on +44-(0) 1384 398100.
> ************************************************************************
> ****
>
>
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>
> ************************************************************************
> ****
> This email is confidential and intended solely for the use of
> the individual to whom it is addressed. Any views or
> opinions presented are solely those of the author and do
> not necessarily represent those of King Edward VI College
> Stourbridge. If you are not the intended recipient, be
> advised that you have received this email in error and
> we request that you do not disseminate, forward, print, or
> copy this email. If you have received this
> email in error please notify King Edward VI College
> Stourbridge, West Midlands, DY8 1TD, UK on +44-(0) 1384 398100.
> ************************************************************************
> ****
>
>
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte

_________________________________________________________________
Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
http://clk.atdmt.com/GBL/go/201469229/direct/01/