Bugzilla – Bug 1636
CAS doesn't work with mysql DB
Last modified: 2004-03-25 18:09:31
You need to
before you can comment on or make changes to this bug.
You can't run CAS over mysql (as opposed to postgres which is the default).
These seem to be two issues: The first is that mysql won't let you have more
than one auto-increment column in a database and the second is that the SQL
statements used table locking specific to postgres.
This is an issue for NEES as they would like to avoid having to install two DBs
(postgres in addition to mysql)
A sample MySQL compliant database schema has been added to the code base and
some code changes have been made to accomadate use of MySQL.
But the code uses subqueries for permission evaluation and MySQL version 4.0.x
does not support subqueries. The support is in place fro version 4.0.1. So no
changes are being made to the code base.