Difference between revisions of "ACP with Mariadb"

Revision as of 16:52, 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 typical option

Configure the ACP Assets

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

@@ Line 28: / Line 28: @@
 ===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).
+*Download the [https://mariadb.com/download-confirmation?group-name=Data%20Access&release-notes-uri=https%3A%2F%2Fmariadb.com%2Fkb%2Fen%2Fmariadb-connector-odbc-3-1-20-release-notes%2F&documentation-uri=https%3A%2F%2Fmariadb.com%2Fkb%2Fen%2Fmariadb-connector-odbc%2F&download-uri=https%3A%2F%2Fdlm.mariadb.com%2F3680382%2FConnectors%2Fodbc%2Fconnector-odbc-3.1.20%2Fmariadb-connector-odbc-3.1.20-win64.msi&product-name=ODBC%20connector&download-size=6.23%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
+*Launch the msi file and install with typical option
 ===Configure the ACP Assets===
 *Add the Suan assets models with Mariadb compatible MYSQL calls to the UI folder.