sitr-general — General Project Information

[Sitr-general] Email Functionality

[Ettienne du P. <et...@ba...>]

hi

are you planning a email system to let support personnel know when a =
support request is requested

Regards
Ettienne Du Plessis
Senior Analyst
First National Battery
Tel  : 011 741 3632
Fax : 011 421 7239
Cell : 083 260 9266
email : et...@ba...


--=20
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.7.8/22 - Release Date: 17/06/2005
=20

[Sitr-general] SITR documentation

[Mike K. <MK...@me...>]

Do you have any documentation for setup and use?

PDF or word etc

Mike Kusk
Systems Manager
Metropolitan Credit Adjusters Ltd
780-423-2231 Ext. 2375

(Notice of Confidentiality:  This communication is privileged and contains
confidential information intended only for the person(s) named above.  Any
other distribution, copying, or disclosure is strictly prohibited.  If you
have received this communication in error, please notify me immediately by
telephone or email and delete the communication.)

Ce courriel est confidentiel et protégé. L'expéditeur ne renonce pas aux
droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou
copie de ce message ou des enseignements qu'il contient par une personne
autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez
ce courriel par erreur, veuillez m'en aviser immédiatement, par retour de
courriel ou par un autre moyen.

RE: [Sitr-general] SITR times out

[Nellurandi, S. <siv...@ci...>]

Thank you so much David. It works after having the following setting in
php.ini

session.gc_maxlifetime =3D 86400

Thanks,
Siva

-----Original Message-----
From: David McDonald [mailto:da...@mc...]=20
Sent: Monday, June 06, 2005 7:50 PM
To: Nellurandi, Sivakumar
Cc: sit...@li...
Subject: Re: [Sitr-general] SITR times out


Siva,

    This is probably a default timeout set in your PHP configuration
file.

       David

Nellurandi, Sivakumar wrote:

> Hi,
> =20
> I am using SITR Version 1.0.5.  Looks like, It times out after 1hr If
> there is no activity in the session.
> =20
> I am getting the following Error message in the browser window.
> =20
> *"Error... You do not have sufficient rights to access this=20
> resource."*
> =20
> Could someone please help me in fixing this problem?
> =20
> Thanks,
> Siva
> =20

Re: [Sitr-general] SITR + LDAP

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

Greg,

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.

I have not tried to authenticate via LDAP with PHP before. I know it is 
possible using Perl and a couple of modules.

All of the authentication is done in globals.php in a function called 
authenticate if I remember correctly. It should be easy to implement if 
PHP has any built in LDAP functions.

I have not tried to use any regexs to add users to groups before. You 
might try editing the code to automatically add users to new groups.

Hope that helps,

David

Greg Baker wrote:

>I have a couple of quick questions..
>
>1)  Does SITR have mechanisms to authenticate via LDAP?
>2)  Is it possible to assign regexs to allow users into a group?  I mean, if I 
>want every user a member of 'foo' group, is this possible without having to 
>add each user individually?
>
>Thanks and I look forward to using SITR in the future.
>Greg
>
>
>-------------------------------------------------------
>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
>
>
>
>  
>

Re: [Sitr-general] SITR times out

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

Siva,

    This is probably a default timeout set in your PHP configuration file.

       David

Nellurandi, Sivakumar wrote:

> Hi,
>  
> I am using SITR Version 1.0.5.  Looks like, It times out after 1hr If 
> there is no activity in the session.
>  
> I am getting the following Error message in the browser window.
>  
> *"Error... You do not have sufficient rights to access this resource."*
>  
> Could someone please help me in fixing this problem?
>  
> Thanks,
> Siva
>  

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
>
>
>

[Sitr-general] SITR + LDAP

[Greg B. <gb...@cs...>]

I have a couple of quick questions..

1)  Does SITR have mechanisms to authenticate via LDAP?
2)  Is it possible to assign regexs to allow users into a group?  I mean, if I 
want every user a member of 'foo' group, is this possible without having to 
add each user individually?

Thanks and I look forward to using SITR in the future.
Greg

[Sitr-general] SITR times out

[Nellurandi, S. <siv...@ci...>]

Hi,
=20
I am using SITR Version 1.0.5.  Looks like, It times out after 1hr If
there is no activity in the session.=20
=20
I am getting the following Error message in the browser window.
=20
"Error... You do not have sufficient rights to access this resource."
=20
Could someone please help me in fixing this problem?
=20
Thanks,
Siva
=20

[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.

[Sitr-general] SITR Search

[Ben A. <bab...@da...>]

Hi David,

 

I was playing around with SITR 2.05 and I've noticed when I perform a search
in the knowledge base of any see empty results for words that I know exist
in either some titles or summaries. Is there any reason for something like
this? Meaning are there reserved words or requirements?

 

Otherwise I have to say it's a great product

 

Ben

 

Ben Abecassis
Team Leader
Customer Service / Technical Support
TravelNet Technologies
1-866-532-4448 ext 141
bab...@da...
Fax: 514-385-6660 

 

 

Re: [Sitr-general] apostrophe's and backslashes

[Lyn <Sit...@li...>]

BT> Quick question...
BT>  
BT> We noticed that if we try to put a backslash in the main body of the
BT> article that once saved it will delete the backslash and the first
BT> character after it. 
BT>  
BT> If we also try to post an apostrophe in the main body we get an error
BT> back. 
BT>  
BT> Any ideas as to why this may be happening or where would we look to see
BT> if we can solve it. 
BT>  
BT> Thanks, 
BT> Bryce 

Hello Bryce,

I suspect that this is because those characters are being interpreted as
part of the program.  You can try escaping them by putting a front slash
in front of the character.  (I think, I can never remember if it's a
front or back slash that does the escaping, try em both)  so something
like this

  it/'s been nice knowing you /\ yours.

will print as

  it's been nice knowing you \ yours.


BT> BTW... Very cool little web app.  What I like is that it is a very
BT> simple fast little app which is exactly what we were looking for. 

I agree 100%.  This program has filled a need for us quite nicely.

-- 
Best regards,
 Lyn                        

Re: [Sitr-general] apostrophe's and backslashes

[Dominik K. <Dom...@Fe...>]

> If we also try to post an apostrophe in the main body we get an error back.
>  
> Any ideas as to why this may be happening or where would we look to see 
> if we can solve it.

Sounds pretty much like the whole body is handled as a string which is 
enclosed in apostrophes.
So if you put one in the text, the strings ends early and the rest is 
treated as php-code, which it certainly is not. That's propably the 
cause for the error.

Dunno about the backslash though.

Cheers,
Dominik

[Sitr-general] apostrophe's and backslashes

[Bryce T. <bt...@me...>]

Quick question... 
 
We noticed that if we try to put a backslash in the main body of the
article that once saved it will delete the backslash and the first
character after it. 
 
If we also try to post an apostrophe in the main body we get an error
back. 
 
Any ideas as to why this may be happening or where would we look to see
if we can solve it. 
 
Thanks, 
Bryce 
 
BTW... Very cool little web app.  What I like is that it is a very
simple fast little app which is exactly what we were looking for. 

[Sitr-general] Announcement FIx

[Dominik K. <Dom...@Fe...>]

Hi,

announcement modification seemed to be a bit buggy.

2.02 could not even create more than one, although it suggested to add one.
Just installed 2.06 - now it seems one can actually create more than one 
announcement, but when modifying, in any case the first one's text is 
displayed in the textbox.

You can correct this by modifying the SQL Statement in 
form_modify_announcement.php
All you have to do is add this line:
AND sys_announcement.announcement_id = ".$announcement_id."

This will get you the correct text into the textbox when editing an 
announcement because now you take reference to the announcement you 
actually want to modify.

The complete statement here looks like this now:

############
$query = "SELECT * FROM sys_announcement, sys_announcement_group, 
sys_account, sys_account_group WHERE 
sys_announcement.announcement_id = 
sys_announcement_group.announcement_group_announcement_id
AND sys_account.account_id = sys_account_group.account_group_account_id 
AND   sys_announcement_group.announcement_group_group_id = 
sys_account_group.account_group_group_id
AND sys_announcement.announcement_creator = sys_account.account_id 
           AND sys_announcement.announcement_id = ".$announcement_id." 
                    GROUP BY announcement_id";
############

Regards,
Dominik

[Sitr-general] installing sitr on EasyPHP

[john b. <joh...@ya...>]

Hello,

I am trying to install sitr using EasyPHP and I am not
sure where to put the sitr files.

I have EasyPHP running with Apache and MySql Started.


Regards,


John B


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Helps protect you from nasty viruses. 
http://promotions.yahoo.com/new_mail

[Sitr-general] Broken last line in install.sql

[Jim H. <jim...@in...>]

Hi,

I just downloaded sitr-2.0.6.tar.gz.

Maybe it's a bug in my local tar, but the very last insert statement
in install.sql was broken over two lines, which caused mysql to
reject it.

Regards,

Jim Hatfield

Re: [Sitr-general] please help

[Lyn B. <ly...@kw...>]

Hi Kenneth,

Did you upload the images as attachments to the document first?

BK> For some reason the insert image just pops up a blank window.
BK> 
BK> Why could this be happening?
BK> 
BK> 
BK> 
BK> Kenneth Burks
BK> -------------------------------------------------------------
BK> 
BK> Web Developer
BK> South Florida Water Management District
BK> 
BK> eMail - kb...@sf...
BK> 
BK> Phone - (561) 682-2703
BK> -------------------------------------------------------------

-- 
Best regards,
 Lyn                        

[Sitr-general] please help

[Burks, K. <kb...@sf...>]

For some reason the insert image just pops up a blank window.

Why could this be happening?

 

Kenneth Burks
-------------------------------------------------------------

Web Developer
South Florida Water Management District

eMail - kb...@sf...

Phone - (561) 682-2703
-------------------------------------------------------------

 

Re: [Sitr-general] Slight Mod

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

Dominik,

    I thought I sent you an eMail a few weeks ago=2E I would be happy to
upload your German language file onto the sourceforge page, and any other
languages people have created=2E I have been very busy recently and I forg=
ot
to follow up on this, sorry=2E

    David

Original Message:
-----------------
From: Dominik Klein Dominik=2EKlein@FernUni-Hagen=2Ede
Date: Wed, 27 Oct 2004 15:06:43 +0200
To: Sitr-general@lists=2Esourceforge=2Enet, Sitr-general@lists=2Esourcefor=
ge=2Enet
Subject: Re: [Sitr-general] Slight Mod


> Thank you!  I had looked in there, but didn't realize that Myphpadmin wa=
s
> limiting my view to just the first 30 records=2E :)  Finding the rest of=

> the entries was great!  I made a bunch of changes so that now my
> installation looks just like I wanted=2E  There was only one item that I=

> had to go out to the actual PHP file to edit=2E  In settings=2Ephp there=
 is
> one line of HTML that is "Create Application" or something like that=2E
> Everything else was contained in the language database=2E  So I assume
> this is just one that got overlooked in the change over=2E
>=20
> It's great now though=2E  I've changed "Application" to be "Category" an=
d I
> changed "Category" to be "Document Type"=2E  Now the screens make more
> sense for my particular use=2E
>=20

You could also add another sys_language_keys entry and grab it from the=20=

database=2E The pattern David uses to get text from the DB and uses it in=20=

his scripts is very easy to understand=2E

$lan_delete =3D LookupText ("Delete");

Saves the text for the actual user's language that is associated with=20
keyword "Delete"=2E

You can easily add a new item to that table and call it whatever you like=2E=


$lan_yournameforit =3D LookupText ("yournameforit")

Instead of strict php-echoing "Create Application" you would echo=20
$lan_yournameforit

That's the entire magic of SITR being able to carry multiple languages=2E=20=

I actually did a complete german set of sys_language_keys for SITR 2=2E0=2E=
4=20
but up to now, David did not reply that he wants it =2E=2E=2E

Well, good thing we have hebrew though :D

David: I'm not meaning to offence you, a quick "no thanks" would have=20
been nice though=2E

cheers
Dominik


-------------------------------------------------------
This SF=2ENet email is sponsored by:
Sybase ASE Linux Express Edition - download now for FREE
LinuxWorld Reader's Choice Award Winner for best database on Linux=2E
http://ads=2Eosdn=2Ecom/?ad_id=3D5588&alloc_id=3D12065&op=3Dclick
_______________________________________________
Sitr-general mailing list
Sitr-general@lists=2Esourceforge=2Enet
https://lists=2Esourceforge=2Enet/lists/listinfo/sitr-general



--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web=2Ecom/ =2E

Re: [Sitr-general] Slight Mod

[Dominik K. <Dom...@Fe...>]

> Thank you!  I had looked in there, but didn't realize that Myphpadmin was
> limiting my view to just the first 30 records. :)  Finding the rest of
> the entries was great!  I made a bunch of changes so that now my
> installation looks just like I wanted.  There was only one item that I
> had to go out to the actual PHP file to edit.  In settings.php there is
> one line of HTML that is "Create Application" or something like that.
> Everything else was contained in the language database.  So I assume
> this is just one that got overlooked in the change over.
> 
> It's great now though.  I've changed "Application" to be "Category" and I
> changed "Category" to be "Document Type".  Now the screens make more
> sense for my particular use.
> 

You could also add another sys_language_keys entry and grab it from the 
database. The pattern David uses to get text from the DB and uses it in 
his scripts is very easy to understand.

$lan_delete = LookupText ("Delete");

Saves the text for the actual user's language that is associated with 
keyword "Delete".

You can easily add a new item to that table and call it whatever you like.

$lan_yournameforit = LookupText ("yournameforit")

Instead of strict php-echoing "Create Application" you would echo 
$lan_yournameforit

That's the entire magic of SITR being able to carry multiple languages. 
I actually did a complete german set of sys_language_keys for SITR 2.0.4 
but up to now, David did not reply that he wants it ...

Well, good thing we have hebrew though :D

David: I'm not meaning to offence you, a quick "no thanks" would have 
been nice though.

cheers
Dominik

[Sitr-general] Slight Mod

[Lyn B. <ly...@kw...>]

Hello Dominik,

>> Can you tell me which files I would need to edit to make this change?
> 
> you need to edit table "sys_language_keys" entry "145"
> 
> most of the text you see is taken from the database (which makes the 
> multilanguage thing possible) with a php-function

Thank you!  I had looked in there, but didn't realize that Myphpadmin was
limiting my view to just the first 30 records. :)  Finding the rest of
the entries was great!  I made a bunch of changes so that now my
installation looks just like I wanted.  There was only one item that I
had to go out to the actual PHP file to edit.  In settings.php there is
one line of HTML that is "Create Application" or something like that.
Everything else was contained in the language database.  So I assume
this is just one that got overlooked in the change over.

It's great now though.  I've changed "Application" to be "Category" and I
changed "Category" to be "Document Type".  Now the screens make more
sense for my particular use.

-- 
Best regards,
 Lyn                         

[Sitr-general] Slight Mod

[Lyn B. <ly...@kw...>]

Hello David,

I need to make a slight change to the SITR v2.0.5 program. In BROWSE I
need to change "Software Application" to something else. I prefer it to
say "Catagory" or "Section". In the previous version I just altered the
Image file to accomplish this, but in v2.0.5 it appears to be textual.

Can you tell me which files I would need to edit to make this change?

-- 
Best regards,
 Lyn                          mailto:ly...@kw...

[Sitr-general] Announcements

[Lyn B. <ly...@kw...>]

Hello David,

  Ah ha...  :)  After adding the second announcement I, of course, made
  an error, so I selected MODIFY to fix my error, but the modify screen
  is working on Announcement number one.  I don't have a way of pulling
  up my second announcement.  All I can do is delete it and re-add it.

  Although I could go into myphpadmin and edit the database record to
  make my alteration I guess.

  Anyway, just letting you know..  Cheers.

-- 
Best regards,
 Lyn                          mailto:ly...@kw...

[Sitr-general] v2.05

[Lyn B. <ly...@kw...>]

Hello David,

  Well, I've had a chance to play with 2.0.5 a little bit now and the
  announcements are showing up on the home page nicely.  I am
  able to add a New Announcement.  However, When I select NEW
  ANNOUNCEMENT I'm presented with the edit window in the upper half of
  the screen.  It contains all the text from the current announcement. I
  can delete that text and type in whatever I want and it shows up as a
  second announcement after pressing the UPDATE button.  So, there is
  definite improvement to the behavior.  Thanks to your efforts. :)

  I'll let you know if I find anything else.

-- 
Best regards,
 Lyn                          mailto:ly...@kw...

[Sitr-general] v2.0.5

[Lyn B. <ly...@kw...>]

Hello David,

  OK, I noticed today that you had a new release so I'm giving it a
  shot. After uploading all files, editing install.php, globals.php with
  the database info and running the 2.0.4.sql on the database, when I
  go to the site location I get the following..

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result resource in /home/virtual/site012/fst/var/www/html/kb/index.php on line 36

Your database is not current and needs to be upgraded to the latest version
Always backup your database before proceeding

If I set the checks in index.php to 0 all is fine.  I'll let you know if
I experience any problems.

Looks like the announcements are fixed. :)

-- 
Best regards,
 Lyn                          mailto:ly...@kw...