Edventures in Normalcy

Common example errors:

Unable to authorize payment: The certificate chain did not validate, no local certificate found, Cert Path = c:\pfpcerts\, Working Directory = c:\windows\system32\inetsrv

or

Result Code: -31
Response Message: The certificate chain did not validate, no local certificate found, Cert Path = c:\pfprocerts, Working Directory = c:\windows\system32\inetsrv
Transaction ID:
Auth. Code:

or

I’m Sorry, there was a problem with your transaction.

Transaction Result:
The certificate chain did not validate, no local certificate found, Cert Path = certs, Working directory = c:\winnt\system32\inetsrv

Well, as of January 4, 2010, your Payflow Pro SDK expires permanently and your payment processing will stop if you are using an outdated SDK. You can see this on their website here:
https://cms.paypal.com/us/cgi-bin/?cmd=_render-content&content_ID=developer/gateway_update_FAQ

Depending on the method or scripting language you are using this can be an easy or difficult thing to get around. As I am Miva Merchant savvy, If you are using Miva Merchant 5, run your updates. If you are running Miva Merchant 4, you can get an updated version of the Payment Module and instructions for instillation at https://support.mivamerchant.com/supportsuite/index.php?_m=downloads&_a=viewdownload&downloaditemid=46&nav=0,12. Zen Cart forums make reference to this change here http://www.zen-cart.com/forum/showthread.php?p=823250#post823250. Anyway, if you have a hand coded cart, visit the top link I supplied for more information. If you find specific articles or information for specific carts, please comment. I will gladly update this post.

All validation error codes have been accounted for with extended information, pulled from the openSSL documentation pages here:

http://www.openssl.org/docs/apps/verify.html

More to come later.

This can be accomplished with the ch_admin_passwd binary.

[root@plesklinux root]# cd /usr/local/psa/admin/bin/

[root@plesklinux bin]# ./ch_admin_passwd —help

./ch_admin_passwd: Utility to set Plesk adminstrator’s password

Gets password from the environment variable PSA_PASSWORD

Password should be from 5 to 16 symbols and should not contain login name,

whitespace, quotes or national characters

Usage: ./ch_admin_passwd

-h, —help

display this help and exit

We must export the variable before running the binary. We will unset the variable when we are done.

[root@plesklinux bin]# export PSA_PASSWORD='newpass'

[root@plesklinux bin]# echo $PSA_PASSWORD

newpass

[root@plesklinux bin]# ./ch_admin_passwd

[root@plesklinux bin]# export PSA_PASSWORD=

[root@plesklinux bin]# cat /etc/psa/.psa.shadow

newpass

[root@plesklinux bin]#

I have just added a script to my tools page, it can be found here: Default Document Locator
It hits a site of your choosing, for common default documents. This is very useful where a site has had false documents uploaded to it and you need to locate the correct one quickly as all pages giving a 200 response code are shown in an iframe.

After restarting ColdFusion, and seeing it not a performance issue, I realized the file I was trying to save to was to a folder that did not exist.

Runtime error in lib/db.mvc @ [00000164:00000024]: lib/dbprim/stores.mv: Line 202: MvOPENVIEW: mysql_stmt_bind_results: Using unsupported buffer type: 246 (parameter: 27)

I run into this one once in a while and always have to remember to upgrade the MySQL driver to the latest.

One of two things, either the patch was not applied\incorrectly applied, seen here:

http://www.bennadel.com/blog/1289-ColdFusion-8-0-1-Bug-Coldfusion-Image-ImageWriter-ImageWritingException.htm

with CF stopped

or the path is wrong in the code, per our example:

http://www.hosting.com/support/cfusion/captcha/

destination=”tmp/readme#tc#.png”

being run from example.com/subfolder

would result int he file trying to be written to:

C:\Websites\userdir\subfolder\tmp\

When performing the callback, Google gets the following error:

401 – Unauthorized: Access is denied due to invalid credentials.
You do not have permission to view this directory or page using the credentials that you supplied.

I have not found the direct solution, but the workaround I have come up with is to put the page it calls back to in its own directory and disable basic authentication on that folder. The call back then completes. I recommend using a randomly generated folder name to prevent it from being stumbled upon by nefarious individuals.

To reorder products within a given category
in your admin section, click on Categories on the left hand side
Then to the right of the category you want to reorder products for
click the “Edit” button
Once the page loads, click the Products tab
Then click the Assigned button
This will show you the products specific to this category
To the right of Product order is a link that should say Hide, if not click the word Show
You can now see the order products will show up on this category
If you wanted the Product 2 to be the first item, you can go to its box, change the 2 to a 1 and hit enter, not Update
You will then notice the order of products has changed on your category that you edited

[View with PicLens]