BI可视化
能想多少想多少
不懂工艺的程序员不是一个好的项目经理
展开
-
Elasticsearch 8.0 installation
after creating an enrollment token on your existing cluster.You can complete the following actions at any time:Reset the password of the elastic built-in superuser with'/usr/share/elasticsearch/bin/elasticsearch-reset-password -u elastic'.Generate a原创 2022-02-18 07:44:16 · 810 阅读 · 0 评论 -
ubuntu 20.01利用apt部署logstash并添加到自启动服务
参考官方指导:https://www.elastic.co/guide/en/logstash/current/installing-logstash.htmlsudo apt-get install apt-transport-https设定elasticsearch的源 echo "deb https://artifacts.elastic.co/packages/7.x/apt stable main" | sudo tee /etc/apt/sources.list.d/elastic-原创 2020-12-08 16:47:42 · 724 阅读 · 0 评论 -
Vue的index.html文件
里面有一个这个id需要和App.vue里中的id,以及main.js里面的el:’#app’保持一致否则有问题。原创 2020-05-20 11:24:02 · 1098 阅读 · 0 评论 -
开始玩Vue
1. 安装nodejs参考教程:https://www.runoob.com/nodejs/nodejs-install-setup.html2. 安装npm参考教程:https://www.runoob.com/nodejs/nodejs-npm.html3. Vue的安装以及创建第一个项目:参考教程:https://www.runoob.com/vue2/vue-install.html注意,Vue应该安装在你的项目下,否则会有下面的错误信息:D:\MyDev\vue\te原创 2020-05-20 10:51:40 · 659 阅读 · 0 评论 -
Logstash 使用JDBC的注意事项
问题:使用如下配置文件,logstash无法连接数据库:input { jdbc { jdbc_driver_library => "../connector/mysql-connector-java-5.0.8.jar" jdbc_driver_class => "com.mysql.jdbc.Driver" jdbc_connection_string =...原创 2020-01-12 09:36:50 · 1310 阅读 · 0 评论 -
logstash使用JDBC连接MySQL错误(已经解决)
开始时候使用JDBC8.0.11[2020-01-03T08:17:00,189][ERROR][logstash.inputs.jdbc ] Unable to connect to database. Tried 1 times {:error_message=>"Java::JavaSql::SQLNonTransientConnectionException: CLIENT...原创 2020-01-03 08:38:53 · 6922 阅读 · 0 评论 -
logstash的file input plugin插件不按顺序读取数据
比如csv文件的内容如下:rec1,1,5,5rec1,2,2,2rec1,3,44,44rec1,4,33,22rec2,5,66,55rec2,6,4,4csv的mapping:csv { separator => "," skip_empty_rows => true columns => [ "Sensor...原创 2020-01-02 15:52:42 · 1112 阅读 · 0 评论 -
logstash 丢掉特定记录
https://stackoverflow.com/questions/27519974/selective-parsing-of-csv-file-using-logstash"Comm_Plan","Queue_Booking","Order_Reference","Generation_Date""","No","FMN1191MVHV","31/03/2014""","No","...原创 2019-11-19 16:21:50 · 509 阅读 · 0 评论 -
ElasticSearch删除命令
删除indexDELETE /apb{ "query": { "match": { "_index":"apb" } }}删除文件POST /ncc_ffbkf08_201708_8000/_delete_by_query{ "query": { "match": { "_id":"-6C6cW0...原创 2019-09-09 15:32:13 · 596 阅读 · 0 评论 -
Logstash 导入 csv文件的坑坑们
Input注意input { file { path => ["D:/20191111_RES.csv"] # 文件路径必须以 ‘/’而不是‘\’ 进行分割,即便是Windows start_position => "beginning" sincedb_path => "D:/testt" # 记录文件的位置,也要以‘/’而不是‘\’进行分割,这里必...原创 2019-11-12 21:11:30 · 2195 阅读 · 3 评论 -
Kibana查询某个index pattern的id
参考:https://discuss.elastic.co/t/get-index-pattern-id/132598GET .kibana/_search{ "_source": ["index-pattern.title"], "query": { "term": { "type": "index-pattern" } }}原创 2019-11-02 21:43:38 · 3793 阅读 · 0 评论 -
Logstash配置的错误
Java::JavaSql::SQLNonTransientConnectionException: Public Key Retrieval is not allowed参考:https://stackoverflow.com/questions/50379839/connection-java-mysql-public-key-retrieval-is-not-allowedht...原创 2019-11-01 08:33:02 · 397 阅读 · 0 评论 -
ELK 7.4.1安装配置
配置elasticsearchElasticsearch 7.4.1默认的配置文件直接启动,是无法通过其他电脑访问的,需要进行如下配置:# 配置为公网访问:network.host: 0.0.0.0 # 配置你本机的IPdiscovery.seed_hosts: ["xxx.xxx.xxx.xxx"]如果不配置discovery.seed_hosts会无法启动,并报错:ERR...原创 2019-10-31 16:01:27 · 466 阅读 · 0 评论 -
Elasticsearch Logstash配置
# reference URL:# https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.htmlinput { jdbc { jdbc_driver_library => "..\..\oracle-connect-test\ojdbc8.jar" jdbc_driver_class ...原创 2019-09-24 16:24:21 · 371 阅读 · 0 评论 -
Elasticsearch下应用Siren Federate插件
Elasticsearch下应用Siren Federate插件插件下载解压缩安装插件下载https://siren.io/downloads/?product=siren-federate下载到的文件名是:siren-federate-6.8.2-10.3.1.zip,(版本差异可能文件名不同)。解压缩下载zip文件后,解压缩到某个文件夹,比如我这里就解压缩到了:D:\softwar...原创 2019-09-29 15:02:34 · 933 阅读 · 0 评论 -
Elasticsearch集群
手把手教你搭建一个 Elasticsearch 集群转载 2019-10-22 13:09:27 · 94 阅读 · 0 评论 -
Elastic Search的中文分词插件ik使用过程
按照官网步骤,用命令行安装了插件:https://github.com/medcl/elasticsearch-analysis-ik/tree/v7.3.1./bin/elasticsearch-plugin install https://github.com/medcl/elasticsearch-analysis-ik/releases/download/v6.3.0/elastics...原创 2019-10-16 15:24:14 · 521 阅读 · 0 评论 -
grafana plugin 安装目录
将下载的zip文件解压缩到:C:\Program Files\GrafanaLabs\grafana\data\plugins原创 2019-10-13 12:38:44 · 2845 阅读 · 0 评论 -
解决在HTML中嵌入Kibana Dashboard浏览器报错的问题
参考:https://stackoverflow.com/questions/30481516/iframe-in-chrome-error-failed-to-read-localstorage-from-window-access-deni出错页面:Failed to read the 'localStorage' property from 'Window': Access is d...原创 2019-10-10 16:33:51 · 1293 阅读 · 0 评论 -
Elasticsearch,Kibana中的用户管理
参考官方网站的说明文档:https://www.elastic.co/guide/en/elastic-stack-overview/6.7/elasticsearch-security.html首先,打开ElasticSearch的安全策略:参考:https://www.elastic.co/guide/en/elastic-stack-overview/6.7/get-started-e...原创 2019-10-10 15:22:25 · 2628 阅读 · 0 评论 -
Grafana中SQL的语句格式
SELECT part_number,product_shift,product_date,$__timeFrom(),$__timeTo() from scm.scm_d_pp_detail where production_line = "$line" and product_date > $__timeFrom() and product_date < $__timeTo()...原创 2019-10-08 14:07:00 · 6982 阅读 · 0 评论