Ah crap.<div><br></div><div>Julian can you paste in the table prefix php into that line?<br><br><div class="gmail_quote">On Wed, Jul 27, 2011 at 4:31 PM, Davies, Dale <span dir="ltr"><<a href="mailto:Dale.Davies@liv-coll.ac.uk">Dale.Davies@liv-coll.ac.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div lang="EN-GB" link="blue" vlink="purple"><div><p class="MsoNormal"><a name="1316c4b943908dcf__MailEndCompose"><span style="font-size:11.0pt;color:#1F497D">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.<u></u><u></u></span></a></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">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...<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">$ldap_hosts = mysql_query("select * from ldap");<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">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.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">I’m guessing the solution must be some other query also not using the table prefix.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Anyways, I’m off home for the day. This can wait until the morning ;-)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Thanks again,<u></u><u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10.5pt;color:#1F497D"><u></u> <u></u></span></b></p><p class="MsoNormal"><b><span style="font-size:10.5pt;color:#1F497D">Dale Davies - VLE / E-Learning Developer<u></u><u></u></span></b></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:#1F497D">Liverpool Community College, CIS Dept, Bankfield Road, Liverpool, L13 0BQ.<u></u><u></u></span></p><p class="MsoNormal"><b><span style="font-size:9.0pt;color:#1F497D">Web:</span></b><span style="font-size:9.0pt;color:#1F497D"> </span><a href="http://www.liv-coll.ac.uk" target="_blank"><span style="font-size:9.0pt">www.liv-coll.ac.uk</span></a><span style="font-size:9.0pt;color:#1F497D"><u></u><u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;color:#1F497D">Tel:</span></b><span style="font-size:9.0pt;color:#1F497D"> 0151 252 3238<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><u></u> <u></u></span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt">From:</span></b><span lang="EN-US" style="font-size:10.0pt"> <a href="mailto:xerte-bounces@lists.nottingham.ac.uk" target="_blank">xerte-bounces@lists.nottingham.ac.uk</a> [mailto:<a href="mailto:xerte-bounces@lists.nottingham.ac.uk" target="_blank">xerte-bounces@lists.nottingham.ac.uk</a>] <b>On Behalf Of </b>Pat Lockley<br>
<b>Sent:</b> 27 July 2011 14:55<br><b>To:</b> Xerte discussion list<br><b>Subject:</b> [Xerte] Re: LDAP givenName & sn<u></u><u></u></span></p></div><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">No, just in login_library and index.php (when it comes to account creation).<u></u><u></u></p>
<div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal" style="margin-bottom:12.0pt">Silly question - try entering the wrong password - see what happens.<u></u><u></u></p><div><p class="MsoNormal">On Wed, Jul 27, 2011 at 2:07 PM, Davies, Dale <<a href="mailto:Dale.Davies@liv-coll.ac.uk" target="_blank">Dale.Davies@liv-coll.ac.uk</a>> wrote:<u></u><u></u></p>
<div><div><p class="MsoNormal"><a name="1316c4b943908dcf_1316bbd18e443ef3__MailEndCompose"><span style="font-size:11.0pt;color:#1F497D">Hi,</span></a><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">I’ve updated “givenname” to “givenName” in the following functions (within login_library.php)...</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span><u></u><u></u></p>
<p><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D">·</span><span style="font-size:7.0pt;color:#1F497D"> </span><span style="font-size:11.0pt;color:#1F497D">get_ldap_array()</span><u></u><u></u></p>
<p><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D">·</span><span style="font-size:7.0pt;color:#1F497D"> </span><span style="font-size:11.0pt;color:#1F497D">get_user_ldap()</span><u></u><u></u></p><p>
<span style="font-size:11.0pt;font-family:Symbol;color:#1F497D">·</span><span style="font-size:7.0pt;color:#1F497D"> </span><span style="font-size:11.0pt;color:#1F497D">authenticate_to_host()</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">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.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">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.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Am I looking in the right place (login_library.php) or are there other places within the Xerte code base that also check LDAP?</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Thanks again,</span><u></u><u></u></p><div><p class="MsoNormal">
<b><span style="font-size:10.5pt;color:#1F497D"> </span></b><u></u><u></u></p><p class="MsoNormal"><b><span style="font-size:10.5pt;color:#1F497D">Dale Davies - VLE / E-Learning Developer</span></b><u></u><u></u></p><p class="MsoNormal">
<span style="font-size:9.0pt;color:#1F497D">Liverpool Community College, CIS Dept, Bankfield Road, Liverpool, L13 0BQ.</span><u></u><u></u></p><p class="MsoNormal"><b><span style="font-size:9.0pt;color:#1F497D">Web:</span></b><span style="font-size:9.0pt;color:#1F497D"> </span><a href="http://www.liv-coll.ac.uk" target="_blank"><span style="font-size:9.0pt">www.liv-coll.ac.uk</span></a><u></u><u></u></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;color:#1F497D">Tel:</span></b><span style="font-size:9.0pt;color:#1F497D"> 0151 252 3238</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span><u></u><u></u></p>
</div><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt">From:</span></b><span lang="EN-US" style="font-size:10.0pt"> <a href="mailto:xerte-bounces@lists.nottingham.ac.uk" target="_blank">xerte-bounces@lists.nottingham.ac.uk</a> [mailto:<a href="mailto:xerte-bounces@lists.nottingham.ac.uk" target="_blank">xerte-bounces@lists.nottingham.ac.uk</a>] <b>On Behalf Of </b>Pat Lockley<br>
<b>Sent:</b> 27 July 2011 12:18<br><b>To:</b> Xerte discussion list<br><b>Subject:</b> [Xerte] Re: LDAP givenName & sn</span><u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">Hello,<u></u><u></u></p>
<div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">From recollection the code does two LDAP checks. Maybe the second one fails?<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p>
</div><div><p class="MsoNormal">I would be surprised givenname isn't in the database in sitedetails or ldap?<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div></div><div><p class="MsoNormal" style="margin-bottom:12.0pt">
Pat<u></u><u></u></p><div><div><p class="MsoNormal">On Wed, Jul 27, 2011 at 11:45 AM, Davies, Dale <<a href="mailto:Dale.Davies@liv-coll.ac.uk" target="_blank">Dale.Davies@liv-coll.ac.uk</a>> wrote:<u></u><u></u></p>
</div><div><div><div><p class="MsoNormal">Hi,<u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">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. <u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">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.<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">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.<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">Any help/advice is much appreciated. Many thanks.<u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal"><b><span style="font-size:10.5pt"> </span></b><u></u><u></u></p>
<p class="MsoNormal"><b><span style="font-size:10.5pt">Dale Davies - VLE / E-Learning Developer</span></b><u></u><u></u></p><p class="MsoNormal"><span style="font-size:9.0pt">Liverpool Community College, CIS Dept, Bankfield Road, Liverpool, L13 0BQ.</span><u></u><u></u></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt">Web:</span></b><span style="font-size:9.0pt"> </span><a href="http://www.liv-coll.ac.uk" target="_blank"><span style="font-size:9.0pt">www.liv-coll.ac.uk</span></a><u></u><u></u></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt">Tel:</span></b><span style="font-size:9.0pt"> 0151 252 3238</span><u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p></div><p class="MsoNormal"> <u></u><u></u></p>
<div class="MsoNormal" align="center" style="text-align:center"><hr size="2" width="100%" align="center"></div><p class="MsoNormal"><br>Please consider the environment before printing this email.<u></u><u></u></p><div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="100%" align="center"></div></div><div><p class="MsoNormal"><br>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. <br>
<br>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. <br>
<br>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. <u></u><u></u></p>
</div><p class="MsoNormal"><b><span lang="EN-US">Error! Filename not specified.</span></b><u></u><u></u></p><div><div class="MsoNormal" align="center" style="text-align:center"><hr size="2" width="100%" align="center"></div>
<p class="MsoNormal" style="margin-bottom:12.0pt"> <u></u><u></u></p><p>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. <u></u><u></u></p>
<p>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. <u></u><u></u></p>
</div></div><div><p class="MsoNormal" style="margin-bottom:12.0pt"><br>_______________________________________________<br>Xerte mailing list<br><a href="mailto:Xerte@lists.nottingham.ac.uk" target="_blank">Xerte@lists.nottingham.ac.uk</a><br>
<a href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte" target="_blank">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</a><br><br>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.<br>
<br>This message has been checked for viruses but the contents of an attachment<br>may still contain software viruses which could damage your computer system:<br>you are advised to perform your own checks. Email communications with the<br>
University of Nottingham may be monitored as permitted by UK legislation.<u></u><u></u></p></div></div><p class="MsoNormal"> <u></u><u></u></p></div></div><div><p class="MsoNormal"><u></u> <u></u></p><div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="100%" align="center"></div><p class="MsoNormal"><br>Please consider the environment before printing this email.<u></u><u></u></p><div class="MsoNormal" align="center" style="text-align:center"><hr size="2" width="100%" align="center">
</div><p class="MsoNormal"><br>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. <br>
<br>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. <br>
<br>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. <br>
<b><span lang="EN-US">Error! Filename not specified.</span></b><u></u><u></u></p><div class="MsoNormal" align="center" style="text-align:center"><hr size="2" width="100%" align="center"></div><p class="MsoNormal"><u></u> <u></u></p>
</div></div><p class="MsoNormal" style="margin-bottom:12.0pt"><br>_______________________________________________<br>Xerte mailing list<br><a href="mailto:Xerte@lists.nottingham.ac.uk" target="_blank">Xerte@lists.nottingham.ac.uk</a><br>
<a href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte" target="_blank">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</a><br><br>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.<br>
<br>This message has been checked for viruses but the contents of an attachment<br>may still contain software viruses which could damage your computer system:<br>you are advised to perform your own checks. Email communications with the<br>
University of Nottingham may be monitored as permitted by UK legislation.<br><br><u></u><u></u></p></div><p class="MsoNormal"><u></u> <u></u></p></div></div>
<br><p>
</p><hr>
<br>Please consider the environment before printing this email.<br><hr>
<br>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.
<br>
<br>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.
<br>
<br>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.
<br><img alt="" border="0" hspace="" vspace=""><br><hr>
<p></p>
<br></div><br>_______________________________________________<br>
Xerte mailing list<br>
<a href="mailto:Xerte@lists.nottingham.ac.uk">Xerte@lists.nottingham.ac.uk</a><br>
<a href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte" target="_blank">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</a><br>
<br>
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.<br>
<br>
This message has been checked for viruses but the contents of an attachment<br>
may still contain software viruses which could damage your computer system:<br>
you are advised to perform your own checks. Email communications with the<br>
University of Nottingham may be monitored as permitted by UK legislation.<br>
<br>
<br></blockquote></div><br></div>