Can you try the same from Studio?
On 23 May 2014 17:34, Tommy <[email protected]> wrote: > Thank you for the link, but unfortunately I tried that and I get a similar > error to the one I get before: > > >> orientdb> connect remote:localhost/SystemDb root >> 295F75C29359FF358DD567ABB518E484B2E8507A6DD76665D5300B1117F51883 >> Connecting to database [remote:localhost/SystemDb] with user 'root'... >> Error: >> com.orientechnologies.orient.enterprise.channel.binary.OResponseProcessingException: >> Exception during response processing. >> >> Error: >> com.orientechnologies.orient.core.exception.OQueryParsingException: Error >> on parsing query at position #6: Error on parsing query >> Query: OUser where name = 'root' limit 1 >> -----------^ >> Error: >> com.orientechnologies.orient.core.exception.OCommandExecutionException: >> Class 'OUSER' was not found in current database >> orientdb {null}> > > > I cannot do anything with the "orientdb {null}>" prompt. I just get the > an exception with the message "Database 'null' is closed". The > root/password combo appear to be correct because I have no trouble logging > into the server. > > On Friday, May 23, 2014 11:28:02 AM UTC-4, Lvc@ wrote: > >> 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.<ini >>>>>>> t>(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.OCommandExecutorSQLDel >>>>>>> egate.parse(OCommandExecutorSQLDelegate.java:49) >>>>>>> com.orientechnologies.orient.core.sql.OCommandExecutorSQLDel >>>>>>> egate.parse(OCommandExecutorSQLDelegate.java:33) >>>>>>> com.orientechnologies.orient.core.storage.OStorageEmbedded.c >>>>>>> ommand(OStorageEmbedded.java:83) >>>>>>> com.orientechnologies.orient.core.sql.query.OSQLQuery.run(OS >>>>>>> QLQuery.java:69) >>>>>>> com.orientechnologies.orient.core.sql.query.OSQLSynchQuery.r >>>>>>> un(OSQLSynchQuery.java:82) >>>>>>> com.orientechnologies.orient.core.query.OQueryAbstract.execu >>>>>>> te(OQueryAbstract.java:29) >>>>>>> com.orientechnologies.orient.core.metadata.security.OSecurit >>>>>>> yShared.getUser(OSecurityShared.java:179) >>>>>>> com.orientechnologies.orient.core.metadata.security.OSecurit >>>>>>> yShared.authenticate(OSecurityShared.java:148) >>>>>>> com.orientechnologies.orient.core.metadata.security.OSecurit >>>>>>> yProxy.authenticate(OSecurityProxy.java:83) >>>>>>> com.orientechnologies.orient.core.db.record.ODatabaseRecordA >>>>>>> bstract.open(ODatabaseRecordAbstract.java:166) >>>>>>> com.orientechnologies.orient.core.db.ODatabaseWrapperAbstrac >>>>>>> t.open(ODatabaseWrapperAbstract.java:54) >>>>>>> com.tinkerpop.blueprints.impls.orient.OrientBaseGraph.openOr >>>>>>> Create(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. > -- --- 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.
