ZͶ¸å|Zabbix+×Ô¶¨Òå½Å±¾ÊµÏÖÍøÔªµÇ¼¼ì²é×Ô¶¯»¯

--²éѯÍøÔªÐÅÏ¢
SELECT
   a.ch_name,d.en_name as netype,f.en_name as en_city,e.en_name as nevendor,b.equipe_ip,b.port,c.user_name,c.password
   ,case g.role_id when 3 then 'root' else 'tszc' end as role,CASE b.description WHEN 'SSH2' THEN 'ssh' ELSE 'telnet' END AS dlxy
   ,case b.description WHEN 'SSH2' THEN 'ssh -p '||b.port||' '||c.user_name||'@'||b.equipe_ip else 'telnet '||b.equipe_ip||' '||b.port end as cmd,
   f.ch_name as ch_city,b.max_connection as rversion
FROM
   tbl_xxxx_bisic a,tbl_xxxx_address b,tbl_xxxx_user c,tbl_xxxx_dictionary d,tbl_xxxx_dictionary e,tbl_xxxx_dictionary f,tbl_xxxx_user g 
WHERE
   a.entity_id = b.equipe_id 
   and a.entity_id = b.equipe_id
   AND b.entity_id = c.equipe_address_id 
   AND g.equipe_id = b.equipe_id
   AND c.entity_id = g.port_user_id
   AND d.entity_id = a.equipe_type_id AND e.entity_id = a.supplier_id AND f.entity_id = a.city_id 
--°´ÍøÔªÀàÐÍ
   AND d.en_name in('DNS') AND e.en_name in ('HW')

[tmn@necpproxy1 ddes]$ ./ddes 5F3D63C8A82FEDDF
xxxxxxxx

[tmn@necpproxy1 ~]$ ssh -p 22 xxxj@10.xxx.xxx.74
Password:
Last login: Wed Jul  1 16:36:00 2020 from 1x.xxx.xxx.134
 Authorized users only. All activity may be monitored and reported
xxxj@CXXXX09BXX:~>

xxxj@CXXXX09BXX:~> exit
logout
Connection to 10.xxx.xxx.74 closed.

[tmn@necpproxy1 bin]$ neloginrule CXXXX09BXX root
SELECT entity_id,version,equipe_type_id,supplier_id FROM tbl_xxxx_bisic where en_name='CXXXX09BXX';
SELECT en_name from tbl_xxxxnary where entity_id=26;
SELECT en_name from tbl_xxxxnary where entity_id=66;
select b.equipe_ip,b.port,c.user_name,c.password from tbl_role_xxxxuser a,tbl_xxxxress b,tbl_xxxx_user c where a.role_id=3 and a.equipe_id=72984 and a.equipe_address_id=b.entity_id and a.port_user_id=c.entity_id;

========= ne information ==========
name = CXXXX09BXX
type = DNS
vendor = HW
version = 3
username = xxxj
password = Xxxxxxxx
ip = 10.xxx.xxx.74
port = 22

========= auto login rules information ==========
index = 0       status = 1      nextstep = 0    recvmsg = ~>


exitcmd = 
exit

#!/usr/bin/sh
#set +x
if [ $# -lt 1 ]
then
echo "cp: Insufficient arguments ($#)" 
echo "Usage: $0 nename or $0 nename username" 
exit 1
fi
if [ $# -eq 1 ]
then
neloginrule $1 root
else
neloginrule $1 $2
fi
nename=`cat ./telnet/nename.tel`
chmod +x $nename
cat $nename
echo ''
$nename

[tmn@necpproxy1 bin]$ telnet.sh XXL3
SELECT entity_id,version,equipe_type_id,supplier_id FROM tbl_xxxx_bisic where en_name='XXL3';
SELECT en_name from tbl_xxxxnary where entity_id=43;
SELECT en_name from tbl_xxxxnary where entity_id=44;
select b.equipe_ip,b.port,c.user_name,c.password from tbl_xxxx_port_user a,tbl_xxxx_address b,tbl_xxxx_user c where a.role_id=3 and a.equipe_id=332291 and a.equipe_address_id=b.entity_id and a.port_user_id=c.entity_id;

========= ne information ==========
name = XXL3
type = LSTP
vendor = ALCATEL
version = 23
username = xxxxj
password = Xxxxxxxx
ip = 10.xxx.xxx.70
port = 23

========= auto login rules information ==========
index = 0       status = 0      nextstep = 1    recvmsg = ogin:
sendmsg = 
xxxxj


index = 1       status = 0      nextstep = 2    recvmsg = assword:
sendmsg = 
Xxxxxxxx


index = 2       status = 0      nextstep = 3    recvmsg = 
sendmsg = 
smv


index = 3       status = 0      nextstep = 4    recvmsg = >
sendmsg = 
sgcmd


index = 4       status = 0      nextstep = 5    recvmsg = Userid:
sendmsg = 
xxxxjzz


index = 5       status = 0      nextstep = 6    recvmsg = Password:
sendmsg = 
Xxxxxxxx


index = 6       status = 0      nextstep = 7    recvmsg = >
sendmsg = 
MM


index = 7       status = 0      nextstep = 8    recvmsg = >MM
sendmsg = 




index = 8       status = 1      nextstep = 0    recvmsg = <


exitcmd = 
exit
exit
exit

telnet 10.xxx.xxx.70 23
Trying 10.xxx.xxx.70...
Connected to 10.xxx.xxx.70.
Escape character is '^]'.


Linux 2.6.32-504.12.2.el6.x86_64 (oamce-2a) (09:14 on Thursday, 02 July 2020)


login: xxxxj
Password: 
Last login: Thu Jul  2 08:31:27 from 1x.xxx.xxx.134
***************************************


    OAM  XXL3  105_0872D01.3.8  oamce-2       


***************************************
***This session is being logged***
xxxxj@oamce-2:~$smv




**************************************************


 Welcome to the A1000 S12 System Management View!


**************************************************




XXL3:XXXXXXGR-1-B:/home/xxxxj>sgcmd


Registering to GUIServer ......
Userid: xxxxjzz
Password: 
Done!


    >MM
    XXL3                2020-07-02    09:14:32  Thu
    <exit


Terminated
XXL3:XXXXXXGR-1-B:/home/xxxxj>exit
exit
xxxxj@oamce-2:~$exit
                    logout
Connection closed by foreign host.
[tmn@necpproxy1 bin]$

[tmn@necpproxy1 ~]$ /xx/xxx/xxxhp/necp_login_test/getfile_proxy -nename APP-HXXXXX-XXXXX012 -username root
»á»°ºÅ:
Êä³öÐÅÏ¢:TimePoint:2020-07-02 10:21:05 PID 90643 APP-HXXXXX-XXXXX012 µÇ¼ÍøԪʧ°Ü!ʧ°ÜÂë:-30

#!/bin/bash
tstr=`date '+%y%m%d%H%M'`
. /u1/tmn/nechk/nechk.env


if [ $# -lt 2 ]
then
echo "cp: Insufficient arguments ($#)"
echo "Usage: sh $0 object_type vendor_type"
exit 1
fi


BIN_DIR=/xx/xxx/xxxhp/necp_login_test
DOC_DIR=${BIN_DIR}/doc
CFG_FILE=${DOC_DIR}/$1_$2_${tstr}.unl


if [ $2 = "ALL" ];
then
if [ $1 = "ALL" ];
then
#wherec="AND d.en_name in('MSC','MME','PGW','FW','GMSC','TMSC','HSS_BE','HSS_UMM','HSS_FE')"
wherec="AND d.en_name in('AGCF','CG','CL','CSCF','DNS','DRA','EDS','EMSC','FW','GMGW','GMSC','GWU','HSS_BE','HSS_FE','HSS_UMM','HSTP','IBCF','IMSCG','LSTP','MGCF','MGW','MME','MSC','NPHSS','NPMSC','PCRF','PGW','SBC','SPR','SW','TAS','TMSC','VC','vCG','vGWC','vMME','vPCRF')"
else
wherec="AND d.en_name in('$1')"
fi
else
wherec="AND d.en_name in('$1') AND e.en_name in ('$2');"
fi


#µ¼³öÍøÔªÐèÒª²âÊԵǼµÄÍøÔªÐÅÏ¢£¬°´ÍøÔª³§É̼°É豸ÀàÐÍ
dbaccess >/dev/null 1>/dev/null 2>&1 << !
database $DB_UNI;
unload to ${CFG_FILE}
SELECT
  a.ch_name,case g.role_id when 3 then 'root' else 'tszc' end as role,e.en_name,c.user_name,d.en_name,b.equipe_ip
FROM
  tbl_xxxx_bisic a,tbl_xxxx_address b,tbl_xxxx_user c,tbl_xxxxnary d,tbl_xxxxnary e,tbl_data_dictionary f,tbl_xxxx_user g
WHERE
  a.entity_id = b.equipe_id 
  and a.entity_id = b.equipe_id
  AND b.entity_id = c.equipe_address_id
  AND g.equipe_id = b.equipe_id
  AND c.entity_id = g.port_user_id
  AND d.entity_id = a.equipe_type_id AND e.entity_id = a.supplier_id AND f.entity_id = a.city_id
  AND not(d.en_name = 'FW' and e.en_name = 'ERICSSON')
  AND not(d.en_name = 'MME' and e.en_name = 'HW' and g.role_id = 2)
  AND a.version <> 'ÍËÍø'
  $wherec;
!
COUNT=`cat ${CFG_FILE} | wc -l`
INDEX=0
echo '{"data":['
cat ${CFG_FILE} | while read LINE; do
nename=`echo ${LINE} | awk -F\| '{print $1}'`
rolename=`echo ${LINE} | awk -F\| '{print $2}'`
supplier=`echo ${LINE} | awk -F\| '{print $3}'`
username=`echo ${LINE} | awk -F\| '{print $4}'`
netype=`echo ${LINE} | awk -F\| '{print $5}'`
ipaddress=`echo ${LINE} | awk -F\| '{print $6}'`
echo -n '{"{#NENAME}":"'${nename}'","{#ROLENAME}":"'${rolename}'","{#USERNAME}":"'${username}'","{#SUPPLIER}":"'${supplier}'","{#NETYPE}":"'${netype}'","{#IPADDR}":"'${ipaddress}'"}'
INDEX=`expr $INDEX + 1`
if [ $INDEX -lt $COUNT ]; then
echo ','
fi
done
echo ']}'


find /xx/xxx/xxxhp/necp_login_test/doc -type f -mtime +7 -exec rm -f {} \;

[tmn@necpproxy1 ~]$ /xx/xxx/xxxhp/necp_login_test/check_nename.sh TAS ZTE
{"data":[
{"{#NENAME}":"CXXXXXXXXS7BXX","{#ROLENAME}":"root","{#USERNAME}":"TSZC","{#SUPPLIER}":"ZTE","{#NETYPE}":"TAS","{#IPADDR}":"1x.xxx.232.76"},
{"{#NENAME}":"CXXXXXXXXS5BXX","{#ROLENAME}":"root","{#USERNAME}":"TSZC","{#SUPPLIER}":"ZTE","{#NETYPE}":"TAS","{#IPADDR}":"1x.xxx.130.12"},
{"{#NENAME}":"CXXXXXXXXS4BXX","{#ROLENAME}":"root","{#USERNAME}":"TSZC","{#SUPPLIER}":"ZTE","{#NETYPE}":"TAS","{#IPADDR}":"1x.xxx.227.235"},
{"{#NENAME}":"CXXXXXXXXS9BXX","{#ROLENAME}":"root","{#USERNAME}":"TSZC","{#SUPPLIER}":"ZTE","{#NETYPE}":"TAS","{#IPADDR}":"1x.xxx.191.108"},
{"{#NENAME}":"CXXXXXXXXS6BXX","{#ROLENAME}":"root","{#USERNAME}":"TSZC","{#SUPPLIER}":"ZTE","{#NETYPE}":"TAS","{#IPADDR}":"1x.xxx.191.12"},
{"{#NENAME}":"CXXXXXXXXS8BXX","{#ROLENAME}":"root","{#USERNAME}":"TSZC","{#SUPPLIER}":"ZTE","{#NETYPE}":"TAS","{#IPADDR}":"1x.xxx.130.76"}]}

### Option: UserParameter
#       User-defined parameter to monitor. There can be several user-defined parameters.
#       Format: UserParameter=<key>,<shell command>
#       See 'zabbix_agentd' directory for examples.
#
# Mandatory: no
# Default:
# UserParameter=


UserParameter=nename.discovery[*],/xx/xxx/xxxhp/necp_login_test/check_nename.sh $1 $2
UserParameter=ne.login[*],/xx/xxx/xxxhp/necp_login_test/check_nelogin.sh $1 $2

#!/bin/bash
tstr=`date '+%y%m%d%H%M'`
. /u1/tmn/nechk/nechk.env


if [ $# -lt 2 ]
then
echo "cp: Insufficient arguments ($#)"
echo "Usage: sh $0 nename role"
exit 1
fi


DOC_DIR=/xx/xxx/xxxhp/necp_login_test/doc
resultfile=${DOC_DIR}/$1_$2_${tstr}.unl
/xx/xxx/xxxhp/necp_login_test/getfile_proxy -nename $1 -username $2 > ${resultfile}


#echo `/xx/xxx/xxxhp/necp_login_test/getfile_proxy -nename $1 -username $2 | grep 'ÍøÔªµÇ½Íê±Ï' | wc -l`
success=`cat ${resultfile} | grep 'ÍøÔªµÇ½Íê±Ï' | wc -l`
if [ ${success} -eq 1 ]; then
echo ${success}
else
failcode=`cat ${resultfile} | awk '{if(NF==6)print $6}' | awk -F: '{print $2}'`
echo ${failcode}
fi

[tmn@necpproxy1 ~]$ /xx/xxx/xxxhp/necp_login_test/check_nelogin.sh CSGS1 root
1

[tmn@necpproxy1 ~]$ /xx/xxx/xxxhp/necp_login_test/check_nelogin.sh APP-HXXXXX-XXXXX012 root
-30

[tmn@necpproxy1 ~]$ /xx/xxx/xxxhp/necp_login_test/check_nelogin.sh XXXXX16BXX root
-40

%zabbix ALL=(ALL) NOPASSWD: ALL

FTP::1x.xxx.xxx.134-tmn\//xx/xxx/XXD/ir|start.sh
#!/usr/bin/bash
. /u1/tmn/.bash_profile
ps -ef | grep -w nxxx_xxxxx_ssh_ir | grep -v grep | awk '{print "kill -9 "$2}' | sh
su tmn -c 'cd /xx/xxx/XXD/ir; ./nxxx_xxxxx_ssh_ir &'

vi /usr/local/etc/zabbix_agentd.conf
EnableRemoteCommands=1

systemctl restart zabbix_agentd.service

Nelogin test {#NENAME} IP {#IPADDR} of {#SUPPLIER} {#NETYPE} for role {#ROLENAME} by {#USERNAME}

ne.login[{#NENAME},{#ROLENAME}]

ʧ°ÜÔ­Òò:{ITEM.VALUE} {#NENAME} IP {#IPADDR} of {#SUPPLIER} {#NETYPE} for role {#ROLENAME} by {#USERNAME} login failed

select * from problem a left join triggers b on a.objectid = b.triggerid left join functions c on b.triggerid = c.triggerid left join items d on c.itemid = d.itemid

INSERT INTO TASK(TASKID, TYPE, STATUS , CLOCK, TTL) 
SELECT ITEMID - 110000 AS TASKID,6 AS TYPE, 3 AS STATUS, 1596071602 AS CLOCK, 3600 AS TTL FROM ITEMS 
WHERE HOSTID = 10737 AND NOT EXISTS (  SELECT 1 FROM TASK WHERE ITEMS.ITEMID - 110000 = TASK.TASKID) 
INSERT INTO TASK_CHECK_NOW 
SELECT ITEMID - 110000 AS TASKID,ITEMID FROM ITEMS 
WHERE HOSTID = 10737 AND NOT EXISTS (  SELECT 1 FROM TASK_CHECK_NOW WHERE ITEMS.ITEMID - 110000 = TASK_CHECK_NOW.TASKID)

select d.itemid
from problem a left join triggers b on a.objectid = b.triggerid
left join functions c on b.triggerid = c.triggerid
left join items d on c.itemid = d.itemid
left join (select f.itemid,max(e.clock) as clock
from task e left join task_check_now f on e.taskid = f.taskid
where f.itemid is not null
group by f.itemid) e on d.itemid = e.itemid
left join history f on d.itemid = f.itemid
where d.hostid = 10737 and r_eventid is null
and f.clock >= UNIX_TIMESTAMP(now()) - 60*60*6 + 1
group by d.itemid having count(*) < 3

update task set clock = (select max(clock)+ 60*5 from history where itemid = taskid +110000),status = 1 
where taskid in (select itemid-110000 from task_check_now where itemid in (
select d.itemid
from problem a left join triggers b on a.objectid = b.triggerid
left join functions c on b.triggerid = c.triggerid
left join items d on c.itemid = d.itemid
left join (select f.itemid,max(e.clock) as clock
from task e left join task_check_now f on e.taskid = f.taskid
where f.itemid is not null
group by f.itemid) e on d.itemid = e.itemid
left join history f on d.itemid = f.itemid
where d.hostid = 10737 and r_eventid is null
and f.clock >= UNIX_TIMESTAMP(now()) - 60*60*6 + 1
group by d.itemid having count(*) < 3))

#!/bin/bash
. /home/zabbix/.bash_profile


mysql -u zabbix -p'********' << EOF >/dev/null 2>&1
    use zabbix
    begin;
    update task set clock = (select max(clock)+ 60*5 from history where itemid = taskid +110000),status = 1 
    where taskid in (select itemid-110000 from task_check_now where itemid in (
    select d.itemid
    from problem a left join triggers b on a.objectid = b.triggerid
    left join functions c on b.triggerid = c.triggerid
    left join items d on c.itemid = d.itemid
    left join (select f.itemid,max(e.clock) as clock
    from task e left join task_check_now f on e.taskid = f.taskid
    where f.itemid is not null
    group by f.itemid) e on d.itemid = e.itemid
    left join history f on d.itemid = f.itemid
    where d.hostid = 10737 and r_eventid is null
    and f.clock >= UNIX_TIMESTAMP(now()) - 60*60*6 + 1
    group by d.itemid having count(*) < 3));
    commit;
EOF


echo $?