Database
1. Go to your Open Enventory Login page on your web browser
2. On the Login page, fill in the following info:
-
Database
: name for the new database
- Username
: root
- Password
: your mysql root password
Change `database-name` in this picture to name of the new database that you want to create
3. Open Enventory will then create a new empty database
This allows for users in one database to see chemicals in another database and/or vice versa.
Note: in the default setting, OE only allows user in one database to see if other databases have chemical(s) but not revealing the chemical's location.
If you want to let users in one database to be able to see location of chemicals in another database, after connecting the databases, please follow the instruction in this link.
1. Go to your Open Enventory Login page on your web browser
2. Log into your database of interest using root as
Username
and your mysql root password as Password

Change "database-name" in this picture to name of the database of interest
3. Go to
Settings
on Top menus:
4. On the left side menu, choose
Manage databases
:
5. There are two types of connections:
- 2-way connections: users in one database can see/search chemicals in another database AND vice versa
- 1-way connection: users in one database can see/search chemicals in another database BUT NOT vice versa)
choose the desired connection and follow the instruction below.
2-way connection
1-way connection
Step 1: Choose as databases that you want to connect (hold Ctrl while choosing). You can choose more than 2. Click
select all
if you want to connect all databases
"romo" and "romo_test" are 2 databases that will be connected
Step 2: Click the button
Connect selected databases

Step 3: Click the green check mark
✅

Using the rubric table, the databases with name in the bold format and listed horizontally in the first row of the table will be able to see/search chemical in database(s) (list vertically in the first column) that has checked check box
For example:
In the picture below, users in
romo
database will be able to see/search chemicals in romo_test
database BUT users in romo_test
database will NOT be able to see/search any chemicals in romo
database.
Step 1: using the info above, make the connection of interest by checking the check boxes
Step 2: Click the green check mark
✅
Done! You can now search chemicals in other database(s) in the search page
Last modified 3yr ago