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.
