[Sitr-general] SITR Setup details

[Peter K. <pet...@ya...>]

I recently set up a version of SITR (I think it was an earlier version) 
as a demo for my company.  I was actually setting up OSU's version - 
https://helpdesk.tss.oregonstate.edu/.  Their knowledgebase is SITR.

For general consumption, and in the hope that it helps someone, here are 
some notes I put together while setting it up:

--Peter

---
Setup:

Update gloabls.php and index.php with the corect database information

Import ./sql/knowledgebase.sql to set up an initial database.
(This worked for me:
  First create a user kb with all permissions on a new database 
knowledgebase
  (The Bugzilla documentation has some useful hints for this)
  Then import the sql into the database using something similar to
  mysql -u kb -p knowledgebase < ./sql/knowledgebase.sql
)

knowledgebase.sql has by default, 3 groups.  These groups are used to
give permissions to knowledgebase aritcles.  E.g., a question "How do
I change the background colour?" could have groups "Guest", "User" and
"Administrator", but a question "How do I delete a user?" might only
have group "Administrator".

These groups are stored in the table "sys_group"

knowledgebase.sql sets up two users by default:  guest and admin
The password for each is the same as the login.

These users are stored in the table "sys_account".

The Guest account must exist in order to be able to view webpages
without logging into the system.  Note that this includes viewing the
login page!

Logging in as Admin gives you the ability to create other logins and
create more categories and groups, etc.

The group permissions these logins have is stored in the table
sys_account_group.  The field "account_group_account_id" is the user ID
from "sys_account" and the "account_group_group_id" is the group ID from
"sys_group".  This isn't really necessary for you to know, unless you
wish to change the initial setup via mysql or editing the .sql file.