<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Error doing update via SQL"]]></title>
		<link>http://www.ldapsoft.com/forum/posts/list/7.page</link>
		<description><![CDATA[Latest messages posted in the topic "Error doing update via SQL"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Error doing update via SQL</title>
				<description><![CDATA[ I am trying to update the userPassword attribute for decendendant objects.  I used the following sql:<br /> <br /> UPDATE ou=People,o=jpmorgan.com  SET userPassword = {SHA}yfmXWU8UG+QskqZgFjRr1BJiuTE=  subtreescope<br /> <br /> It did find all the entries, processed them, and said successfully updated.  However, when I go back to verify the userPassword attribute, it is not the value that I set.  I aslo know that it did update the value becuse the old value is not the same.  So it has updated the value, but I don't know to what.<br /> <br /> Also, when browsing the table view, I see that the value has been updated not to the exact value I specified, but rather to another value using SSHA.<br /> <br /> I also tried the same update without specifying any encrytion as follows but I got the same results as above.<br /> <br /> UPDATE ou=People,o=jpmorgan.com  SET userPassword = testpw01  subtreescope<br /> ]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/11/21.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/11/21.page</link>
				<pubDate><![CDATA[Tue, 5 Aug 2008 16:47:02]]> GMT</pubDate>
				<author><![CDATA[ Matthew]]></author>
			</item>
			<item>
				<title>Re:Error doing update via SQL</title>
				<description><![CDATA[ Are u verifying the password using password editor? userpassword attribute --&gt; type the password in the verify box and click verify<br /> <br /> I tried the following on our test ldap and was able to verify both of them.<br /> <br /> UPDATE ou=MemberGroupA,o=stooges SET  userPassword='newpassword'<br /> subtreescope<br /> <br /> UPDATE ou=MemberGroupA,o=stooges SET  userPassword='{SHA}VJlSQ5MNOHSTwmtJhSY3ooXON80='<br /> subtreescope<br /> ]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/11/22.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/11/22.page</link>
				<pubDate><![CDATA[Tue, 5 Aug 2008 17:07:12]]> GMT</pubDate>
				<author><![CDATA[ support]]></author>
			</item>
			<item>
				<title>Re:Error doing update via SQL</title>
				<description><![CDATA[ I found the problem.  I had to get the syntax EXACTLY right with regard to spaces:<br /> 1.  Only 1 space after UPDATE/SET.<br /> 2.  No space before or after =<br /> <br /> I tweaked the query, ran it, and it did the update as expected.<br /> ]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/11/24.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/11/24.page</link>
				<pubDate><![CDATA[Tue, 5 Aug 2008 17:50:15]]> GMT</pubDate>
				<author><![CDATA[ Anonymous]]></author>
			</item>
			<item>
				<title>Re:Error doing update via SQL</title>
				<description><![CDATA[ I found the problem. I had to get the syntax EXACTLY right with regard to spaces: <br /> 1. Only 1 space after UPDATE/SET. <br /> 2. No space before or after = <br /> <br /> I tweaked the query, ran it, and it did the update as expected. <br /> ]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/11/25.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/11/25.page</link>
				<pubDate><![CDATA[Tue, 5 Aug 2008 17:51:16]]> GMT</pubDate>
				<author><![CDATA[ Matthew]]></author>
			</item>
	</channel>
</rss>
