Laravel Enlighten

Passwordless - Send Email

Legacy user (registered with phone) is logged in and tries to add an email that has been used for another account

Request

Method:	POST
Route:	api/auth/passwordless/email
Example:	api/auth/passwordless/email

Input	Value
email	[email protected]
section	email/random
callback	http://www.ferretti.com/est-maiores-praesentium-corrupti-non-debitis
test	true

Request Headers

host:	localhost:49527
user-agent:	Symfony
accept:	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
accept-language:	en-us,en;q=0.5
accept-charset:	ISO-8859-1,utf-8;q=0.7,*;q=0.7
authorization:	Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vbG9jYWxob3N0OjQ5NTI3IiwiaWF0IjoxNjUyNzc1OTUwLCJuYmYiOjE2NTI3NzU5NTAsImp0aSI6Ikczb3RLbHV3eXRkOG9nTkgiLCJzdWIiOiIxMCIsInBydiI6IjIzYmQ1Yzg5NDlmNjAwYWRiMzllNzAxYzQwMDg3MmRiN2E1OTc2ZjcifQ.tK2xRga_jZJNM6woKuxrMrXajowxVnYcGVdIqtXykBk
content-type:	application/x-www-form-urlencoded

Response

403 JSON

Response Headers

cache-control:	no-cache, private
date:	Tue, 17 May 2022 08:25:50 GMT
content-type:	application/json
x-ratelimit-limit:	60
x-ratelimit-remaining:	59

{
    "data": null,
    "errors": {
        "message": "Email already taken."
    }
}

Test Queries

Time: 0.34

insert into `users` (`updated_at`, `created_at`) values (?, ?)

Bindings

0:	2022-05-17 08:25:50
1:	2022-05-17 08:25:50

Time: 0.63

insert into `login_tokens` (`user_id`, `token`, `medium_type`, `medium_handle`, `expires_at`, `section`, `consumed_at`, `callback_url`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Bindings

0:	10
1:	2soCQ6RFGh
2:	phone
3:	+1-220-662-9239
4:	2022-05-17 08:40:50
5:	NdnyVRmt5UhzEnLy
6:
7:	http://dubuque.com/distinctio-eaque-et-aliquam-labore-aspernatur
8:	2022-05-17 08:25:50
9:	2022-05-17 08:25:50

Time: 0.55

select * from `users` where (`phone_verified_at` is not null or `email_verified_at` is not null) and `id` = ? limit 1

Bindings

Time: 0.5

select * from `users` where (`phone_verified_at` is null or `email_verified_at` is null) and `id` = ? limit 1

Bindings

Time: 0.41

update `login_tokens` set `consumed_at` = ?, `login_tokens`.`updated_at` = ? where `id` = ?

Bindings

0:	2022-05-17 08:25:50
1:	2022-05-17 08:25:50
2:	17

Time: 0.37

update `users` set `phone` = ?, `phone_verified_at` = ?, `users`.`updated_at` = ? where `id` = ?

Bindings

0:	+1-220-662-9239
1:	2022-05-17 08:25:50
2:	2022-05-17 08:25:50
3:	10

Time: 0.21

insert into `users` (`updated_at`, `created_at`) values (?, ?)

Bindings

0:	2022-05-17 08:25:50
1:	2022-05-17 08:25:50

Time: 0.25

insert into `login_tokens` (`user_id`, `token`, `medium_type`, `medium_handle`, `expires_at`, `section`, `consumed_at`, `callback_url`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Bindings

0:	11
1:	g18UMsd6D2
2:	email
3:	[email protected]
4:	2022-05-17 08:40:50
5:	aRv1QxpijvC5MGQ2
6:
7:	http://www.morar.net/voluptates-eveniet-et-fugiat
8:	2022-05-17 08:25:50
9:	2022-05-17 08:25:50

Time: 0.28

select * from `users` where (`phone_verified_at` is not null or `email_verified_at` is not null) and `id` = ? limit 1

Bindings

Time: 0.29

select * from `users` where (`phone_verified_at` is null or `email_verified_at` is null) and `id` = ? limit 1

Bindings

Time: 0.26

update `users` set `email_verified_at` = ?, `email` = ?, `users`.`updated_at` = ? where `id` = ?

Bindings

0:	2022-05-17 08:25:50
1:	[email protected]
2:	2022-05-17 08:25:50
3:	11

Time: 0.26

update `login_tokens` set `consumed_at` = ?, `login_tokens`.`updated_at` = ? where `id` = ?

Bindings

0:	2022-05-17 08:25:50
1:	2022-05-17 08:25:50
2:	18

Time: 0.35

insert into `login_tokens` (`user_id`, `token`, `medium_type`, `medium_handle`, `expires_at`, `section`, `consumed_at`, `callback_url`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Bindings

0:	11
1:	AucSVgWPMp
2:	phone
3:	1-678-809-3291
4:	2022-05-17 08:40:50
5:	O7aDyrbMTh2l88kf
6:
7:	http://wisozk.com/autem-itaque-dolore-non-voluptatem-soluta-quos-corporis.html
8:	2022-05-17 08:25:50
9:	2022-05-17 08:25:50

Time: 0.58

select * from `users` where (`phone_verified_at` is not null or `email_verified_at` is not null) and `id` = ? limit 1

Bindings

Time: 0.38

update `login_tokens` set `consumed_at` = ?, `login_tokens`.`updated_at` = ? where `id` = ?

Bindings

0:	2022-05-17 08:25:50
1:	2022-05-17 08:25:50
2:	19

Time: 0.44

update `users` set `phone` = ?, `phone_verified_at` = ?, `users`.`updated_at` = ? where `id` = ?

Bindings

0:	1-678-809-3291
1:	2022-05-17 08:25:50
2:	2022-05-17 08:25:50
3:	11

Request Queries

Time: 0.33

select * from `users` where (`phone_verified_at` is not null or `email_verified_at` is not null) and `id` = ? limit 1

Bindings

Time: 0.31

select * from `users` where (`phone_verified_at` is not null or `email_verified_at` is not null) and `email_verified_at` is not null and `email` = ? limit 1

Bindings

0:	[email protected]

Request

Method:	POST
Route:	api/auth/passwordless/email
Example:	api/auth/passwordless/email

Input	Value
email	[email protected]
section	email/random
callback	http://www.ferretti.com/est-maiores-praesentium-corrupti-non-debitis
test	true

Request Headers

host:	localhost:49527
user-agent:	Symfony
accept:	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
accept-language:	en-us,en;q=0.5
accept-charset:	ISO-8859-1,utf-8;q=0.7,*;q=0.7
authorization:	Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vbG9jYWxob3N0OjQ5NTI3IiwiaWF0IjoxNjUyNzc1OTUwLCJuYmYiOjE2NTI3NzU5NTAsImp0aSI6Ikczb3RLbHV3eXRkOG9nTkgiLCJzdWIiOiIxMCIsInBydiI6IjIzYmQ1Yzg5NDlmNjAwYWRiMzllNzAxYzQwMDg3MmRiN2E1OTc2ZjcifQ.tK2xRga_jZJNM6woKuxrMrXajowxVnYcGVdIqtXykBk
content-type:	application/x-www-form-urlencoded