Skip to content

Instantly share code, notes, and snippets.

View cherts's full-sized avatar

Mikhail Grigorev cherts

View GitHub Profile
@cherts
cherts / openvpn-background-user-passwd.sh
Created November 14, 2019 12:18
Runing openvpn in background mode with interactive password required
#!/bin/expect -f
# Run: openvpn-background-user-passwd.sh "username" password"
set ovpn_user [lindex $argv 0]
set ovpn_passwd [lindex $argv 1]
spawn /sbin/openvpn --config /etc/openvpn/client.ovpn
expect "Enter Auth Username:" {
@cherts
cherts / zabbix_sender.sh
Created November 15, 2019 11:36
Zabbix-sender on bash
#!/bin/ash
help="Usage: zabbix_sender.sh <-z zabbix server> [-p server port] [-s host name] <-k key name> <-o key value>"
while getopts "z:p:s:k:o:h" c; do
case $c in
z)z=${OPTARG};;
p)p=${OPTARG};;
s)s=${OPTARG};;
k)k=${OPTARG};;
o)o=${OPTARG};;
h)echo $help;exit 0;;
@cherts
cherts / set_winsrv2012_params.ps1
Created December 23, 2019 08:22
Windows Server 2012
# Run this command in PowerShell
# Set timezone
%windir%\system32\tzutil.exe /s "Ekaterinburg Standard Time"
# Disable IPv6
Set-ItemProperty -Path 'HKLM:\System\CurrentControlSet\services\TCPIP6\Parameters' -name "DisabledComponents" -Value 255;
# Enable RDP
Set-ItemProperty -Path 'HKLM:\System\CurrentControlSet\Control\Terminal Server' -name "fDenyTSConnections" -Value 0;
@cherts
cherts / create_oracle_monitor_user.sql
Created December 24, 2019 12:39
User for Oracle Database monitoring via Zabbix
CREATE USER ZABBIXMON IDENTIFIED BY "zabbixmon" DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT CONNECT TO ZABBIXMON;
GRANT RESOURCE TO ZABBIXMON;
ALTER USER ZABBIXMON DEFAULT ROLE ALL;
GRANT SELECT ANY TABLE TO ZABBIXMON;
GRANT CREATE SESSION TO ZABBIXMON;
GRANT SELECT ANY DICTIONARY TO ZABBIXMON;
GRANT UNLIMITED TABLESPACE TO ZABBIXMON;
GRANT SELECT ANY DICTIONARY TO ZABBIXMON;
GRANT SELECT ON V_$SESSION TO ZABBIXMON;
@cherts
cherts / set-network-profile.ps1
Created December 25, 2019 10:26
Set connection private on Windows Server 2012 R2
$Profile = Get-NetConnectionProfile -InterfaceAlias "Ethernet 1"
$Profile.NetworkCategory = "Private"
Set-NetConnectionProfile -InputObject $Profile
@cherts
cherts / zabbix_selinux_centos8_config.txt
Last active June 29, 2024 22:54
Zabbix on CentOS 8 with SELinux
If you're running the Zabbix on CentOS 8 with SELinux enabled on it, then you must do all command on this section.
Install SELinux utilities using the dnf command below.
dnf install policycoreutils checkpolicy setroubleshoot-server
Once the installation is complete, create a new directory '~/zabbix-linux' and go into it.
mkdir -p ~/zabbix-selinux
cd ~/zabbix-selinux/
@cherts
cherts / zabbix_web_filter_clean_3415.sql
Last active January 13, 2020 11:01
Cleaning filter in web-interface from Zabbix v3.4.15
# Get zabbix user id:
SELECT u.userid FROM users u WHERE u.ALIAS='mgrigoriev';
# Cleaning filter on 'Problems' page:
DELETE FROM profiles WHERE idx='web.problem.filter.show' AND idx2='0' AND userid='XXX';
DELETE FROM profiles WHERE idx='web.problem.filter.groupids' AND userid='XXX';
DELETE FROM profiles WHERE idx='web.problem.filter.hostids' AND userid='XXX';
DELETE FROM profiles WHERE idx='web.problem.filter.application' AND idx2='0' AND userid='XXX';
DELETE FROM profiles WHERE idx='web.problem.filter.triggerids' AND userid='XXX';
DELETE FROM profiles WHERE idx='web.problem.filter.problem' AND idx2='0' AND userid='XXX';
@cherts
cherts / zabbix_web_filter_clean_444.sql
Created January 13, 2020 11:00
Cleaning filter in web-interface from Zabbix v4.4.4
# Get zabbix user id:
SELECT u.userid FROM users u WHERE u.ALIAS='mgrigoriev';
# Cleaning filter on 'Problems' page:
DELETE FROM profiles WHERE idx='web.problem.filter.show' AND idx2='0' AND userid='XXX'
DELETE FROM profiles WHERE idx='web.problem.filter.groupids' AND userid='XXX'
DELETE FROM profiles WHERE idx='web.problem.filter.hostids' AND userid='XXX'
DELETE FROM profiles WHERE idx='web.problem.filter.application' AND idx2='0' AND userid='XXX'
DELETE FROM profiles WHERE idx='web.problem.filter.triggerids' AND userid='XXX'
DELETE FROM profiles WHERE idx='web.problem.filter.name' AND idx2='0' AND userid='XXX'
@cherts
cherts / userparameter_mounted.conf
Last active February 3, 2020 05:19
Check mounted filesystem in zabbix-agent
# Test
# zabbix_agentd -t vfs.fs.mounted["/","rw"]
# Return 1 if fs / is mounted rw mode, else return 0
UserParameter=vfs.fs.mounted[*],findmnt -nr -o source -T "$1" -O "$2" > /dev/null && echo 1 || echo 0
@cherts
cherts / userparameter_systemd.conf
Created January 29, 2020 15:21
zabbix-agent systemd service discovery
UserParameter=systemd.service.discovery,sys_list=$(systemctl list-unit-files | grep ".service" | awk '{split($0,a,".service"); split($0,b," "); print "\"{#SERVICE}\":\""a[1]"\",\"{#STATE}\":\"" b[2]"\""}'); echo -n '['; for s in $sys_list; do echo -n "{"$s"},"; done | sed 's/.$//' ; echo -n ']'