#1 — Problem with custom fields username and password

by Nate Aune last modified Aug 21, 2009 03:06 AM
State Unconfirmed
Version: 1.0
Area Functionality
Issue type Bug
Severity Medium
Submitted by Nate Aune
Submitted on Dec 23, 2008
Responsible
Target release:
When using the 1.0b2 (SVN/UNRELEASED) version of collective.salesforce.authplugin, I got the following error:

Traceback (innermost last):
  Module ZPublisher.Publish, line 110, in publish
  Module ZPublisher.BaseRequest, line 583, in traverse
  Module Products.PluggableAuthService.PluggableAuthService, line 233, in validate
  Module Products.PluggableAuthService.PluggableAuthService, line 600, in _extractUserIds
  Module collective.salesforce.authplugin.mixins.authmixin, line 54, in authenticateCredentials
  Module Products.salesforcebaseconnector.salesforcebaseconnector, line 161, in query
  Module beatbox.python_client, line 148, in query
  Module beatbox._beatbox, line 68, in query
  Module beatbox._beatbox, line 325, in post
SoapFaultError: 'INVALID_FIELD' "INVALID_FIELD: select UserName__c,Password__c from Contact ^ ERROR at Row:1:Column:8 No such column 'UserName__c' on entity 'Contact'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names."

When I tried to change it in the ZMI, I continued to get the error:
We're sorry, but there seems to be an error…
The error has been logged as entry number 1230009272.260.21554668451

And I was not able to get access to my Plone site.

I quickly realized that I had swapped the field names and used "username" and "password" in Salesforce, when I should have been using UserName__c and Password__c.

The documentation on the /acl_users/salesforceauthmultiplugin page is not very clear, as it states:
Salesforce.com fields which map to Plone's "username" and "password" fields formatted like the following:
password|Password__c
username|UserName__c

which makes me think that the Salesforce.com fields are the first ones and the Plone fields are the second. I think simply clarifying that the Salesforce fields are Password__c and UserName__c would make this ambiguity go away.

The documentation on this page isn't really any more clear. https://svn.plone.org/[…]/INSTALL.txt

When I tried to make the field Password__c in Salesforce, I got the following error:
Error: The custom field name you provided Password__c on object Contact can only contain alphanumeric characters, must begin with a letter, cannot end with an underscore or contain two consecutive underscore characters, and must be unique across all Contact fields

But I was able to make a field Password_c (with just one underscore), but then I get the error above stating that all custom fields must end with __c.
So now I'm back to square one. Any ideas?
Added by Nate Aune on Dec 23, 2008 06:40 AM
I realized after playing around with this some more, that the __c is appended automatically by Salesforce, so all I have to do is type "Username" for the field name, and Salesforce will make it "Username__c". This could probably be made more clear in the documentation, especially for those of us who are relatively new to Salesforce.
Added by Nate Aune on Dec 23, 2008 07:01 AM
I realized after playing around with this some more, that the __c is appended automatically by Salesforce, so all I have to do is type "Username" for the field name, and Salesforce will make it "Username__c". This could probably be made more clear in the documentation, especially for those of us who are relatively new to Salesforce.
Added by (anonymous) on May 28, 2009 06:24 AM
HzWQEo <a href="http://cilybtiuqiga.com/">cilybtiuqiga</a>, [url=http://axvqdgiywaoy.com/]axvqdgiywaoy[/url], [link=http://axtuvfalsrqe.com/]axtuvfalsrqe[/link], http://fyddugvunobc.com/
Added by (anonymous) on Jun 03, 2009 10:43 PM
#1" rel="nofollow">http://www.youtube.com/SaleemConnla#1 abilify, :],
Added by (anonymous) on Jun 04, 2009 04:44 AM
#1" rel="nofollow">http://www.youtube.com/PippinYvon#1 celexa, 99878,
Added by (anonymous) on Jun 04, 2009 08:05 PM
#1" rel="nofollow">http://www.youtube.com/EliezerTakis#1 alli, 2302739667, #1" rel="nofollow">http://www.youtube.com/RuslanPatrizio#1 benadryl, 506, #1" rel="nofollow">http://www.youtube.com/GudmundIsrael#1 coumadin, =-], #1" rel="nofollow">http://www.youtube.com/InnokentiJob#1 avandia, 1157, #1" rel="nofollow">http://www.youtube.com/ColtenEelis#1 anastrozole, =-)),
Added by (anonymous) on Jun 04, 2009 09:42 PM
#1" rel="nofollow">http://www.youtube.com/SusilaBakr#1 atenolol, mmh, #1" rel="nofollow">http://www.youtube.com/ToreVadim#1 cipro, 6515, #1" rel="nofollow">http://www.youtube.com/RajeshHernando#1 aciclovir, vfow, #1" rel="nofollow">http://www.youtube.com/DudelMin#1 biaxin, 283799168077, #1" rel="nofollow">http://www.youtube.com/OzIestyn#1 cephalexin 500mg, unnpk,
Added by (anonymous) on Jun 04, 2009 11:20 PM
#1" rel="nofollow">http://www.youtube.com/EwaldElias#1 cheap adipex, ozivfdnfme, #1" rel="nofollow">http://www.youtube.com/GudmundIsrael#1 coumadin, 54678, #1" rel="nofollow">http://www.youtube.com/DudelMin#1 biaxin, ocsjsmjz, #1" rel="nofollow">http://www.youtube.com/YuutoBartomeu#1 citalopram side effects, uhefrczlhgec, #1" rel="nofollow">http://www.youtube.com/VernerKwasi#1 cialis online, flibtywcmaiv,
Added by (anonymous) on Jun 05, 2009 12:58 AM
http://www.petitiononline.com/accutan/petition.html roaccutane, hemgflj, #1" rel="nofollow">http://www.youtube.com/SusilaBakr#1 atenolol effects, 47970616198, #1" rel="nofollow">http://www.youtube.com/ToreVadim#1 ciprofloxacin, 02787280773, #1" rel="nofollow">http://www.youtube.com/AkiBlake#1 bactrim, wvn, #1" rel="nofollow">http://www.youtube.com/InnokentiJob#1 avandia, 887300,
Added by (anonymous) on Jun 09, 2009 12:30 PM
#1" rel="nofollow">http://www.youtube.com/MirkoDeandre#1 lithium side effects, =-), #1" rel="nofollow">http://www.youtube.com/NikolajRoi#1 levita, 34394, #1" rel="nofollow">http://www.youtube.com/EliasEoghan#1 ibuprofen side effects, =-OOO, #1" rel="nofollow">http://www.youtube.com/RudolfGermain#1 magnesium deficiency, xnvvpbhz, #1" rel="nofollow">http://www.youtube.com/IosifFeodor#1 paxil, 894914557,
Added by (anonymous) on Jun 09, 2009 02:31 PM
#1" rel="nofollow">http://www.youtube.com/ZoticusMarkus#1 levofloxacin, 8DDD, #1" rel="nofollow">http://www.youtube.com/MercuryHuey#1 phentermine cheap, 8]], #1" rel="nofollow">http://www.youtube.com/HuanBernardo#1 olanzapine, :]], #1" rel="nofollow">http://www.youtube.com/RudolfGermain#1 calcium magnesium, hego, #1" rel="nofollow">http://www.youtube.com/ColemanArtair#1 lexipro, 513342288,
Added by (anonymous) on Jun 09, 2009 04:34 PM
#1" rel="nofollow">http://www.youtube.com/TyriqElpidio#1 metformin effects, :-))), #1" rel="nofollow">http://www.youtube.com/NikolajRoi#1 levita, =-D, #1" rel="nofollow">http://www.youtube.com/OrtziAditya#1 mobic, %)), #1" rel="nofollow">http://www.youtube.com/RudolfGermain#1 online metformin, =-DD, #1" rel="nofollow">http://www.youtube.com/KermanLeachlainn#1 norvasc, yuqq,
Added by (anonymous) on Jun 09, 2009 06:22 PM
#1" rel="nofollow">http://www.youtube.com/NarinderYuri#1 lamictal side effects, 8(, #1" rel="nofollow">http://www.youtube.com/NikolajRoi#1 levita, vgamoukol, #1" rel="nofollow">http://www.youtube.com/MercuryHuey#1 phentermine cheap, =DDD, #1" rel="nofollow">http://www.youtube.com/RudolfGermain#1 cheap metformin, 172187710293, #1" rel="nofollow">http://www.youtube.com/ColemanArtair#1 lexipro, %]]],
Added by (anonymous) on Jun 12, 2009 11:47 PM
#1" rel="nofollow">http://www.youtube.com/discounttramadol#1 discount tramadol, :-))),
Added by (anonymous) on Jun 13, 2009 05:50 AM
#1" rel="nofollow">http://www.youtube.com/buytramadolnow1#1 buy tramadol, 5171,
Added by (anonymous) on Jun 13, 2009 11:58 AM
#1" rel="nofollow">http://www.youtube.com/cheapcialis100#1 cheap cialis, 99438230,
Added by (anonymous) on Jun 13, 2009 06:32 PM
#1" rel="nofollow">http://www.youtube.com/buyfioricet11#1 buy fioricet, %-(((,
Added by (anonymous) on Jul 09, 2009 04:44 PM
#2" rel="nofollow">http://www.youtube.com/buygenericcialis1#2 buy generic cialis, =-[[[,
Added by (anonymous) on Jul 09, 2009 10:29 PM
#2" rel="nofollow">http://www.youtube.com/soma139#2 soma, exo,
Added by (anonymous) on Jul 10, 2009 09:58 AM
#2" rel="nofollow">http://www.youtube.com/discounttramadol#2 discount tramadol, 2246138592,
Added by (anonymous) on Jul 12, 2009 09:05 AM
#1" rel="nofollow">http://ubuntuforums.org/member.php?u=872681#1 soma, 1644,
Added by (anonymous) on Jul 12, 2009 10:01 PM
#1" rel="nofollow">http://ubuntuforums.org/member.php?u=872570#1 overnight tramadol, bixatzvmur,
Added by (anonymous) on Jul 13, 2009 05:08 PM
#1" rel="nofollow">http://www.kaboodle.com/fioricet1#1 fioricet, %[,
Added by (anonymous) on Jul 14, 2009 01:06 AM
#1" rel="nofollow">http://www.kaboodle.com/cheaptramadol#1 cheap tramadol, 65403617,
Added by (anonymous) on Aug 20, 2009 06:32 PM
#1" rel="nofollow">http://www.kaboodle.com/xenical1#1 Xenical, qqiqkoe,
Added by (anonymous) on Aug 21, 2009 03:06 AM
#1" rel="nofollow">http://www.kaboodle.com/viagrasofttabs#1 Viagra Soft Tabs, =-P,

No responses can be added.