Hi,
I am new to OrientDB so appologies if this is carbonunitfailure!. I just
downloaded and installed orientdb-community-1.7-rc1 on 64bit Windows with
JRE 1.7.0_45_b18
I am unable to add any newly created user to any existing or newly created
role on a brand new install. Each new user is created successfully (select
from OUser shows the users present but with [0] for roles). On attempting
to log in as the new user, login fails.
To reproduce either:
connect remote:localhost/GratefulDeadConcerts admin admin
or
connect remote:localhost/GratefulDeadConcerts root <pwdfromconfig>
then
insert into orole (name,mode,rules) values
("mynewrole",1,{"database.class.Person":0}) -> succeeds
insert into ouser (name,password,status,roles) values
("mynewuser","mypassword","ACTIVE",(select from orole where name="mynewrole"))
-> succeeds
insert into ouser (name,password,status,roles) values
("mynewuser2","mypassword","ACTIVE",(select from orole where name="writer")) ->
succeeds
disconnect -> succeeds
connect remote:localhost/GratefulDeadConcerts mynewuser mypassword -> fails
with error
Error:
com.orienttechnologies.orient.enterprise.channel.binary.OResponseProcessingException:
Exception during response processing
Error: com.orienttechnologies.orient.core.excption.OSecurityAccessException:
User 'mynewuser' has no role defined
connect remote:localhost/GratefulDeadConcerts mynewuser2 mypassword -> fails
with error
Error:
com.orienttechnologies.orient.enterprise.channel.binary.OResponseProcessingException:
Exception during response processing
Error: com.orienttechnologies.orient.core.excption.OSecurityAccessException:
User 'mynewuser2' has no role defined
select from OUser -> shows:
3 |#5:3|mynewuser |{SHA-256}65ED.....|ACTIVE|[0]
4 |#5:5|mynewuser2|{SHA-256}65ED.....|ACTIVE|[0]
Presumably the [0] is not correct?
Interestingly, I get an initially better error when I create a plocal database:
create database plocal:../databases/test1 admin admin plocal -> succeeds
connect plocal:../databases/test1 admin admin
then
insert into orole (name,mode,rules) values
("mynewrole",1,{"database.class.Person":0}) -> succeeds
insert into ouser (name,password,status,roles) values
("mynewuser","mypassword","ACTIVE",(select from orole where name="mynewrole"))
-> succeeds
insert into ouser (name,password,status,roles) values
("mynewuser2","mypassword","ACTIVE",(select from orole where name="writer")) ->
succeeds
select from OUser -> shows:
3 |#5:3|mynewuser |{SHA-256}65ED.....|ACTIVE|[0]
4 |#5:5|mynewuser2|{SHA-256}65ED.....|ACTIVE|[0]
However, on attemting to connect as one of the new users:
connect plocal:../databases/test1 mynewuser mypassword
I get a diffrerent error:
Connecting to database [plocal:../databases/test1] with user 'mynewuser'...
Database seems corrupted:
>Security metadata is broken: current user 'mynewuser' has no roles defined
Auto-repair will execute this action:
> The 'admin' user will be reinstalled with default role ('admin') and password
> ('admin')
Do you want to repair it (Y/n)?
If you select Y, the console goes into an apparently endless loop printing the
prompt:
orientdb {test1}>
orientdb {test1}>
orientdb {test1}>
orientdb {test1}>
orientdb {test1}>
orientdb {test1}>
etc
I home that this makes sense.
Best wishes,
Nicholas Lumb
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
