stevel Posted June 2, 2004 Share Posted June 2, 2004 You would not see anything from your browser - the access happens from the web site server. Quote Steve Contributions: Country-State Selector Login Page a la Amazon Protection of Configuration Updated spiders.txt Embed Links with SID in Description Link to comment Share on other sites More sharing options...
kenb Posted June 3, 2004 Share Posted June 3, 2004 nrlatsha- It appears my major problem is that the Surepay payment module doesn't store anything in cc_number. Without anything stored, the following code in catalog/checkout_process.php will not call maxmind.php: if (tep_not_null($sql_data_array['cc_number'])) { require(DIR_WS_MODULES . 'maxmind/maxmind.php'); } The first four and last four digits are visible on the checkout confirmation page. Are these useable? They do not appear to be stored anywhere in the database. Anyone have an idea of how I can work around this? Quote Link to comment Share on other sites More sharing options...
bglkk Posted June 3, 2004 Share Posted June 3, 2004 I'm a registered, free user and I get Bin Country and Bin Name just fine. hmm, if you're getting BIN country and BIN name then there is still a small problem with the Linkpoint module. Maxmind site says this, guess it's out of date... * Only registered users can access BIN Match output. ** Paid Services returns these geographical details. Free service returns distance estimate only. *** Only Premium Paid Service returns binCountry and binName. Quote "Buy the ticket, take the ride..." -HST Link to comment Share on other sites More sharing options...
akkinmore Posted June 3, 2004 Share Posted June 3, 2004 Hi I would like to find out more before I begin. 1. What info is being sent to the maxmind server? 2. How secure is the process? 3. Does maxmind retain CC no. and other relevant info?? Quote Link to comment Share on other sites More sharing options...
stevel Posted June 3, 2004 Share Posted June 3, 2004 Information sent is: - The first six digits of the credit card number - State, country and postal code of the customer - domain name of the customer's e-mail address The information can be sent over an SSL connection if you set it up that way. Maxmind does not retain the info as far as I know. Note that you are not sending the entire CC number, nor details such as the expiration date, customer name, etc. Quote Steve Contributions: Country-State Selector Login Page a la Amazon Protection of Configuration Updated spiders.txt Embed Links with SID in Description Link to comment Share on other sites More sharing options...
bglkk Posted June 3, 2004 Share Posted June 3, 2004 I just rebuilt apache, now when I place a test order to Linkpoint I'm getting this: url https://www.maxmind.com/app/ccv2r?i=198.30....ientAPI=PHP/1.0 Warning: Cannot modify header information - headers already sent by (output started at /home/upgrade1/public_html/catalog/includes/modules/maxmind/HTTPBase.php:108) in /home/upgrade1/public_html/catalog/includes/functions/general.php on line 29 However, when I refresh the brower the cart is empty--the order is going through, and the Maxmind fields (except for binCountry and binName) are populated in admin. No lines after ?> in HTTPBase.php or CreditCardFraudDetection.php. Quote "Buy the ticket, take the ride..." -HST Link to comment Share on other sites More sharing options...
useronthenet Posted June 6, 2004 Share Posted June 6, 2004 Hi, I have created the new database 'orders_maxmind' but get an the following error:- ERROR 1062: Duplicate entry '' for key 1 This is when I try to put the key for order_id any solutions ? Thanks for your help Regards Tim Quote Link to comment Share on other sites More sharing options...
sefu Posted June 10, 2004 Share Posted June 10, 2004 Ok thanks everyone for helping, I have seperated the first 6 numbers from the encyption script. I had a problem with the BIN details displaying. I discovered that I do need to enter a license number to get these details. I found that my free account which allows me 1000 queries per month to have a license key. To find it go to the log in form http://www.maxmind.com/app/ccv2_login After you have logged in, there is a link near the bottom of the page called http interface, click it. Look for the heading License Key, and in bold there is your license key :) Quote Link to comment Share on other sites More sharing options...
nrlatsha Posted June 13, 2004 Author Share Posted June 13, 2004 Sorry for the late replies, I've been on vacation... kenb - So when you run the test script with an order id that is already present, the orders_maxmind table gets updated, but you can't see anything under that order in admin? I just want to make sure that's the problem you're having right now. I'll take a look at the surepay mod again today to see if we can move it somewhere else or use a different var to look for cc orders... But you should see the fields in admin->orders if you see them in orders_maxmind... sefu - It looks like you have everything working now, correct? stevel - Did you happen to make any progress on the issue with split emails? bglkk - That may be an issue with that httpbase.php, in fact I think there is an upgrade for that, I got an email from MaxMind on vacation about an upgrade, but didn't get a chance to look. Look for an updated contrib by the end of the day... useronthenet - Are you still having the database troubles? Quote 9 times out of 10 its a PEBCAK Error (Problem exists between chair and keyboard) Replace that and you're fine... Link to comment Share on other sites More sharing options...
magicproshop Posted June 13, 2004 Share Posted June 13, 2004 (edited) Noel, Sorry, I had to move on to other things temporarily. But now I am back trying to get his working with Authorize.net Consolidated v.1.0 for AIM ( http://www.oscommerce.com/community/contri...h,authorize.net ). The above Authorize.net contribution uses a rather modified checkout_process.php file, this may be the reason everything is screwing up. Right now I have everything installed as you have instructed. The problem right now is that the maximind table is not getting populated. Any ideas? Edited June 13, 2004 by magicproshop Quote Arizona Patent Services Link to comment Share on other sites More sharing options...
sefu Posted June 14, 2004 Share Posted June 14, 2004 sefu - It looks like you have everything working now, correct? Yes everything is working perfectly now :) Thanks for the excellent mod! I am thinking about going for a paid service, I'm not sure if its a restriction of the free service but it doesnt show all the bin names, previously the free service would should 99% of the BIN names. Now with some of the request it would only show the BIN country and match. ANyone else experience this? Quote Link to comment Share on other sites More sharing options...
nrlatsha Posted June 14, 2004 Author Share Posted June 14, 2004 (edited) magicproshop - I've been on vacation, so don't worry about putting it on the side for a bit, I had to also. Did you try the mod I gave in this post: http://www.oscommerce.com/forums/index.php?sho...ndpost&p=373843? It looks as if that is where the authorize.net stuff is getting called, so I just added maxmind to that call... sefu - I'm just about to release the next version of this contrib. That will include the new features. I'm just working on the upgrade install instructs and waiting to see if the auth.net mod works Edited June 14, 2004 by nrlatsha Quote 9 times out of 10 its a PEBCAK Error (Problem exists between chair and keyboard) Replace that and you're fine... Link to comment Share on other sites More sharing options...
stevel Posted June 14, 2004 Share Posted June 14, 2004 I didn't try to analyze the split email problem any further - since I moved the Maxmind code to the end of the process, everything works the way I want it to. Quote Steve Contributions: Country-State Selector Login Page a la Amazon Protection of Configuration Updated spiders.txt Embed Links with SID in Description Link to comment Share on other sites More sharing options...
magicproshop Posted June 14, 2004 Share Posted June 14, 2004 Noel, Yes, I did add the custom code you gave for the checkout_process file and it still does not populate the database. Quote Arizona Patent Services Link to comment Share on other sites More sharing options...
magicproshop Posted June 14, 2004 Share Posted June 14, 2004 (edited) Noel, It is working now! I have implemented the needed Authorize.net adjustments and I also needed to a change the Curl HTTPS settings in the maxmind.php file to O. // If you want Secure HTTPS and you have Curl and OpenSSL installed// and the php curl binding then // uncomment the next line with the word isSecure $ccfs->isSecure = 0; I am setting up my site on a test domain in which I don't have a secure certificate installed (I do have the SSL version of CURL though). Once I switched the default setting from "1" to "0" it worked like a charm. Thanks so much for your help. Take care Edited June 14, 2004 by magicproshop Quote Arizona Patent Services Link to comment Share on other sites More sharing options...
nrlatsha Posted June 14, 2004 Author Share Posted June 14, 2004 magicproshop - Fantastic! I was beginning to wonder what could be going on there... That is very good information for everyone though. Best of luck to you and your store. Now that you have it setup... **** NEW VERSION UPLOADED V1.4 **** http://www.oscommerce.com/community/contributions,2115 Screen Shot still here: http://www.nabcomdiamonds.com/catalog/images/maxmind.jpeg Change notes: 14 June 2004 08:20:59 V1.4 (1) Cleaned up code (2) Added options for advanced queries (3) Replaced maxmind files with updated versions (4) Added testing file & instructs (5) Instructions for upgrades added too... In case anybody was wondering, this is a FREE service from MaxMind. Lemme know of any problems with the install or upgrade. Noel Quote 9 times out of 10 its a PEBCAK Error (Problem exists between chair and keyboard) Replace that and you're fine... Link to comment Share on other sites More sharing options...
Druide Posted June 15, 2004 Share Posted June 15, 2004 Thanks NOEL for the NEW version, i just came back from my Holiday in Europe (Holland & Spain) and i was planning to make such a contribution on my site. Thanks for saving me a couple of hours :) it works like a charm. One question though, if a registered customer has something like Ghostsurf installed then you will NEVER be able to track the correct distance (Distance from IP address to Billing Location in kilometers (large distance = higher risk)) Since i have 'GhostSurf' installed on my box, i can verify the above Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
nrlatsha Posted June 15, 2004 Author Share Posted June 15, 2004 One question though, if a registered customer has something like Ghostsurf installed then you will NEVER be able to track the correct distance (Distance from IP address to Billing Location in kilometers (large distance = higher risk)) Since i have 'GhostSurf' installed on my box, i can verify the above Does it identify it as an anonymous proxy for your then? Quote 9 times out of 10 its a PEBCAK Error (Problem exists between chair and keyboard) Replace that and you're fine... Link to comment Share on other sites More sharing options...
useronthenet Posted June 16, 2004 Share Posted June 16, 2004 Hi nrlatsha Yes I am stil having the same problem of putting the primary key to the field name 'order_id' error still the same: ERROR 1062: Duplicate entry '' for key 1 Any help would be appreciated Regards Tim Quote Link to comment Share on other sites More sharing options...
nrlatsha Posted June 16, 2004 Author Share Posted June 16, 2004 Hi nrlatsha Yes I am stil having the same problem of putting the primary key to the field name 'order_id' error still the same: ERROR 1062: Duplicate entry '' for key 1 Any help would be appreciated Regards Tim Check your database to see if the primary index is already setup for order_id, it should be... Quote 9 times out of 10 its a PEBCAK Error (Problem exists between chair and keyboard) Replace that and you're fine... Link to comment Share on other sites More sharing options...
bglkk Posted June 16, 2004 Share Posted June 16, 2004 I just rebuilt apache, now when I place a test order to Linkpoint I'm getting this: url https://www.maxmind.com/app/ccv2r?i=198.30....ientAPI=PHP/1.0 Warning: Cannot modify header information - headers already sent by (output started at /home/upgrade1/public_html/catalog/includes/modules/maxmind/HTTPBase.php:108) in /home/upgrade1/public_html/catalog/includes/functions/general.php on line 29 However, when I refresh the brower the cart is empty--the order is going through, and the Maxmind fields (except for binCountry and binName) are populated in admin. No lines after ?> in HTTPBase.php or CreditCardFraudDetection.php. Hi Noel: Just installed v1.4 and ran maxtest.php. Seems to be working fine again (except for BinCountry and BinName still coming up blank). Thanks! Quote "Buy the ticket, take the ride..." -HST Link to comment Share on other sites More sharing options...
nrlatsha Posted June 16, 2004 Author Share Posted June 16, 2004 Glad to hear it went well and thats its working for you now... I didn't get bin country or name until I upgraded from the free service... Quote 9 times out of 10 its a PEBCAK Error (Problem exists between chair and keyboard) Replace that and you're fine... Link to comment Share on other sites More sharing options...
bglkk Posted June 17, 2004 Share Posted June 17, 2004 OK, after registering for the free service at Maxmind, now I'm getting a BinName, but no BinCountry. BinMatch is the same as ever: "Not Found". According to the Maxmind site, I should be getting BinMatch, but not the other two (which require Premium Paid service). It's no big deal, just a little weird. Anyway, I reckon this is an issue with Maxmind, not your excellent contribution. Quote "Buy the ticket, take the ride..." -HST Link to comment Share on other sites More sharing options...
stevel Posted June 17, 2004 Share Posted June 17, 2004 I get the Name, Match and Country with a free account. As I understand it, the only thing missing is the City of the IP address. Quote Steve Contributions: Country-State Selector Login Page a la Amazon Protection of Configuration Updated spiders.txt Embed Links with SID in Description Link to comment Share on other sites More sharing options...
sefu Posted June 18, 2004 Share Posted June 18, 2004 I had a similar problem, look a few pages back. I would not get any bin information, but I found that my free account had a license number which I entered in and I get all the information now Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.