ANZ eGate problems

[euphoric]

Hi guys,

I have managed to install Zencart 1.3.8 on my local development server using Windows Server 2008, IIS7, PHP 5.2.6, MySQL 5.1.28 (not using xampp).

Now I have installed the CC via MIGS ANZ eGate payment module as provided by Cameron Manderson in the addons download section.

I have setup the configuration of the module as:

Enable MIGS Payment Module - True
Merchant-Hosted Integration Model - True
MIGS Test Host Simulator - True
MIGS Merchant ID - {my merchant id inputted without TEST prefix as it says in the instructions. It is automatically appended in the module correct?
MIGS Access Code - {my access code}
MIGS Secure Hash Secret - {my secure hash code}
Optional Notification Email Address - {my email address}

I have tested other payment modules and i can checkout fine. When I use this module, I provide the test details and if “Email options > Email Archiving Active?” is set to off I get this message when confirming the order:

The credit card number starting with was not entered correctly, or we do not accept that kind of card. Please try again or use another credit card. (this is displayed above the checkout section)

When I have “Email options > Email Archiving Active?” is set to on I get this error message straight away. I believe this is so because the HTML code is being inserted into the subject field for some reason?

1406 Data too long for column 'email_subject' at row 1
in:
[insert into dev_email_archive (email_to_name, email_to_address, email_from_name, email_from_address, email_subject, email_html, email_text, date_sent, module) values ('', '[email protected]', 'matesrates Australia', '[email protected]', 'vpc_Version=1&vpc_Command=pay&vpc_MerchTxnRef=REFNUMGOESHERE&vpc_Merchant=MERHCANTGOESHERE&vpc_OrderInfo=testAT20081021084928&vpc_CardNum=5123456789012346&vpc_CardExp=1301&vpc_CardSecurityCode=123&btn_submit_x=28&btn_submit_y=26&vpc_AccessCode=B26A3508&vpc_Amount=22500', '_html_ _head_ _meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\" /_ _base href=\"http://piggy/Clients/matesrates/zencart/\" /_ _style type=\"text/css\"_ body {background-color:#ffffff; color:#000000; font-family:Verdana, Arial, Helvetica, sans-serif; text-align:center;} a:link {color:#0066cc;} a:hover {background-color:#eeeecc; color:#0066cc;} a:visited {color:#0066cc;} .holder {background-color:#f9f9f9; border:1px solid #9a9a9a; font-size:9px; text-align:left; width:550px;} .header {font-size:10px; padding:0px; width:550px;} .content {font-size:10px; padding:5px; width:550px;} .footer {border-top:1px solid #9a9a9a; font-size:9px; margin-top:10px; text-align:center; width:550px;} .extra-info {background-color:#cccc99; border:1px solid #9a9a9a; font-size:10px; margin-top:10px; padding:5px; width:550px;} .extra-info-bold {font-weight:bold;} .disclaimer {background-color:#f9f9f9; border:1px solid #cccccc; font-size:10px; margin-top:10px; padding:5px; width:550px;} .disclaimer1 {color:#666666; padding:5px;} .disclaimer1 a:link {color:#666666;} .disclaimer1 a:visited {color:#666666;} .disclaimer2 {color:#666666; padding:5px;} .copyright {border-bottom:0px solid #9a9a9a; padding:5px;} _/style_ _/head_ _body_ _div class=\"holder\"_ _!-- Header Section --_ _div class=\"header\"_ _img src=\"email/header.jpg\" alt=\"logo\" /_ _/div_ _!-- Content Section --_ _div class=\"content\"_ _div_vpc_Version=1&vpc_Command=pay&vpc_MerchTxnRef=REFGOESHERE&vpc_Merchant=MERCHANTGOESHERE&vpc_OrderInfo=testAT20081021084928&vpc_CardNum=5123456789012346&vpc_CardExp=1301&vpc_CardSecurityCode=123&btn_submit_x=28&btn_submit_y=26&vpc_AccessCode=B26A3508&vpc_Amount=22500_/div_ _div_$EMAIL_MESSAGE_HTML_/div_ _/div_ _!-- Footer Section --_ _div class=\"footer\"_ _div class=\"copyright\"_Copyright (c) 2008 _a href=\"http://piggy/Clients/matesrates/zencart/index.php?main_page=index\" target=\"_blank\"_Matesrates Online Store_/a_. Powered by _a href=\"http://www.zen-cart.com\" target=\"_blank\"_Zen Cart_/a__/div_ _/div_ _/div_ _div class=\"disclaimer\"_ _div class=\"disclaimer1\"_This email address was given to us by you or by one of our customers. If you feel that you have received this email in error, please send an email to _a href=\"mailto:[email protected]\"[email protected] _/a_ _/div_ _div class=\"disclaimer2\"_This email is sent in accordance with the US CAN-SPAM Law in effect 01/01/2004. Removal requests can be sent to this address and will be honored and respected._/div_ _/div_ _/body_ _/html_', 'There was an error when processing a transaction response from the MIGS Payment Gateway vpc_Version=1&vpc_Command=pay&vpc_MerchTxnRef=REFGOESHERE&vpc_Merchant=MERCHANTGOESHERE&vpc_OrderInfo=testAT20081021084928&vpc_CardNum=5123456789012346&vpc_CardExp=1301&vpc_CardSecurityCode=123&btn_submit_x=28&btn_submit_y=26&vpc_AccessCode=B26A3508&vpc_Amount=22500 Details of the Error are as follows MIGS: ORDER CUSTOMER: firstname=Liv lastname=Tyler company=ALl global street_address=89 Allenswood Road suburb= city=Perth postcode=2105 state=New South Wales zone_id=183 country=Array format_id=1 telephone=0401910599 email_address=tranm01###################### SERVER VARS: ALLUSERSPROFILE=C:ProgramData APPDATA=C:Windowssystem32configsystemprofileAppDataRoaming APP_POOL_ID=DefaultAppPool APR_ICONV1_PATH=C:Program FilesCollabNet Subversion Serverhttpdbiniconv CommonProgramFiles=C:Program FilesCommon Files COMPUTERNAME=PIGGY ComSpec=C:Windowssystem32cmd.exe FP_NO_HOST_CHECK=NO lib=C:Program FilesSQLXML 4.0bin LOCALAPPDATA=C:Windowssystem32configsystemprofileAppDataLocal NUMBER_OF_PROCESSORS=4 OS=Windows_NT Path=C:Windowssystem32;C:Windows;C:WindowsSystem32Wbem;C:Program FilesMicrosoft SQL Server80ToolsBinn;C:Program FilesMicrosoft SQL Server90Toolsbinn;C:Program FilesMicrosoft SQL Server90DTSBinn;C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDE;C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssemblies;C:Program FilesCollabNet Subversion Server PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC PROCESSOR_ARCHITECTURE=x86 PROCESSOR_IDENTIFIER=x86 Family 15 Model 2 Stepping 9, GenuineIntel PROCESSOR_LEVEL=15 PROCESSOR_REVISION=0209 ProgramData=C:ProgramData ProgramFiles=C:Program Files PUBLIC=C:UsersPublic SystemDrive=C: SystemRoot=C:Windows TEMP=C:WindowsTEMP TMP=C:WindowsTEMP USERDOMAIN=MATESRATES USERNAME=PIGGY$ USERPROFILE=C:Windowssystem32configsystemprofile windir=C:Windows FCGI_ROLE=RESPONDER HTTP_CONNECTION=keep-alive HTTP_KEEP_ALIVE=300 HTTP_CONTENT_LENGTH=250 HTTP_CONTENT_TYPE=application/x-www-form-urlencoded HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 HTTP_ACCEPT_CHARSET=ISO-8859-1,utf-8;q=0.7,*;q=0.7 HTTP_ACCEPT_ENCODING=gzip,deflate HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5 HTTP_COOKIE=.ASPXANONYMOUS=8uo9AABpyQEkAAAAOTQxMTBiZTYtNTJmNS00OTk2LTgzOTctOTQxMmRmMGYwOTBi0; _csuid=48f2ac8f1e68c74b; zenid=2r5qvgvl9hphq1jkts75usnip4; zenAdminID=t2pnr2iqefr45ecqc910ddlm24 HTTP_HOST=piggy HTTP_REFERER=http://piggy/Clients/matesrates/zencart/index.php?main_page=checkout_confirmation HTTP_USER_AGENT=Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 DOCUMENT_ROOT=C:inetpubwwwroot REQUEST_URI=/Clients/matesrates/zencart/index.php SCRIPT_FILENAME=C:inetpubwwwrootClientsmatesrateszencartindex.php APPL_MD_PATH=/LM/W3SVC/1/ROOT/Clients/matesrates/zencart APPL_PHYSICAL_PATH=C:inetpubwwwrootClientsmatesrateszencart AUTH_TYPE= AUTH_PASSWORD= AUTH_USER= CERT_COOKIE= CERT_FLAGS= CERT_ISSUER= CERT_SERIALNUMBER= CERT_SUBJECT= CONTENT_LENGTH=250 CONTENT_TYPE=application/x-www-form-urlencoded GATEWAY_INTERFACE=CGI/1.1 HTTPS=off HTTPS_KEYSIZE= HTTPS_SECRETKEYSIZE= HTTPS_SERVER_ISSUER= HTTPS_SERVER_SUBJECT= INSTANCE_ID=1 INSTANCE_META_PATH=/LM/W3SVC/1 LOCAL_ADDR=172.24.5.2 LOGON_USER= PATH_TRANSLATED=C:inetpubwwwrootClientsmatesrateszencartindex.php QUERY_STRING=main_page=checkout_process REMOTE_ADDR=172.24.5.18 REMOTE_HOST=172.24.5.18 REMOTE_PORT=53476 REMOTE_USER= REQUEST_METHOD=POST SCRIPT_NAME=/Clients/matesrates/zencart/index.php SERVER_NAME=piggy SERVER_PORT=80 SERVER_PORT_SECURE=0 SERVER_PROTOCOL=HTTP/1.1 SERVER_SOFTWARE=Microsoft-IIS/7.0 URL=/Clients/matesrates/zencart/index.php ORIG_PATH_INFO=/Clients/matesrates/zencart/index.php PHP_SELF=/Clients/matesrates/zencart/index.php REQUEST_TIME=1224578969', now() , 'default')]

If anyone could shed any light on why this is happening that would be greatly appreciated. This payment module is crucial for our store! Thanks Zenners

[euphoric]

Anyone experiencing this problem or could help me diagnose the cause of the problem?

[euphoric]

Ok I have tried installing zen cart on a linux/php/mysql configuration.

I have tried to contact the AUTHOR of this mod (cameron Anderson) and I have not heard ANYTHING from him at all. Tried his email, blog and here. Anyone else have a functioning version of this module working.?

I still get the "The credit card number starting with was not entered correctly, or we do not accept that kind of card. Please try again or use another credit card. (this is displayed above the checkout section)" error, but now the emails are being sent. Just that the query string is added to the subject line of the ERROR email.

I can't find out what error is being thrown to cause the error message????? here is the email:

There was an error when processing a transaction response from the MIGS Payment Gateway

vpc_Version=1&vpc_Command=pay&vpc_MerchTxnRef=testAT20081027205835%2F1&vpc_Merchant=TESTANZNAME&vpc_OrderInfo=testAT20081027205835&vpc_CardNum=5123456789012346&vpc_CardExp=1305&vpc_CardSecurityCode=123&btn_submit_x=60&btn_submit_y=25&vpc_AccessCode=B26A3508&vpc_Amount=4249

Details of the Error are as follows

MIGS:

ORDER CUSTOMER:
firstname=Firstname
lastname=Lastname
company=Company
street_address=Address
suburb=
city=perth
postcode=6009
state=Western Australia
zone_id=189
country=Array
format_id=1
telephone=1234567891
email_address=EmailAddress

SERVER VARS:
PATH=/usr/local/bin:/usr/bin:/bin
REDIRECT_STATUS=200
UNIQUE_ID=QywiQNBxlBMAAGeVFlgAAAAa
SCRIPT_URL=/zencart/index.php
SCRIPT_URI=http://test.daiclub.com/zencart/index.php
HTTP_HOST=test.daiclub.com
HTTP_USER_AGENT=Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.3)
Gecko/2008092417 Firefox/3.0.3
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_ACCEPT_ENCODING=gzip,deflate
HTTP_ACCEPT_CHARSET=ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_KEEP_ALIVE=300
HTTP_CONNECTION=keep-alive
HTTP_REFERER=http://test.daiclub.com/zencart/index.php?main_page=checkout_confirmation
HTTP_COOKIE=zenid=448f13c0c3659e87e183995f66e85ede;
PHPSESSID=556ae6b39b9560d7f4e4c4411f897b41;
56c9dc05084f6c2e0a06900680ad26ed=a5608e0f9506b8303c8270749ee8c583;
zenAdminID=45229d45ea8c6997d8962a24d790369e
CONTENT_TYPE=application/x-www-form-urlencoded
CONTENT_LENGTH=250
SERVER_SIGNATURE=
SERVER_SOFTWARE=Apache/2.0.61 (Unix) PHP/4.4.7 mod_ssl/2.0.61 OpenSSL/0.9.7e
mod_fastcgi/2.4.2
SERVER_NAME=test.daiclub.com
SERVER_ADDR=208.113.149.212
SERVER_PORT=80
REMOTE_ADDR=203.161.75.205
DOCUMENT_ROOT=/root/test_mike/test.daiclub.com
SERVER_ADMIN=EMAIL
SCRIPT_FILENAME=/root/test.daiclub.com/cgi-bin/php.cgi
REMOTE_PORT=50098
REDIRECT_QUERY_STRING=main_page=checkout_process
REDIRECT_URL=/zencart/index.php
GATEWAY_INTERFACE=CGI/1.1
SERVER_PROTOCOL=HTTP/1.1
REQUEST_METHOD=POST
QUERY_STRING=main_page=checkout_process
REQUEST_URI=/zencart/index.php?main_page=checkout_process
SCRIPT_NAME=/cgi-bin/php.cgi
PATH_INFO=/zencart/index.php
PATH_TRANSLATED=/root/test.daiclub.com/zencart/index.php
PHP_SELF=/zencart/index.php
argv=Array
argc=1

[ozprodrivers]

We were involved with changing/ upgrading the eGate software in May 08 to get it to work better and with the ANZ. We ran it live to ANZ using the Test option they gave us. Once it worked we then went live and it hasn't missed a beat.

I see you are on a local machine?

Have you been in contact with the ANZ to get your merchant account etc?

Cheers

Dave

[euphoric]

Thanks for your reply.

I managed to get it working using the merchant hosted model. However for the life of me can't get it working using the server hosted model? Have any of you guys managed to get it working with the server hosted model?

Also I noticed with the merchant hosted model, if for whatever reason the credit card info is wrongly supplied it tries to redirect you back to the site but ends up at the migs screen with an error (i notice that there is no merchant name there)??? very weird..