Users

1
0
-1

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

Thank you very much.
A greeting.

3 answers

1
0
-1

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

regards

1
0
-1

1
0
-1

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.

Comments

Submitted by josejaviercasquero on Tue, 05/09/2017 - 14:42

Thank you
Best regards

Submitted by josejaviercasquero on Tue, 05/09/2017 - 16:27

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

Submitted by Sean McP on Tue, 05/09/2017 - 21:02

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

Submitted by josejaviercasquero on Wed, 05/10/2017 - 08:52

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

Submitted by josejaviercasquero on Wed, 05/10/2017 - 09:03

I searched the Bonita directory and there is no file named: "bonita_journal.db"

Submitted by josejaviercasquero on Wed, 05/10/2017 - 10:30

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

Notifications