Hi David, this is part of this issue, http://uwyn.com/issues/browse/RIFE-188. I have no eta for when it would be implemented though.
You could try with another datasource and another user, and give the user that schema as its default schema. You can provide the datasource to every auth operation and element. There should be docs / javadocs for most things. Hope this helps, Geert On 24 Aug 2007, at 17:51, David Herbert wrote: > > I have a requirement that my authentication tables be stored in a > separate schema (within the same PostgreSQL database) to my science > data. I can see that I can override RIFE's default names for > authentication parameters via config parameters TABLE_ROLE etc. So I > think I can safely set this one to user_management.authrole, where > "user_management" is my schema name. However, when I try this, RIFE > comes up with the error: > > WARNING: Can't install the credentials database structure.; Error > while > executing the SQL 'CREATE TABLE users.authrole (roleId INTEGER NOT > NULL, > name VARCHAR(20) NOT NULL, CONSTRAINT USERS.AUTHROLE_PK PRIMARY KEY > (roleId), CONSTRAINT USERS.AUTHROLE_NAME_UQ UNIQUE (name))'.; ERROR: > syntax error at or near "." > > What appears to have happened is that the derived constraints > USERS.AUTHROLE_PK and USERS.AUTHROLE_NAME_UQ don't have quotes round > them and the SQL query fails (I have verified that it works if I put > double quotes around these constraint names). Is it possible some > other > way (e.g. by multiple datasources) to achieve creation of > authentication > tables in a Postgres schema that isn't "public" or some other default? > If multiple datasources is the way to go, please could someone > point me > at an example? > > Thanks, > > David Herbert > British Antarctic Survey. > > -- > This message (and any attachments) is for the recipient only. NERC > is subject > to the Freedom of Information Act 2000 and the contents of this > email and any > reply you make may be disclosed by NERC unless it is exempt from > release under > the Act. Any material supplied to NERC may be stored in an electronic > records management system. > > > > -- Geert Bevin Terracotta - http://www.terracotta.org Uwyn "Use what you need" - http://uwyn.com RIFE Java application framework - http://rifers.org Music and words - http://gbevin.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "rife-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rife-users?hl=en -~----------~----~----~----~------~----~------~--~---
