Is php-mysql supported by pfSense 2.0? And where to put my php cron jobs?
I have just made a php file which extracts ping results to my main server and then stores data to MySQL on my main server.
1- What directory is the best place to put this .php file on a stock pfSense 2.0 install so that it can be called and run from cron job?
2- Does pfSense 2.0 stock has php-mysql installed? or do I have to install that as a package? please guide.
I would have to guess that a stock build has got php running as the Web GUI is php..
As far as where to put the file, i also don't know sorry.
pfsense doesn't have mysql installed by default. Take a look at installed packages by running```
I don't think it is a good idea to have that file running on pfsense. You may create a vulnerability or open pfsense for attack when doing this. Good luck!
Running the MySQL client isn't as dangerous as the server, so it's not too bad there.
That said, you'd have to compile php52-mysql, which can be done using a pfSense builder setup (check the doc wiki), and then copy the files over to the firewall.