Difference between revisions of "ACP with Mariadb"
Line 28: Line 28:
  
 
===Install the MariaDB ODBC connector===
 
===Install the MariaDB ODBC connector===
 +
*Download the [https://mariadb.com/download-confirmation/?group-name=Data%20Access&release-notes-uri=https%3A%2F%2Fmariadb.com%2Fkb%2Fen%2Fmariadb-connector-c-3-4-3-release-notes%2F&documentation-uri=https%3A%2F%2Fmariadb.com%2Fkb%2Fen%2Fabout-mariadb-connector-c%2F&download-uri=https%3A%2F%2Fdlm.mariadb.com%2F3964760%2FConnectors%2Fc%2Fconnector-c-3.4.3%2Fmariadb-connector-c-3.4.3-win64.msi&product-name=C%20connector&download-size=16.15%20MB MariaDB ODBC 3.1 connector] (still using 3.1 for now since know it works).
 +
*Launch the msi file and install with complete options
 +
 
===Configure the ACP Assets===
 
===Configure the ACP Assets===
 
*Add the Suan assets models with Mariadb compatible MYSQL calls to the UI folder.
 
*Add the Suan assets models with Mariadb compatible MYSQL calls to the UI folder.

Revision as of 16:38, 9 January 2025

Page is under construction

Steps to setup the ACP database for use with Mariadb

Install MariaDB server

  • download Mariadb 10.6.2 (Current tested version).
  • Launch the installer - accept defaults including Heidisql
  • Set a new root password when prompted
  • Check allow remote access for root for now.
  • Install as service - service name Mariadb
  • Enable networking - port 3306
  • Finish installing with defaults

Setup HeidiSQL

Optional - Allows you to use a GUI, but all can be done with the command prompt. *Launch HeidiSQL (You need to start a session too create a database)

  • Click new session at bottom left - then you can leave all as default for now
    • Network type Mariadb or Mysql (default)
    • Library Libmaria.dll (default)
    • Hostname / IP 127.0.0.1 (default)
    • leave unchecked prompt for credentials and Windows authentication (default)
    • User: root
    • Password - enter the password for root
    • port 3306
    • leave the rest default and click [Open]

Expected: New session starts - there are no user databases yet

Create database

  • In HeidiSQL right click on the session name (Unnamed unless you named it) > Select Create New > > Database > suan_subscriptions > Press [OK]

Install the MariaDB ODBC connector

  • Download the MariaDB ODBC 3.1 connector (still using 3.1 for now since know it works).
  • Launch the msi file and install with complete options

Configure the ACP Assets

  • Add the Suan assets models with Mariadb compatible MYSQL calls to the UI folder.
Comments


You are not allowed to post comments.