[CPS-users] SQLDirectory authentication not quite working??

[Joshua Kramer]

Greetings all,

Ok, so I tried the things in my previous post:

1. Create a database table matching the Members schema;
2. Create a SQLDirectory
3. Rename the original Members directory
4. Rename the SQLDirectory to be "Members"

Now, I have a Nuxeo site that authenticates successfully against 
Postgres.  However, there are two problems, and a question:

1. The directory is never written to: when I change a password or try to 
sign up a new user, no database writes are attempted at all; the current 
page just refreshes itself.  This is OK, as I had planned to write my 
own signup pages anyway that will most likely write directly to the DB, 
but I still need to be able to change password.

2. New user folders aren't created.  I read in the documentation that 
when a user logs in that CPS has not seen before, CPS creates the user's 
Private Spaces.  This doesn't work; if I manually insert a user into the 
database, and log in as that user, then the user is presented an 
environment in which they can't do anything except logoff or see public 
resources.  Do I have to put the new user creation stuff in my signup 
pages and scripts?

3. How are roles and groups stored in the DB?  From looking at 
ZPsycopgDA and SQLDirectory, it looks as if I should store a comma 
separated list of values in a VARCHAR; I tried to use Postgres varchar 
arrays for these fields and it didn't work...

Cheers,
-Josh