Printable View
Hi there, I'm currently installing the ePDQ module on my 1.3.8 zencart and the final step is to password protect the /epdq/ directory. How do I do that?? Honestly, you'd think I'd be able to figure it out but no...:frusty:
I have a H-Sphere host control panel and Ipswitch WS-FTP pro FTP program...
Thankies!
Try using a .htpasswd file.
I used to have ePDQ, updated the site from 1.2.4 to 1.3.8 and now, obviously ePDQ is broken. Any chance you could share your files, if you think you've got it working?
Thanks,
Tryf
OK, so one thing I've just found is that both epdqresponse.php and epdq_response.php refer to this database table: tblTransLog, however, my table is actually called tbltranslog - so I have to simply change the name to lower case in both files.
This ePDQ situation is ridiculous, we really do need to get the mod on here as one set of files for 1.3.8 - does anyone actually have them, or are we all about to get there at the same time?
Im having problems with the final return to the store. I can take payment, but the final return doesnt work. I get a problem with the translog thing to.
When im looking at my database though, i cant see tblTransLog...
Where is yours?
Cheers Rob
Hi Guys i have just installed a new zencart and the epdq mod.
Havin major problems with this mod and not really getting anywhere.
When submitting an order to epdq all i get is:
Sorry, there has been a problem processing your payment.
Mandatory information not present.
Not sure weather its a security thing or the mod isn't working correctly or i have installed wrong, any ideas?
@rtnewton - Did you fill out all the information requested when you installed the mod? In particular the passphrase?
@thesoapycaldron - if you're using the current Zen Cart mod for the CPI service there is no need to password protect any directories.
everybody else ... no idea what this translog table is. What ePDQ services are you trying to access? What mod are you using? Where did you get it from?
@thesoapycaldron
Are you using CPI? If so the references in the ePDQ documentation to password protecting a directory are to protect the script that would be executed when transaction information is returned from ePDQ. However, the ePDQ mod in the free add-ins area above, doesn't support this. Presumably store owners would need to reconcile orders with payments via their CPI admin page.
Moreover, there seems to be a gaping compatibility issue between ePDQ and Zen Cart. ePDQ CPI assumes that an order is created prior to calling it to to process the payment. Zen Cart is built on the assumption that you don't want your database cluttered up with faled orders, so doesn't create one until payment is received.
And it gets worse.
ePDQ assumes that you already have the order recorded, takes the payment but doesn't force the customer to return, so you have money, but no order. The information is sitting there (at least temporarily) in the customer's basket recorded in the database - but may be lost or changed if the customer subsequently returns to the site.
Can it get worse? Well, yes!
If a client returns to the site from ePDQ, the mod in its current treats that as a success, even if the payment was declined. Order for processing, but no money. Ouch. Those reconciliation processes that the ePDQ docs bang on about are rather important. BUT, worse still, the only reference that ePDQ has for the transaction is a random number generated by the mod and then thrown away. Aie, aie, aie.
The only way that I can see to get around this at the present, is to re-order the Zen Cart checkout, to create an order with a new "unpaid" status before going to ePDQ, and expand the ePDQ mod to take full advantage of the POST information.
If somebody has a better idea, I'd really love to hear it!!!
I see what you mean and yuck, those are nasty scenarios.
I've just finished (well so I thought) a site for a guy using the epdq system and so far the site's quiet so there haven't been any problems but if someone can come up with a solution - maybe a few of us can club together to pay for someone to come up with one then I'd be happy to. If, and hopefully when, his business grows the last thing I want is for there to be payment problems.
Thanks,
Richard
Hi Richard
We actually sorted this. After several long and sometimes useful, sometimes unproductive conversations with Barclays we got to the bottom of all that what was happening.
For the record, the earlier statement has proven to be completely accurate. And don't be fooled by the message on the final ePDQ page that implies that in fact a transaction is only confirmed if a customer presses that last button. This is not the case, the transaction has been done and the wording is just to try to encourage customers to return to your store.
We therefore built a version that notified Zen Cart as soon as the transaction had gone, and had Zen Cart immediately create a corresponding order. Perfect. Except that after working perfectly on our test server, it reused to work in the same way on the client's web host's server (a Zen Cart-certified host).
So we ended up building two process flows with a switch. One of the flows is optimal, the other has a hole, but with a way to catch and deal with anything falling through it.
Along the way we added an audit trail table and took advantage of more of the ePDQ options (such as not requiring that customers re-enter their shipping information).
I'll post this as an add-in. I'd be interested to know how it works for other people. Won't be supporting it though. I was glad to see the back of it and wouldn't recommend ePDQ unless absolutely necessary.
Thanks for your reply. Just to check, I'm using this module:
http://www.zen-cart.com/index.php?ma...oducts_id=1040
I presume this is the correct one? The add in would be really helpful and gratefully appreciated. Thanks for your help - I agree, this has been the most problematic of all the payment providers I've used.
Thanks,
Richard
Right add-in. Wrong version. I've had confirmation that my update (well more of a replacement really) has been approved, but it's not appeared where it should. I'll follow up with the Zen Cart team and see if we can find out where it's hiding.Quote:
Originally Posted by rpain
My bad. Didn't read the email properly, it was the confirmation rather than the approval. But it's up now.
Thanks - I'm now so nearly there. I get through the checkout and all is well. The details appear in the epdq boxes which is great. The problem is that I get the technical problem page. The payment registers in the epdq admin area but the order doesn't appear in the zen admin area. Not ideal I think you'll agree.
I've looked at the log table all through the order process and no temporary order is created. The log file says:
temporary order ID c3-o1 not recognised in ePDQ log table.
I also then tried:
http://www.websiteaddress.co.uk/epdq....php?oid=c3-o1 (the order id from the epdq area) and still get the technical problem page.
Help please!
Also - step 1:
The "Allowed URL" will usually be https://YOUR-SITE-URL/index.php?main...t_confirmation and the "POST URL" will be http://YOUR-SITE-URL/epdq_result.php.
should be:
The "Allowed URL" will usually be https://YOUR-SITE-URL/index.php?main...t_confirmation and the "POST URL" will be http://YOUR-SITE-URL/epdq/epdq_result.php.
- I'm guessing :-?
I really think you're doing a great job - it's just a shame the epdq system is so horrible.
Richard
Anyone?
I won't bump again it's only because I've currently taken the payment option down as it's not working.
Thanks,
Richard
What do you have in the epdq_log table?
And you're right about the installation instructions.
The log table remains empty all the way through.
Richard
OK - I think I know where the problem lies.
The header_php.php file has the following code:
if (isset($$_SESSION['payment']->form_action_url)) {
$form_action_url = $$_SESSION['payment']->form_action_url;
} else {
$form_action_url = zen_href_link(FILENAME_CHECKOUT_PROCESS, '', 'SSL');
}
The system seems to just want to send me straight to the barclaycard site and avoids the checkout_process page which is why it's not adding a temporary order to the epdg_log table I'm guessing. I tried just changing the code to:
$form_action_url = zen_href_link(FILENAME_CHECKOUT_PROCESS, '', 'SSL');
- to force it to go to the checkout process page but that came up with the technical_problem.html page. The error in the log is 'Temporary order ID not passed as parameter from ePDQ'.
I'm really confused? :-(
I may have to go back to the other plug in but I'd really rather get this working.
Thanks for any ideas.
Richard
If you go straight to checkout_process bypassing ePDQ the process will fail. This is a good thing since you are completely bypassing ePDQ so attempting to create an order without collecting a payment.
It is correct to go to ePDQ after checkout confirmation, hopefully get a success indicator back from there, and then return to create the order.
If you bypass ePDQ then the log table will remain empty since it is the automated callback from ePDQ that populates it.
Ah - so at what point in the process should the log table be populated? I've tried going through the process from start to finish (even through the live payment) and the table has remained empty at every stage.
It's populated by the autoresponse from ePDQ. Can't remember the exact name, but the section that you set up at the bottom of your ePDQ control panel. If it's not coming back and populating the table you may have these details slightly wrong.
It's actually quite hard to get them right, since much of what you type is obscured, so you're typing blind and have to wait 15 minutes for it to propogate across their servers.
However, if the message returned from ePDQ doesn't connect, that gets recorded by ePDQ and they should be able to tell you (via their helpdesk) whether they are receiving success (200) or failure (300 series) confirmations.
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
If you go there without passing in parameters, it will indeed fail.Quote:
Originally Posted by tuneyour
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 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.
:oops:Quote:
Originally Posted by kuroi
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.
Hi -- i installed this module in my store. I am currently testing the module and followed the install instructions thoroughly.
I made sure that the post url included the epqd directory (install doc omits this). All works fine and declined transactions get routed correctly.
My problem is that all my transactions get declined. When using the bogus cc number 4111.... this works as designed however when using real cc numbers with matching addresses all cards are declined. I am testing with 0.01 euro totals. I called my cc company and they are not even seeing the declines which means they fail at barclays end. I sent epqd support an email but it's friday so i'm not sure if they will respond before moniday.
Also -- how do i hard code so that barclays site requires the 3 digit security code (currently this is optional)? Thanks for your help.
quick update...Quote:
Originally Posted by jazznuts699
the reason all my transactions were failing was because Barclays setup my store as a sterling only -- they forgot to setup the mutlicurrncy store. Once this new store was setup and active my transactions started working. Please see below for steps i did to make order#'s appear, change currency, and force to use credit card security code.
i had to change the EPDQ_REDIRECT_WORKING to false to get the order # to show up. with this variable set to TRUE i would get a completed payment but no order #.
i added the following code in \\includes\modules\payment\epdq.php to force use of security code:
add this in your code -- somewhere where you define variables
add this also:Code://start force to use Card Security Code
//This defines whether the Card Security Code is a mandatory field, 1=on, 2=off
$mandatecsc = '1';
//end force use of Card Security Code
lastly to use a different currency other than GBP you need to modify the currencycode variable. a list of the iso numbers and codes is located at the end of your integration guide. You need to provide the number not the code here:Code:// parameters to be encrypted
$params = 'clientid=' . $clientid;
$params .= '&password=' . $passphrase;
$params .= '&oid=' . $oid;
$params .= '&chargetype=' . $chargetype;
$params .= '¤cycode=' . $currencycode;
$params .= '&total=' . $total;
// start force to use Card Security Code
$params .= '&mandatecsc=' . $mandatecsc;
// end force use of Card Security Code
hope this helps someone else as it took me a handful of .01 transactions to test this on my site and it works.Code://$currencycode = '826'; // Pounds sterling. Could add processing for other codes, if site's merchant account supports them
$currencycode = '978'; // Euros.
another update:
in CPI Administration panel you provide return URL which in my case is over HTTPS. However when the page actually redirects after a successful payment it is done over HTTP.
the following code change in \\includes\modules\payment\epdq.php is needed:
change from
to this:Code:$options = array(
'epdqdata' => $strEPDQ[1],
'returnurl' => zen_href_link('epdq_cpi_handler.php', '', 'NONSSL',false,false,true),
'merchantdisplayname' => MODULE_PAYMENT_EPDQ_DISPLAY_NAME,
'supportedcardtypes' => $supportedcardtypes,
'collectdeliveryaddress' => $collectdeliveryaddress,
'email' => $order->customer['email_address']
);
all i have left to do is figure out how to include our secure logo in the epqd payment page instead of the text.Code:$options = array(
'epdqdata' => $strEPDQ[1],
'returnurl' => zen_href_link('epdq_cpi_handler.php', '', 'SSL',false,false,true),
'merchantdisplayname' => MODULE_PAYMENT_EPDQ_DISPLAY_NAME,
'supportedcardtypes' => $supportedcardtypes,
'collectdeliveryaddress' => $collectdeliveryaddress,
'email' => $order->customer['email_address']
);
I have tried without success:
1. In admin page under payment\epqd\Display Name add full https link to image instead of text
2. In \\includes\modules\payment\epdq.php added variable $cpi_logo which has the entire HTTPS link, then added $params .= '&cpi_logo=' . $cpi_logo;
no go so far
if a transaction fails and the customer gets redirected back to checkout payment, when they try to complete the order again it will always fail as the ORDER ID is the same and Barclays cant except the same order ID twice whether it was successful or not.
Is it mega work to make zen-cart create a new order number when this happens? Has anyone else found this problem?
cheers
Hi,
How do we change the payment dropdown options when the user gets to the epdq payment page in the barclaycard system? Currently the list includes payment types we can't accept. Barclaycard are telling us that it's something we need to set from the site - anyone have any ideas?
Thanks,
Richard
Did you ever find a workaround for this rob?Quote:
Originally Posted by idlerob
Likewise, is this a problem that got solved?Quote:
Originally Posted by jazznuts699
Many thanks!
Hi all,
I have installed ePDQ on my store and I think it is working fine.
For a test I tried to buy a product off my store and the payment went through successfully and I received a confirmation email regarding the product and payment.
After that anytime I want to buy anything it simply says that the purchase is declined. I looked at the codes and nothing was wrong. I called up the bank help desk and they looked at the log files and said that the problem is that your site always generates the same order ir and because of that only the first payment went through and after that all payments are declined.
I looked up in my Phpmyadmin and saw that no data has been passed to the epdq_log table and i think that 's the main issue because it also can not pass the data to the zen cart as well.
Can anybody please tell me how to fix this? I don't even know where to start and what to do...
Thank you
:frusty: