Quick start guide for MSSQL | for DLMS smart meters

By Administrator, 5 April, 2024

Join the Gurux Community or follow @Gurux for project updates.

Gurux.DLMS.AMI is a part of Gurux Device Framework. For more info check out Gurux.

This document shows how you can easily start using Gurux.DLMS.AMI with MSSQL database.

In this example, the Microsoft SQL docker is used as Gurux.DLMS.AMI database. The following values are used

The database super admin password
YOUR_MSSQL_SA_PASSWORD_1
Gurux DLMS AMI database name.
YOUR_GURUX_AMI_DB
Gurux DLMS AMI database user name.
YOUR_GURUX_AMI_DB_USER_NAME
Gurux DLMS AMI database password.
YOUR_GURUX_AMI_DB_USER_PASSWORD_2
Your localhost IP address.
YOUR_IP_ADDRESS

Start MSSQL docker

You can start MSSQL database docker by running:

docker run --name=guruxamidb --env=MSSQL_SA_PASSWORD=YOUR_MSSQL_SA_PASSWORD_1 --env=MSSQL_PID=Evaluation --env=ACCEPT_EULA=Y -p 1433:1433 -d mcr.microsoft.com/mssql/server:2022-preview-ubuntu-22.04

Create database user

Open a terminal connection to the docker and start SQL client.

/opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P YOUR_MSSQL_SA_PASSWORD_1

Create the database:

CREATE DATABASE YOUR_GURUX_AMI_DB
GO

Then create your own user for Gurux.DLMS.AMI.

CREATE LOGIN YOUR_GURUX_AMI_DB_USER_NAME WITH PASSWORD = 'YOUR_GURUX_AMI_DB_USER_PASSWORD_1'
GO

Then user permissions to create tables for Gurux.DLMS.AMI.

USE YOUR_GURUX_AMI_DB;
CREATE USER YOUR_GURUX_AMI_DB_USER_NAME FOR LOGIN YOUR_GURUX_AMI_DB_USER_NAME
GO
GRANT CREATE TABLE, ALTER, INSERT, UPDATE, DELETE, SELECT, REFERENCES TO YOUR_GURUX_AMI_DB_USER_NAME
GO

Start GuruxAMI

Before starting the Gurux.DLMS.AMI docker you need your computer IP address. localhost doesn't work. You can get your localhost IP address by running 'ipconfig' in your command line interface. Do not run ipconfig on the docker.

ipconfig

Replace YOUR_DB_IP_ADDRESS with your IP address. Start Gurux DLMS AMI docker by running:

docker run --rm -it -e "Database:Type=MSSQL" -e "Database:Settings=Server=YOUR_DB_IP_ADDRESS;Database=YOUR_GURUX_AMI_DB;User ID=YOUR_GURUX_AMI_DB_USER_NAME;Password=YOUR_GURUX_AMI_DB_USER_PASSWORD_1;TrustServerCertificate=True" -e "IdentityServer:Key:Type=Development" -p 8000:80 -p 8001:443 -e ASPNETCORE_URLS="https://+;http://+" -e ASPNETCORE_HTTPS_PORT=8001 -e ASPNETCORE_ENVIRONMENT=Development -e ASPNETCORE_Kestrel__Certificates__Default__Password="YOUR_CREDENTIAL_PASSWORD" -e ASPNETCORE_Kestrel__Certificates__Default__Path=/https/Gurux.DLMS.AMI.Server.pfx -v %USERPROFILE%\.aspnet\https:/https/ guruxorg/guruxdlmsamiserver:latest

You can see traces in your command prompt. If you want to run Gurux.DLMS.AMI as a service add -d -argument. Now you can test that Gurux.DLMS.AMI is up and running starting browser:

https://localhost:8001/