Edventures in Normalcy

Install Microsoft Visual C++ 2008 SP1 Redistributable Package (x86)

• This is a requirement for the next item.
• The installer can be found here.

1. Initiate the installer, click Next at the first screen.

   

2. Click the select box for I have read and accept the license terms. and then click Install >.

3. 

4. Click Finish.

   

Install OpenSSL

1. Download the installer from here.
2. Initiate the installer, click OK if you see this screen

   

3. Click Next >.

   

4. Select the radio for I accept the agreement and click Next >.

   

5. Click Next >.

   

6. Click Next >.

   

7. Click Next >.

   

8. Click Install.

   

9. Choose a donation option right for you and click Finish.

   

10. Once installation has completed, it places the dll’s in the following places:

    C:\WINDOWS\system32\libeay32.dll
    C:\WINDOWS\system32\ssleay32.dll

Install the Miva Merchant Empresa engine

1. Download the latest installation from here.
2. Initiate the installer, click Next >.

   

3. Select the radio for I accept the terms in the license agreement and click Next >.

   

4. Click Next >.

   

5. Click Install.

   

6. Click Finish.

   

Install GD

1. Download the latest gd-latest-win32.zip from here. I personally had to obtain the zip using archive.org, in which you can download the same file as I have saved it here.
2. Create a new folder within the Miva Merchant Empresa installation directory and name the Folder SYSTEM. You should then have one of the following paths

   C:\Program Files)\Miva Merchant\Miva Merchant Empresa\SYSTEM

   Or:

   C:\Program Files (x86)\Miva Merchant\Miva Merchant Empresa\SYSTEM

3. Open up the gd-latest-win32.zip file.

   

4. Inside of the bin folder you will find a file bgd.dll.

   

5. Copy this file to the SYSTEM folder we created earlier.

   

6. Grant IUSR read access to this dll.

Configure IIS for the Empresa Engine

• First off, if this is a 64bit version of IIS6, it needs to be run in 32 bit mode in order for Miva Merchant Empresa settings to show. To load IIS in 32 bit mode, put a shortcut on the desktop, edit the shortcut adding ‘ /32′ to the end of the path, causing the path to end up being:

%SystemRoot%\system32\inetsrv\iis.msc /32

• Also, you will want to configure IIS to run 32 bit applications. To do this, run the following command:

  cscript.exe C:\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1

IIS Web Server Extension

1. Open IIS and select Web Service Extensions.

   

2. Click Add a New Web Service Extensionand enter the requested information:
   • Extension Name: Miva
   • Required Files:C:\Program Files\Miva Merchant\Miva Merchant Empresa\MivaVMIIS.dll

     Or for x64 Required Files: C:\Program Files (x86)\Miva Merchant\Miva Merchant Empresa\MivaVMIIS.dll

   • Check Set Extension Status to Allowed

   

3. Click Ok.

IIS Mapping for .mvc

1. Open IIS, right-click Websites and select Properties.

   

2. Click on the Home Directory tab and then click Configuration.

   

3. On the Mappings tab, click Add.

   

4. Enter the requested information:
   • Executable:C:\Program Files\Miva Merchant\Miva Merchant Empresa\MivaVMIIS.dll

     Or for x64 Executable:“C:\Program Files (x86)\Miva Merchant\Miva Merchant Empresa\MivaVMIIS.dll”

     • Remember to include the double quotes

   • Extension Type: .mvc
   • Leave the other options as the defaults

   

5. Click OK.
6. I recommend checking a website to ensure the mapping has propagated throughout the website tree.

ISAPI Filters for x64 based OS’s

• Since IIS will be running essentially in 32 bit mode, we need to make sure that other entities, such as .NET 2.0 are set to run the 32 bit versions as well.

1. Open IIS, right-click Websites and select Properties.

   

2. Click on the ISAPI Filterstab.

   

3. Select ASP.NET_2.0.50727.0 and click Edit….

   

4. For anything .NET, you can update the Executable field replacing “Framework64″ with just “Framework”, keeping the rest of the field intact. Click OK. Click OK.

Miva VM Settings

1. Open the site in question within IIS, right-click the site, and choose Properties.

   

2. Choose the Miva Merchant Empresa tab.

   

3. Enter the requested information:
   • Restrict scripts to the following directory and below:

     This will be the same as the Home Directory

   • Store data in the following directory:

     In my case, this is usually be the same as the Home Directory, but in C:\MivaData\subfolderName

4. Click Browse for the Look for SSL root certificates in the following directory: setting.
5. Make sure you are using the openssl-0.9 directory because we installed OpenSSL 0.9 and not version one.

   

6. Click OK.

Commerce and System Libraries

1. There are a total of 3 main Commerce libraries (LinkPoint, AuthorizeNet, and CyberCash). AuthorizeNet and CyberCash can be obtained elsewhere while LinkPoint was included in the Miva Merchant Empresa installer.
2. Once downloaded place them in the appropriate location:

   C:\Program Files\Miva Merchant\Miva Merchant Empresa\COMMERCELIBRARIES

   or

   C:\Program Files (x86)\Miva Merchant\Miva Merchant Empresa\COMMERCELIBRARIES

3. Right-click on the COMMERCELIBRARIES folder and choose Properties.

   

4. Click on the Security tab.

   

5. Click Advanced, check the checkbox for Replace permission on entries on all child objects with entries shown here that apply to child objects and click OK.

   

6. Click Yeson the warning message.

   

7. Click OK to close the COMMERCELIBRARIES Properties box.
8. Continuing from the last screen within IIS, click Libraries.

   

9. Click Addto add the AuthorizeNet Library.
   1. Change the Library Type to

      Commerce

      .

   2. Set the Method to

      AuthorizeNet

      .

   3. Enter in the path to the MCATHNET.DLLfile:

      C:\Program Files)\Miva Merchant\Miva Merchant Empresa\COMMERCELIBRARIES\MCATHNET.DLL

      Or:

      C:\Program Files (x86)\Miva Merchant\Miva Merchant Empresa\COMMERCELIBRARIES\MCATHNET.DLL

   4. Verify your settings

      

   5. Click OK to save your changes.
10. Click Add to add the CyberCash Library.
    1. Change the Library Type to

       Commerce

       .

    2. Set the Method to

       CyberCash

       .

    3. Enter in the path to the MCATHNET.DLLfile:

       C:\Program Files)\Miva Merchant\Miva Merchant Empresa\COMMERCELIBRARIES\MCYBCSH.DLL

       Or:

       C:\Program Files (x86)\Miva Merchant\Miva Merchant Empresa\COMMERCELIBRARIES\MCYBCSH.DLL

    4. Verify your settings

       

    5. Click OK to save your changes.
11. Click Add to add the GD Library.
    1. Change the Library Type to

       System

       .

    2. Set the Method to

       GD

       .

    3. Enter in the path to the bgd.dllfile:

       C:\Program Files)\Miva Merchant\Miva Merchant Empresa\SYSTEM\bgd.dll

       Or:

       C:\Program Files (x86)\Miva Merchant\Miva Merchant Empresa\SYSTEM\bgd.dll

    4. Verify your settings

       

    5. Click OK to save your changes.

Test using the Miva Diagnostics tool

1. Copy diag6.mvc from either location below, and paste it in the webroot.

   C:\Program Files\Miva Merchant\Miva Merchant Empresa\TOOLS

   Or

   C:\Program Files (x86)\Miva Merchant\Miva Merchant Empresa\TOOLS

2. From within IIS, locate this file, right click on it and choose Browse.
3. Run each test.
   1. Under System Variables make sure miva_sslavailable = 1.
      • If it equals 0 try installing OpenSSL again.
   2. Under License Manager Callyou want to make sure all tests pass:

      

   3. Under Installed Database Libraries you want to make sure all tests pass, and that it shows both MivaSQL and MySQL:

      

   4. Under Installed Commerce Librariesyou want to make sure all tests pass, and that it shows LinkPoint, AuthorizeNet, and CyberCash:

      

   5. Under Installed System Libraries you want to make sure all tests pass, and that it shows GD:

      

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.

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.

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]

So you have some categories (image one) and this is what they look like (image two). Then you add a third Category (image three) and you see what it looks like (image four), but you feel this is a sub category, or a sub type of a main category. So what you want to do, is set it as a sub category. To do this, in the admin, on the far right, click Edit (image five). Click the Look Up button (image six) and chose the appropriate parent category (image seven). Then Click the Update button (image eight). Now, if you go to the site, the site by default looks like Image two, but if you click on Category One, it shows you the sub categories (image nine)

[View with PicLens]

To edit your settings log into your Seller Central Account, Click on Checkout Pipeline Settings under Settings on the left hand menu. Click on the Edit button. You will find the correct settings to set these to within your Miva Merchant admin section, at the screen where you edit the Payment settings for your Checkout by Amazon module. The correct settings are listed on the bottom. Keep in mind the Merchant URL must be a secure (https) URL. Then Click Update to complete.

[View with PicLens]

Scripts seem to have been upgraded but the backend was not, so the scripts are looking for a field that does not exist.  From my understanding may be related to core 14.

This post is primarily for when going from 4-5 to find out what module the missing one was.

For all of those like me that can never remember, when looking for the OINF page, look to the OCST and ORDL pages instead.

If customer is not logged in -> OINF Goes to ORDL
If customer is logged in -> OINF Goes to OCST

To edit your settings log into your PayPal Manager Account, Click on Service Settings, and then Click on Configuration.  You will find the correct settings to set these to within your Miva Merchant admin section, at the screen where you edit the Payment settings for your Verisign Payflow Link module.

[View with PicLens]