MySQL

This chapter contains an example of a basic Fudo Enterprise configuration, to monitor SQL queries to a remote MySQL database server.

In this scenario, the user connects to a MySQL database using individual login and password. When establishing the connection with the remote server, Fudo Enterprise substitutes the login and the password with the previously defined values: root/password (authorization modes are described in the User authorization modes section).

Warning

Note that the MySQL server caching_sha2_password plugin isn’t supported by Fudo Enterprise. Supportable MySQL plugins by Fudo Enterprise are mysql_native_password and mysql_old_password. Server plugin should be set to mysql_native_password in /etc/mysql/mysql.conf.d/mysqld.cnf and a User object is created with mysql_native_password plugin.

Prerequisites

The following description assumes that the system has been already initiated. For more information on the initiation procedure refer to the System initiation topic.

Configuration

Adding a server

Server is a definition of the IT infrastructure resource, which can be accessed over one of the specified protocols.

1. Select Management > Servers.

2. Click + Add server.

3. Provide essential configuration parameters:

Parameter	Value
General
Name	mysql_server
Description
Blocked
Protocol	MySQL
Bind address	Any
Permissions
Granted users
Destination
Address	10.0.1.35
Mask	32
Port	3306

4. Click Save or Save and close

Adding a user

User defines a subject entitled to connect to servers within monitored IT infrastructure. Detailed object definition (i.e. unique login and domain combination, full name, email address etc.) enables precise accountability of user actions when login and password are substituted with a shared account login credentials.

1. Select Management > Users.

2. Click Add.

3. Provide essential user information:

Parameter	Value
General
Name	john_smith
Role	user
Blocked
Account validity	Indefinite
Settings Tab
Safes
Authentication section
Authentication failures
Enforce password complexity
Add authentication method:	Static password
Password	john
User Data Tab
Fudo domain
AD Domain
LDAP Base
Full name	John Smith
Email	john@smith.com
Organization
Phone
Permissions Tab
Granted users

4. Click Save.

Adding a listener

Listener determines server connection mode (proxy, gateway, transparent, bastion) as well as its specifics.

1. Select Management > Listeners.

2. Click Add.

3. Provide essential configuration parameters:

Parameter	Value
General
Name	mysql_listener
Blocked
Protocol	Mysql
Permissions
Granted users
Connection
Mode	proxy
Local address	10.0.150.151
Port	3306

4. Click Save.

Adding an account

Account defines the privileged account existing on the monitored server. It specifies the actual login credentials, user authentication mode: anonymous (without user authentication), regular (with login credentials substitution) or forward (with login and password forwarding); password changing policy as well as the password changer itself.

1. Select Management > Accounts.

2. Click Add.

3. Provide essential configuration parameters:

Parameter	Value
General
Name	admin_mysql_server
Blocked
Type	regular
Session recording	all
Notes
Data retention
Override global retention settings
Delete session data after	61 days
Permissions
Granted users
Server
Server	mysql_server
Credentials
Domain
Login	root
Replace secret with	with password
Password	password
Repeat password	password
Password change policy	Static, without restrictions

4. Click Save.

Defining a safe

Safe directly regulates user access to monitored servers. It specifies available protocols’ features, policies and other details concerning users and servers relations.

1. Select Management > Safes.

2. Click Add.

3. Provide essential configuration parameters:

Parameter	Value
General
Name	mysql_safe
Blocked
Notifications
Login reason
Require approval
Policies
Note access	No access
Protocol functionality
RDP
SSH
VNC

4. Select Users tab.

5. Click Add user.

6. Find John and click ..

7. Click OK.

8. Select Accounts tab.

9. Click Add account.

10. Find the admin_mysql_server object and click ..

11. Click OK.

12. Click in the Listeners column.

13. Find the mysql_listener object and click ..

14. Click OK.

15. Click Save.

Establishing Connection with a MySQL Database

1. Launch a command line interface client.

2. Enter mysql -h 10.0.150.151 -u john_smith -p, to connect to the database server.

3. Enter the user’s password.

4. Continue browsing the database contents using SQL queries.

Viewing User Session

1. Open a web browser and go to the Fudo Enterprise administration page.

2. Enter user login and password to log in to Fudo Enterprise administration panel.

3. Select Management > Sessions.

4. Find John Smith’s session and click i.

Related topics:

• Quick start - SSH connection configuration

• Quick start - RDP connection configuration

• Quick start - HTTP connection configuration

• Quick start - Telnet connection configuration

• Requirements

• Data model