Posts

Yum via Proxy

Edit /etc/yum.conf Add proxy=http://<Proxy-Server-IP-Address>:<Proxy_Port> proxy_username=<Proxy-User-Name> proxy_password=<Proxy-Password>  Example: proxy=http://192.168.1.0:3128 proxy_username=sysops proxy_password=passw0rd!

Install zabbix-agent passive

  CentOS/RHEL 7: rpm -Uvh https://repo.zabbix.com/zabbix/4.0/rhel/7/x86_64/zabbix-release-4.0-2.el7.noarch.rpm CentOS/RHEL 6: rpm -Uvh https://repo.zabbix.com/zabbix/4.0/rhel/6/x86_64/zabbix-release-4.0-2.el6.noarch.rpm yum install zabbix-agent /etc/zabbix/zabbix_agentd.conf Server=192.168.1.100 Hostname=Server1 systemctl enable zabbix-agent systemctl start zabbix-agent

Hbase shell data manipulation

Example how to truncate: Enter to the hbase shell cd /opt/hbase/bin ./hbase shell check table list truncate table truncate 'AgentEvent' truncate 'AgentInfo' truncate 'AgentLifeCycle' truncate 'AgentStatV2' truncate 'ApiMetaData' truncate 'ApplicationIndex' truncate 'ApplicationMapStatisticsCallee_Ver2' truncate 'ApplicationMapStatisticsCaller_Ver2' truncate 'ApplicationMapStatisticsSelf_Ver2' truncate 'ApplicationStatAggre' truncate 'ApplicationTraceIndex' truncate 'HostApplicationMap_Ver2' https://data-flair.training/blogs/data-manipulation-hbase-command/

Simple script to collect SNMP information using PHP

Install PHP yum install php, php-pgsql, php-snmp Write code network_poller.php <?php //DB connection $conn = "host=127.0.0.1 port=5432 dbname=networkdb user=netuser password=P@ssw0rd options='--client_encoding=UTF8'"; $dbconn = pg_connect($conn); if(!$dbconn) {   echo "Error: Unable to open database\n"; } else {   echo "Opened database successfully\n"; } //Select query checking $QUERY_SELECT_NET_DEVICE = "SELECT ipaddress,netdevicename,model,annotation FROM network_device_list"; $SELECT = pg_query($QUERY_SELECT_NET_DEVICE) or die('Query failed: ' . pg_last_error()); //Clean table $QUERY_DELETE_NET_STATUS = "DELETE FROM network_device_status"; $DELETE = pg_query($QUERY_DELETE_NET_STATUS) or die('Query failed: ' . pg_last_error()); while ($row = pg_fetch_row($SELECT)) {   echo "NETWORK DEVICE STATUS: $row[0] $row[1] $row[2] $row[3]"; $CPULOAD_STRING = snmpwalk("$row[0]", "P@ssw0rd",...