Difference between revisions of "ACP with Mariadb"

Revision as of 15:57, 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

Configure the ACP Assets

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

@@ Line 1: / Line 1: @@
-Steps to setup the ACP databse for use with Mariadb
+'''''<font color=blue>Page is under construction</font>'''''
+Steps to setup the ACP database for use with Mariadb
 ===Install MariaDB server===
@@ Line 11: / Line 13: @@
 ===Setup HeidiSQL===
 ''Optional'' - Allows you to use a GUI, but all can be done with the command prompt. *Launch HeidiSQL
-*Click new session at bottom left
+(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
 **<code>Network type</code> '''<code>Mariadb or Mysql </code>'''(default)
 **<code>Library</code> '''<code>Libmaria.dll </code>'''(default)
@@ Line 20: / Line 23: @@
 **<code>port</code> '''<code>3306</code>'''
 **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 '''<code>Create New ></code>''' > '''<code>Database</code>''' > '''<code>suan_subscriptions</code>''' > Press '''<code>[OK]</code>'''
-*Install the MariaDB ODBC driver
+===Install the MariaDB ODBC connector===
+===Configure the ACP Assets===
 *Add the Suan assets models with Mariadb compatible MYSQL calls to the UI folder.