新手请求帮助！谢谢！Zabbix安装过程出现错误

dengbao2001

进入mysql控制台，show database 看看数据库是否建立好了

jieshuyang2004

dengbao2001 发表于 2015-02-09 18:08
进入mysql控制台，show database 看看数据库是否建立好了

我mysql的命令也不熟悉，执行了一下，是这种显示：

mysql> show database
        ->

是我的库没建好么？

dengbao2001

show databases；

jieshuyang2004

回复 11# dengbao2001


我之前应该已经建好库了，怎么show database没有呢？

我执行了下建库命令，显示如下：

[root@localhost zabbix-2.4.3]# mysql -uzabbix -p123456 zabbix < /tmp/zabbix-2.4.3/database/mysql/schema.sql
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1050 (42S01) at line 1: Table 'maintenances' already exists
[root@localhost zabbix-2.4.3]#
[root@localhost zabbix-2.4.3]# mysql -uzabbix -p123456 zabbix < /tmp/zabbix-2.4.3/database/mysql/images.sql
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1062 (23000) at line 1: Duplicate entry '1' for key 'PRIMARY'
[root@localhost zabbix-2.4.3]#
[root@localhost zabbix-2.4.3]# mysql -uzabbix -p123456 zabbix < /tmp/zabbix-2.4.3/database/mysql/data.sql
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1062 (23000) at line 2: Duplicate entry '10001' for key 'PRIMARY'
[root@localhost zabbix-2.4.3]#
   

jieshuyang2004

回复 13# dengbao2001


mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| zabbix             |
+--------------------+
4 rows in set (0.01 sec)

mysql>


   

dengbao2001

从这个看，zabbix已经建立了，切换到zabbix用户，去访问这个数据库看看

jieshuyang2004

回复 16# dengbao2001

[root@localhost zabbix-2.4.3]# mysql -uzabbix -p123456
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 92
Server version: 5.7.5-m15 MySQL Community Server (GPL)

Copyright (c) 2000, 2014, 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 |
| zabbix             |
+--------------------+
2 rows in set (0.00 sec)

mysql>


   

jieshuyang2004

dengbao2001 发表于 2015-02-09 18:48
从这个看，zabbix已经建立了，切换到zabbix用户，去访问这个数据库看看

从上面看好像zabbix也没问题，不过从IE访问，还是出错。

jieshuyang2004

请帮忙看看，谢谢

chenyx

楼主看下apache的errorlog日志,看看有没有错误信息.
另外,selinux停掉看看