新聞中心
這里有您想知道的互聯(lián)網(wǎng)營銷解決方案
logstash同步nginx日志到數(shù)據(jù)庫-創(chuàng)新互聯(lián)
本文參考:/tupian/20230521/9436373.html? ? ? ? ? ? ? ?/tupian/20230521/10360264.html -ivh? logstash-6.6.2.rpm
2.上傳數(shù)據(jù)庫驅(qū)動jar包
wget? https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.48.tar.gz
mkdir?-p?/usr/share/logstash/vendor/jar/jdbc cd?/usr/share/logstash/vendor/jar/jdbc [root@localhost?soft]#?cd?/usr/share/logstash/vendor/jar/jdbc [root@localhost?jdbc]#?ll total?984 -rw-r--r--.?1?logstash?logstash?1006959?Jul?11?19:43?mysql-connector-java-5.1.48-bin.jar [root@localhost?jdbc]#
3.數(shù)據(jù)庫創(chuàng)建庫 并授權(quán)用戶
create?database?nginxlog; use?nginxlog; CREATE?TABLE?`consumerlog`?( ??`client_ip`?varchar(128)?DEFAULT?NULL, ??`log_time`?timestamp?NOT?NULL?DEFAULT?CURRENT_TIMESTAMP, ??`status`?int(6)?DEFAULT?NULL, ??`http_referer`?text, ??`AgentVersion`?varchar(512)?DEFAULT?NULL, )? grant?all??on??nginxlog.*?to??nginxlog@'%'??identified??by??'123456';
4.安裝?logstash-output-jdbc插件
vim?/usr/share/logstash/Gemfile #?source?"/tupian/20230521/rubygems.org"??將國外的源注釋,換成國內(nèi)的 source?"https://gems.ruby-china.com/"
本文題目:logstash同步nginx日志到數(shù)據(jù)庫-創(chuàng)新互聯(lián)
網(wǎng)站路徑:http://www.ef60e0e.cn/article/coiscs.html