Fixed. Please retry with last 1.7-SNAPSHOT. Lvc@
On 23 May 2014 19:25, Luca Garulli <[email protected]> wrote: > 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.
