Differences

This shows you the differences between two versions of the page.

--- tutorials:mairlistdb:mairlistdb-server [2014/09/26 12:54] – [Adding Users] tw
+++ tutorials:mairlistdb:mairlistdb-server [2015/02/25 09:05] – [Self-signed certificate with SSL Buddy] tw
@@ Line 1: / Line 1: @@
 ====== mAirListDB Server ======
-A networked mAirListDB set involves two types of servers:
+A networked mAirListDB setup involves two types of servers:
   * An SQL server (PostgreSQL, MSSQL) to hold the metadata for the audio files and scheduling information (library, playlists)
@@ Line 94: / Line 94: @@
 ===== 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:
@@ Line 107: / Line 107: @@
 ==== 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://www.atozed.com/intraweb/blog/20100413.EN.aspx]
+SSL Buddy is a Windows tool that lets you easily create self-signed certificates. You can download it here: http://www.atozed.com/intraweb/blog/20100413.EN.aspx
 After the installation, run SSL Buddy and follow these steps to create a certificate for your mAirListDB server. (See screenshots below for a visual walkthrough.)
@@ Line 115: / Line 115: @@
   - 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//.
+  - 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 (''domainname.cer'') and the key file (''domainname.key'') in the output directory you specified.
@@ Line 132: / Line 132: @@
 ====== 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 //Databases//.
+  - Click //Add//, then select //mAirListDB (Internet Client)//.
+  - In the dialog that appears, enter hostname, port, SSL or not, user and password.
+  - Click OK to save.
+{{ :tutorials:mairlistdb:pasted:20140926-150146.png }}
+Now you can run the mAirListDB app, or use the database connection from within the playout window.