Bug 1636 - CAS doesn't work with mysql DB
: CAS doesn't work with mysql DB
: CAS/SAML utilities
: 3.2beta
: PC All
: P2 enhancement
: ---
Assigned To:
  Show dependency treegraph
Reported: 2004-03-15 11:22 by
Modified: 2004-03-25 18:09 (History)



You need to log in before you can comment on or make changes to this bug.

Description From 2004-03-15 11:22:52
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)
------- Comment #1 From 2004-03-25 18:09:31 -------
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.