1 |
kashani wrote: |
2 |
|
3 |
> Andrew D. Fant wrote: |
4 |
> |
5 |
>> gentoo-server wrote: |
6 |
>> |
7 |
>>>> I'm looking for a web based job ticket system. We use apache 2 and |
8 |
>>>> mysql |
9 |
>>>> currently, and also have php 4/5. |
10 |
>>>> |
11 |
>>>> Any suggestions? |
12 |
>>> |
13 |
>>> |
14 |
>>> http://www.bestpractical.com/rt/ |
15 |
>>> |
16 |
>>> We use it with ~10 users, and ~5000 end users submitting tickets. |
17 |
>>> Works |
18 |
>>> very well for us. |
19 |
>>> |
20 |
>>> Stan |
21 |
>> |
22 |
>> |
23 |
>> I'll second that. We use RT here and it works quite well. Better than |
24 |
>> many commercial solutions, in fact. |
25 |
>> |
26 |
>> Andy |
27 |
> |
28 |
> |
29 |
> Ditto here, but RT is royal pain in the ass to get working. Gentoo |
30 |
> does have an ebuild for it now, so it may not be as bad as when I |
31 |
> built mine a few years ago. |
32 |
> |
33 |
> You'll need Mysql w/innodb support for the current version and you may |
34 |
> have the best luck with Apache1 and mod_perl1. |
35 |
> |
36 |
> kashani |
37 |
|
38 |
I second that, Apache1 and mod_perl. |
39 |
|
40 |
The way I do it is I have an entire Perl ,Apache and RT installation in |
41 |
the RT users homedir: |
42 |
|
43 |
0 100 |
44 |
32M apache |
45 |
8.0K dead.letter |
46 |
4.0K last_ip.pl |
47 |
3.8M lib |
48 |
57M local-perl |
49 |
1.3M man |
50 |
211M rt |
51 |
32M rt_backups |
52 |
424K share |
53 |
18M src |
54 |
4.0K startup.pl |
55 |
|
56 |
It works out very well, it migrates machine to machine very well, and is |
57 |
fairly immune to upgrades to perl and such breaking it. |
58 |
|
59 |
Other things to watch out for: |
60 |
* There are changes you need to make to your MySQL system. Specifically |
61 |
there is usually a mismatch between RT's max attachment size and MySQL's |
62 |
packet size, which means cropped attachments. The rest are just |
63 |
performance related. There is a relationship between RT's speed, and |
64 |
the memory you give MySQL. |
65 |
|
66 |
* Some file in /etc needs to be updated. Shared memory related I think? |
67 |
|
68 |
|
69 |
-- |
70 |
gentoo-server@g.o mailing list |