kashani wrote:
Andrew D. Fant wrote:
gentoo-server wrote:
I'm looking for a web based job ticket system. We use apache 2 and mysql
currently, and also have php 4/5.
Any suggestions?
http://www.bestpractical.com/rt/
We use it with ~10 users, and ~5000 end users submitting tickets. Works
very well for us.
Stan
I'll second that. We use RT here and it works quite well. Better than many commercial solutions, in fact.
Andy
Ditto here, but RT is royal pain in the ass to get working. Gentoo does have an ebuild for it now, so it may not be as bad as when I built mine a few years ago.
You'll need Mysql w/innodb support for the current version and you may have the best luck with Apache1 and mod_perl1.
kashani
I second that, Apache1 and mod_perl.
The way I do it is I have an entire Perl ,Apache and RT installation in the RT users homedir:
0 100 32M apache 8.0K dead.letter 4.0K last_ip.pl 3.8M lib 57M local-perl 1.3M man 211M rt 32M rt_backups 424K share 18M src 4.0K startup.pl
It works out very well, it migrates machine to machine very well, and is fairly immune to upgrades to perl and such breaking it.
Other things to watch out for:
* There are changes you need to make to your MySQL system. Specifically there is usually a mismatch between RT's max attachment size and MySQL's packet size, which means cropped attachments. The rest are just performance related. There is a relationship between RT's speed, and the memory you give MySQL.
* Some file in /etc needs to be updated. Shared memory related I think?
-- [email protected] mailing list
