I am absolutely stumped over this one. We configured emailfriend on our Canadian website and it works fine. However on our USA website we get 404 permissions error. All subdirectories appear to be the same on both sites however I just cannot figure out why the error on this USA site.

We host our sites as well as email, etc.

Error from website log is:
#Software: Microsoft Internet Information Services 8.5
#Version: 1.0
#Date: 2018-05-26 18:16:17
#Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) cs(Referer) sc-status sc-substatus sc-win32-status time-taken
2018-05-26 18:16:14 (xxx.xxx.xxx.xxx ip removed by me for security reasons) GET /proddetail.asp prod=82063-250&cat=108 80 - 76.70.31.48 Mozilla/5.0+(compatible;+AhrefsBot/5.2;++http://ahrefs.com/robot/) - 200 0 0 718
2018-05-26 18:17:05 (xxx.xxx.xxx.xxx ip removed by me for security reasons) GET /proddetail.asp prod=471.BKK1.07 80 - 76.70.31.48 Mozilla/5.0+(compatible;+DotBot/1.1;+http://www.opensiteexplorer.org/dotbot,+help@moz.com) - 404 0 0 140

2018-05-26 18:17:17 (xxx.xxx.xxx.xxx ip removed by me for security reasons) GET /proddetail.asp prod=380-060P 80 - 76.70.31.48 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/66.0.3359.181+Safari/537.36 http://www.canadacutlery.us/products.asp?cat=102 200 0 0 296

2018-05-26 18:17:17 (xxx.xxx.xxx.xxx ip removed by me for security reasons) GET /favicon.ico - 80 - 76.70.31.48 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/66.0.3359.181+Safari/537.36 http://www.canadacutlery.us/proddetail.asp?prod=380-060P 200 0 0 46

2018-05-26 18:17:19 (xxx.xxx.xxx.xxx ip removed by me for security reasons) GET /emailfriend.asp lang=&id=380-060P 80 - 76.70.31.48 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/66.0.3359.181+Safari/537.36 http://www.canadacutlery.us/proddetail.asp?prod=380-060P 200 0 0 16

Can anyone help me understand what might be going wrong here.

Thanks, Peter


CCI - Tools for the Discriminating Chef

Hi Peter

It could be your host has black-listed the file so ask if that's the case and can be changed on their end.

Andy

Please feel free to review / rate our software

Thanks Andy, we are the host?

CCI - Tools for the Discriminating Chef

Blacklist Check

IP/Hostname: www.canadacutlery.us
IP address tested: 76.70.31.48
Test performed from: New York, NY
Test performed at: 2018-05-26 18:54:35 (GMT +00:00)

Lookup server Open Proxy Spam Other Details
dnsrbl.net NO NO NO -
cbl.abuseat.org NO NO NO -
proxies.blackholes.easynet.net NO NO NO -
sbl-xbl.spamhaus.org NO NO NO -
psbl.surriel.com NO NO NO -
dnsbl.sorbs.net No response


CCI - Tools for the Discriminating Chef

Yes, that would have resulted in a forbidden error so wouldn't be the problem, sorry.

It does appear to be a permissions problem though so can you compare the two sites in that respect?

Andy

Please feel free to review / rate our software

Yes, I have done that and they appear to be the same with respect to permissions. Is the emailfriend.asp only accessing the www. root or does it also need vsadmin\inc\ , etc.?

CCI - Tools for the Discriminating Chef

Yes it is also dependent on files in the vsadmin/inc/ folder.

Andy

Please feel free to review / rate our software

Hi Andy,

We have done extensive research on the 403 error (Email Friend and Ask a Question). It appears that the USA SQL database when originally created was actually copied from our Canadian SQL database.

There appears to be an issue with the database. Here is what one of my tech people advised......

====================
[red]So I spent a fair bit of time yesterday and today trying to trouble shoot this 403 error. So to make a long story short I think the problem is in the database.

The 403 error is being generated by the emailfriend.asp page. It looks like page is checking something in the database and them failed to find what it needed and then triggered the 403 page. The failed request tracking logs specified the 403 error was coming from the emailfriend.asp page on line 97. Before line 97 there are a bunch of if and then statements for validation before sending the email.

To prove my theory I changed the dB conn open file to point to cc.ca and the email friend test went out correctly. After I switched it back I got the 403 error. No files from cc.us have been changed.

So I am not sure where else to look. DNS is working correctly and the server is not blacklisted. [/red]
====================

So long story short, Andy is there anything we can do to fix the SQL database issue?

Regards, Peter


CCI - Tools for the Discriminating Chef

Are both databases running the same version with the corresponding emailfriend.asp file on the server?

Andy

Please feel free to review / rate our software

Two separate databases on SQL server.
Two separate web configurations each pointing to the separate databases.

Its possible that the original cc.us database was created using our cc.ca database as a template.

Regards, Peter

CCI - Tools for the Discriminating Chef

Are they one the same version? I mean sometimes the emailfriend.asp changes between versions and I just wanted to check that the version you have for each corresponds to the version the store is running.

Andy

Please feel free to review / rate our software

Just to be sure I re-copied the update to 6.9.2 and re-ran the updatestore. Version is 6.9.2, emailfriend.asp is Date created 7/2/2017 9:55 PM

No change to error.

Regards, Peter

CCI - Tools for the Discriminating Chef

I just tried it on your US site and it shows a 403 Forbidden error (rather than 404) so it won't be anything to do with versions but just server permissions on that file I believe.

Andy

Please feel free to review / rate our software

IUSR = Full control
IIS_IUSER = Full control
Internet Guest = Read & execute, Read, Write

Settings are exactly the same on both databases and directories.

We are absolutely baffled on this one. Sorry

Regards, Peter

CCI - Tools for the Discriminating Chef