LogoLogo
Modified Version by KVOriginal Source CodeContact
KV.2020-02-01
KV.2020-02-01
  • Overviews
  • Download
  • Contact
  • User Guides
    • Chemical Inventory
      • Database
        • Database Backup and Restore
        • Best Practice for SQL Users Backup
      • Chemicals
        • Search Chemicals
        • Add a single chemical
        • Import a list of chemicals
        • Edit Chemicals
        • Edit Multiple Chemical Containers
        • Move multiple chemical containers
        • Borrow and Return Chemicals
        • Delete a chemical container
        • Delete multiple chemical containers
      • Users
        • Create a New User
        • Create a Guest Account
        • Create Multiple Users
        • Change User Password
        • Modify User Permission, Information
        • Delete a User
        • Inactivate a User
      • Storages/Locations
      • Terminal Mode
        • Set Up a Terminal User
        • Borrow and Return Chemicals
        • Change Chemical Location
        • Get Information on a Chemical
        • Dispose of Chemicals
      • TODO
    • Electronic Lab Notebook
      • Getting Started with ELN
    • Barcode Scanner Settings
      • Taotronic Wireless Barcode Scanner
      • Honeywell MS9520 Barcode Scanner
  • Installation
    • CentOS 7
    • Mac OSX
    • Windows
    • Raspbian on Raspberry pi 3B
  • Advanced Settings
    • OE Settings
      • Turn On Import and Edit function for Chemical Containers
    • Useful SQL commands
    • Hosting Server Related
    • Resources for Setting Up New Server
    • Other Supporting Programs for OE
      • Find Missing SDS
      • Find Missing Structure
    • Docker Build
  • Change Logs
    • Versions
Powered by GitBook
On this page
  • Create a database
  • Connect databases

Was this helpful?

Export as PDF
  1. User Guides
  2. Chemical Inventory

Database

PreviousChemical InventoryNextDatabase Backup and Restore

Last updated 5 years ago

Was this helpful?

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

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

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.

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

Step 2: Click the button Connect selected databases

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

Done! You can now search chemicals in other database(s) in the search page

Step 3: Click the green check mark

Step 2: Click the green check mark

✅
✅
Change `database-name` in this picture to name of the new database that you want to create
Change "database-name" in this picture to name of the database of interest
"romo" and "romo_test" are 2 databases that will be connected