Database issue?

This will be quite a long explenation, but I been testing this in a different kind of ways when came to this issue. With this long explenation I just want to give you a clear impression about the issue and all the things I have noticed, so you have a good view of what is happening.

Last few days I have been testing the v7 software from my laptop and today I decided to instal the version 7 on the studio pc for the first time. Since I am not near my studio, I did everything on remote wich is working well.

On the pc in the studio where version 6.3 is running, I today installed version 7 (snapshot 5007).
As my version 6.3 is a professional license, I also use the professional trial license at the version 7 software.
In Postgresql I have created a new database for version 7 and I imported a backup of the database from version 6 into it. This was done quite easy.
When setting up the database connection in the configuration software of mAirlist version 7, everything works;
test sql connection = working
database login = working (using admin/admin)
When I checked the database app version 7 I am able use the new database without any issue, all tracks are shown, all playlists are present.

After this I did setup the DBserver so I am able to use my laptop on remote for editing the database. This connection is now up and running without any problem, the connection is stable and I am able to use the database. Even the songs are items are sended over the internet to my laptop so I can listen to them.

After having the database installed on the pc in my studio and the connection made to my laptop by internet using the DBServer , I started the mAirlist software on the pc in my studio for the first time.
In this software something strange is happening.

When starting the software I get this error;
5007 Mairlist Database ID errors

It’s strange since I only get this message when starting the mAirlist software. I don’t get this message when starting the Database nor the DBserver app.

After pressing continue on the error popup, the playlists, cartwall are loaded as planned. The software starts the automation and everything seem fine.
Except the browser! In the browser, the fold down tree isn’t visible, nor will the search tab give any result when searching an item. The playlists are visible in the browser tough. So it seem that the database is connected, but the database and database search tabs aren’t connected to the database.



It’s strange that the playlist is found, but the database isn’t visible. The tracks are added in the playlists and playing without any problem. especially when knowing that the Database app and the DBServer connection is working without any problems.

You have any idea what can cause this problem? and also I wonder how to solve this :wink:
This issue is tested with dark and light skin.

The “Database ID” is a unique ID (GUID) that is generated when you initially create the database. It is stored in the config table of the SQL database, and also in the configuration (database.ini) - it is displayed on the Settings tab of the database connection properties.

The purpose of the ID is to help mAirList telling the databases apart, in case you have more than one database connection registered.

When you start mAirList, it checks whether the ID noted in the configuration matches the one from the SQL tables, and refused to connect if they don’t.

Usually you would get into this situation when you recreate your database and reuse/clone an existing entry in the configuration, adjusting it to point to the new SQL database (or mldb file, or DBServer URL).

In this case, you should go to the Settings tab and clear the value from the Database ID field, then click OK - mAirList will inform you that the Database ID is still unknown, and will prompt you to retrieve and set it in the configuration.

Thx for your fast reply Torben.

Since retrieving the DatabaseID, everything works well.
Had to create new SSL keys for the DBserver, but that works again.

Problem solved.