I then thought having a cron jop run a PHP file and iterate over the Notifications table and re-send any that had not expired or been acknowledged, but I found that PHP files run from a shell terminal (as I assume would be the case when using a cron job), do not have MySQL, which kills what I'm trying to do.
I was also confused by some of the instructions in the wiki:
It says to make the symbolic link to PHP5 in "~/public_cgi/php5"
and to copy the php.ini file to the same directory.
(I did not have a "public_cgi" directory in my home directory so I made one,
I also tried creating the link, and copying the php.ini file to the WWW_Pages
of my home directory neither of these worked)
Then the instructions say " In your .htaccess file replace the reference to /cgi-bin/php5 to be the one you just created in your own cgi directory, i.e."
and gives the following example:
AddHandler php-cgi .php
Action php-cgi /cgi-bin/USERNAME/php5
I tried replacing "cgi-bin" with "public_cgi" and "WWW_Pages" neither of which worked.
Soooo .... I either need some more specific/correct examples of how to use a custom php.ini (asuming I can load a custom extension (ev.so) that way), or a way I can run a php file which can execute mysqli commands from a cron job.