Change the file /etc/mysql/conf.d/mysql.cnf
(require elevated privileges) adding
[mysqld]
general_log = on
general_log_file=/var/log/query
If you change the filename, keep it consistent in the following steps !
# this config file is an example of config file for handle | |
# remote host with nrpe insted of the new ncpa | |
# save this file on the controller, NOT on the controlled machine | |
define host { | |
host_name Server 212 | |
address 212.271.149.146 | |
check_command check-host-alive | |
max_check_attempts 5 |
#!/bin/bash | |
cd /var/www/credit-sales | |
git status --porcelain | grep php >> /dev/null | |
if [ $? -gt 0 ]; then | |
echo "CRITICAL, folder credit-sales modified" | |
exit 2 | |
fi |
#### See https://support.nagios.com/forum/viewtopic.php?f=7&t=53059 | |
# Save the content of the file into /usr/local/nagios/libexec/custom_check_mem | |
# - ownership root:nagios | |
# - permissions 755 | |
#!/bin/bash | |
# Script to check real memory usage | |
# L.Gill 02/05/06 - V.1.0 | |
# ------------------------------------------ | |
# ######## Script Modifications ########## |
# Edit the following file on nagios controller | |
# | |
# add an entry like | |
define contact { | |
contact_name user_nick_name | |
use generic-contact | |
alias Realtebo |
define host { | |
host_name HostNameWithoutSpecialChars | |
hostgroups NCPA | |
address 139.xx.yyy.zzzz | |
check_command check_ncpa!-t 'community_string' -P 5693 -M system/agent_version | |
max_check_attempts 5 | |
check_interval 5 | |
retry_interval 1 | |
check_period 24x7 | |
contacts nagiosadmin |
#!/bin/bash | |
# Download and run | |
# curl https://gist.githubusercontent.com/realtebo/3451070eba5a55186afb686d1690abd2/raw/install_ansible.sh?_=$(date +%s) | bash | |
sudo apt-get update && sudo apt-get install software-properties-common -y | |
sudo apt-add-repository universe -y | |
sudo apt-add-repository ppa:ansible/ansible -y | |
sudo apt-get update && sudo apt-get install ansible python-pip -y | |
pip install "pywinrm>=0.3.0" |
# Nota - Se eseguendo dpk c'è un errore di comandi non trovati | |
# su | |
# nano /root/.bashrc | |
# appendero in fondo | |
# export PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin | |
# salvare | |
# source /root/.bashrc | |
su |
############################################################################################################## | |
# https://docs.ansible.com/ansible/latest/user_guide/windows_setup.html#upgrading-powershell-and-net-framework | |
# | |
# The username and password parameters are stored in plain text in the registry. Make sure the Remove-Item | |
# commands are run, check them after the script finishes to ensure no credentials are still stored on the host. | |
# | |
# The ConfigureRemotingForAnsible.ps1 script is intended for training and development purposes only and | |
# should not be used in a production environment, since it enables settings (like Basic authentication) | |
# that can be inherently insecure. | |
############################################################################################################## |