Want to migrate mairlist db to new pc

[Alanqfm]

I’ve cloned the database. But when i try to import it to the new pc there is only showing some specific .mldb files. The cloned file cannot open. I will look into the new FAQ and will back to you.
Thank you for the support.

[Stefan_Hillen]

@Alanqfm

But when i try to import it to the new pc

Wait, what?

You don’t need to import any dB files if you followed the instructions here:

@Stefan_Hillen

The thread you quoted above is more than eleven (11!) years old and was recent for v4.

Please use this instruction:

Ok, so you want to migrate your existing (local mode) mAirListDB to a MySQL backend, right? This is what “Clone database” in the DB App (Database → Export → Clone Database) is made for. Works for any SQL type (networked or local mode) for source and target. These are the steps to perform: Create user and empty SQL database in your MySQL server. Do not add the connection to the mAirList configuration at this time! In particular, do not perform the initial setup (create tables) in the config!…

Then you need to copy all your music files / elements in the exact same folder hierarchy similar to the old PC.

Please follow the instructions linked above step by step - it’s no magic

And I really suggest to update to the latest v6.3.24. Or are there any reasons you can’t?

[Alanqfm]

2. Open the DB app (of the existing local mode app) and go to Database → Export → Clone database. Select MySQL as the target type, and enter IP/user/password/database as required. Cloning will copy the tables row by row, so it might take a long time. You can choose to transfer only part of the playlist history to speed up the process.

Here, which IP/User/password/database I should have to give? the new PC IP or Old one? Can u type here an EXAMPLE??? Please??

[Alanqfm]

I tried the database backup steps and nownshoung this error.

Is there any solution? Or Can i give you my pc in remote, so that you can help me.

[Alanqfm]

After tried a lot now i am in this position.

[Liam]

PostgreSQL 13+: "[FireDAC][Phys][PG][libpq] authentication method 10 not supported." error

Here is infomation for all users that intend to use mAirList with version 13 and later of the PostgreSQL server: PostgreSQL 13 (and later) uses the new scram-sha-256 password encryption by default, something that is not supported by the libpq.dll client library shipped with mAirList by the time of this writing (v6.3.6). Thus, you will see the following error: [FireDAC][Phys][PG][libpq] authentication method 10 not supported. We are going to ship an updated libpq.dll in the near future. Until…

[Alanqfm]

I did these steps. And I can connect thr db to thr playout software from the same pc that i installed the db app. But my onair pc is in another studio and I can’t login there. When i try to connect the db there it shows the same error. Please look at this image carefully.

When i trying to add the db on a second pc with the same credentials it shows error

[Torben]

For mAirList 6 and PostgreSQL 12+,. you have to install the newer libpq.dll and support libraries from here: https://download.mairlist.com/other/libpq10.zip

Just copy the contents into the mAirList program directory, replacing the existing files.

mAirList 7 already ships the newer versions.

[Alanqfm]

Hi, I have already downloaded and copied these files. The only problem now having is , I cant connect the db to another pc having the mairlist professional studio software.

[Alanqfm]

Any thing to do here???

[Stefan_Hillen]

@Alanqfm

I cant connect the db to another pc having the mairlist professional studio software.

Add the second line in the pg_hba-file with the IP of the remote PC like in the example.

# IPv4 local connections:
host    all             all             127.0.0.1/32            scram-sha-256
host    all             all             xxx.xx.xx.xx/32        scram-sha-256

[Alanqfm]

Thank you @Stefan_Hillen ! It has connected. But I tried to login the database to the mairlist professional studio, all went good. Logged in. But it showing “ the files can’t open”. If this can solved I can connect the db to the onair. Hope you will guide me.

[Liam]

@Alanqfm

But it showing “ the files can’t open”

Do you really have all the music/jingle files in the folder that is in your database?

Open database -> Administration -> Configuration... -> Storage locations

[Alanqfm]

Yes. Everything placed in order. But showing the error. But in another pc its okay. But in Onair pc i have to connect it originally, it showing error.

[Stefan_Hillen]

@Alanqfm

But in Onair pc i have to connect it originally, it showing error.

Hi,

I think you’re following the wrong path here.

Could you please describe what you try to achieve because it went from “cloning a database to use mAirList on a new computer” to “I want to connect a second PC to the database” now.

For just connecting the other mAirList PC to your Server PC there is a much better and easier way, where the connected remote PC will temporarily download and then play local elements / songs from the server PC.

This

@Liam

Do you really have all the music/jingle files in the folder that is in your database?

Open database -> Administration -> Configuration... -> Storage locations

will not work when you are directly connected via “networked, PostgreSQL backend” from another machine because the remote PC will look for the files on its own local drives.

As long as you have no exact copy of your files and structure on remote PCs or all your files are stored on a network drive with the same Letter and Path for all remote PC it will not work this way.

And, pardon me to ask again, but why are using v6.0.4? The update to the much improved 6.3.24 is free of charge.

[Alanqfm]

Thank you for your valuable advices. Let me Explain.

I am working in a commercial FM radio station. Already we are running the DB app in PC 1 , the studio (playout ) software in the ONAIR Studio PC 2.

Now we planned to upgrade the PC 1 and build a PC with more storage, RAM, SSD drives and all. That is PC 3.I have copied all the files in the exact folder structure from PC 1 to PC 3. And the SQL things and connections are done as you all helped me with that topics. Now before change the license and connect to onair studio i just want to run a demo in another PC. I want to test if it will run without a problem. So i tried to connect DB from PC3 to PC 4 and it gone wrong. Its showing files can’t open.

[Stefan_Hillen]

@Alanqfm

So i tried to connect DB from PC3 to PC 4 and it gone wrong. Its showing files can’t open.

Hi Alan,

I think the errors are caused by some fundamental misunderstanding how the database connection between mAirList-setups works.

@Stefan_Hillen

As long as you have no exact copy of your files and structure on remote PCs or all your files are stored on a network drive with the same Letter and Path for all remote PC it will not work this way.

Let me explain:

When you’ve connected a Remote PC via the IP address to gain direct access to the PostgreSQL-Database the remote PC will look for the files/elements in the local path the element is linked to in the database entry.

So if your element/file on the Studio PC with the Server is stored in

D:\Music\Billy Joel\leningrad.mp3

your Remote PC also will look for this file in its local path

D:\Music\Billy Joel\leningrad.mp3

but will not find it there because it’s only stored locally only on the Studio PC with the server.

As long as you have no exact local copy of all of your files on a remote PC OR stored them on a network drive, where the server and every client gains access through the same letter and path it WILL NOT WORK.

But there’s a clever and…

Easy Solution: The mAirListDB Server

mAirListDB Server is built into mAirList.exe but runs as a standalone process. It creates a HTTP/HTTPS server (on one or two TCP ports) that listens for incoming requests from clients.

It will send the needed elements/files temporarily from the Studio Computer/Server to the Remote PC for editing/PFL or to be used in the playout of the second machine.

Every time a Client need a file to play it will access the elements through the server db so you don’t need to have a local copy on a remote installation.

Important Note 1:

Only the “Advanced Server” or “Studio Professional” edition has this feature enabled through the license but every edition can connect to the host.

Important Note 2:

The client computer must have a compatible copy of mAirList installed, and set up a “mAirListDB (Internet Client)” connection accordingly. Thereafter, the client user can run the mAirListDB application to connect to the mAirListDB server and work with the database as usual.

Important Note 3:

A couple of things are not available when connecting through mAirListDB Server:

• Storage synchronization (needs direct access to the storage network share)

• Database cloning (needs direct access to the SQL server)

How-to set up the connection

1. Setting up the host on the studio PC

You will find the Database Server app in the mAirList group in the Windows Start Menu. Alternatively, if you’re running the Zip distribution of mAirList, you can start mAirListDB Server using the batch file DBServer.bat inside the program folder.

When you run the application, the main window will appear:

Before you enable the server, you should check the TCP ports that are used for HTTP and HTTPS. The default ports are 8840 (HTTP) and 9840 (HTTPS).

It may be necessary to open these ports in your firewall before client computers can access them. (If you use the Windows built-in firewall, you will be prompted to grant access when you click Enable server for the first time.)

2. Setting up the mAirListDB Client computer

On the client (remote!) computer, follow these steps to add a connection to the mAirListDB Server:

1. Open mAirList Configuration.

2. Go to Databases.

3. Click Add, then select mAirListDB (Internet Client).

4. In the dialog that appears, enter hostname (= IP adress of the studio PC), port, user and password.

Note: In more recent versions of mAirList, a randomized one-time token is used for authentication to the server. In order to generate the token, click Sign In, enter user name and password, and a token will be requested from the server and entered into the input field.

5. Click OK to save.

Now you have access to all files/elements stored locally on the server PC.

Please test it and report back if this solved your connection problems.

[Alanqfm]

Hi @Stefan_Hillen , Thank you for your advice. I did these steps, and upto setting up the db server all went good. But when i connect it as internet client to the playout pc, it is error again. And can’t access the files. We have already another onair running. There , from the db pc, the playout pc is connected as Networked, PostgreSQL backend. And it is working perfectly. In the new case the DB PC and and setups are oky. But the playout pc still Error. I will upload the pic

[Stefan_Hillen]

Please take a look in the Audio Routing.of the configuration and check if the players are routed correctly to a working/available soundcard (=device)

Did you update tob“ the latest and improved 6.3 now?

[Alanqfm]

Yes updated and audio devices also checked. But nothing happened. The remote pc is not reading the “elements/files” from the database pc.

Any other solutions???
Thank you for the support.