Reitrac | Stripe Developers | Page 1

delicate tartanBOT Mar 30, 2023, 12:50 PM

#

left tangle Mar 30, 2023, 12:51 PM

#

Hi there

#

What does "not loaded" mean exactly?

#

Can you give me more details?

lethal dune Mar 30, 2023, 12:53 PM

#

Have a webhook with 4 events : checkout
my webbook is inside stipe-php/webhook.php in ftp and my webhook url is :
https://fairescales.monagraphic-dev.com/stripe-php/webhook.php

In my switch ($event->type) i try to add SQL request to write in my databse but it doesnt works. I have the same code for another website and it works perfectly :/

#

Webbook always return 400 ERR

#

Capture_decran_2023-03-30_a_15.00.12.png

#

My url is success after payment :

access=ok&session_id=cs_test_a16fZ5ru4tyzMZSiqrGRI6Fj2DN3muz2qKC6TKVjJZtGDLZk3tZyozI6XA

left tangle Mar 30, 2023, 1:02 PM

#

The 400 error comes from your code

#

So what do you see in your server console for that error?

#

Have you added logs to figure out why your webhook handler code is returning a 400?

lethal dune Mar 30, 2023, 1:03 PM

#

Problaly because my webhook is not writing in database so i try to load some variable doesnt exist

left tangle Mar 30, 2023, 1:05 PM

#

Okay so then you are going to need to debug the issue with your database

#

That isn't really a Stripe-specific issue in that case so I won't be able to help much

lethal dune Mar 30, 2023, 1:06 PM

#

i remove my code

#

and let only :

case 'checkout.session.completed':
$sql = "INSERT INTO stripe (transaction, prix, statut,email, nom, id_produit, checkout_session, test) VALUES ('123456789', '1000', 'OK', 'nicolas@monagraphic.com', 'nicolas', '123', '123456789', 'test')";

$conn->exec($sql);
break;

#

but always same error

left tangle Mar 30, 2023, 1:07 PM

#

If you remove the database insertion does it work?

lethal dune Mar 30, 2023, 1:07 PM

#

i try

#

nop

#

error 400

#

again

#

:/

left tangle Mar 30, 2023, 1:09 PM

#

Okay and what is the error message?

#

You are going to need to provide way more information for me to help you.

lethal dune Mar 30, 2023, 1:10 PM

#

in front office, not error.
Only error in stripe dashboard

#

When i check the webhook in dashboard, all informations are loaded in query but the respons is 400 ERR

left tangle Mar 30, 2023, 1:11 PM

#

You code is sending that error as a response to Stripe

#

That is how a Webhook works. We send the Webhook to your endpoint then you respond to it.

#

The response is what you see in your Dashboard

#

Can you share your webhook handler code?

lethal dune Mar 30, 2023, 1:12 PM

#

yes, let me just hide my secret key

#

can i send php file here ?

left tangle Mar 30, 2023, 1:12 PM

#

You can drop the code between three backticks like this

#

Or you can attach a txt file

lethal dune Mar 30, 2023, 1:14 PM

#

📎 message.txt

left tangle Mar 30, 2023, 1:15 PM

#

Can you also provide an Event ID from your Dashboard?

lethal dune Mar 30, 2023, 1:16 PM

#

start by we_ ?

#

evt_1MrLDaDyNb2IQXqaro6gZAdE

#

we_1MrKfWDyNb2IQXqalGZflC0F

left tangle Mar 30, 2023, 1:19 PM

#

Yep the evt_xxx

#

Okay give me a sec to look

#

Okay in your code for try { $event = \Stripe\Webhook::constructEvent( $payload, $sig_header, $endpoint_secret ); } catch(\UnexpectedValueException $e) { // Invalid payload http_response_code(400); exit(); } catch(\Stripe\Exception\SignatureVerificationException $e) { // Invalid signature http_response_code(400); exit(); }

Let's add a string in each response that differentiates those 400s

#

You could also add an error_log there

#

Ah wait a second

#

Is your endpoint public?

#

From looking at that event you provided internally it looks like we aren't able to reach your endpoint at all since the IP is in a private range.

lethal dune Mar 30, 2023, 1:23 PM

#

my host IP ?

left tangle Mar 30, 2023, 1:24 PM

#

Yep

lethal dune Mar 30, 2023, 1:24 PM

#

How can solve it ?

#

:/

left tangle Mar 30, 2023, 1:25 PM

#

You need to adjust your server config to make that endpoint public so Stripe can POST to it

lethal dune Mar 30, 2023, 1:25 PM

#

I have to contact my host so ?

left tangle Mar 30, 2023, 1:25 PM

#

If you don't know how to adjust the config yourself then yes

lethal dune Mar 30, 2023, 1:26 PM

#

ok i'll contact them

#

thanks a lot

left tangle Mar 30, 2023, 1:29 PM

#

Sure thing

lethal dune Mar 30, 2023, 1:36 PM

#

Host return me that IP is not private

left tangle Mar 30, 2023, 1:39 PM

#

Hmm okay well let's check that then by adding a log at the beginning of your endpoint before your handler and ensuring you see that log when you trigger an event

lethal dune Mar 30, 2023, 1:41 PM

#

i remove my webhook.php and add the clean code that stripe give me to try

left tangle Mar 30, 2023, 1:42 PM

#

That is a good option as well

lethal dune Mar 30, 2023, 1:44 PM

#

400ERR with the default file

left tangle Mar 30, 2023, 1:46 PM

#

Can you give me the Event ID that you tested with?

lethal dune Mar 30, 2023, 1:46 PM

#

evt_1MrLlfDyNb2IQXqaKpFU8yS6

left tangle Mar 30, 2023, 1:48 PM

#

Okay so yeah for that Event that was sent to your we_1MrKfWDyNb2IQXqalGZflC0F endpoint it does appear to be public.

#

Did you change the webhook secret to match the one for that endpoint?

lethal dune Mar 30, 2023, 1:49 PM

#

When i create new webhook, the secret is not the same that when i go to my webhook and click on reveal

#

reveal = Secret signing key

left tangle Mar 30, 2023, 1:50 PM

#

You need to use the secret for the endpoint that you are testing with

#

Otherwise you are going to hit the 400 in your code for failed webhook verification

lethal dune Mar 30, 2023, 1:51 PM

#

i check my other webhook file and the key is the same

left tangle Mar 30, 2023, 1:52 PM

#

Right it shouldn't be the same though if this is a different endpoint?

#

Okay let's pause

#

Can you adjust your code to clarify the 400s that you are responding with

#

So send back a string as well that indicates which 400 it is

lethal dune Mar 30, 2023, 1:53 PM

#

try {
  $event = \Stripe\Webhook::constructEvent(
    $payload, $sig_header, $endpoint_secret
  );
} catch(\UnexpectedValueException $e) {
  // Invalid payload
  http_response_code('code 1');
  exit();
} catch(\Stripe\Exception\SignatureVerificationException $e) {
  // Invalid signature
  http_response_code('code 2');
  exit();
}

#

can i replace my success URL by the default html file ?

left tangle Mar 30, 2023, 1:54 PM

#

I'm not a PHP expert but not sure it will let you send a string here actually with http_response_code

left tangle Mar 30, 2023, 1:55 PM

#

lethal dune can i replace my success URL by the default html file ?

Not sure what you mean by that

lethal dune Mar 30, 2023, 1:56 PM

#

checkout.session.completed

#

Hoste remove "tiger protec"

left tangle Mar 30, 2023, 1:58 PM

#

Sorry I don't understand

lethal dune Mar 30, 2023, 1:58 PM

#

it seems works

#

my host remove a protection

#

named "Tiger protect"

#

BUT

#

ho no

#

not works

#

it works only when i remove http_response_code(400); to string

#

evt_1MrLwkDyNb2IQXqaM53jmvt9
Works

left tangle Mar 30, 2023, 2:00 PM

#

Yep I see you responded to that Event successfully

lethal dune Mar 30, 2023, 2:01 PM

#

Yes

#

but the next one was error

left tangle Mar 30, 2023, 2:02 PM

#

Next event you triggered?

lethal dune Mar 30, 2023, 2:02 PM

#

When i remove 400 from http_response_code('code 1');event works

#

when i add 400 (default option) it doesnt works

#

but webhooks doesnt write in my database...

left tangle Mar 30, 2023, 2:03 PM

#

Okay so then seems that you are actually hitting that error.

#

Where is that response in your code?

lethal dune Mar 30, 2023, 2:04 PM

#

400 ?

left tangle Mar 30, 2023, 2:05 PM

#

Yeah the one that you said you removed and then added back and now you hit that error

#

Which error block is it in?

lethal dune Mar 30, 2023, 2:06 PM

#

i dont know, when i change for a string, i have no error...

left tangle Mar 30, 2023, 2:07 PM

#

Right because you are sending back the response there to Stripe, so if you don't send an error response then that means you don't see an error in Stripe. But your webhook handler still hit an error.

lethal dune Mar 30, 2023, 2:07 PM

#

perhaps

#

^^"

#

To sum up, the payments go through and work. The webhook is loaded but stops at an error and therefore does not generate any code below.
If I add the default file provided by STRIPE, I get the same error

left tangle Mar 30, 2023, 2:09 PM

#

Yeah so we need to know which error you are actually hitting in your webhook handler code so we can debug that

#

That is why I was saying before to make the errors that you are responding with unique

#

So we know where in your code it is erroring

lethal dune Mar 30, 2023, 2:10 PM

#

// Invalid payload

OR

// Invalid signature

left tangle Mar 30, 2023, 2:11 PM

#

Yep so which one?

lethal dune Mar 30, 2023, 2:11 PM

#

As i said, i dont know

#

Ok

left tangle Mar 30, 2023, 2:14 PM

#

Add an echo right before your http_response_code

lethal dune Mar 30, 2023, 2:14 PM

#

I changed 400 with another code

#

100 and 600

left tangle Mar 30, 2023, 2:14 PM

#

Like we show here: https://stripe.com/docs/webhooks/quickstart?lang=php

#

  // Invalid payload
  echo '⚠️  Webhook error while parsing basic request.';
  http_response_code(400);
  exit();
}```

lethal dune Mar 30, 2023, 2:14 PM

#

600 is returned

#

So

#

  // Invalid signature
  http_response_code(600);
  exit();
}`````

Invalid signature

#

Event : evt_1MrME3DyNb2IQXqa4iZnmppR

delicate tartanBOT Mar 30, 2023, 2:15 PM

#

left tangle Mar 30, 2023, 2:16 PM

#

Great okay so now we need to check on the Webhook secret that you are using

#

It likely isn't the one for that endpoint

lethal dune Mar 30, 2023, 2:16 PM

#

Ok

#

where can i find my secret ?

#

Click on reveal ?

left tangle Mar 30, 2023, 2:18 PM

#

Yep

lethal dune Mar 30, 2023, 2:18 PM

#

It works

#

I replace this key several time

#

...

#

thanks a lot for your patience !

#Reitrac