For more information: https://github.com/orientechnologies/orientdb/wiki/Security#restore-admin-user
Lvc@ On 23 May 2014 17:09, Luca Garulli <[email protected]> wrote: > Hi Tommy, > login into the database as root and the password you find in your > $ORIENTDB_HOME/config/orientdb-server-config.xml file. Then: > > *insert into OUser set name = 'admin', password = 'admin', status = > 'ACTIVE', roles = (select from ORole where name = 'admin')* > > Lvc@ > > > On 23 May 2014 16:30, Tommy <[email protected]> wrote: > >> We are using 1.7-rc1. The database using plocal storage and is running >> in a OServer in a Java process. We believe the database got into this >> state because a developer was constantly terminating the Java process at >> startup while testing something else (unrelated to OrientDb) in our code >> base. >> >> I can put the database in a server and log into the server as root in the >> console. But I do not see a way to add users to my database without >> logging into a database. What command should I be using? >> >> >> On Friday, May 23, 2014 4:38:57 AM UTC-4, Andrey Lomakin wrote: >> >>> Hi, >>> What version do you use, which storage type do you use ? >>> >>> Any way you can do following. >>> >>> Put database into the server, logging as root, put new users in >>> database. >>> >>> >>> >>> On Thu, May 22, 2014 at 11:08 PM, Tommy <[email protected]> wrote: >>> >>>> Somehow I got a test database into a state where the "OUser" class is >>>> missing. Luckily there is nothing I care about in the db, but it got me >>>> thinking about how I can defend against this in the field. Can I still get >>>> data out if there are no users? Can I add users back in? How are >>>> essential OrientDb classes protected against accidental deletes? >>>> >>>> This is the error I see when trying to log into Orient Studio: >>>> >>>> --> com.orientechnologies.orient.core.exception.OCommandExecutionException: >>>>> Class 'OUSER' was not found in current database [ONetworkProtocolHttpDb] >>>>> 2014-05-22 15:17:38:424 SEVE Internal server error: >>>>> com.orientechnologies.orient.core.exception.OQueryParsingException: >>>>> Error on parsing query at position #6: Error on parsing query >>>>> Query: OUser where name = 'admin' limit 1 >>>>> -----------^ >>>> >>>> >>>> And this is the error I see when trying to write to the database in my >>>> Java code: >>>> >>>> Error on parsing query at position #6: Error on parsing query >>>>> Query: OUser where name = 'admin' limit 1 >>>>> -----------^ >>>>> com.orientechnologies.orient.core.sql.filter.OSQLTarget.< >>>>> init>(OSQLTarget.java:70) >>>>> com.orientechnologies.orient.core.sql.OSQLEngine. >>>>> parseTarget(OSQLEngine.java:330) >>>>> com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect. >>>>> parse(OCommandExecutorSQLSelect.java:109) >>>>> com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect. >>>>> parse(OCommandExecutorSQLSelect.java:65) >>>>> com.orientechnologies.orient.core.sql.OCommandExecutorSQLDelegate. >>>>> parse(OCommandExecutorSQLDelegate.java:49) >>>>> com.orientechnologies.orient.core.sql.OCommandExecutorSQLDelegate. >>>>> parse(OCommandExecutorSQLDelegate.java:33) >>>>> com.orientechnologies.orient.core.storage.OStorageEmbedded. >>>>> command(OStorageEmbedded.java:83) >>>>> com.orientechnologies.orient.core.sql.query.OSQLQuery.run( >>>>> OSQLQuery.java:69) >>>>> com.orientechnologies.orient.core.sql.query.OSQLSynchQuery. >>>>> run(OSQLSynchQuery.java:82) >>>>> com.orientechnologies.orient.core.query.OQueryAbstract. >>>>> execute(OQueryAbstract.java:29) >>>>> com.orientechnologies.orient.core.metadata.security. >>>>> OSecurityShared.getUser(OSecurityShared.java:179) >>>>> com.orientechnologies.orient.core.metadata.security. >>>>> OSecurityShared.authenticate(OSecurityShared.java:148) >>>>> com.orientechnologies.orient.core.metadata.security. >>>>> OSecurityProxy.authenticate(OSecurityProxy.java:83) >>>>> com.orientechnologies.orient.core.db.record. >>>>> ODatabaseRecordAbstract.open(ODatabaseRecordAbstract.java:166) >>>>> com.orientechnologies.orient.core.db. >>>>> ODatabaseWrapperAbstract.open(ODatabaseWrapperAbstract.java:54) >>>>> com.tinkerpop.blueprints.impls.orient.OrientBaseGraph. >>>>> openOrCreate(OrientBaseGraph.java:878) >>>>> com.tinkerpop.blueprints.impls.orient.OrientBaseGraph.< >>>>> init>(OrientBaseGraph.java:134) >>>>> com.tinkerpop.blueprints.impls.orient.OrientTransactionalGraph.< >>>>> init>(OrientTransactionalGraph.java:58) >>>>> com.tinkerpop.blueprints.impls.orient.OrientTransactionalGraph.< >>>>> init>(OrientTransactionalGraph.java:54) >>>>> com.tinkerpop.blueprints.impls.orient.OrientGraph.< >>>>> init>(OrientGraph.java:34) >>>>> ... >>>>> >>>> -- >>>> >>>> --- >>>> 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/d/optout. >>>> >>> >>> >>> >>> -- >>> Best regards, >>> Andrey Lomakin. >>> >>> Orient Technologies >>> the Company behind OrientDB >>> >>> -- >> >> --- >> 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/d/optout. >> > > -- --- 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/d/optout.
