Database

Create a 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
​
Connect databases
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 2yr ago