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