Архивы Павел - Страница 148 из 274

Zabbix: Получаем по известному триггеру (triggerid) номера телефонов для оповещения

28.10.2016 Павел Грибов Из жизни

Мега запрос..

SELECT
  sendto
FROM media
WHERE userid IN (SELECT
  userid
FROM (SELECT
  users_groups.userid
FROM operations
INNER JOIN opmessage_grp
  ON opmessage_grp.operationid = operations.operationid
INNER JOIN users_groups
  ON opmessage_grp.usrgrpid = users_groups.usrgrpid
WHERE operations.actionid IN (SELECT
  actionid
FROM conditions
WHERE conditiontype = 2
AND value = 15266
UNION ALL
SELECT
  actionid
FROM conditions
WHERE conditiontype = 0
AND value IN (SELECT
  groups.groupid
FROM triggers
INNER JOIN functions
  ON triggers.triggerid = functions.triggerid
INNER JOIN items
  ON items.itemid = functions.itemid
INNER JOIN hosts
  ON hosts.hostid = items.hostid
INNER JOIN hosts_groups
  ON hosts_groups.hostid = hosts.hostid
INNER JOIN groups
  ON groups.groupid = hosts_groups.groupid
WHERE triggers.triggerid = 15266)
UNION ALL
SELECT
  actionid
FROM conditions
WHERE conditiontype = 1
AND value IN (SELECT
  hosts.hostid
FROM triggers
INNER JOIN functions
  ON triggers.triggerid = functions.triggerid
INNER JOIN items
  ON items.itemid = functions.itemid
INNER JOIN hosts
  ON hosts.hostid = items.hostid
INNER JOIN hosts_groups
  ON hosts_groups.hostid = hosts.hostid
INNER JOIN groups
  ON groups.groupid = hosts_groups.groupid
WHERE triggers.triggerid = 15266))
UNION ALL
SELECT
  opmessage_usr.userid
FROM operations
INNER JOIN opmessage_usr
  ON opmessage_usr.operationid = operations.operationid
WHERE operations.actionid IN (SELECT
  actionid
FROM conditions
WHERE conditiontype = 2
AND value = 15266
UNION ALL
SELECT
  actionid
FROM conditions
WHERE conditiontype = 0
AND value IN (SELECT
  groups.groupid
FROM triggers
INNER JOIN functions
  ON triggers.triggerid = functions.triggerid
INNER JOIN items
  ON items.itemid = functions.itemid
INNER JOIN hosts
  ON hosts.hostid = items.hostid
INNER JOIN hosts_groups
  ON hosts_groups.hostid = hosts.hostid
INNER JOIN groups
  ON groups.groupid = hosts_groups.groupid
WHERE triggers.triggerid = 15266)
UNION ALL
SELECT
  actionid
FROM conditions
WHERE conditiontype = 1
AND value IN (SELECT
  hosts.hostid
FROM triggers
INNER JOIN functions
  ON triggers.triggerid = functions.triggerid
INNER JOIN items
  ON items.itemid = functions.itemid
INNER JOIN hosts
  ON hosts.hostid = items.hostid
INNER JOIN hosts_groups
  ON hosts_groups.hostid = hosts.hostid
INNER JOIN groups
  ON groups.groupid = hosts_groups.groupid
WHERE triggers.triggerid = 15266))) AS us
GROUP BY userid)
AND mediatypeid = 5;

100

101

102

103

104

105

106

SELECT

sendto

FROM media

WHERE userid IN (SELECT

userid

FROM (SELECT

users_groups.userid

FROM operations

INNER JOIN opmessage_grp

ON opmessage_grp.operationid = operations.operationid

INNER JOIN users_groups

ON opmessage_grp.usrgrpid = users_groups.usrgrpid

WHERE operations.actionid IN (SELECT

actionid

FROM conditions

WHERE conditiontype = 2

AND value = 15266

UNION ALL

SELECT

actionid

FROM conditions

WHERE conditiontype = 0

AND value IN (SELECT

groups.groupid

FROM triggers

INNER JOIN functions

ON triggers.triggerid = functions.triggerid

INNER JOIN items

ON items.itemid = functions.itemid

INNER JOIN hosts

ON hosts.hostid = items.hostid

INNER JOIN hosts_groups

ON hosts_groups.hostid = hosts.hostid

INNER JOIN groups

ON groups.groupid = hosts_groups.groupid

WHERE triggers.triggerid = 15266)

UNION ALL

SELECT

actionid

FROM conditions

WHERE conditiontype = 1

AND value IN (SELECT

hosts.hostid

FROM triggers

INNER JOIN functions

ON triggers.triggerid = functions.triggerid

INNER JOIN items

ON items.itemid = functions.itemid

INNER JOIN hosts

ON hosts.hostid = items.hostid

INNER JOIN hosts_groups

ON hosts_groups.hostid = hosts.hostid

INNER JOIN groups

ON groups.groupid = hosts_groups.groupid

WHERE triggers.triggerid = 15266))

UNION ALL

SELECT

opmessage_usr.userid

FROM operations

INNER JOIN opmessage_usr

ON opmessage_usr.operationid = operations.operationid

WHERE operations.actionid IN (SELECT

actionid

FROM conditions

WHERE conditiontype = 2

AND value = 15266

UNION ALL

SELECT

actionid

FROM conditions

WHERE conditiontype = 0

AND value IN (SELECT

groups.groupid

FROM triggers

INNER JOIN functions

ON triggers.triggerid = functions.triggerid

INNER JOIN items

ON items.itemid = functions.itemid

INNER JOIN hosts

ON hosts.hostid = items.hostid

INNER JOIN hosts_groups

ON hosts_groups.hostid = hosts.hostid

INNER JOIN groups

ON groups.groupid = hosts_groups.groupid

WHERE triggers.triggerid = 15266)

UNION ALL

SELECT

actionid

FROM conditions

WHERE conditiontype = 1

AND value IN (SELECT

hosts.hostid

FROM triggers

INNER JOIN functions

ON triggers.triggerid = functions.triggerid

INNER JOIN items

ON items.itemid = functions.itemid

INNER JOIN hosts

ON hosts.hostid = items.hostid

INNER JOIN hosts_groups

ON hosts_groups.hostid = hosts.hostid

INNER JOIN groups

ON groups.groupid = hosts_groups.groupid

WHERE triggers.triggerid = 15266))) AS us

GROUP BY userid)

AND mediatypeid = 5;

Оставить комментарий groupid, triggerid, triggers, userid, zabbix, список пользователей

Zabbix — MySQL запрос на выборку текущих активных алертов

27.10.2016 Павел Грибов Из жизни

SELECT groups.name,
       hosts.hostid,
       hosts.host,
       triggers.description,
       triggers.comments,
       triggers.triggerid,
       triggers.priority
FROM triggers
INNER JOIN functions ON triggers.triggerid=functions.triggerid
INNER JOIN items ON items.itemid=functions.itemid
INNER JOIN hosts ON hosts.hostid=items.hostid
INNER JOIN hosts_groups ON hosts_groups.hostid=hosts.hostid
INNER JOIN groups ON groups.groupid=hosts_groups.groupid
WHERE hosts.status = 0
  AND items.status = 0
  AND triggers.status = 0
  AND triggers.priority=3
  AND triggers.value=1;

SELECT groups.name,

hosts.hostid,

hosts.host,

triggers.description,

triggers.comments,

triggers.triggerid,

triggers.priority

FROM triggers

INNER JOIN functions ON triggers.triggerid=functions.triggerid

INNER JOIN items ON items.itemid=functions.itemid

INNER JOIN hosts ON hosts.hostid=items.hostid

INNER JOIN hosts_groups ON hosts_groups.hostid=hosts.hostid

INNER JOIN groups ON groups.groupid=hosts_groups.groupid

WHERE hosts.status = 0

AND items.status = 0

AND triggers.status = 0

AND triggers.priority=3

AND triggers.value=1;

Выбираем кто из пользователей Zabbix видит хост:

SELECT  
    usrgrp.usrgrpid ,  
    usrgrp.name  AS  user_group ,  
    groups.name  as  host_group , 
    host 
FROM  users  
    JOIN users_groups   ON  users.userid  =  users_groups.userid  
    JOIN usrgrp ON  users_groups.usrgrpid  =  usrgrp.usrgrpid  
    JOIN rights  ON  usrgrp.usrgrpid  =  rights.groupid  
    JOIN groups ON  rights.id  =  groups.groupid  
    JOIN hosts_groups  ON  groups.groupid  =  hosts_groups.groupid  
    JOIN hosts on  hosts_groups.hostid  =  hosts.hostid
    where hosts.hostid=1025;

SELECT

usrgrp.usrgrpid ,

usrgrp.name AS user_group ,

groups.name as host_group ,

host

FROM users

JOIN users_groups ON users.userid = users_groups.userid

JOIN usrgrp ON users_groups.usrgrpid = usrgrp.usrgrpid

JOIN rights ON usrgrp.usrgrpid = rights.groupid

JOIN groups ON rights.id = groups.groupid

JOIN hosts_groups ON groups.groupid = hosts_groups.groupid

JOIN hosts on hosts_groups.hostid = hosts.hostid

where hosts.hostid=1025;

Оставить комментарий alert, mysql, triggers, zabbix

Восстановление пароля в Remmina

21.10.2016 Павел Грибов Linux

Идем в папку .remmina
В файле remmina.pref ищем secret:

cat remmina.pref | grep secret

1

cat remmina.pref | grep secret
В файле *.remmina ищем password:

cat 1451037668335.remmina | grep password

1

cat 1451037668335.remmina | grep password

Создаем скрипт на питоне, в него подставляем secret и password:

#!/usr/bin/python
from Crypto.Cipher import DES3
import base64
secret = base64.decodestring('тут секрет')
key = secret[:24]
iv = secret[24:]
EEpwd = 'тут пароль'
DEpwd = base64.decodestring(EEpwd)
DDpwd = DES3.new(key, DES3.MODE_CBC, iv).decrypt(DEpwd)
print "Decoded (Decrypted ( PWD ) ) : ",DDpwd

#!/usr/bin/python

from Crypto.Cipher import DES3

import base64

secret = base64.decodestring('тут секрет')

key = secret[:24]

iv = secret[24:]

EEpwd = 'тут пароль'

DEpwd = base64.decodestring(EEpwd)

DDpwd = DES3.new(key, DES3.MODE_CBC, iv).decrypt(DEpwd)

print "Decoded (Decrypted ( PWD ) ) : ",DDpwd

Оставить комментарий decode, password, remmina, восстановить, пароль

Mysql выгрузка дампа без данных

20.10.2016 Павел Грибов MySQL

Следующая команда выгрузит дамп базы данных с триггреми, процедурами, таблицами НО! без данных в таблицах.

mysqldump --routines --no-data --no-create-db --skip-opt billing > onlytriggers.sql

1	mysqldump --routines --no-data --no-create-db --skip-opt billing > onlytriggers.sql

Оставить комментарий

Пример клиента WebSocket на PHP

19.10.2016 Павел Грибов PHP

Если клиент на javascript для WebSocket это весьма простая вещь, то на PHP чуточку сложнее. Готовых примеров в сети раз-два и обчелся. Вот пример одной из реализаций:

$local = "http://грибовы.рф";		    
$data = "Скрипт обработки выбора фильтра абонентом";  
$key="woeudhцукацук цук пупркеркеуенakcslerug;er";

	$host=$row2["mysql_ip"];
	$port = 8000;
	$head = "GET / HTTP/1.1"."\r\n".
		"Upgrade: WebSocket"."\r\n".
		"Connection: Upgrade"."\r\n".
		"Origin: $local"."\r\n".
		"Host: $host"."\r\n".
		"Sec-WebSocket-Key: asd245345235d6asd6as7d"."\r\n".
		"Content-Length: ".strlen($data)."\r\n"."\r\n";
	
	$sock = fsockopen($host, $port, $errno, $errstr, 2);
	fwrite($sock, $head ) or die('error:'.$errno.':'.$errstr);
	$headers = fread($sock, 2000);
	//echo $headers;
	fwrite($sock, hybi10Encode($data)) or die('error:'.$errno.':'.$errstr);
	$wsdata = fread($sock, 2000);
	//var_dump(hybi10Decode($wsdata));
	//echo "--send\n";    
	    $mess["key"]=$key;
	    $mess["command"]="UpdateFilterContent";
	    fwrite($sock, hybi10Encode(json_encode($mess))) or die('error:'.$errno.':'.$errstr);
	//echo "--read\n";        
	$wsdata = fread($sock, 2000);
	//var_dump(hybi10Decode($wsdata));
	fclose($sock);

$local = "http://грибовы.рф";

$data = "Скрипт обработки выбора фильтра абонентом";

$key="woeudhцукацук цук пупркеркеуенakcslerug;er";

$host=$row2["mysql_ip"];

$port = 8000;

$head = "GET / HTTP/1.1"."\r\n".

"Upgrade: WebSocket"."\r\n".

"Connection: Upgrade"."\r\n".

"Origin: $local"."\r\n".

"Host: $host"."\r\n".

"Sec-WebSocket-Key: asd245345235d6asd6as7d"."\r\n".

"Content-Length: ".strlen($data)."\r\n"."\r\n";

$sock = fsockopen($host, $port, $errno, $errstr, 2);

fwrite($sock, $head ) or die('error:'.$errno.':'.$errstr);

$headers = fread($sock, 2000);

//echo $headers;

fwrite($sock, hybi10Encode($data)) or die('error:'.$errno.':'.$errstr);

$wsdata = fread($sock, 2000);

//var_dump(hybi10Decode($wsdata));

//echo "--send\n";

$mess["key"]=$key;

$mess["command"]="UpdateFilterContent";

fwrite($sock, hybi10Encode(json_encode($mess))) or die('error:'.$errno.':'.$errstr);

//echo "--read\n";

$wsdata = fread($sock, 2000);

//var_dump(hybi10Decode($wsdata));

fclose($sock);

Вспомогательные функции:

» Читать далее

Оставить комментарий php, WebSocket, websocket client

« 1 … 146 147 148 149 150 … 274 »

Пн	Вт	Ср	Чт	Пт	Сб	Вс
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31