12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
ADADADADAD
mysql数据库 时间:2024-12-24 19:11:40
作者:文/会员上传
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
1、安装PHP及扩展包rpm-Uvhhttp://mirror.webtatic.com/yum/el6/latest.rpmyum-yinstallphp56wphp56w-gdphp56w-mysqlphp56w-bcmathphp56w-mbstringphp56w-xmlphp56w-ldap
2
以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。
1、安装PHP及扩展包
rpm-Uvhhttp://mirror.webtatic.com/yum/el6/latest.rpmyum-yinstallphp56wphp56w-gdphp56w-mysqlphp56w-bcmathphp56w-mbstringphp56w-xmlphp56w-ldap
2、安装mysql及配置
rpm-ivhhttp://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpmyuminstall-ymysql-servermysql-devel/etc/init.d/mysqldstartmysql_secure_installation
Entercurrentpasswordforroot(enterfornone):<–初次运行直接回车Setrootpassword?[Y/n]<–是否设置root用户密码,输入y并回车或直接回车Removeanonymoususers?[Y/n]<–是否删除匿名用户,生产环境建议删除,所以直接回车Disallowrootloginremotely?[Y/n]<–是否禁止root远程登录,根据自己的需求选择Y/n并回车,建议禁止Removetestdatabaseandaccesstoit?[Y/n]<–是否删除test数据库,直接回车Reloadprivilegetablesnow?[Y/n]<–是否重新加载权限表,直接回车
mysql-uroot-pzabbixmysql>CREATEDATABASEzabbixCHARACTERSETutf8COLLATEutf8_bin;mysql>GRANTALLPRIVILEGESONzabbix.*TOzabbix@localhostIDENTIFIEDBY'zabbix';mysql>flushprivileges;mysql>showdatabases;
修改配置文件
#vim/etc/my.cnf[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockinnodb_file_per_table=1character-set-server=utf8#独立表空间模式innodb_file_per_table=1symbolic-links=0sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
重启mysql服务
/etc/init.d/mysqldrestartStoppingmysqld:[OK]Startingmysqld:[OK]chkconfigmysqldon
3、安装依赖包
yum-yinstalllibcurl-devellibxml2-develnet-snmpnet-snmp-develyum-yinstallhttpdOpenIPMI-libsfpingiksemel
4、更新libcurl,如果不更新,发送邮件告警会失败,下面的链接中有详细的信息
http://www.iyunv.com/thread-261219-1-1.html
rpm-ivhcity-fan.org-release-1-13.rhel6.noarch.rpm
curl-Vcurl7.19.7(x86_64-redhat-linux-gnu)libcurl/7.19.7NSS/3.21BasicECCzlib/1.2.3libidn/1.18libssh3/1.4.2Protocols:tftpftptelnetdictldapldapshttpfilehttpsftpsscpsftpFeatures:GSS-NegotiateIDNIPv6LargefileNTLMSSLlibzcurl-Vcurl7.53.1(x86_64-redhat-linux-gnu)libcurl/7.53.1OpenSSL/1.0.1ezlib/1.2.3c-ares/1.12.0libssh3/1.8.0nghttp2/1.6.0Protocols:dictfileftpftpsgopherhttphttpsimapimapsldapldapspop3pop3srtspscpsftpsmbsmbssmtpsmtpstelnettftpFeatures:AsynchDNSIPv6LargefileGSS-APIKerberosSPNEGONTLMNTLM_WBSSLlibzHTTP2UnixSocketsHTTPS-proxyMetalink
5、下载源码包
下载地址:http://www.zabbix.com/download
6、安装
tar -zxf zabbix-3.0.8.tar.gz
cd zabbix-3.0.8
./configure --prefix=/usr/local/zabbix --enable-server --enable-agent --with-mysql --with-net-snmp --with-libcurl --with-libxml2
make && make install
7、拷贝服务启动脚本到/etc/init.d/目录
cpmisc/init.d/fedora/core/zabbix_server/etc/init.d/cpmisc/init.d/fedora/core/zabbix_agentd/etc/init.d/
修改/etc/init.d/zabbix_server和/etc/init.d/zabbix_agent启动脚本,将
BASEDIR=/usr/local
改成
BASEDIR=/usr/local/zabbix
8、导入数据库文件
mysql-uzabbix-pzabbix-hlocalhostzabbix<database/mysql/schema.sqlmysql-uzabbix-pzabbix-hlocalhostzabbix<database/mysql/p_w_picpaths.sqlmysql-uzabbix-pzabbix-hlocalhostzabbix<database/mysql/data.sql
9、创建软连接
ln-s/usr/local/zabbix/etc/etc/zabbix
10、修改php配置,我这里是将修改后的配置用单独的文件保存
cd/etc/httpd/conf.dvimzabbix.conf
php_valuemax_execution_time300php_valuememory_limit128Mphp_valuepost_max_size32Mphp_valueupload_max_filesize2Mphp_valuemax_input_time300php_valuealways_populate_raw_post_data-1php_valuedate.timezoneAsia/Shanghai
11、创建zabbix目录
mkdir/var/www/html/zabbixcp-R/usr/local/src/zabbix-3.0.8/frontends/php/*/var/www/html/zabbix/chown-Rapache:apache/var/www/html/zabbix
12、创建log目录
mkdir/var/log/zabbix
配置日志切割
cat/etc/logrotate.d/zabbix-agent
/var/log/zabbix/zabbix_agentd.log{weeklyrotate12compressdelaycompressmissingoknotifemptycreate0664zabbixzabbix}
cat/etc/logrotate.d/zabbix-server
/var/log/zabbix/zabbix_server.log{weeklyrotate12compressdelaycompressmissingoknotifemptycreate0664zabbixzabbix}
13、修改zabbix_server.conf配置文件,修改后的配置如下,这是生产用的配置,内存都调高了.使用root用户启动zabbix server
LogFile=/var/log/zabbix/zabbix_server.logLogFileSize=0PidFile=/var/run/zabbix/zabbix_server.pidDBHost=localhostDBName=zabbixDBUser=zabbixDBPassword=zabbixStartPollers=40StartPollersUnreachable=20StartTrappers=8StartPingers=8StartDiscoverers=8StartHTTPPollers=8SNMPTrapperFile=/var/log/snmptrap/snmptrap.logHousekeepingFrequency=1CacheSize=128MStartDBSyncers=8HistoryCacheSize=32MHistoryIndexCacheSize=32MTrendCacheSize=8MValueCacheSize=128MTimeout=30TrapperTimeout=120AlertScriptsPath=/usr/lib/zabbix/alertscriptsExternalScripts=/usr/lib/zabbix/externalscriptsLogSlowQueries=3000AllowRoot=1
14、修改zabbix_agent.conf配置文件,修改后的配置如下(使用root用户启动zabbix agent)
LogFile=/var/log/zabbix/zabbix.agent.logServer=127.0.0.1ServerActive=127.0.0.1Hostname=ZabbixserverAllowRoot=1Include=/usr/local/zabbix/etc/zabbix_agentd.conf.d/
15、设置zabbix agent和zabbix server服务开机启动
chkconfig--addzabbix_serverchkconfig--addzabbix_agentdchkconfigzabbix_serveronchkconfigzabbix_agentdon/etc/init.d/zabbix_serverstart/etc/init.d/zabbix_agentdstart
16、启动apache服务
/etc/init.d/httpdstartchkconfighttpdon
17、登录zabbix web进行配置
配置zabbix数据库的密码
不用配置,直接下一步
不用配置,下一步
配置完成
登录zabbix,账号默认为Admin,密码为zabbix,登录后最好是改掉
11-20
11-19
11-20
11-20
11-20
11-19
11-20
11-20
11-19
11-20
11-19
11-19
11-19
11-19
11-19
11-19