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 12:50] – [Using HTTPS/SSL] tw | tutorials:mairlistdb:mairlistdb-server [2015/02/25 09:05] – [Self-signed certificate with SSL Buddy] tw | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== mAirListDB Server ====== | ====== mAirListDB Server ====== | ||
- | A networked mAirListDB | + | A networked mAirListDB |
* An SQL server (PostgreSQL, | * An SQL server (PostgreSQL, | ||
Line 73: | Line 73: | ||
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): | 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: | Then click //Add// to add a new user: | ||
- | {{ dbserver-users.png }} | ||
{{ dbserver-edituser.png }} | {{ 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 ===== | ===== 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. | + | 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: | mAirListDB Server needs a set of SSL certificate files to work: | ||
Line 89: | Line 102: | ||
- A root certificate (the certificate of the authority that issued our certificate) | - A root certificate (the certificate of the authority that issued our certificate) | ||
- | You can either obtain a " | + | You can either obtain a " |
- | + | ||
- | //The client side of mAirList does not verify the certificate chain currently, so a self-signed certificate will work fine as long as you only use mAirList on the client side.// | + | |
All certificates must be in PEM format. The file extension depends on the software that was used to create the certificate and key: '' | 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 ==== | ==== 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: [http:// | + | SSL Buddy is a Windows tool that lets you easily create self-signed certificates. You can download it here: http:// |
After the installation, | After the installation, | ||
Line 104: | Line 115: | ||
- Select 1024 or 2048 bit key size, and enter your e-mail address, then 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 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//. | + | - 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 ('' | - A message will appear saying that the certificate has been created. You will find the certificate ('' | ||
Line 121: | Line 132: | ||
====== Setting up the mAirListDB Client computer ====== | ====== Setting up the mAirListDB Client computer ====== | ||
+ | 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. |
tutorials/mairlistdb/mairlistdb-server.txt · Last modified: 2021/07/02 06:17 by ulinobbe