[Rtir] several problems + versions to use.

[Becz Tamas]

Hello,

We are planning to use RTIR as our incident handling system, and
therefore installed a test version. It is based on the request-tracker3
packages found in Debian (upstream version 3.0.11) and the rtir 1.0.5
downloaded from bestpracticals website. I use pgsql as a database
server. Required Perl modules are from debian unstable packeges, if they
exist. If not, I get them from CPAN.
I also installed the Statistics module, which I found on the wiki.

However, there are several issues, that I think are beyond configuration
problems, but rather caused by more-or-less incompatible versions. I'm
now planning to put rtir into a clean, chrooted environment.

I would really appriciate if someone who has a fine working install told
me the exact versions of rt, rtir, db server, and required perl modules
they use?


Also, i found that the released rtir-1.1.2 beta is compatible with rt
3.2. Should I give that a try?

Below are some of the errors, maybe someone has some ideas of what
causes these:

1) On clicking the incident reports, the following appear in syslog:
Sep 28 09:26:17 cert postgres[26023]: [9] ERROR:  pg_atoi: error in
"Incident Reports": can't parse "Incident Reports"

Sep 28 11:26:17 cert RT: DBD::Pg::st execute failed: ERROR:  pg_atoi:
error in "Incident Reports": can't parse "Incident Reports" at
/usr/share/perl5/DBIx/SearchBuilder.pm line 140. 
(/usr/share/request-tracker3/lib/RT.pm:250)

Sep 28 11:26:17 cert RT: DBIx::SearchBuilder error:ERROR:  pg_atoi:
error in "Incident Reports": can't parse "Incident Reports" ^IQuery
String is SELECT main.* FROM CustomFields main   WHERE ((main.Disabled =
'0')) AND ((main.Queue = '4')OR(main.Queue = '0')OR(main.Queue =
'0')OR(main.Queue = 'Incident Reports')) ORDER BY main.SortOrder ASC 
(/usr/share/request-tracker3/lib/RT.pm:250)

Sep 28 11:26:17 cert RT: DBD::Pg::st fetchrow_hashref failed: no
statement executing at /usr/share/perl5/DBIx/SearchBuilder.pm line 158. 
(/usr/share/request-tracker3/lib/RT.pm:250)

For me, it looks like the index num for Incident Reports cannot be
found, and therfore SearchBuilder creates an invaild query.

2) AdminCC filed does not get filled in when trying to comment on or
reply to a ticket. (I did added it to the Queue

3) When I write a comment on a ticket I get a "Status: Illegal value for
Status" message. (There is no way to set it on the comment form)

4) There is a template, that cannot be deleted, I get a permission
denied error, even when logged in as root.


Thank you,
-- 
Becz Tamás
MTA SZTAKI - Network Security Department
----
Addr: H-1111 Budapest, Lágymányosi u. 11.
Room: L I/9.box
Tel: +36-1-279-6280
ICQ: 68747712
----
rekurzió (fn.) lásd rekurzió
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Ez az =?ISO-8859-1?Q?=FCzenetr=E9sz?=
	=?ISO-8859-1?Q?_digit=E1lis?= =?ISO-8859-1?Q?_al=E1=EDr=E1ssal?= van
	=?ISO-8859-1?Q?ell=E1tva?=
Url : http://lists.bestpractical.com/pipermail/rtir/attachments/20040928/ba9413e6/attachment.pgp