Bug 1636 – CAS doesn't work with mysql DB

Bug 1636 - CAS doesn't work with mysql DB

Summary:

CAS doesn't work with mysql DB

Status:	RESOLVED WONTFIX

Product:	CAS/SAML utilities
Component:	CAS
Version:	3.2beta
Platform:	PC All

Importance:	P2 enhancement
Target Milestone:	---
Assigned To:	Rachana Ananthakrishnan

URL:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2004-03-15 11:22 by Von Welch
Modified:	2004-03-25 18:09 (History)

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note

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

Description From Von Welch 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 Rachana Ananthakrishnan 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.