What sort of software do people use to manage various tasks? Something like a helpdesk or ticketing system, where users can report problems, etc.

Keystone with Postgres. That is, http://www.stonekeep.com/keystone.php3 and http://www.postgresql.org/.