Skip to content

Latest commit

 

History

History
20 lines (20 loc) · 851 Bytes

README.md

File metadata and controls

20 lines (20 loc) · 851 Bytes
Raw

db events notify tool

This three step installation project allows you to be notified of new inserts in table of a database:
  1. edit configs
    • edit config.txt (if needed)
    • edit config-mysql.txt (you can find example in config-mysql-example.txt)
    • edit config-sms-ru.txt (you can find example in config-mysql-example.txt)
  2. run python3 installation-mysql.py (if needed, install mysql.connector first via sudo python3 pip install mysql-connector)
  3. add mysql-dbevents-notify.py in crontab or systemd to autorun watcher after reboot

The test insert to try on the tracker project:
INSERT INTO `accounts`(`id_account`, `email`, `passwordh`, `id_company_fk`, `date_of_reg`, `is_blocked`) VALUES (null,"[email protected]","hash",null,null,0)