11:06 pm

February 27, 2018

Hello, so in my project i will send command hcitool data scheduled every hour everyday depends on the schedule in MySQL table.
Example: Monday 10.00 - 13.00
Wednesday 15.00 - 17.00
Then my raspi will do hcitool command to capture bluetooth MAC address around it at monday 10, 12, 13 and wednesday 15, 16, 17.
The question is, do anyone know how to trigger it from MySQL?
Best regards
5:37 am


Top
January 29, 2014

Where is the MySQL table located? Is MySQL running on your raspi or somewhere else?
If its running on the raspi then one solution is a cron job that runs every hour. This triggers a script that compares the current time to the list stored in the database and takes action when they match.
What is the structure of your table? How are you going to represent the range of time and days?
Most Users Ever Online: 166
Currently Online:
22 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
rw950431: 272
Vinod: 240
piajola: 95
turgo: 70
vespapierre: 63
Adarsh_Murthy: 62
Member Stats:
Guest Posters: 1
Members: 8665
Moderators: 1
Admins: 2
Forum Stats:
Groups: 3
Forums: 14
Topics: 1600
Posts: 5760
Newest Members:
Advantagetreeexperts, laundrydaddyuk, techhhelp5, ken, tran, huldacormierModerators: cstapels: 460
Administrators: Hans: 405, lee: 457