I have this issue when I have created a database in postgreSQL and want to connect from mairlist 7. According to wiki I should select mAirListDB (networked, PostgreSQL backend, but that option is not available in my mAirList 7 Advanced Server version.
I can select Internet client instead, but then the options are different from the wiki, and I cannot find a way to avoid the Socket Error - # 10061 connection refused.
See attached screenshots.
Any support for how to connect to the Postgre SQL database are appreciated.
Thank you Stefan. I can see that. I just didnāt thought about Advanced server wasnāt able to do server stuff. What the heck!
Iām having trouble getting the normal DBserver working stable, thatās why I tried SQL. A friend of mine said, that DBserver isnāt good for multi clients. At the moment I canāt connect from the client computer and I have the Advanced Home version. First I had the wrong IP adress for the radio, so when I changed that to the correct one, it worked for a few days, then it wonāt connect again, socket error 10060. I double checked the IP adress at the radio, and it didnāt change. Canāt figure it out.
I hope someone can help me out. Thanks!
I didnāt do anything in the firewall, just in the router (8840, 9840)
So you meen I should do rules in firewall both incoming and outgoing?
BTW. Is it true, that DBServer can be reason to crashes?
Whatās your setup? Advanced Server on a hosted windows Server with a local dB and youāre trying to connect from another mAirlist Instance to this database?
Iām not sure what the term āhosted windows serverā meens, but we installed the advanced server at the radio station on a regular computer (windows 10 pro). The music files is on a synology diskstation in that particular LAN. We enabled the DBserver.
I installed the advanced home version at my home computer (windows 10 pro) and connected to the server, so I could put info into the files and get the system up and running with playlists etc. in my spare time. We are all volunteers, so the radio donāt make money yet.
states that mAirlist couldnāt even find the server application. So letās try two things.
First: Are you shure the dBServer-App is still running on the server (and āactiveā)? Some users accidentally close it instead of just minimizing it. Just asking because you said it worked some days beforeā¦
Second: On the āServerā Windows you should open the ports 8840 (for http) and/or 9840 if youāre doing https. Incoming and outgoing because the dbServer needs them to communicate with the internet client(s) on other PCs like yours.
Even if it worked at the beginning: Windows may decline communication after some time if they arenāt set properly. Iāve been there too
Oh, and it should be clear that mAirlist needs permission to send and receive dara through the firewall of your home PC tooā¦
Please give it a try and report back if it workedā¦
This is not a problem of the mAirListDB Server. Itās related to the database.
The mAirList Advanced Server edition contains a local database (SQLite). This is absolutely okay for a single-user-environment or when not too many users want to have access to this database at the same time.
In a classical multi-user-environment, and your radio station looks like this, this might be too much for the local database. A networked database like PostgreSQL or from the software of your Synology is the best.
For this, you need mAirList Professional Studio. This is available with a home user discount, too, if you still meet the corresponding requirements.
I have asked you to contact mAirList sales to ask for it, but I havenāt seen a mail from you to date.
What I want to tell you with it: The problem has nothing to do with the mAirListDB Server. It works perfect in each situation. But you canāt blame this tool if the database behind this tool is not powerful enough for the number of accesses.
So I think this might cause a part of the problems and, with all respect to your friend, his thought seems to be wrong.
Thanks for all your help so far. At the moment I have opened port 8840, 9840 in my home router as well as in my windows firewall incoming and outgoing (also at the radio). I even tried to reinstall mairlist and made a new connection to the database, but same result.
Hi Uli
At the moment Iām the only client to the database, so I think I will wait to Pro upgrade.
I have to get this dbserver to work first. We havenāt begun to use the system yet, because it doesnāt work. I dont think the manager is going to upgrade as long as it doesnāt work with dbserver.