Guest User

Untitled

a guest
Nov 6th, 2017
24
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.99 KB | None | 0 0
  1. just ran delete from core.person where personid = 55010
  2.  
  3.  
  4. then ran:
  5. Set IDENTITY_INSERT core.Person On
  6.  
  7. Insert Into [core].[Person]
  8. (
  9. [PersonId]
  10. ,[RoleId]
  11. ,[GenderId]
  12. ,[AddressId]
  13. ,[FirstName]
  14. ,[MiddleName]
  15. ,[LastName]
  16. ,[Handle]
  17. ,[Password]
  18. ,[Title]
  19. ,[Overview]
  20. ,[BirthDate]
  21. ,[Image]
  22. ,[ForcePasswordChange]
  23. ,[EmployeeHireDate]
  24. ,[EmployeeFireDate]
  25. ,[IsInternal]
  26. ,[IsActive]
  27. ,[IsLoginConfirmed]
  28. ,[ExternalKey]
  29. ,[CreatePersonId]
  30. ,[UpdatePersonId]
  31. ,[CreateDate]
  32. ,[UpdateDate]
  33. )
  34.  
  35. Select
  36. 55010 as PersonId
  37. ,1 as RoleId
  38. ,0 as GenderId
  39. ,0 as AddressId
  40. ,'Kelton' as FirstName
  41. ,'Matthew' as MiddleName
  42. ,'Crouse' as LastName
  43. ,'Kelton.Crouse@gmail.com' as Handle
  44. ,convert(varchar(32), HashBytes('MD5', 'NaCl_And_Peppa123'), 2) as Password
  45. ,'System Admin' as Title
  46. ,'' as Overview
  47. ,null as BirthDate
  48. ,'' as Image
  49. ,0 as ForcePasswordChange
  50. ,null as EmployeeHireDate
  51. ,null as EmployeeFireDate
  52. ,1 as IsInternal
  53. ,1 as IsActive
  54. ,1 as IsLoginConfirmed
  55. ,'COPE-SYSTEM-ADMIN' as ExternalKey
  56. ,1 as CreatePersonId
  57. ,0 as UpdatePersonId
  58. ,GetDate() as CreateDate
  59. ,null as UpdateDate
  60.  
  61. Set IDENTITY_INSERT core.Person Off
  62. then cleared cache, and attempted to log in....
  63.  
  64. LogId MessageTypeId Code Method Message Timestamp
  65. 31038 1 n/a Person.AuthUserByCredentials kelton.crouse@gmail.com found but the password failed or the user is inactive or the user is not allowed to login. 2017-11-06 15:17:46.860
  66.  
  67. That's what returned.
  68.  
  69. Here's my payload giving 401 unauthorized:
  70.  
  71. {source: 1, handle: "kelton.crouse@gmail.com", password: "123", remember: null}handle:"kelton.crouse@gmail.com"
  72. password:"123"
  73. remember:null
  74. source:1
Add Comment
Please, Sign In to add comment