User Tools

Site Tools


tutorials:mairlistdb:mairlistdb-server

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
tutorials:mairlistdb:mairlistdb-server [2014/09/26 12:55] – [Using HTTPS/SSL] twtutorials:mairlistdb:mairlistdb-server [2015/03/31 09:10] – [Self-signed certificate with SSL Buddy] tw
Line 1: Line 1:
 ====== mAirListDB Server ====== ====== 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)   * An SQL server (PostgreSQL, MSSQL) to hold the metadata for the audio files and scheduling information (library, playlists)
Line 107: Line 107:
 ==== 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://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: <del>http://www.atozed.com/intraweb/blog/20100413.EN.aspx</del> 
 + 
 +Edit 2015-03-31: Original download link for SSL Buddy seems to be dead at the moment - here's an alternative link: http://download.mairlist.com/other/sslbuddysetup.exe
  
 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.) 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 117:
   - 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 (''domainname.cer'') and the key file (''domainname.key'') in the output directory you specified.   - 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 134:
 ====== 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 //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.
tutorials/mairlistdb/mairlistdb-server.txt · Last modified: 2021/07/02 06:17 by ulinobbe

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki