First, ConcourseConnect only works with PostgreSQL, which is a great reference platform as it has an agreeable license for redistribution, but I see your dilemma.

To get MySQL working, the PostgreSQL scripts would need to be modified for MySQL syntax. That's fairly straightforward and could be accomplished in a few days. Second, though, the application would need some adjustments to work with the MySQL syntax. I've done this before with other projects so I know it can take a week or two of development. After that, lots of QA.

Finally, MySQL would need to be supported in future development and that is why we've cut back on supporting other databases, like MySQL and MS SQL. In the end, it doesn't matter if MySQL is added to the development, but someone either needs to maintain it or pay for it to be maintained since we are quite pleased with PostgreSQL, although MySQL would be a good next candidate.

Does anyone want to sponsor the development and maintenance of MySQL compatibility?

Would you consider having Connect hosted in a PostgreSQL environment?

Thanks Matt, for the time being i am trying my hands with connect on postgres, :)
Now I am facing another problem:
Installation was smooth and i am able to get to home page but after 2-3 clicks application fails due to following error:

Caused by: java.lang.OutOfMemoryError: PermGen space

Note: I am running the app through eclipse-IDE - WASCE, and following are my jvm settings:
C:\Utils\eclipse-jee-ganymede-win32\eclipse\eclipse.exe -vm "C:\Program Files\Java\jre1.5.0_22\bin" -vmargs -XX:MaxPermSize=512m

Please correct me if i am mistaking at some place

I haven't used Eclipse and WASCE, but make sure that the memory settings are being set on WASCE and not just Eclipse, which might be the case. I think the default is 64m and you would get that error message if WASCE isn't being configured properly.

For IntelliJ + Tomcat I use:
-Xms256m -Xmx512m -XX:PermSize=64m -XX:MaxPermSize=256m -XX:+UseParNewGC

i did a simple migration from postgre to MySQL, it seems work fine. MySQL scripts is shared here. http://blog.csdn.net/chif_/article/details/7022516