New Mandator Using PHPMyAdmin
From i-doit documentation
Contents |
Step 1:
- Login to your PHPMyAdmin Frontend with root permissions
- Prepare to create a new database
- Type in the name of it
- Click create
Step 2:
- Click Import from the main tabbed navigation
Step 3:
- Select idoit_data.sql from "i-doit-directory/setup/sql"
Step 4:
- Click go button on the right side to import the database structure
Step 5:
- Switch to your System database in the left database selection
- Select table: "isys_mandator"
- Click browse to see the existing entries
Step 6:
- Click Edit, to edit an existing mandator - or click insert from the tabbed navigation on top
- In this example, we're using the way to create a new entry from an existing one
Step 6:
- Ok, now it's your turn to edit the fields for your needs:
Here is a short description of the corresponding fields:
- isys_mandator__id = Auto generated ID of this recordset, leave this blank. Remove existing id from the existing dataset
- isys_mandator__title = Name of your mandator for the GUI
- isys_mandator__description = Short description of this mandator
- isys_mandator__dir_cache = Directory for caching in i-doit-dir/temp/
- isys_mandator__dir_tpl = Your theme for users who are not logged in (Login window)
- isys_mandator__db_host = IP of your MySQL Database
- isys_mandator__db_port = Port of your MySQL Database (3306 is the default)
- isys_mandator__db_name = MySQL Database name of newly created mandator
- isys_mandator__db_user = User who has got read and write permissions to the mandator database
- isys_mandator__db_pass = Password for this user
- isys_mandator__sort = Here your can define a priority for sorting the mandator selection items in the i-doit GUI
- isys_mandator__default_lang_const = The constant for the mandator's language. Currently there are two languages included: ISYS_LANGUAGE_ENGLISH and ISYS_LANGUAGE_GERMAN.
- isys_mandator__short_lang = Short name of your language (Also displayed in GUI)
- isys_mandator__active = Status. If this mandator should be activated, set this to 1, otherwize to 0
- Select "Insert as new row" on the bottom left side to create a new entry from this existing one
- Click go to insert
Step 7
Grant access:
GRANT ALL PRIVILEGES ON `isys_mandator__db_name` . * TO 'isys_mandator__db_user'@'isys_mandator__db_host';
Step 8
- i-doit now knows how to reach your new mandator database
- You can now switch to your i-doit screen and login with admin/admin
- If you would like to add contacts/system-users which are only allowed to connect to this mandator, they need a unique username/password combination for this mandator configured in the contact section of i-doit
