ACP with Mariadb

Page is under construction, but should be complete enough to use for dev environment.

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.

user: For now I have left the user as root because it is fewer steps and this is not yet for production.

• 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

Add a new 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

Continue with the setup

If you are setting up a production server, return to Ana:Suan/Steps_to_set_up_a_production_server#SSL certificate and continue the setup. For a development server you may be able to continue.

Configure the ACP Assets

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

Add tables to the databse

Edit the DB driver info.ana library

• In the library "*\ui\assets\DB driver info.ana"
  • Ensure MariaDB 3.1 is selected in the pulldown menu for the Database driver
• Enter 'suan_subscriptions' in the Database text input
• Enter your username ('root' for now) in the myusername text input
• Enter the password for the user 'root' in the mypassword text input
• Save the library with the new settings -Select File form the top menu and click save.

Create and populate the tables

• Open the model file "*\acp\ui\assets\Create Suan DB.ana"
• Press the "Create the Tables" button
• Press the "Populate the Tables" button

Expected: No errors - there will not be a message if the tables are successfully populated.

• Check the database
  • Using Heid SQL, select the suan_subscriptions database and insure the tables are present. You may need to right click and select refresh to see the tables. Select a table and click the data tab to ensure the table is populated with the correct schema and initial data. if the data tab is not present you can double a click a table to ensure it shows the first time.

Return to the setup page

You can return to the instructions for setting up a dev environment or production environment and use the database, as long as the assets are the mariadb assets.