ServiceBuilder Online - Setting Up the Web Server

Setting Up The Free Webserver

When setting up the web server so your team can access ServiceBuilder on the Internet you must do the following. These are very simplified instructions, so if you have problems, use the contact page to obtain more information.

Download and Install Abyss Web Server version X1 from Aprelium Technologies (free)
- Aprelium.com
Download and install ActivePerl for Windows (free):
- ActivePerl
Download and install DBI.
1. Check out this page for some more information on installing and configuring DBD, which is necessary for ServiceBuilder Online.
2. Open a DOS command prompt and type the following:
3. perl -MCPAN -e shell
4. Type no
5. At the cpan> prompt type the following:
  - m DBI
6. There will be results. Wait for it to finish
7. Install DBI by typing the following:
  - install DBI
8. There will be many results... wait again.
9. At the prompt type the following:
  - m DBD::mysql
10. There will be results again. wait for it to finish
11. Type the following:
  - install DBD::mysql
12. When it is finished displaying results, you are finished.
Set up the ServiceBuilder database to be available over ODBC:
1. Click Start, Settings, Control Panel
2. Click administrative tools (you're looking for Data Sources (ODBC))
3. Open Data Sources
4. Click the 'System DSN' tab
5. Click 'Add'
6. Find 'Microsoft Access Driver' then click 'Finish'
7. Type ServiceBuilderData in the Data Source Name
8. Type ServiceBuilder in the description
9. Click the 'Select' button and find the back-end for your ServiceBuilder database (called sb_data.mdb)
  - Remember to locate the network copy of the back-end database.
10. Click 'OK', then 'OK' again.
Obtain a free domain name from CJB.NET. We suggest something like "yourchurchname.cjb.net" for your Intranet domain. Then you'll need to do the following:
1. Obtain the DIPUpdate script from Intelliscript.net-- (it's free)
2. Set it up according to the instructions which come with it, and place it on your church's Internet site in the cgi-bin-- not on your own Intranet, but you're church's Internet.
3. Set up a system of regularly calling this script from your ServiceBuilder computer. My suggestion is to create a text file with the following code in it:
  <html><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><meta http-equiv="Refresh" Content="1200;URL=update.htm"></head><body><iframe SRC="http://www.yourchurch.org/cgi-bin/dip_update.pl" NAME=ip WIDTH=100% ALIGN=top FRAMEBORDER=0 MARGINWIDTH=0 MARGINHEIGHT=0 SCROLLING=auto bgcolor="#000080"></iframe></body></html>
4. Save this as 'update.htm' and then right click on your desktop, click 'Active Desktop,' and 'New Desktop Item.' Browse to find the file 'update.htm' and click 'OK' then click 'OK' again.
Obtain the ServiceBuilder Perl scripts from us and copy them to your web directory. These scripts are no additional charge.
Test it out, then distribute your new CJB domain name to your music team.