php/mysql ticketing systems

July 27, 2005 7:49 AM

Can anyone suggest some good php/mysql ticketing systems to review? 'Tis for tech support tickets. Thanks.
posted by pissfactory to Computers & Internet (16 answers total)

I like Trac -- which is a PHP + MySQL app that handles tickets and a whole lot more. It was discussed in an AskMe thread a week ago; it provides the aforementioned ticket system, an integrated wiki (that extends to the ticket system, but also can handle traditional wiki-like functionality for writing docs, readmes, and the like), permissions, and a Subversion source repository browser. It's great; I use it for two projects, and it's perfect for me.

(And to bring up a pet peeve -- the question in that AskMe thread I linked to above doesn't ever use the word "Trac" despite it being specifically about Trac. This means that (a) users have to hover over the link to see what the question is even about, and (b) it dilutes the ability of the search engine to return the thread under appropriate circumstances.)
posted by delfuego at 8:15 AM on July 27, 2005

Double Choco Latte is a fairly complete ticketing and project management system.
posted by tumble at 8:17 AM on July 27, 2005

delfuego: Point taken. I was posting at work, and I didn't have time to really think it through. However, I would like to point out that I did assign the appropriate keywords: ( SCM bugtracking softwaredevelopment )
posted by lilboo at 8:26 AM on July 27, 2005

Um...Trac is NOT a PHP+MySQL system at all! :( It's written in Python and can be run as either a CGI module in Apache or using Apache's mod_python. I forget if it has a standalone Web server as well, it might.

And it backends into a SQLite database, not MySQL, although for something fairly simple/low-volume as ticket tracking the difference is negligible.

That said, as evidenced by my commenting in the linked thread, Trac is a great solution, so if your host or server is capable of running Python via Apache and has the right sqlite packages, it may still be a viable solution.

I'm afraid I don't know offhand of any equivalent PHP/MySQL systems, but they must be out there. Try looking on SourceForge or Freshmeat for starters.
posted by cyrusdogstar at 8:42 AM on July 27, 2005

DotProject can more than likely do what you're looking for, is open source and uses php/mySQL.
posted by furtive at 8:50 AM on July 27, 2005

RT is Perl, not PHP, but it's one of the best ticketing systems I've worked with.
posted by mendel at 9:20 AM on July 27, 2005

Well, if we're bringing up Non-PHP ticketing systems, RT is pretty much the gold standard for OSS trouble ticketing systems. It uses MySQL and Perl.

On even pretty low end hardware you'll be able to scale to 250000+ tickets.
posted by togdon at 9:21 AM on July 27, 2005

Ok, Live Preview 2nds RT as the non PHP choice...
posted by togdon at 9:23 AM on July 27, 2005

We use H2Desk, and it's quite nice.
posted by Merdryn at 9:35 AM on July 27, 2005

eventum is the system we use for providing support at mysql.
posted by jimw at 9:55 AM on July 27, 2005

I use Cerberus HelpDesk for my webhosting company. Very easy to configure, modify and integrate, full of features on both the client and admin side.

Some others that come to mind are Kayako and PerlDesk.
posted by re.becca at 11:43 AM on July 27, 2005

Wow, I'm a moron -- I thought that it was PHP and used MySQL! Shows what the f*!@ I know. All I can say is that I set two installations up about six months ago and love them, whatever they're written in and use for storage. :)
posted by delfuego at 12:42 PM on July 27, 2005

I recently used PHP Ticket for a similar application, though it required quite a bit of modification. If you're not looking for too many features, it's pretty quick and painless to install and manage.
posted by greatgefilte at 1:20 PM on July 27, 2005

OTRS is very good too. They have a nice Windows's installer.. but it is based on code that is a little out of date to what is shipping for their POSIX platforms.
posted by cowmix at 2:51 PM on July 27, 2005

I recommend phpBugTracker.
posted by nj_subgenius at 4:59 PM on July 27, 2005

I can vouch for both Trac and Jira, but neither one is ideal for end users to interact with.
posted by waxpancake at 1:32 AM on July 31, 2005