[Techtalk] linux helpdesk software?

[bsweeney]

Hey all,

Once of my co-workers has been trying to get a good helpdesk/computer 
tracking database setup in my department, and I started looking as well 
but have been unable to find anything that's really flexible.  I was 
wondering what other linuxchix might be using?  We're looking for 
something that's:

1) Very flexibe.  Like to be able to edit what fields are in different 
forms/tables, like adding types of hardware that aren't built into the 
database.
2) Fairly easy to use/admin/setup.  Unfortunately, neither myself nor 
anyone else that would be using this knows php or mysql/postgresql all 
that well.
3) Web interface
4) Real-time "queue" of issues, viewable by users reporting problems and 
tech support staff
5) Different levels of users, those that can add machines, address 
issues, etc, and those that can just submit problems and view status of 
problems.
6) Chat room/posting board for users to communicate with admins and each 
other (this would be a nice feature, but not necessary)?
7) Free, or at least cheap (<$200)

We'd like to try and make the trouble-ticket sytem tracker software all 
one package, since they'll share a lot of data anyway.

Any suggestions?

-Brian