could not get this to work

[sanfx]

Could not get it to work, although would be really useful for my self hosted web application.

the scrape from port 9100 this is what I am getting:

# HELP lock_statements 
# TYPE lock_statements gauge
lock_statements 0.0
# HELP process_virtual_memory_bytes Virtual memory size in bytes.
# TYPE process_virtual_memory_bytes gauge
process_virtual_memory_bytes 3.731456e+07
# HELP process_resident_memory_bytes Resident memory size in bytes.
# TYPE process_resident_memory_bytes gauge
process_resident_memory_bytes 2.9073408e+07
# HELP process_start_time_seconds Start time of the process since unix epoch in seconds.
# TYPE process_start_time_seconds gauge
process_start_time_seconds 1.63569407048e+09
# HELP process_cpu_seconds_total Total user and system CPU time spent in seconds.
# TYPE process_cpu_seconds_total counter
process_cpu_seconds_total 15.43
# HELP process_open_fds Number of open file descriptors.
# TYPE process_open_fds gauge
process_open_fds 9.0
# HELP process_max_fds Maximum number of open file descriptors.
# TYPE process_max_fds gauge
process_max_fds 1.048576e+06
# HELP insert_statements 
# TYPE insert_statements gauge
insert_statements 0.0
# HELP python_info Python platform information
# TYPE python_info gauge
python_info{implementation="CPython",major="2",minor="7",patchlevel="15",version="2.7.15"} 1.0
# HELP update_statements 
# TYPE update_statements gauge
update_statements 0.0
# HELP select_statements 
# TYPE select_statements gauge
select_statements 0.0
# HELP delete_statements 
# TYPE delete_statements gauge
delete_statements 0.0

It doesnt have the "Started on port 9100"
which means the function is not getting excecuted.

in your python script what does dst mean in line sniff(prn=pkt_callback, filter='dst port 3306', store=0)

in prometheus configuration I have added these lines:

  - job_name: 'mysql_sidecar'
    static_configs:
      - targets: ['192.168.1.11:9100']

where 192.168.1.11 is the host where the docker container with your python app is running