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 | |
|
Comments (0)