Barclays ePDQ help please:)

Ah - there are a few POST boxes in the cpi admin area including user and password. I've filled in the return address box of course but don't know whether anything needs to go in those other text boxes.

POST URL is the URL of the epdq_result.php file to which epdq will send the success or failure message. This is the file that populates the log table.

The POST User name and POST password are the access details that allow ePDQ access to you HTTP authenticated ePDQ folder without which it can't reach the epq_result file.

The POST Email is the email address to which you want failure messages sent if it's unable to establish connection with the epq_result file.

Ah I see. It also mentions 'continue option 1.**' (and 2 and 3) with yes/no radio buttons - should these all be yes? There's also a 'POST Order result' currently set to no. Oh - have I been v stupid?? Should this be yes then?

Currently the epdq folder is unprotected - I need to enter something in for the form to allow me to save the details. Any idea what I would put in?

I'm trying to find their documentation at the moment but not having a great deal of luck.

Thanks for your help - I really appreciate it.

Hi - forget the last email about what username and password to put in - found a site saying just to put in 'none' and 'none'. I'm still a little confused by the options, though.

I'll give it a go now.

The options are basically options built in, probably some time ago, allow extra undefined extra security steps to be added. What they now map to is covered in their docs.

The username and password should be those which you have set up on your server to protect the epdq folder, after all you don't want people spoofing payments.

This is a nightmare :-(

I get all through the system - enter card details and they're accepted. A transaction status of 'success' appears in the log. When I get returned to the site it says thanks for ordering your order number is (and it's blank)

I get an email saying:

Your order details follow:
Order #: c1-o1

I then try to follow the simulated ending of the order but I can't make it appear in the orders list.

It's not a total disaster as I can use the master password to log in as the user and see what's in their basket.

I can't do the manual completion - it again goes to the thank you page saying your order number is (and blank)

I'm surprised my bank hasn't called me yet due to the number of £1 transactions I'm making...

I'm off to watch TV!

It took a lot of 1p transactions to get the mod written.

Is it possible that, like we found, your server is refusing to redirect out of the epdq folder to complete the order? If so that's why there's a second process flow invoked by a single switch in the code, and explained in the installation instructions.

This is to do with the EPQD URL POST ?

When i go here "http://www.yousite.com/epdq/epdq_result.php"

I Get This

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' oid = '', chargetype = '', datetime =' at line 3
in:
[insert into epdq_log set transactionstatus = '', total = , oid = '', chargetype = '', datetime = '']

Is this right or could this be why its not creating Orders in Zen Cart after Transaction

what should the folders be CHMOD be set to?

even with the post_url_simulator it still dose not creat a log file

tuneyour:

This is to do with the EPQD URL POST ?

When i go here "http://www.yousite.com/epdq/epdq_result.php"

I Get This

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' oid = '', chargetype = '', datetime =' at line 3
in:
[insert into epdq_log set transactionstatus = '', total = , oid = '', chargetype = '', datetime = '']

Is this right or could this be why its not creating Orders in Zen Cart after Transaction

what should the folders be CHMOD be set to?If you go there without passing in parameters, it will indeed fail.

A further warning about ePDQ.

The code supplied by them and integrated into this mod uses the php function fsockopen(), which ePDQ have told me today is turned off by default in PHP5. So if your webhost is keeping their PHP up-to-date, there is a real risk that this mod will simply stop working.

Apparently, they have an alternative CURL-based approach that avoids this issue, though I haven't yet managed to get hold of a copy of the code.

Hi - me again.

Still not getting a lot further so I decided to go down the redirect: false line. I'm now getting to the payment area, entering my card details and then getting payment declined. I've now tried it with a couple of cards which I know work.

Has anyone else seen this symptom?

The other thing, if I avoid the redirection option do I need to change thr post url entry to https://www.domain.com/epdq_cpi_handler.php instead of http://YOUR-SITE-URL/epdq/epdq_result.php within the cpi admin area?

Thanks,

Richard

If you're actually getting to the ePDQ and then having a legitimate card declined, I'd contact ePDQ support. Their servers log every transaction and their staff can see the log, so should be able to advise as to why the transaction is being rejected.

kuroi:

A further warning about ePDQ.

The code supplied by them and integrated into this mod uses the php function fsockopen(), which ePDQ have told me today is turned off by default in PHP5. So if your webhost is keeping their PHP up-to-date, there is a real risk that this mod will simply stop working.

Apparently, they have an alternative CURL-based approach that avoids this issue, though I haven't yet managed to get hold of a copy of the code.
:oops:
This is the exact error I'm receiving, would seem my webhost is indeed running on PHP5

Help :cry:

My webhost allows the use of a custom php.ini so ive switched on that option that's off by default and at least the errors have gone away!

Good to hear. The host I use for public sites, switched the option on for me, so I didn't need to integrate the curl option either.

I've got the same problem as rpain on 7th december where the transaction is successful and return to the site has blank order number.

The 'epdq_log' table shows that the transaction was successful but the order doesn't appear in my 'orders' table and so isn't shown in orders on my ZenCart admin page.

Trying the simulated ending by calling epdq_cpi_handler.php just does the same thing and returns to the 'Thank You' page with a blank order number and nothing added to the 'orders' table.

The shopping cart still contains the products ordered and so isn't cleared.

Have the problems of integration with Barclays ePDQ CPI been resolved now? Or should it be avoided?

It should be avoided. Most of the UK banks continue to use the first generation payment systems that were great in their day, but flawed and under-featured in today's e-commerce world.

At Kuroi we understand our clients trust in their banks (though that's wobbling seriously at the moment), but recommend that they use a specialist payment gateway.

Even the client who insisted on it and for whom we built this module has now (happily) switched to a more reliable service.