Category Archives: Zabbix

Ubuntu，修改源

By Adamhuan | 2017年7月27日

在Ubuntu中，源的设置地址在：/etc/apt/source.list

Welcome to Ubuntu 16.04.2 LTS (GNU/Linux 4.4.0-62-generic x86_64)

 * Documentation:  https://help.ubuntu.com
 * Management:     https://landscape.canonical.com
 * Support:        https://ubuntu.com/advantage

348 packages can be updated.
0 updates are security updates.



The programs included with the Ubuntu system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.

Ubuntu comes with ABSOLUTELY NO WARRANTY, to the extent permitted by
applicable law.

root@phpIPAM:~# 
root@phpIPAM:~# cat /etc/apt/sources.list
# 

# deb cdrom:[Ubuntu-Server 16.04.2 LTS _Xenial Xerus_ - Release amd64 (20170215.8)]/ xenial main restricted

#deb cdrom:[Ubuntu-Server 16.04.2 LTS _Xenial Xerus_ - Release amd64 (20170215.8)]/ xenial main restricted

# See http://help.ubuntu.com/community/UpgradeNotes for how to upgrade to
# newer versions of the distribution.
#deb http://us.archive.ubuntu.com/ubuntu/ xenial main restricted
# deb-src http://us.archive.ubuntu.com/ubuntu/ xenial main restricted

## Major bug fix updates produced after the final release of the
## distribution.
#deb http://us.archive.ubuntu.com/ubuntu/ xenial-updates main restricted
# deb-src http://us.archive.ubuntu.com/ubuntu/ xenial-updates main restricted

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
## team. Also, please note that software in universe WILL NOT receive any
## review or updates from the Ubuntu security team.
#deb http://us.archive.ubuntu.com/ubuntu/ xenial universe
# deb-src http://us.archive.ubuntu.com/ubuntu/ xenial universe
#deb http://us.archive.ubuntu.com/ubuntu/ xenial-updates universe
# deb-src http://us.archive.ubuntu.com/ubuntu/ xenial-updates universe

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu 
## team, and may not be under a free licence. Please satisfy yourself as to 
## your rights to use the software. Also, please note that software in 
## multiverse WILL NOT receive any review or updates from the Ubuntu
## security team.
#deb http://us.archive.ubuntu.com/ubuntu/ xenial multiverse
# deb-src http://us.archive.ubuntu.com/ubuntu/ xenial multiverse
#deb http://us.archive.ubuntu.com/ubuntu/ xenial-updates multiverse
# deb-src http://us.archive.ubuntu.com/ubuntu/ xenial-updates multiverse

## N.B. software from this repository may not have been tested as
## extensively as that contained in the main release, although it includes
## newer versions of some applications which may provide useful features.
## Also, please note that software in backports WILL NOT receive any review
## or updates from the Ubuntu security team.
#deb http://us.archive.ubuntu.com/ubuntu/ xenial-backports main restricted universe multiverse
# deb-src http://us.archive.ubuntu.com/ubuntu/ xenial-backports main restricted universe multiverse

## Uncomment the following two lines to add software from Canonical's
## 'partner' repository.
## This software is not part of Ubuntu, but is offered by Canonical and the
## respective vendors as a service to Ubuntu users.
# deb http://archive.canonical.com/ubuntu xenial partner
# deb-src http://archive.canonical.com/ubuntu xenial partner

#deb http://security.ubuntu.com/ubuntu xenial-security main restricted
# deb-src http://security.ubuntu.com/ubuntu xenial-security main restricted
#deb http://security.ubuntu.com/ubuntu xenial-security universe
# deb-src http://security.ubuntu.com/ubuntu xenial-security universe
#deb http://security.ubuntu.com/ubuntu xenial-security multiverse
# deb-src http://security.ubuntu.com/ubuntu xenial-security multiverse


# -------------------------

deb http://mirrors.163.com/ubuntu/ zesty main restricted universe multiverse

# -------------------------
#deb https://mirrors.tuna.tsinghua.edu.cn/ubuntu/ zesty main restricted universe multiverse

# -------------------------

#deb http://mirrors.aliyun.com/ubuntu/ xenial main restricted universe multiverse
#deb http://mirrors.aliyun.com/ubuntu/ xenial-security main restricted universe multiverse
#deb http://mirrors.aliyun.com/ubuntu/ xenial-updates main restricted universe multiverse
#deb http://mirrors.aliyun.com/ubuntu/ xenial-backports main restricted universe multiverse
root@phpIPAM:~# 
root@phpIPAM:~# 
root@phpIPAM:~#

Welcome to Ubuntu 16.04.2 LTS (GNU/Linux 4.4.0-62-generic x86_64)

* Documentation: https://help.ubuntu.com

* Management: https://landscape.canonical.com

* Support: https://ubuntu.com/advantage

348 packages can be updated.

0 updates are security updates.

The programs included with the Ubuntu system are free software;

the exact distribution terms for each program are described in the

individual files in /usr/share/doc/*/copyright.

Ubuntu comes with ABSOLUTELY NO WARRANTY, to the extent permitted by

applicable law.

root@phpIPAM:~#

root@phpIPAM:~# cat /etc/apt/sources.list

# deb cdrom:[Ubuntu-Server 16.04.2 LTS _Xenial Xerus_ - Release amd64 (20170215.8)]/ xenial main restricted

#deb cdrom:[Ubuntu-Server 16.04.2 LTS _Xenial Xerus_ - Release amd64 (20170215.8)]/ xenial main restricted

# See http://help.ubuntu.com/community/UpgradeNotes for how to upgrade to

# newer versions of the distribution.

#deb http://us.archive.ubuntu.com/ubuntu/ xenial main restricted

# deb-src http://us.archive.ubuntu.com/ubuntu/ xenial main restricted

## Major bug fix updates produced after the final release of the

## distribution.

#deb http://us.archive.ubuntu.com/ubuntu/ xenial-updates main restricted

# deb-src http://us.archive.ubuntu.com/ubuntu/ xenial-updates main restricted

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu

## team. Also, please note that software in universe WILL NOT receive any

## review or updates from the Ubuntu security team.

#deb http://us.archive.ubuntu.com/ubuntu/ xenial universe

# deb-src http://us.archive.ubuntu.com/ubuntu/ xenial universe

#deb http://us.archive.ubuntu.com/ubuntu/ xenial-updates universe

# deb-src http://us.archive.ubuntu.com/ubuntu/ xenial-updates universe

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu

## team, and may not be under a free licence. Please satisfy yourself as to

## your rights to use the software. Also, please note that software in

## multiverse WILL NOT receive any review or updates from the Ubuntu

## security team.

#deb http://us.archive.ubuntu.com/ubuntu/ xenial multiverse

# deb-src http://us.archive.ubuntu.com/ubuntu/ xenial multiverse

#deb http://us.archive.ubuntu.com/ubuntu/ xenial-updates multiverse

# deb-src http://us.archive.ubuntu.com/ubuntu/ xenial-updates multiverse

## N.B. software from this repository may not have been tested as

## extensively as that contained in the main release, although it includes

## newer versions of some applications which may provide useful features.

## Also, please note that software in backports WILL NOT receive any review

## or updates from the Ubuntu security team.

#deb http://us.archive.ubuntu.com/ubuntu/ xenial-backports main restricted universe multiverse

# deb-src http://us.archive.ubuntu.com/ubuntu/ xenial-backports main restricted universe multiverse

## Uncomment the following two lines to add software from Canonical's

## 'partner' repository.

## This software is not part of Ubuntu, but is offered by Canonical and the

## respective vendors as a service to Ubuntu users.

# deb http://archive.canonical.com/ubuntu xenial partner

# deb-src http://archive.canonical.com/ubuntu xenial partner

#deb http://security.ubuntu.com/ubuntu xenial-security main restricted

# deb-src http://security.ubuntu.com/ubuntu xenial-security main restricted

#deb http://security.ubuntu.com/ubuntu xenial-security universe

# deb-src http://security.ubuntu.com/ubuntu xenial-security universe

#deb http://security.ubuntu.com/ubuntu xenial-security multiverse

# deb-src http://security.ubuntu.com/ubuntu xenial-security multiverse

# -------------------------

deb http://mirrors.163.com/ubuntu/ zesty main restricted universe multiverse

# -------------------------

#deb https://mirrors.tuna.tsinghua.edu.cn/ubuntu/ zesty main restricted universe multiverse

# -------------------------

#deb http://mirrors.aliyun.com/ubuntu/ xenial main restricted universe multiverse

#deb http://mirrors.aliyun.com/ubuntu/ xenial-security main restricted universe multiverse

#deb http://mirrors.aliyun.com/ubuntu/ xenial-updates main restricted universe multiverse

#deb http://mirrors.aliyun.com/ubuntu/ xenial-backports main restricted universe multiverse

root@phpIPAM:~#

一般，修改了源文件后，可以对UBUNTU的源做出更新：

root@phpIPAM:~# apt-get update
Hit:1 http://mirrors.163.com/ubuntu zesty InRelease
Reading package lists... Done
root@phpIPAM:~#

root@phpIPAM:~# apt-get update

Hit:1 http://mirrors.163.com/ubuntu zesty InRelease

Reading package lists... Done

root@phpIPAM:~#

对源做出检索：[……]

Zabbix Agent：监控MySQL（Percona Monitoring Plugins 1.1.7）

By Adamhuan | 2017年7月26日

0 Comment

开始本文的前提：
安装有Zabbix Agent。

————————————————————————
这里，采用Percona的Monitoring Plugins配合Zabbix，实现监控。
具体的配置方法如下。

Percona Monitoring Plugins：
官方下载[……]

Zabbix Agent：MS Windows客户端的配置

By Adamhuan | 2017年7月25日

0 Comment

环境：
Zabbix Server，192.168.92.132

Zabbix Client：
—> MS Windows：192.168.92.1

在官方网站获取【zabbix pre-compiled agents】的安装包：
https://www.zabbix.com/d[……]

Zabbix：Login name or password is incorrect.【修改口令】

By Adamhuan | 2017年7月21日

0 Comment

在Zabbix的使用过程中，可能你会遇到如题所示的问题。
具体呈现如下：

可以在后台ZABBIX的数据库中，直接修改账户的密码：

[root@zabbix ~]# !mysql
mysql -u root -p'*********'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 154
Server version: 5.7.18-15-log Percona Server (GPL), Release 15, Revision bff2cd9

Copyright (c) 2009-2017 Percona LLC and/or its affiliates
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| zabbix             |
+--------------------+
5 rows in set (0.00 sec)

mysql> 
mysql> use zabbix;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> desc users;
+----------------+---------------------+------+-----+---------+-------+
| Field          | Type                | Null | Key | Default | Extra |
+----------------+---------------------+------+-----+---------+-------+
| userid         | bigint(20) unsigned | NO   | PRI | NULL    |       |
| alias          | varchar(100)        | NO   | UNI |         |       |
| name           | varchar(100)        | NO   |     |         |       |
| surname        | varchar(100)        | NO   |     |         |       |
| passwd         | char(32)            | NO   |     |         |       |
| url            | varchar(255)        | NO   |     |         |       |
| autologin      | int(11)             | NO   |     | 0       |       |
| autologout     | int(11)             | NO   |     | 900     |       |
| lang           | varchar(5)          | NO   |     | en_GB   |       |
| refresh        | int(11)             | NO   |     | 30      |       |
| type           | int(11)             | NO   |     | 1       |       |
| theme          | varchar(128)        | NO   |     | default |       |
| attempt_failed | int(11)             | NO   |     | 0       |       |
| attempt_ip     | varchar(39)         | NO   |     |         |       |
| attempt_clock  | int(11)             | NO   |     | 0       |       |
| rows_per_page  | int(11)             | NO   |     | 50      |       |
+----------------+---------------------+------+-----+---------+-------+
16 rows in set (0.00 sec)

mysql> 
mysql> select userid,alias,name,surname,passwd,url from users;
+--------+-------+--------+---------------+----------------------------------+-----+
| userid | alias | name   | surname       | passwd                           | url |
+--------+-------+--------+---------------+----------------------------------+-----+
|      1 | Admin | Zabbix | Administrator | e2798af12a7a0f4f70b4d69efbc25f4d |     |
|      2 | guest |        |               | d41d8cd98f00b204e9800998ecf8427e |     |
+--------+-------+--------+---------------+----------------------------------+-----+
2 rows in set (0.00 sec)

mysql> update users set passwd=md5("zabbix") where userid='1';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> 
mysql> select userid,alias,name,surname,passwd,url from users;
+--------+-------+--------+---------------+----------------------------------+-----+
| userid | alias | name   | surname       | passwd                           | url |
+--------+-------+--------+---------------+----------------------------------+-----+
|      1 | Admin | Zabbix | Administrator | 5fce1b3e34b520afeffb37ce08c7cd66 |     |
|      2 | guest |        |               | d41d8cd98f00b204e9800998ecf8427e |     |
+--------+-------+--------+---------------+----------------------------------+-----+
2 rows in set (0.00 sec)

mysql> 
mysql> exit
Bye
[root@zabbix ~]#

[root@zabbix ~]# !mysql

mysql -u root -p'*********'

mysql: [Warning] Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 154

Server version: 5.7.18-15-log Percona Server (GPL), Release 15, Revision bff2cd9

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sys |

| zabbix |

+--------------------+

5 rows in set (0.00 sec)

mysql>

mysql> use zabbix;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> desc users;

+----------------+---------------------+------+-----+---------+-------+

+----------------+---------------------+------+-----+---------+-------+

| alias | varchar(100) | NO | UNI | | |

| url | varchar(255) | NO | | | |

| autologin | int(11) | NO | | 0 | |

| autologout | int(11) | NO | | 900 | |

| refresh | int(11) | NO | | 30 | |

| type | int(11) | NO | | 1 | |

| attempt_failed | int(11) | NO | | 0 | |

| attempt_clock | int(11) | NO | | 0 | |

| rows_per_page | int(11) | NO | | 50 | |

+----------------+---------------------+------+-----+---------+-------+

16 rows in set (0.00 sec)

mysql>

mysql> select userid,alias,name,surname,passwd,url from users;

+--------+-------+--------+---------------+----------------------------------+-----+

+--------+-------+--------+---------------+----------------------------------+-----+

+--------+-------+--------+---------------+----------------------------------+-----+

2 rows in set (0.00 sec)

mysql> update users set passwd=md5("zabbix") where userid='1';

Query OK, 1 row affected (0.00 sec)

Rows matched: 1 Changed: 1 Warnings: 0

mysql>

mysql> select userid,alias,name,surname,passwd,url from users;

+--------+-------+--------+---------------+----------------------------------+-----+

+--------+-------+--------+---------------+----------------------------------+-----+

+--------+-------+--------+---------------+----------------------------------+-----+

2 rows in set (0.00 sec)

mysql>

mysql> exit

Bye

[root@zabbix ~]#

然后用【Alias】与【passwd】去Zabbix的登录页面【http://192.[……]

Zabbix error：can’t connect to local MySQL server through socket

By Adamhuan | 2017年2月27日

0 Comment

报错如题所示，更详细的内容如下：

在ZABBIX的日志文件【/etc/zabbix/zabbix_server.conf，可以找到配置的日志文件的位置】中，你可以看到很多类似标题所示的报错

 28106:20170227:112642.572 database is down: reconnecting in 10 seconds
 28106:20170227:112652.572 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
 28106:20170227:112652.572 database is down: reconnecting in 10 seconds
 28106:20170227:112702.573 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
 28106:20170227:112702.573 database is down: reconnecting in 10 seconds
 28106:20170227:112712.573 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
 28106:20170227:112712.573 database is down: reconnecting in 10 seconds

28106:20170227:112642.572 database is down: reconnecting in 10 seconds

28106:20170227:112652.572 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

28106:20170227:112652.572 database is down: reconnecting in 10 seconds

28106:20170227:112702.573 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

28106:20170227:112702.573 database is down: reconnecting in 10 seconds

28106:20170227:112712.573 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

28106:20170227:112712.573 database is down: reconnecting in 10 seconds

该报错的原因很简单，因为启用[……]