WebTTS 3.0 (C) 1998,1999 Robert Gash 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. A copy of the GNU GPL has been included in this distribution with the filename LICENSE. This program is distributed under the GNU GPL. You may freely distribute modified copies of this program under the terms contained in the GNU General Public License. DONATIONS --------- I felt I should put this at the top of the README so everyone can see it. Even though this is very very tacky, if I put it at the bottom you wouldn't see it because most everyone (myself included) stops reading after they get to "Installation" ;] I have spent many many hours working on WebTTS for all of the world to enjoy. I feel software should be distributed in source under the GPL (or another license that is similar to the GPL), which is why I publish WebTTS under the GPL. I also believe that software should be free. Period. However, I do have to make a living, and writing WebTTS takes away from the time that I spend at my job or elsewhere. Therefore, with the release of WebTTS 2.5 I am going to mention a DONATION. That's right, a money DONATION. This is NOT REQUIRED, if you don't think WebTTS is worthy of being paid for, fine, use it until your heart's content (and even longer if you like). However, if you do feel that all of my hard work is worthy of a little donation, you can send them to the address below (checks or money orders please, you shouldn't send cash in the mail). I am going to suggest US$10 for a donation, if you want to give more or less, feel free, this is just what I am suggesting. Again, I should stress that this is not required, your databases won't blowup and your computer won't cease to function if you don't donate, but if you really like the software and think I deserve something, this would be a great way to show me you care. If you do send a donation, please include your eMail address. I will put it in a database and I will inform you of current status of the project, and you will receive an eMail when new versions are released. If you want to register, but don't want to get any eMail from me, simply note that you don't want eMail on the note. You may send checks or money orders (with a note including your eMail addr) to: Robert Gash 2320 Dogwood Ln Orange Park, FL 32073 USA Introduction ------------ This package is for businesses (or individuals) that require a trouble tracking system. I have written this implementation for use by an ISP in an environment where they must track service problems (outages, downtime, emergencies) coming from many sources covering a vast array of topics. Within this package you will find all of the programs necessary to run a WWW-based Trouble Ticketing system, that can be accessed through your favorite browser. This program provides rudimentary authentication and tracking. Requirements ------------ WebTTS 3.0 REQUIRES the following packages to be installed for it to work: - Perl 5.004 or higher * - DBI 1.12 or higher * - DBD 1.20 or higher (MySQL Driver) * - Mail::Sendmail 0.77 or higher (only if you want to send eMails) * (http://www.cpan.org/modules/by-module/Mail/Mail-Sendmail-0.77.tar.gz) - DB_File (only to import any older pre-3.0 databases) * - MySQL Database Server (www.mysql.com, tested with 3.22.xx) * Denotes a file that is found on the CPAN, available at http://www.cpan.org. Installation ------------ Installation of this is very simple: 1) Copy the tts.pl, tts-*.pl and cgi-lib.pl scripts to a directory that is publicly accessible and has permission to run CGI programs. 2) Give all the files a+rx permissions (0555 for you numerical permission people) that you have just placed in the public CGI directory. 3) Edit all of the variables in the USER EDIT section of tts-inc.pl . You must create a user in your MySQL system that has the following permissions: SELECT, INSERT, UPDATE, DELETE for the $dbname database. Use your root or admin MySQL account for the install scripts ONLY, as this is a major security hole if you use them for all WebTTS operations. CREATE the $dbname database by hand using the MySQL client tools, check your docs on how to do this (CREATE DATABASE whatever, I don't know how to make Perl do this for you so I've got to have you do this one step by hand.) Check your MySQL docs if you get lost anywhere. 4) ALL INSTALL/IMPORT SCRIPTS ARE IN THE install-scripts DIRECTORY DO NOT COPY THIS DIRECTORY TO A PUBLICALLY-ACCESSIBLE DIRECTORY, OTHERWISE YOU MAY MUCK SOMETHING UP, IF THIS DIR IS A PUBLICALLY ACCESSIBLE DIRECTORY PLEASE EXECUTE rm -rf ./install-scripts AFTER YOU ARE DONE INSTALLING. A) If you are UPGRADING from 2.1 or 2.5 edit tts-import.pl and change the noted setup variables, then execute tts-import.pl and it will create the tables and insert all of your old ticket information into the tables and import all of your users. B) If this is a new install please run tts-install.pl to create the tables, and add the "admin" user with password "admintts". Also make sure that you change the ownership of the tts-inc.pl file to the user that the webserver runs as and remove group and world read/write access to it so your SQL login information stays secure. 5) Access the tts.pl file you have installed through your favorite WWW browser. You will be prompted with a login screen, enter "admin" for the login name and "admintts" for the password (this is if you have done a fresh install, otherwise you just use whatever logins you had in 2.5 or 2.1 and continue to use WebTTS like normal). I suggest going DIRECTLY to the User Management area and adding a new user for yourself (make sure you have admin rights, or you can't access the user management stuff!), then deleting the admin user. If you are upgrading all of your old settings have been retained, so you can just keep on using the system the same way you always have. That's it! Nothing more to do! Miscellany ---------- I have also included 1 other program to aid in the operation of this program: 1) pubview.pl -- This program allows people to view public alerts. By default public alerts are "ALERT"s "System Maintenance" and "System Downtime" tickets. If a ticket is closed, public users can't see it, so you don't have to show users the old tickets. You call the script from an or direct access like this: pubview.pl?type . "type" can be "alert" for Alerts, "downtime" for System Downtime, or "maintenance" for System Maintenance (without the quotes of course). When you use pubview.pl, please be sure that the include '/path/to/tts-inc.pl'; points to the proper path for tts-inc.pl. Contact ------- You can contact me (Robert Gash) at the following addresses Robert Gash 2320 Dogwood Ln Orange Park, FL 32073 USA eMail: gashalot@gashalot.com ICQ: 13356305 http://www.gashalot.com (my webpage that has some more ways to contact me)