Details
-
Bug
-
Resolution: Fixed
-
Low
-
Discovery 3.1.1
-
None
-
1
-
Severity 3 - Minor
-
Description
Issue Summary
In order to be able to scan MySQL DB - Discovery uses Credentials saved in the tool (AES-256 Encrypted).
If the DB is running on Linux, and the Password includes an exclamation mark (or two) - the executed command will break and return -Bash: ! : event not found
This is reproducible on Data Center: not relevant
Steps to Reproduce
- In your MySQL DB - create a User with sufficient permissions to execute the commands in the following Pattern. Set a Password containing an exclamation mark '!'
- Set up the Discovery tool to Scan a Linux Host, hosting MySQL:
Enable required Linux patterns (Hostinfo) and Linux_Application_mySQL-DBs.pat - Save SSH Credentials to log on to the Host
- Save Application>MySQL credentials (created in 1. above) to log in to the DB
- Execute the scan
Expected Results
the command
sudo mysql -u $$login$$ -p$$password$$ -e "SELECT table_schema AS \"Database name\", Round(Sum(data_length + index_length) / 1024 / 1024, 0) AS \"Size (MB)\" FROM information_schema.TABLES GROUP BY table_schema;"
returns the information from the Data base
Actual Results
An error
-Bash: ! : event not found
And no Database information is gathered.
Workaround
Use a Password which does not include !