Hi, i've created a new issue for this: https://github.com/orientechnologies/orientdb/issues/2379
Fix arrives in a few minutes. Lvc@ On 23 May 2014 17:46, Tommy <[email protected]> wrote: > I tried Studio and cannot get past the login screen. > > I also tried deleting the "OUser" class on the demo GratefulDeadConserts > database to determine if my database is corrupted. I get the same error > with the GratefulDeadConcerts database. My steps for that are below: > > *orientdb {remote:localhost/}> connect >> remote:localhost/GratefulDeadConcerts root* >> *295F75C29359FF358DD567ABB518E484B2E8507A6DD76665D5300B1117F51883* >> Disconnecting from remote server [remote:localhost/]... >> OKConnecting to database [remote:localhost/GratefulDeadConcerts] with >> user 'root'...OK >> *orientdb {GratefulDeadConcerts}> drop class OUser* >> Removed class in 0.166000 sec(s). >> *orientdb {GratefulDeadConcerts}> connect remote:localhost root >> 295F75C29359FF358DD567ABB518E484B2E8507A6DD76665D5300B1117F51883* >> Disconnecting from the database [GratefulDeadConcerts]... >> OKConnecting to remote Server instance [remote:localhost] with user >> 'root'...OK >> *orientdb {remote:localhost/}> connect >> remote:localhost/GratefulDeadConcerts root >> 295F75C29359FF358DD567ABB518E484B2E8507A6DD76665D5300B1117F51883* >> Disconnecting from remote server [remote:localhost/]... >> OKConnecting to database [remote:localhost/GratefulDeadConcerts] with >> user 'root'... >> >> Error: >> com.orientechnologies.orient.enterprise.channel.binary.OResponseProcessingException: >> Exception during responseprocessing. >> 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 currentdatabase >> *orientdb {null}>* >> > > It looks like the documentation no longer applies. I am worried about how > easy it is to delete the OUser class and potentially brick a database. > Thank you for working with me on this issue. > > -Tommy > > On Friday, May 23, 2014 11:35:50 AM UTC-4, Lvc@ wrote: > >> 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.OCommandExecutorSQLSel >>>>>>>>> ect.parse(OCommandExecutorSQLSelect.java:109) >>>>>>>>> com.orientechnologies.orient.core.sql.OCommandExecutorSQLSel >>>>>>>>> ect.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.OrientTransactionalGra >>>>>>>>> ph.<init>(OrientTransactionalGraph.java:58) >>>>>>>>> com.tinkerpop.blueprints.impls.orient.OrientTransactionalGra >>>>>>>>> ph.<init>(OrientTransactionalGraph.java:54) >>>>>>>>> com.tinkerpop.blueprints.impls.orient.OrientGraph.<init>(Ori >>>>>>>>> entGraph.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. > -- --- 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.
