tutorials:mairlistdb:mairlistdb-server
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
tutorials:mairlistdb:mairlistdb-server [2014/09/26 10:04] – [Running mAirListDB Server for the first time] tw | tutorials:mairlistdb:mairlistdb-server [2016/08/23 07:41] – [Setting up the mAirListDB Client computer] tw | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== mAirListDB Server ====== | ====== mAirListDB Server ====== | ||
- | A networked mAirListDB | + | A networked mAirListDB |
* An SQL server (PostgreSQL, | * An SQL server (PostgreSQL, | ||
Line 69: | Line 69: | ||
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.) | 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.) | ||
+ | |||
+ | ===== Adding Users ===== | ||
+ | |||
+ | Before a client can connect to the server, you must add user to the account database. Go to the //Users// tab to see the current user list (should be empty at this point): | ||
+ | |||
+ | {{ dbserver-users.png }} | ||
+ | |||
+ | Then click //Add// to add a new user: | ||
+ | |||
+ | {{ dbserver-edituser.png }} | ||
+ | |||
+ | The user must have a name and a password. You can either type a password or have mAirList generate a random password for you. | ||
+ | |||
+ | The available //User Levels// correspond to the security roles used by mAirListDB: | ||
+ | |||
+ | * Read-only | ||
+ | * Studio (Read-only + write access to playlist history table) | ||
+ | * DJ (Studio + create/edit playlists) | ||
+ | * Folder Manager (DJ + move items between folders in Library) | ||
+ | * Manager (Folder Manager + full Library editing) | ||
+ | * Administrator (Manager + full configuration rights) | ||
+ | |||
+ | |||
+ | ===== Using HTTPS/SSL ===== | ||
+ | |||
+ | mAirListDB Server supports SSL encrypted connections over HTTPS. We recommend to enable the HTTPS server and only use encrypted connections when accessing the server from the Internet. The HTTPS server runs on a different port (default: 9840) than the unencrypted HTTP server. | ||
+ | |||
+ | mAirListDB Server needs a set of SSL certificate files to work: | ||
+ | |||
+ | - A certificate file (the public part of the certificate) | ||
+ | - A key file (the secret part of the certificate) | ||
+ | - A root certificate (the certificate of the authority that issued our certificate) | ||
+ | |||
+ | You can either obtain a " | ||
+ | |||
+ | All certificates must be in PEM format. The file extension depends on the software that was used to create the certificate and key: '' | ||
+ | ==== Self-signed certificate with SSL Buddy ==== | ||
+ | |||
+ | SSL Buddy is a Windows tool that lets you easily create self-signed certificates. You can download it here: < | ||
+ | |||
+ | Edit 2015-03-31: Original download link for SSL Buddy seems to be dead at the moment - here's an alternative link: http:// | ||
+ | |||
+ | After the installation, | ||
+ | |||
+ | - Run SSLBuddy, select //Generate and self-sign a certificate//, | ||
+ | - A wizard will appear, click //Next//. | ||
+ | - Select 1024 or 2048 bit key size, and enter your e-mail address, then click //Next//. | ||
+ | - Enter you country, state and city, then click //Next//. | ||
+ | - Enter the domain name - **this should match the public IP or FQDN hostname under which the clients will access the server later**. Also enter your business name (or your personal name) and the directory in which the key and certificate should be saved. Then click //Next//. | ||
+ | - A message will appear saying that the certificate has been created. You will find the certificate ('' | ||
+ | |||
+ | <WRAP center> | ||
+ | {{sslbuddy1.png? | ||
+ | {{sslbuddy2.png? | ||
+ | {{sslbuddy3.png? | ||
+ | {{sslbuddy4.png? | ||
+ | {{sslbuddy5.png? | ||
+ | {{sslbuddy6.png? | ||
+ | </ | ||
+ | |||
+ | You can now enter the certificate and key file in the mAirListDB Server configuration. **Note: As this is a self-signed certificate, | ||
+ | |||
+ | {{ dbserver-ssl.png }} | ||
====== Setting up the mAirListDB Client computer ====== | ====== Setting up the mAirListDB Client computer ====== | ||
+ | ===== Connection setup ===== | ||
+ | |||
+ | |||
+ | On the client computer, follow these steps to add a connection to the mAirListDB Server: | ||
+ | |||
+ | - Open mAirList Configuration. | ||
+ | - Go to // | ||
+ | - Click //Add//, then select // | ||
+ | - In the dialog that appears, enter hostname, port, SSL or not, user and password. | ||
+ | - Click OK to save. | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | Now you can run the mAirListDB app, or use the database connection from within the playout window. | ||
+ | |||
+ | ===== Audio file caching (optional) ===== | ||
+ | |||
+ | Sometimes it's a good idea to keep a synchronized copy of all of your audio files on the client computer, especially when broadcasting from a location with a slow internet connection. | ||
+ | |||
+ | If you have such a synchronized copy of any audio storage folder, you can go to the // | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | Now when mAirList needs an audio file for playback, it will first check if it's in the cache folder, and only if it's not, the file will be transferred via HTTP. This will save a lot of bandwith. |
tutorials/mairlistdb/mairlistdb-server.txt · Last modified: 2021/07/02 06:17 by ulinobbe