Sermons on the Web Instructions

Site map:

Evaluation

To understand Sermons on the Web from the point of view of someone browsing your church's web site, browse one of the live sites.

To evaluate sermon publication check the system requirements above and install Sermons on the Web. After installation, run Sermons on the Web Publisher, click Browse, and select an audio file with a .wav or .mp3 extension. If you don't have an audio file handy, there are several in C:\Windows\Media. If you create a file named something like 2007-11-10 AM Anderson - Just Looking.wav, you can see how Sermons on the Web automatically populates fields based on the file name.

Next click Publish. For the demo, the FTP upload step is skipped, but the other publication actions proceed as they would on an actual deployment. After publication, you can see your sermon on the online demo. From there you can also browse the administration web pages, which sound workers will use occasionally.

Installation

Sermons on the Web is designed to work with any web hosting provider that supports PHP and MySQL. Since configuration interfaces differ between providers, the exact steps to install Sermons on the Web will vary. The following table lists each step in general terms in the left column. The right column contains the details of the deployment to Brookside Baptist Church (the first site to go online with Sermons on the Web) to serve as an example. Fortunately, many of the details may be applicable since the example uses hosting tools that are common in the industry.

StepDeployment example
1. Obtain a PC to record and upload the sermons, and connect it to your audio mixer. Almost any modern PC will do; a 1 GHz or faster processor is recommended. Run a cable from an output of your mixer into the line-in on your computer; most computer motherboards are designed well enough that a separate audio card is not required.
2. Install audio recording and editing software. Install Audacity. Sermons on the Web doesn't use the editing software, but you will need it to create the .wav files.
3. Download and install Sermons on the Web.

4. Obtain a web hosting account that supports PHP and MySQL (if you don't already have one). A web hosting account is space you rent on a computer that serves your web site 24/7/365.

Select an account with enough storage to hold your sermons. Each hour of sermons uses approximately 10 MB.

 This example is based on a Midwest Websites PHP MySQL web hosting account. 1 GB of storage is enough for two half-hour sermons per week, with lots of room to spare for anything additional.
5. Configure your sermons web site.
  1. Extract ChurchWebSite.zip.
  2. Fill in Sermons\Config.php with info about your database and church.
  3. Integrate Sermons on the Web into your web site:
    • If you are using the Sermons on the Web starter web site, fill in the placeholders in the top-level index.html. Optionally, customize index.html and index.php for your site.
    • If you already have a web site and will be using Sermons on the Web as is, add a link on your web site to Sermons/. Optionally, customize index.php for your site.
    • For tighter integration, modify your existing site to call the functions in Views.php. In this method of integration, the files index.php and Main.css in the Sermons folder aren't used to display Sermons, but rather serve as examples. Within Main.css, use the "Sermons web part" section as a template for defining your styles.
    • To create a page dedicated to a single service type such as a Sunday school, see the filtering example.
 Extract C:\Program Files\Sermons on the Web\ChurchWebSite.zip into a new folder in your Documents folder. (On 64-bit versions of Windows, the installation is in C:\Program Files (x86).) Open Sermons\Config.php in Notepad and fill in the required configuration variables. Then, if using the starter web site, open index.html in Notepad and replace the placeholders with information about your church.
6. Create a database, and initialize its structure using SermonDatabaseSchema.sql.
  1. From cPanel, click MySQL Databases.
  2. From the Create New Database section of the MySQL Account Maintenance page, in the Db field, enter sermons, and click Create Database. (Note that the actual database name may have the beginning of your hosting account name prepended, e.g. mychurch_sermons.)
  3. From the Add New User section, enter the username sermons and your web hosting account password, and click Add User. (Like the database name, the user name created may be prepended with your hosting account name.)
  4. From the Add User To Database section, select the username from the drop down box, select the database name from the other drop down box, and click Submit.
  5. Grant the select, insert, update, and delete privileges to the user.
  6. From cPanel, click phpMyAdmin.
  7. Select the sermons database, and click Import. Click Browse, and from the extracted web site files, select Sermons\Admin\SermonDatabaseSchema.sql. Click Go.
7. Upload the web application. From the extracted web site files, copy the Sermons folder to the public_html folder on your web site. You can do this with an FTP program such as FileZilla. If you are using the starter web site, also copy index.html.
8. Set security on the Admin folder.
  1. From cPanel, click Password Protect Directories.
  2. Navigate to the Admin directory. (Click the folder next to the word Sermons; then click Admin.)
  3. Check the box to enable protection, enter the resource name Sermons on the Web Administration, and click Save.
  4. Add an authorized user with the same username and password of your web hosting account.
9. Configure the Publisher.

On your PC, run Sermons on the Web Publisher. Click Tools, then Options, and set the options in the Organization, Web site, and any other desired categories.

Optionally, from the Windows Control Panel Power Options, set the computer to enter the sleeping power state after a period of inactivity. The period need not be long, since Windows considers the computer active when recording or publishing a sermon.

10. Populate the database with your service types, speakers, and series.

In the Publisher click Sermon administration. Review the services types, and modify/add to suit your needs. Add your known speakers and series. You can further modify these lists at any time.

When you are done, back in the Publisher, click Tools, then Refresh field value lists.

Security

By default, the Sermons on the Web Publisher options folder and data folders can be read and modified by all users. You should limit who has access to the computer or set appropriate permissions on the folders. The options folder is C:\ProgramData\Sermons on the Web (or on Windows XP and earlier, C:\Documents and Settings\All Users\Application Data\Sermons on the Web). The options folder contains the web site administration password, which although encrypted in version 1.3.2 and later, could still be technically decrypted by any user with access to the folder. The data folders are specified in the Publisher options.

A common protocol for uploading files (such as sermon MP3 files) is FTP. However, FTP does not encrypt passwords or file data during transmission. For most churches, the chance of interception and potential harm are low enough for this to not be a concern, but if it is, you'll want to use a secure transport such as HTTPS.

Troubleshooting

In case of difficulty, following are some tests you can perform to help identify the problem:

Everyday use

Once you have Sermons on the Web deployed, follow these steps to publish a sermon:

  1. Use your recording and editing software to record the sermon.
  2. Save the sermon with a name that follows this pattern: 2007-08-20 AM LastName - Title of the Sermon.wav. Actually, you can use any file name, but this pattern allows Sermons on the Web to recognize information about the sermon and makes it easier for you to sort your sermons. If you have multiple of the same type of service on the same day (e.g. during a seminar), append the service number to the service type (e.g. AM1 instead of AM).
  3. Run Sermons on the Web Publisher. Drag and drop the audio file onto the Sermons on the Web or click Browse and choose the file.
  4. Fill in the series, scripture reference, and description, according to your needs.
  5. Click Publish.
  6. Lock the computer (if appropriate), and go fellowship.

Maintenance

Editing lists

When there are changes to your service types, speakers, or series, go to the sermons administration web page (you can use the link in the Publisher). From there make whatever changes you need. The administration web page does not support deletion. To delete, you must edit the database directly, for example with phpMyAdmin.

Backups

You should regularly back up your sound computer, particularly the Publisher data and options folders, and the web site database.

Copyright 2009 Edward D. Brey. Free to redistribute and modify per the GNU General Public License version 3 or later.