# Users

**URL:** <https://community.ofelia.com/t/users/8456>\
**Category:** Q&A\
**Created:** [9 May 2017 07:11 UTC](https://community.ofelia.com/t/users/8456 "2017-05-09T07:11:58Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![josejaviercasquero](https://avatars.discourse-cdn.com/v4/letter/j/46a35a/32.png) [@josejaviercasquero](https://community.ofelia.com/u/josejaviercasquero)\
**Post date:** [9 May 2017 07:11 UTC](https://community.ofelia.com/t/users/8456/1 "2017-05-09T07:11:58Z")

</div>

Where are the users of the bonita portal saved? In what database and in what table?

Thank you very much.  
A greeting.

---

<div class="post-metadata">

**Author:** ![Sean\_McP](https://dub1.discourse-cdn.com/flex013/user_avatar/community.ofelia.com/sean_mcp/32/932_2.png) [@Sean\_McP](https://community.ofelia.com/u/Sean_McP)\
**Post date:** [9 May 2017 10:14 UTC](https://community.ofelia.com/t/users/8456/2 "2017-05-09T10:14:26Z")

</div>

The users are in database …\bonita\_journal.db and the relevant tables are

- Group\_
- Profile
- Profileentry (not sure about this one…
- Profilemember
- Role
- User\_
- User\_ContactInfo
- User\_Login
- User\_Membership

regards  
Seán

_PS: As this reply answers your question, please mark as resolved._

---

<div class="post-metadata">

**Author:** ![Sean\_McP](https://dub1.discourse-cdn.com/flex013/user_avatar/community.ofelia.com/sean_mcp/32/932_2.png) [@Sean\_McP](https://community.ofelia.com/u/Sean_McP)\
**Post date:** [10 May 2017 21:05 UTC](https://community.ofelia.com/t/users/8456/3 "2017-05-10T21:05:47Z")

</div>

Yes it looks like you did something wrong, deinstall and reinstall much better and then try again.

regards

---

<div class="post-metadata">

**Author:** ![sanaammar43\_1421819](https://avatars.discourse-cdn.com/v4/letter/s/3be4f8/32.png) [@sanaammar43\_1421819](https://community.ofelia.com/u/sanaammar43_1421819)\
**Post date:** [30 July 2020 16:32 UTC](https://community.ofelia.com/t/users/8456/4 "2020-07-30T16:32:23Z")

</div>

Where are the users of the bonita saved? In what database and in what table??&nbsp;

---

<div class="post-metadata">

**Author:** ![josejaviercasquero](https://avatars.discourse-cdn.com/v4/letter/j/46a35a/32.png) [@josejaviercasquero](https://community.ofelia.com/u/josejaviercasquero)\
**Post date:** [9 May 2017 12:42 UTC](https://community.ofelia.com/t/users/8456/5 "2017-05-09T12:42:59Z")

</div>

Thank you  
Best regards

---

<div class="post-metadata">

**Author:** ![josejaviercasquero](https://avatars.discourse-cdn.com/v4/letter/j/46a35a/32.png) [@josejaviercasquero](https://community.ofelia.com/u/josejaviercasquero)\
**Post date:** [9 May 2017 14:27 UTC](https://community.ofelia.com/t/users/8456/6 "2017-05-09T14:27:02Z")

</div>

In my Bonita database I have these tables (I put them all down)  
The tables that you said I do not have (the USERS table is of users that access the BBDD), I need the table of users that enter the portal of Bonita  
I have a free version of Bonita, is that the problem?

CATALOGS  
COLLATIONS  
COLUMNS  
COLUMN\_PRIVILEGES  
CONSTANTS  
CONSTRAINTS  
CROSS\_REFERENCES  
DOMAINS  
FUNCTION\_ALIASES  
FUNCTION\_COLUMNS  
HELP  
INDEXES  
IN\_DOUBT  
LOCKS  
QUERY\_STATISTICS  
RIGHTS  
ROLES  
SCHEMATA  
SEQUENCES  
SESSIONS  
SESSION\_STATE  
SETTINGS  
TABLES  
TABLE\_PRIVILEGES  
TABLE\_TYPES  
TRIGGERS  
TYPE\_INFO  
USERS  
VIEWS

---

<div class="post-metadata">

**Author:** ![Sean\_McP](https://dub1.discourse-cdn.com/flex013/user_avatar/community.ofelia.com/sean_mcp/32/932_2.png) [@Sean\_McP](https://community.ofelia.com/u/Sean_McP)\
**Post date:** [9 May 2017 19:02 UTC](https://community.ofelia.com/t/users/8456/7 "2017-05-09T19:02:39Z")

</div>

That is not the Bonita Database, that is a database that you’ve created called bonita\_journal\_etc.

This is a common problem when accessing h2 databases,

for your connection string you must only call it _bonita\_journal.db_ do not call it _bonita\_journal.db.h2.db_

The h2 driver adds the _h2.db_ automatically.

So if you open the folder

{{ bonitaInstallDir }}\workspace\default\h2\_database

you will find you’ve created a invalid empty database called _bonita\_journal.db.h2.db.h2.db_ you can safely delete this

regards  
Seán

---

<div class="post-metadata">

**Author:** ![josejaviercasquero](https://avatars.discourse-cdn.com/v4/letter/j/46a35a/32.png) [@josejaviercasquero](https://community.ofelia.com/u/josejaviercasquero)\
**Post date:** [10 May 2017 06:52 UTC](https://community.ofelia.com/t/users/8456/8 "2017-05-10T06:52:08Z")

</div>

Hi,  
I’m having trouble accessing the database, sometimes it works for me sometimes, what file should I run to open the database?

I have many same files on directories called “h2-1.3.175.jar” and “h2-1.3.170.jar”

In the following path: “{{bonitaInstallDir}} \ workspace \ default \ h2\_database” There is no file “bonita\_journal.db”, there is only the file “bonita\_journal.db.h2.db” that I just deleted as you told me

What is the fastest and easiest way to open the Bonita database?

Thank you very much  
Best regards

---

<div class="post-metadata">

**Author:** ![josejaviercasquero](https://avatars.discourse-cdn.com/v4/letter/j/46a35a/32.png) [@josejaviercasquero](https://community.ofelia.com/u/josejaviercasquero)\
**Post date:** [10 May 2017 07:03 UTC](https://community.ofelia.com/t/users/8456/9 "2017-05-10T07:03:56Z")

</div>

I searched the Bonita directory and there is no file named: “bonita\_journal.db”

---

<div class="post-metadata">

**Author:** ![josejaviercasquero](https://avatars.discourse-cdn.com/v4/letter/j/46a35a/32.png) [@josejaviercasquero](https://community.ofelia.com/u/josejaviercasquero)\
**Post date:** [10 May 2017 08:30 UTC](https://community.ofelia.com/t/users/8456/10 "2017-05-10T08:30:29Z")

</div>

After deleting the file you told me, it does not work for me. I can not log in to localhost, nor can I run the Bonita portal. I’m going to uninstall and reinstall Bonita on my machine

---

<div class="post-metadata">

**Author:** ![romualdo.s.rs](https://avatars.discourse-cdn.com/v4/letter/r/9fc348/32.png) [@romualdo.s.rs](https://community.ofelia.com/u/romualdo.s.rs)\
**Post date:** [26 June 2017 13:49 UTC](https://community.ofelia.com/t/users/8456/11 "2017-06-26T13:49:27Z")

</div>

And is it possible to select this data in a connector? And how can I select these data and display them to check the users already registered?
