Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Monitoring Storage Manage MySQL and Apache

Deltona

Hi guys,

Is it possible to monitor these two things on the STM server using SAM?

Regards,

Deltona

Find more posts tagged with

Accepted answers

All comments

aLTeReGo

Yes, you can use SAM to monitor both Apache and MySQL on your Storage Manager server. However, you will likely have to change some configuration settings on the Storage Manager server to do so. For example, to monitor Apache your STM must be running on Unix. You'll need to know the root SSH credentials to connect to run Perl. You'll need to enable the Apache server status page and install an additional perl module if it's not already installed. Instructions on how to configure Apache for monitoring with SAM are available here.

To monitor the MySQL database you'll simply need credentials to connect to the database, and will likely need to bind MySQL to all network adapters instead of just the loopback. The can be changed by altering the "bind-address" setting in your MySQL configuration file to 0.0.0.0. More information on the "bind-address" setting can be found here.

Both of these changes will require restarting of the server or of the Apache and MySQL services before taking effect.

Deltona

\Program Files\SolarWinds\Storage Manager Server\mysql\bin>mysql.exe -u admin
-p
Enter password: **********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1070
Server version: 5.5.12 MySQL Community Server (GPL)

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use mysql
Database changed
mysql> update user set Grant_priv='Y' where user='admin';
Query OK, 1 row affected (0.02 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> --bind-address=0.0.0.0
-> \q
Bye

\Program Files\SolarWinds\Storage Manager Server\mysql\bin>

Restarted MySQL (and all STM services). Still cannot connect to the database.

"Host 'orion.xxx.int' is not allowed to connect to this MySQL server"

This outrules there being any issue with anything other than the database itself.

Tried editing the mysql config file (mysql_config.pl) found in \Program Files\SolarWinds\Storage Manager Server\mysql\bin but didn't find anything relating to bind.

aLTeReGo

You will likely have better success asking this question in the Storage Manager forum. I'm familiar with MySQL and Apache, but my knowledge of Storage Manager is limited. I would run "netstat -an" on the Storage Manager server and ensure all network interfaces are listening on port 3306. Also, have you installed the appropriate MySQL ODBC driver on the SAM server?