My fix was just to add the following lines to default_roles_permissions.sql

insert into UserRole (ROLENAME) values ('user_admin');
insert into VisitorRole ( VISITORID, ROLEID ) select Visitor.VISITORID,
UserRole.RoleID from Visitor, UserRole where Visitor.loginid = 'turbine' AND
UserRole.rolename = 'user_admin';

I have just downloaded Turbine, so I'm not completely clear on the
User->Role->Permission relationships and how they are used in Turbine.

I was trying to add a user from the Turbine Add User screen.

I added the line you gave me and I now get one line further in the code :)

It now throws an Exception on

                    nextId = row.getValue("NEXT_ID").asInt();

in IDBroker.

Beneath this, the Exception is actually being thrown by the following:

    public Value getValue (String columnName) throws DataSetException
    {
        return getValue(schema().index (columnName));
    }

within village::Record.

I'll read the IDBroker comments.

Thanks!


-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Frank Kim
Sent: Thursday, March 02, 2000 10:35 PM
To: Turbine
Subject: RE: DB



> Debugging into the code, I found the user_admin role was not
> assigned to the
> "turbine" user in default_roles_permissions.sql

Can you post your fix.

> I also have problems adding users which I found is caused by the ID_TABLE
> not having an entry for "Visitor"
>
> I just got code out of CVS - am I missing something? How should I populate
> the ID_TABLE?

How are you "adding users?"  The id table should only be used if you are
trying to use BasePeer for your inserts.  Can you post a stack trace.

If you want to try to get it working with the ID_TABLE then insert values
like this and read the comments in IDBroker.
insert into id_table(id_table_id, table_name, next_id, quantity)
values (1, 'Visitor', 1, 10);

Hope this helps




------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Problems?:           [EMAIL PROTECTED]




------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Problems?:           [EMAIL PROTECTED]

Reply via email to