Configuring a Database
FlexNet Code Insight 6.13.3
To configure a database for FlexNet Code Insight, perform the following steps.
To configure a database:
|
1.
|
Use an existing database or create a new database and schema for use by FlexNet Code Insight. Make sure your user has the right privileges to access the schema. |
|
2.
|
Ensure that the schema name conforms to the following guidelines: |
|
•
|
The first character of the database name is alphabetic. |
|
•
|
The database name only contains alphanumeric characters or the following special characters: _ $ #. |
|
•
|
Do not use dashes (-) in the database schema name. |
|
3.
|
Ensure that the database server is configured to accept connections from the client machines that FlexNet Code Insight is using (both core and Scan Engine servers). For example, in MySQL with a database user named FlexNet Code Insight, this can be accomplished with the following command. |
GRANT ALL PRIVILEGES on *.* to 'CodeInsight'@'%' with GRANT OPTION;
|
4.
|
Ensure you select the correct character set (UTF-8) and storage engine (InnoDB). |
|
5.
|
To check if you have the correct character set, use the following database command. |
SHOW VARIABLES LIKE 'character%';
|
6.
|
Make sure the character_set_database has utf8 in the Value column. |
|
7.
|
To check if you have InnoDB set up, use the following database command. |
SHOW ENGINES;
|
8.
|
The InnoDB row should show YES or DEFAULT in the Support column. |
Open topic with navigation