Re: [Sitr-general] SITR Setup details

[David M. <da...@mc...>]

Peter,

    I apologize for taking so long to reply to your message, I have been 
VERY busy lately.

    I am glad you have found my application useful.

    Hopefully some of the others on the mailing list will find this useful.

       David

Peter Kay wrote:

> 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.
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you 
> shotput
> a projector? How fast can you ride your desk chair down the office 
> luge track?
> If you want to score the big prize, get to know the little guy.  Play 
> to win an NEC 61" plasma display: http://www.necitguy.com/?r=20
> _______________________________________________
> Sitr-general mailing list
> Sit...@li...
> https://lists.sourceforge.net/lists/listinfo/sitr-general
>
>
>