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] <javascript:>> 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>(
>>>>>>>> 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] <javascript:>.
>> 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.
