[Xerte] Re: LDAP givenName & sn

[Pat Lockley]

and then in setup/htaccess.conf add the new line

rewriteRule ^workspaceproperties_([A-Za-z0-9]+)$
*/workspaceproperties.php?template_id=$1

On Thu, Jul 28, 2011 at 11:21 AM, Pat Lockley
<patrick.lockley at googlemail.com> wrote:
> This is a good change
>
> $ldap_hosts = mysql_query("select * from ldap");
>
>
> To...
>
> ·         $ldap_hosts = mysql_query("select * from " .
> $xerte_toolkits_site->database_table_prefix . "ldap");
>
> On Thu, Jul 28, 2011 at 11:16 AM, Julian Tenney
> <Julian.Tenney at nottingham.ac.uk> wrote:
>> Not being a numpty here, but what EXACTLY is the fix?
>>
>>
>>
>> I don’t know what this means, so unsure what to do:
>>
>> Not sure the .htaccess change shouldn't be "dollared" - the install mods the
>> default htaccess so don't add that line in by default
>>
>> You want me to do this?
>>
>> ·         $ldap_hosts = mysql_query("select * from ldap");
>>
>>
>>
>> To...
>>
>>
>>
>> ·         $ldap_hosts = mysql_query("select * from " .
>> $xerte_toolkits_site->database_table_prefix . "ldap");
>>
>> Can you reply slowly in words I’ve seen before please…
>>
>>
>>
>> ;-)
>>
>>
>>
>> From: xerte-bounces at lists.nottingham.ac.uk
>> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Pat Lockley
>> Sent: 28 July 2011 10:52
>>
>> To: Xerte discussion list
>> Subject: [Xerte] Re: LDAP givenName & sn
>>
>>
>>
>> the top line is the fix (thank you).
>>
>>
>>
>> Not sure the .htaccess change shouldn't be "dollared" - the install mods the
>> default htaccess so don't add that line in by default
>>
>> On Thu, Jul 28, 2011 at 10:38 AM, Davies, Dale <Dale.Davies at liv-coll.ac.uk>
>> wrote:
>>
>> Hi Julian,
>>
>>
>>
>> Two things I have found so far.  The first fixes a bug where the users first
>> name and surname were not being saved into the database when logging in.
>> The second fixes a bug where trying to update workspace properties returned
>> a 404.
>>
>>
>>
>> In login_library.php at about line 537 change....
>>
>>
>>
>> ·         $ldap_hosts = mysql_query("select * from ldap");
>>
>>
>>
>> To...
>>
>>
>>
>> ·         $ldap_hosts = mysql_query("select * from " .
>> $xerte_toolkits_site->database_table_prefix . "ldap");
>>
>>
>>
>>
>>
>> In the .htaccess file I added the following line...
>>
>>
>>
>> ·         rewriteRule ^workspaceproperties/?$ /xerte/workspaceproperties.php
>>
>>
>>
>>
>>
>> Hope this helps J
>>
>>
>>
>>
>>
>> Dale Davies - VLE / E-Learning Developer
>>
>> Liverpool Community College, CIS Dept, Bankfield Road, Liverpool, L13 0BQ.
>>
>> Web: www.liv-coll.ac.uk
>>
>> Tel: 0151 252 3238
>>
>>
>>
>> From: xerte-bounces at lists.nottingham.ac.uk
>> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Julian Tenney
>> Sent: 28 July 2011 09:31
>>
>> To: Xerte discussion list
>> Subject: [Xerte] Re: LDAP givenName & sn
>>
>>
>>
>> What exactly do I need to do?
>>
>>
>>
>> You can commit a change…?
>>
>>
>>
>> From: xerte-bounces at lists.nottingham.ac.uk
>> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Pat Lockley
>> Sent: 27 July 2011 17:08
>> To: Xerte discussion list
>> Subject: [Xerte] Re: LDAP givenName & sn
>>
>>
>>
>> Ah crap.
>>
>>
>>
>> Julian can you paste in the table prefix php into that line?
>>
>> On Wed, Jul 27, 2011 at 4:31 PM, Davies, Dale <Dale.Davies at liv-coll.ac.uk>
>> wrote:
>>
>> I read about the password thing elsewhere on the mailing list, I seem to get
>> the behaviour one would expect.  As in, the only way anyone can log in is by
>> using only the correct username and correct password, a blank or incorrect
>> password will not allow a login.
>>
>>
>>
>> I’ve made some progress on my problem, it seems that around line 537 of
>> login_library.php the following mysql query does not use the user defined
>> table name prefix...
>>
>>
>>
>> $ldap_hosts = mysql_query("select * from ldap");
>>
>>
>>
>> Adding my table name prefix almost fixes things, now the given name and sn
>> are pulled in, doing a var_dump on $login_check shows this, but only the sn
>> is saved in the database.
>>
>>
>>
>> I’m guessing the solution must be some other query also not using the table
>> prefix.
>>
>>
>>
>> Anyways, I’m off home for the day.  This can wait until the morning ;-)
>>
>>
>>
>>
>>
>> Thanks again,
>>
>>
>>
>> Dale Davies - VLE / E-Learning Developer
>>
>> Liverpool Community College, CIS Dept, Bankfield Road, Liverpool, L13 0BQ.
>>
>> Web: www.liv-coll.ac.uk
>>
>> Tel: 0151 252 3238
>>
>>
>>
>> From: xerte-bounces at lists.nottingham.ac.uk
>> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Pat Lockley
>> Sent: 27 July 2011 14:55
>> To: Xerte discussion list
>> Subject: [Xerte] Re: LDAP givenName & sn
>>
>>
>>
>> No, just in login_library and index.php (when it comes to account creation).
>>
>>
>>
>> Silly question - try entering the wrong password - see what happens.
>>
>> On Wed, Jul 27, 2011 at 2:07 PM, Davies, Dale <Dale.Davies at liv-coll.ac.uk>
>> wrote:
>>
>> Hi,
>>
>>
>>
>> I’ve updated “givenname” to “givenName” in the following functions (within
>> login_library.php)...
>>
>>
>>
>> ·         get_ldap_array()
>>
>> ·         get_user_ldap()
>>
>> ·         authenticate_to_host()
>>
>>
>>
>> The “givenName” and “sn” attributes definitely exists in the Active
>> Directory and I am able to access them via my own PHP applications, but for
>> some reason Xerte seems to be ignoring them.  No errors shown in the Xerte
>> logs or the apache error log.
>>
>>
>>
>> Another thing I have tried after changing these is to remove the user
>> account from the Xerte database and try logging in again, but to no avail.
>> The user account can log in, but no other data is saved in the row, just the
>> user id.
>>
>>
>>
>> Am I looking in the right place (login_library.php) or are there other
>> places within the Xerte code base that also check LDAP?
>>
>>
>>
>> Thanks again,
>>
>>
>>
>> Dale Davies - VLE / E-Learning Developer
>>
>> Liverpool Community College, CIS Dept, Bankfield Road, Liverpool, L13 0BQ.
>>
>> Web: www.liv-coll.ac.uk
>>
>> Tel: 0151 252 3238
>>
>>
>>
>> From: xerte-bounces at lists.nottingham.ac.uk
>> [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Pat Lockley
>> Sent: 27 July 2011 12:18
>> To: Xerte discussion list
>> Subject: [Xerte] Re: LDAP givenName & sn
>>
>>
>>
>> Hello,
>>
>>
>>
>> From recollection the code does two LDAP checks. Maybe the second one fails?
>>
>>
>>
>> I would be surprised givenname isn't in the database in sitedetails or ldap?
>>
>>
>>
>> Pat
>>
>> On Wed, Jul 27, 2011 at 11:45 AM, Davies, Dale <Dale.Davies at liv-coll.ac.uk>
>> wrote:
>>
>> Hi,
>>
>>
>>
>> I’ve set Xerte up on a Linux web server, everything works perfectly apart
>> from one aspect.  When a user logs in their name is not pulled into the
>> Xerte users database via LDAP.
>>
>>
>>
>> I have checked through the code and found login_library.php to contain
>> “givenname”, so I changed this to “givenName”.  However this still does not
>> pull in the name.  We definitely have values stores in those attributes
>> within the Active Directory.
>>
>>
>>
>> Am I missing something?  I can’t find any solution unfortunately, I realise
>> this isn’t a huge problem as Xerte still works regardless, but users are
>> unable to search for each other and share/hand over projects.
>>
>>
>>
>> Any help/advice is much appreciated.  Many thanks.
>>
>>
>>
>>
>>
>> Dale Davies - VLE / E-Learning Developer
>>
>> Liverpool Community College, CIS Dept, Bankfield Road, Liverpool, L13 0BQ.
>>
>> Web: www.liv-coll.ac.uk
>>
>> Tel: 0151 252 3238
>>
>>
>>
>>
>>
>> ________________________________
>>
>> Please consider the environment before printing this email.
>>
>> ________________________________
>>
>> This email and any attachments are 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 Liverpool Community College or associated companies. You must not,
>> directly or indirectly, use, disclose, distribute, print, or copy any part
>> of this message if you are not the intended recipient.
>>
>> The message content of in-coming emails is automatically scanned to identify
>> Spam and viruses otherwise Liverpool Community College does not actively
>> monitor content. However, sometimes it will be necessary for Liverpool
>> Community College to access business communications during staff absence.
>>
>> Liverpool Community College has taken steps to ensure that this email and
>> any attachments are virus free. However, it is the responsibility of the
>> recipient to ensure that it is virus free and no responsibility is accepted
>> by Liverpool Community College for any loss or damage arising in any way
>> from its use.
>>
>> Error! Filename not specified.
>>
>> ________________________________
>>
>>
>>
>> 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
>> 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.
>>
>>
>>
>>
>>
>> ________________________________
>>
>> Please consider the environment before printing this email.
>>
>> ________________________________
>>
>> This email and any attachments are 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 Liverpool Community College or associated companies. You must not,
>> directly or indirectly, use, disclose, distribute, print, or copy any part
>> of this message if you are not the intended recipient.
>>
>> The message content of in-coming emails is automatically scanned to identify
>> Spam and viruses otherwise Liverpool Community College does not actively
>> monitor content. However, sometimes it will be necessary for Liverpool
>> Community College to access business communications during staff absence.
>>
>> Liverpool Community College has taken steps to ensure that this email and
>> any attachments are virus free. However, it is the responsibility of the
>> recipient to ensure that it is virus free and no responsibility is accepted
>> by Liverpool Community College for any loss or damage arising in any way
>> from its use.
>> Error! Filename not specified.
>>
>> ________________________________
>>
>>
>>
>> _______________________________________________
>> Xerte mailing list
>> 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.
>>
>>
>>
>>
>>
>> ________________________________
>>
>> Please consider the environment before printing this email.
>>
>> ________________________________
>>
>> This email and any attachments are 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 Liverpool Community College or associated companies. You must not,
>> directly or indirectly, use, disclose, distribute, print, or copy any part
>> of this message if you are not the intended recipient.
>>
>> The message content of in-coming emails is automatically scanned to identify
>> Spam and viruses otherwise Liverpool Community College does not actively
>> monitor content. However, sometimes it will be necessary for Liverpool
>> Community College to access business communications during staff absence.
>>
>> Liverpool Community College has taken steps to ensure that this email and
>> any attachments are virus free. However, it is the responsibility of the
>> recipient to ensure that it is virus free and no responsibility is accepted
>> by Liverpool Community College for any loss or damage arising in any way
>> from its use.
>> Error! Filename not specified.
>>
>> ________________________________
>>
>>
>>
>> _______________________________________________
>> Xerte mailing list
>> 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.
>>
>>
>>
>>
>>
>> ________________________________
>>
>> Please consider the environment before printing this email.
>>
>> ________________________________
>>
>> This email and any attachments are 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 Liverpool Community College or associated companies. You must not,
>> directly or indirectly, use, disclose, distribute, print, or copy any part
>> of this message if you are not the intended recipient.
>>
>> The message content of in-coming emails is automatically scanned to identify
>> Spam and viruses otherwise Liverpool Community College does not actively
>> monitor content. However, sometimes it will be necessary for Liverpool
>> Community College to access business communications during staff absence.
>>
>> Liverpool Community College has taken steps to ensure that this email and
>> any attachments are virus free. However, it is the responsibility of the
>> recipient to ensure that it is virus free and no responsibility is accepted
>> by Liverpool Community College for any loss or damage arising in any way
>> from its use.
>> Error! Filename not specified.
>>
>> ________________________________
>>
>>
>>
>> _______________________________________________
>> Xerte mailing list
>> 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.
>>
>>
>>
>> _______________________________________________
>> Xerte mailing list
>> 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.
>>
>>
>>
>