Knowledgebase: Miva Empresa VM
How to connect Miva Merchant to a MySQL database?
Posted by - NA -, Last modified by Wayne Smith on 02 September 2009 08:10 AM
Title :
----------
MySQL: Database Library


Symptom :
----------
What do i need to have my Miva Merchant software connect to a MySQL database?
Does Miva provide the source and compiled versions of their libraries


DIAGNOSTIC :
------------------

MySQL is available for use with Miva Merchant software with Miva VM 5.00 or higher

You will need to have the MySQL library installed and configured in the
Miva VM configuration to use the MySQL database with Miva Merchant Software

Yes Miva does provide the source and compiled versions of their libraries

Use the Miva Diagnostic Application 5 to determine if the MySQL library is installed
and configured on the server 'Installed Database Libraries' if 'MySQL' shows up in green
it is installed and configured correctly

Solution :
----------

1 Aquire the library
2 Install the library (reinstalling will not corrupt the Miva VM)
3 Configure the library

Windows
1 You can aquire the library from the Miva ftp software site, contact Miva support for connect information
2 IIS >> wesite properties >> Miva VM TAB >> Click Libraries >> Ensure there is a Type 'Database' with Method 'MySQL' and a path to 'mvdmysql.dll'
3 If the entry is not found Click add and browse to the 'mvdmysql.dll' you aquired from the Miva ftp account

UNIX/Linux
1 You can acquire the library from the Miva ftp software site, contact Miva support for connect information
2 Miva VM Global (Server Safe):
use the diag tool to determine the location of the MivaSQL library and put it there
ex (s.mvconfig_database_mivasql: /mivavm-v5.03/lib/databases/mivasql.so)

2 Miva VM Private (Standard):
use the diag tool to determine the location of the MivaSQL library and put it there
ex (s.mvconfig_database_mivasql: /mivavm-v5.03/lib/databases/mivasql.so)

3 Miva VM Global (Server Safe):
add the directives to the httpd.conf
ex (SetEnv MvCONFIG_DATABASE_mysql /mivavm-v5.03/lib/databases/mysql.so)

3 Miva VM Private (Standard):
use the diag tool to determine the location of the MivaSQL library and put it there
ex ()

At this point you have the library
Installed
Configured

If this was a Miva VM Global (Server Safe) or Windows Miva VM Install reboot the web server

ex: httpd restart or iis restart respectively
(595 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below. This is required to prevent automated registrations and form submissions.

Help Desk Software by Kayako support.miva.com/supportsuite/index.php?