For the LoRaWAN Network Server (Simple LNS) project, a database connection will be required in the future. As an intermediate step, there is another project called Packet Recorder, which records all LoRaWAN messages and assigns them to a network operator. This makes it possible to identify who operates a network in the area and how many devices are connected to it. The following article describes the compilation process on Linux and the creation of a static library from the MariaDB/MySQL Connector.

To edit and compile the source code in Visual Studio Code, the appropriate compiler must be available. It is recommended to start with the tutorial C++ Compiling and complete all steps before editing and compiling the code provided here. Visual Studio Code is also available for Linux, and the necessary support for CMake can be installed as a package on Linux. First, the source code of the MariaDB C Connector must be downloaded and extracted, for example, to C:/mariadb-connector-c.

Using a terminal, navigate to the extracted directory of the MariaDB C Connector, create a new folder named "Build," and then switch to this folder:

The following command is used to generate a static library for Linux from the source code:

cmake . -DWITH_SSL=OFF -DWITH_STATIC_LIB=ON -DWITH_DYNAMIC_LIB=OFF

If all files were successfully generated, you can proceed with the following command: make

If this step was also successfully completed, you can proceed with the following command: make install

By default, the previous command "make install" copies the MariaDB Connector files to the directory "/usr/local/". The project can be opened in Visual Studio Code. In the CMakeLists.txt file, the correct paths must be specified:

Compilation Process

The project can now be compiled. On Linux a ./packetrecorder file should be located in the Build folder of the opened project directory. For the Packet Recorder to work correctly, the config file containing the credentials for the MariaDB/MySQL database must be in the same directory. Further information can be found in this article: