Online references

Thishttps://www.sqlserverversions.com/

chapter instructs

Helps you how to createdetect athe databaserelease storage that contains access control entities, e.g. a set of Organizations, Roles and Subjects (Users and Groups). This db storage can be referred by other storages, thus in effect providing access control to objects and functions in AVIX. 

We will, step by step, describe how a server is installed and configured to use a local h2 database. This db will be configured to contain two so-called repositories, "avix" and "admin". Repositories are basically containers of storages. 

We will make use of an AVIX5 application/client to perform someversion of the necessarySQL tasks.Server you have installed. Use the SQL Server SMS and connect to your SQL Server instance, and right-click to show the properties: 

 

SQL Server Configuration Manager

A tool you'll need to check ports etc. 

SQL Server Configuration Manager - SQL Server | Microsoft Learn

Basically, if you have SQL Server installed, but cannot find the configuration manager by searching the start menu, you'll have to access it as a so-called "MMC snap-in". Thus it might not be an installed application. 

All in all, on more modern Windows systems you'll find the the file in C:\Windows\SysWOW64\, as seen below. Just run it. 

 

 

INITIAL SERVER SETUP

INSTALL AVIX SERVER

Download the installation media, the server zip archive. If you don´t have a download URL, ask your contact at Solme AB to get one. The downloadable unit may be entitled "se.solme.avix.server.product-win32.win32.x86_64.zip" or similarly. 

Note March 14th 2023: Use "master" build #1073 or later!

Unzip the server zip file at the host where you intend to install it. 

Avoid white spaces in the path! 

The unzipped content will look like this:

Repositories.xml file

Make sure to create a file called "repositories.xml" in the root directory of the installation. The example content below uses embedded h2 db. (In a real deployment scenario, you will likely use a professional DBMS e.g. MS SQL Server, Postgres etc)

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<repositoryConfig>
	<!-- h2 repository example (self-hosted by the AVIX server) -->
	<repository name="avix" type="se.solme.avix.server.cdo.h2" databaseName="avix"/>
	<repository name="admin" type="se.solme.avix.server.cdo.h2" databaseName="admin"/>
</repositoryConfig>

START SERVER

In a production deployment scenario, you would install the AVIX5 server as a service at this point and start it. For testing purposes however, it works just as well to simply start the server application by running its executable.

CREATE ACCess control storage named "ac"

We will use the AVIX application (client) to create some db data.

 

INSTALL AVIX APPLICATION

The installation media may be called "se.solme.avix.application.rcp.product-win32.win32.x86_64.zip" or similarly. Unzip this on your computer. 

As with the server, make sure sure that it is a "master" build #1073 or later (writing this on March 14th 2023). 

CREATE the access control storage named "ac"

Start the AVIX application/client.  (Below, we are assuming that the server and application are running on the same Windows machine. Thus, "localhost" is used. It is also assumed that you have a license to run the AVIX software. )

Connect to the running AVIX5 server using "localhost:45500" and create your first storage. Accept the name "New storage", and open the storage.  

By default, new storages are using the “Local” access control principle. Change that to “Storage URL” , and click the “…” browse button: 

In the “admin” repo, create a new storage and name it “AC”. Finally click on “Open”:

Click “Apply”, and accept the suggestions in the “Disconnect from current system” dialog that appears.

Unfortunately, you now need to close the storage “New storage” and re-open it again. (This is due to caching mishaps, and will be fixed in forthcoming AVIX application versions).

While in "New storage", open the Security view (Help->Open Security). It will be empty, but you should be able to click on the create organization button. Do that, and make sure to set the password for the “Administrator” user. Remember this password, or enter it in your password manager of choice.

You can accept to generate the example system that is suggested. 

At this point, we will close down the AVIX storage, and also close down the AVIX application.

load_storages.xml file

Finally, make sure to create a file called "load_storages.xml" in the root directory of the installation. This file informs the server on startup, which storages that should be loaded. It should have the following contents to load the AC storage that was created in the prior step:

<?xml version="1.0" encoding="UTF-8"?>
<load_storage_config>
	<load_storage storage="dba:/localhost:45500/admin/AC" workspace="AC"/>
</load_storage_config>

You will need to restart the server for the load_storages.xml file to be processed.