My Address Book SQL (version 1.1)
Please read everything but email me if
(1) you do not understand
(2) you get it running (so I can check it out and put up a link to your
DISTRIBUTION / LICENSE
HOW TO USE
1. web server (only tested on UNIX and LINUX)
2. Perl 5.8.0 (may work with others)
4. DBI perl module
This Address Book script is meant to be a single-user address book, capable
of holding information about the user's friends and family, such as addresses,
phone numbers, email addresses, webpage, and notes about the contact. This can
be used as a multi-user list, like a member directory, but there is only one
username and password for changing information (adding and editing contacts).
It is more suited to be a directory for viewing only by members, to be maintained
by a single admin.
Add an unlimited number of contacts.
Easy to use and read.
Specify your own colors.
Use your own template.
This software is released under the GPL. Please see the included LICENSE file.
Copyright (C) 2003 Erin Spiceland This program is free software; you can redistribute
it and/or modify it under the terms of the GNU General Public License as published
by the Free Software Foundation; either version 2 of the License, or (at your option)
any later version. This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this
program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite
330, Boston, MA 02111-1307 USA Use this script at your own risk! I make no warranties
that it is hack proof!
Installation is easy:
1. Put all of these files under your cgi-bin (or other executable web
directory). If you just unzip the zip file inside the cgi-bin folder, it will create a classifieds folder
inside the cgi-bin directory.
2. Now give all cgi and pm files executable permissions. To do this from commandline on a UNIX/Linux server,
do "chmod 755 *.cgi protected/*.cgi". If you do not have commandline access or are on a Windows server, you should
have access to a control panel of some sort which will allow you to change the permissions of these files.
3. Edit lib/sitevariables.pm to match your needs. This file holds all the information about My Address Book
that might vary from server to server. It also has many options like fonts and colors that you can change to
customize your site. There are several things that are very important for you to change if you want My Address Book
to work. The names of these variables are $database, $database_user, and $database_password. It is essential that
you find out from your admin your database name, user, and password for this script to work.
4. You may need to modify the first line of index.cgi to point to where
perl is located on your server.
#!/usr/bin/perl (most common)
5. Create your MySQL table. You can do this from commandline using this command from within the cgi-bin/addressbook
#!/soft/script/bin/perl (for users in web.utk.edu/~username/cgi-bin/)
$ mysql <your database name here> < makecontactstable <hit enter here>
Fire up your browser and point it at the index.cgi script.
Good Luck! Email me if you use it!
Just point your browser at it. Click "View All" to view all contacts at the same time,
or choose a letter to view all contacts with last name starting with that letter. Click
"Add Contact" to add a new contact.
If you get an internal server error, run it from command line so that you can see what
is going wrong by doing this:
[erin@fuzzymonkey] $ ./index.cgi
Looking at the output of this command can often give a hint at what is going wrong. If the
permissions are wrong, you'll often get "bash: ./index.cgi - Permission denied." When emailing
for help, be sure to include the output of this command in order to give us a better idea of what
10.12.2003 Version 1.1 Fixed a bug that messed up the display of search results.
09.14.2003 Version 1.0 First release of My Address Book!
I need to do/need help with the following items
Add capability for letting each contact update their own listings, but no other listings.
Anything else you want me to add... just email me.
Send questions or comments to email@example.com
Mike and Erin Spice