Hi,
I have a problem, i have configured 2 datasources and i want to index the data different index but my data are not on the good index.
my /etc/logstash/conf.d/config_mysql_glpi_tickets.conf
input {
jdbc {
jdbc_driver_library => "/usr/share/logstash/vendor/jdbc-mysql/mysql-connector-java-5.1.44-bin.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_connection_string => "jdbc:mysql://ip:3306/glpi"
jdbc_user => "user"
jdbc_password => "pass"
schedule => "*/5 * * * *"
jdbc_page_size => 50000
jdbc_paging_enabled => true
statement => "SELECT * FROM view_tickets"
use_column_value => true
tracking_column => "id"
tracking_column_type => "numeric"
}
}
output {
elasticsearch {
hosts => ["http://localhost:9200"]
index => "glpi_tickets"
document_type => "tickets"
document_id => "%{id}"
}
}
And my /etc/logstash/conf.d/config_mysql_glpi_tasks.conf
input {
jdbc {
jdbc_driver_library => "/usr/share/logstash/vendor/jdbc-mysql/mysql-connector-java-5.1.44-bin.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_connection_string => "jdbc:mysql://ip:3306/glpi"
jdbc_user => "user"
jdbc_password => "pass"
schedule => "*/5 * * * *"
jdbc_page_size => 50000
jdbc_paging_enabled => true
statement => "SELECT * FROM view_tickets"
use_column_value => true
tracking_column => "id"
tracking_column_type => "numeric"
}
}
output {
elasticsearch {
hosts => ["http://localhost:9200"]
index => "glpi_tickets"
document_type => "tickets"
document_id => "%{id}"
}
}
On my glpi_tickets index i have tasks document. I don't understand my mistake